Professional Education Course

Advanced Microsoft Excel

Bookmark and Share

Course Title: Advanced Microsoft Excel
Program ID: MNGT 1034P Subject: Leadership & Management

Sections

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.

 

Course Description

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.

Course Materials

Some handouts and notes will be provided during the class. All presentation, working, and example files will be provided via T-Square.

Instructors

Jim Lemoine

Course Agenda

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

Data Analysis

  • Commonly used Formulae in Data Analysis
  • Advanced Ifs, Ands, and Ors
  • Nested Formulae
  • Using Pivot Tables
  • Goal Seek

Data Presentation

  • 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