Advanced Excel: Beyond the Basics

Washington D.C. campuses

GA Washington D.C. (1776 8th Floor)
1133 15th Street NW, 8th Floor
Washington DC 20005

Past Locations for this Class

Advanced Excel: Beyond the Basics

Washington D.C.

Washington D.C. campuses

GA Washington D.C. (1776 8th Floor)
1133 15th Street NW, 8th Floor
Washington DC 20005

Past Locations for this Class

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.

Prereqs & 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"

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.