Advanced Microsoft Excel

  • Overview
  • Course Content
Overview

Advanced Microsoft Excel

Course Description

Understanding the ins and outs of the spreadsheet program Microsoft Excel is an incredibly valuable skill as a business professional. In the Advanced Microsoft Excel course, you will grow your knowledge above and beyond the average skill level of most users and learn how to use the program in the workplace as an analysis and presentation tool. Instantly apply your newfound talent to your day-to-day activities at your organization, or promote it during your job search.

Course Content

EFFICIENCY AND EFFECTIVENESS IN MICROSOFT EXCEL

  • How to import and sort data
  • How to work 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
  • How to use pivot tables
  • Goal seek

DATA PRESENTATION

  • How to use graphical style to get your point across
  • How to get the most out of the chart wizard
  • Conditional formatting
  • How to make it print right
  • Grouping and filtering
  • How to make sure your boss doesn't mess it up

APPLICATIONS, MACROS, AND AUTOMATION

  • The idea of a macro
  • What you can do with macros
  • Macros recording and running
  • How to build macros from scratch
  • How to code with Visual Basic for Applications (VBA)

Session Details

Who Should Attend

This course is designed for those interested in Microsoft Excel as an advanced analytical tool.

Woman with dark long hair wearing a headset works in front of a laptop on Excel.

What You Will Learn

  • Efficiency and effectiveness
  • Data analysis
  • Data presentation
  • Applications, macros, and automation
Analytics professional working on two desktop monitors

How You Will Benefit

  • 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.
  • Grow Your Professional Network icon
    Grow Your Professional Network
  • Taught by Experts in the Field icon
    Taught by Experts in the Field

The course schedule was well-structured with a mix of lectures, class discussions, and hands-on exercises led by knowledgeable and engaging instructors.

- Abe Kani
President

TRAIN AT YOUR LOCATION

We enable employers to provide specialized, on-location training on their own timetables. Our world-renowned experts can create unique content that meets your employees' specific needs. We also have the ability to deliver courses via web conferencing or on-demand online videos. For 15 or more students, it is more cost-effective for us to come to you.

  • Save Money
  • Flexible Schedule
  • Group Training
  • Customize Content
  • On-Site Training
  • Earn a Certificate
Learn More

Want to learn more about this course?