Professional Education Course
Advanced Microsoft Excel
There are no sections available for registration to this course at this time. If you want to request an offering of this course, please contact us.
Important Course Information
New offerings will be scheduled for Fall 2014 and dates will be posted above when available.
A discounted fee of $125 is available for Georgia Tech students with a valid Georgia Tech ID.
The purpose of this course is provide Georgia Tech students the necessary skills to use MS Excel in the workplace as an analysis and presentation tool, above and beyond the average skill level of most users, thus making the student a more attractive candidate in the job market. Seats will also be made available to non-Georgia Tech students.
Who Should Attend
Those interested in Excel as an advanced analytical tool
How You Will Benefit
Upon course completion the student should have a basic understanding of how to:
- View, arrange, and import data from other sources
- Leverage the power of formulae for data analysis
- Use PivotTables to analyze and present data
- Use graphics and conditional formatting to make your data clearer
- Protect data and forms
- Create and run macros to automate number-crunching
- Perform other Excel tasks and tricks that are useful in the business world.
Some handouts and notes will be provided during the class. All presentation, working, and example files will be provided via T-Square.
Efficiency & Effectiveness in MS Excel
- Introduction to Class
- Importing and Sorting Data
- Working with Multiple Sheets
- Different Ways to View your Worksheet
- Useful Shortcuts and Time-savers
- The Power of the Formula Wizard
- Commonly used Formulae in Data Analysis
- Advanced Ifs, Ands, and Ors
- Nested Formulae
- Using Pivot Tables
- Goal Seek
- Using Graphical Style to Get Your Point Across
- Getting the Most out of the Chart Wizard
- Conditional Formatting
- Making it Print Right
- Grouping & Filtering
- Making Sure Your Boss Doesn't Mess It Up
Applications, Macros, & Automation
- The Idea of a Macro
- What You Can Do with Macros
- Recording Macros
- Running Macros
- Building Macros from Scratch
- Coding with VBA