Professional Education Course

Advanced Microsoft Excel

Bookmark and Share

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

Sections

Registration DeadlineSection DatesFormat & LocationCEUsFeeStatus
Sep 02, 2014 (Tue)Sep 02, 2014 (Tue) - Oct 07, 2014 (Tue)Atlanta (Scheller College of Business) (this is an onsite course)1.2$595OPEN

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

Meeting Times
On the first day, check in at least 30 minutes before the class start time.

  • Tuesday, September 2, 2014 (6:30 PM-8:30 PM)
  • Tuesday, September 9, 2014 (6:30 PM-8:30 PM)
  • Tuesday, September 16, 2014 (6:30 PM-8:30 PM)
  • Tuesday, September 23, 2014 (6:30 PM-8:30 PM)
  • Tuesday, September 30, 2014 (6:30 PM-8:30 PM)
  • Tuesday, October 7, 2014 (6:30 PM-8:30 PM)

Alternate Rates

  • $125 -- Georgia Tech Rate (valid Ga Tech ID required)

CRN

14924/220415306
Sep 13, 2014 (Sat)Sep 13, 2014 (Sat) - Sep 20, 2014 (Sat)Atlanta (Scheller College of Business) (this is an onsite course)1.2$595OPEN

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

Meeting Times
On the first day, check in at least 30 minutes before the class start time.

  • Saturday, September 13, 2014 (10:00 AM-5:00 PM)
  • Saturday, September 20, 2014 (10:00 AM-5:00 PM)

Alternate Rates

  • $125 -- Georgia Tech Rate (valid Ga Tech ID required)

CRN

14958/220415386

Important Course Information

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.

Student Requirements

Students attending the SEP 2 - OCT 7, 2014 offering should bring a laptop with Excel 2013 (available to Ga Tech students at office365.gatech.edu)

Course Administrator

Jim Lemoine

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