Advanced Excel: Beyond the Basics
12

Thursday, 12 December

7 9 pm PST

GA Los Angeles (DTLA)

360 E. 2nd Street, Suite 400
Los Angeles, CA 90012
$65 USD
Regular Ticket
$65 USD
Total

Questions? Read our FAQs

Advanced Excel: Beyond the Basics | December 12

Troy Howard Photo


Officer, Senior Product Strategic Analyst, Bank of America

12

Thursday, 12 December

7 9 pm PST

GA Los Angeles (DTLA)

360 E. 2nd Street, Suite 400
Los Angeles, CA 90012
$65 USD
Regular Ticket
$65 USD
Total

Questions? Read our FAQs

About This Class

In this class we will move beyond the basics of spreadsheet creation. Topics will include data manipulation/troubleshooting and advanced functions to summarize and analyze data having multiple attributes. We will also introduce Pivot Tables, advanced graphs, and macros. Class exercises will be utilized to facilitate understanding.

Takeaways

Students will learn how to effectively streamline and analyze data using some of the more advanced features of Excel.

Preparation

  • A basic understanding of the Excel spreadsheet layout and Pivot Tables

  • Common uses such as entering data into a blank spreadsheet and copying/pasting

  • An understanding of common functions such as SUM, IF, and VLOOKUP

  • Ability to create a graph from two or more sets of data points

Instructions for setting up the Developer tab for Macros:

    PC: File > Options > Customize Ribbon > check "Developer"
    Mac: Excel > Preferences > View > in Ribbon > check "Developer tab"

About the Instructor

Troy Howard Photo

Officer, Senior Product Strategic Analyst,
Bank of America

My name is Troy Howard and I am a Officer, Senior Product Strategic Analyst for Bank of America. I am also the CEO and president of techoward, which will be a data analytics company once I begin the ground work.

I have over 20 years of experience in data analytics and network engineering. I have always had a love for technology and an appreciation for the changes that occur on a yearly basis. I have worked for firms ranging from workmen's comp and technology related companies to as financial institutions. One of the most exciting aspects of learning data analytics is that there is always something new on the horizon.

Refund Policy

We understand that, sometimes, plans change. If you can no longer make it to a class or workshop, please email us at least 7 days before the scheduled event date. No refunds will be given to cancellations made within a week of the class or workshop.

Coming up near you

Let’s Keep You Updated

Enter your email to start following

By providing us with your email, you agree to the terms of our Privacy Policy and Terms of Service.