THE PDC OF GLENDALE COMMUNITY COLLEGE

The PDC Creates Custom Training Programs that Address ALL of Your Company's Training Needs.

MICROSOFT® EXCEL (INTERMEDIATE-ADVANCED)

Course Description

In this course participants will work with charts and tables along with other useful formatting tools. They will also learn to create formulas that use built-in functions to perform advanced analysis. The class will cover the creation of shared workbooks and the tracking of changes within them. Participants will cover a number of topics and will be introduced to a wide range of software capabilities in the subjects of calculation, data management, data analysis, visualization and reporting. Students will participate in creating various worksheet models as guided by the instructor.

Audience

The course is designed for individuals who are seeking to learn the ever-increasing capabilities of the Microsoft Excel application. This course can be a great value for participants seeking personal growth opportunities to improve their workplace performance, participants transitioning from older versions of Excel and anyone wishing to move their Excel skills to a higher level.

Prerequisites

Prospective students should have experience using Excel. Generally, 6 months or more is optimal. However, students having experience in other Microsoft applications such as Outlook or Word will likely adapt quickly.

Topics and Course Content

This course will cover topics such as:

  • PivotTables and PivotCharts
  • Introduction to Power Query and Power Pivot
  • Advanced Functions:
    • Lookups (VLOOKUP, XLOOKUP, INDEX, MATCH, etc.)
    • Data Statistical (DSUM, DAVERAGE, DGET, etc.)
    • Logical (IF, AND, OR)
    • Text (UPPER, LOWER, CONCAT, etc.)
  • Tables
  • Workbook Auditing
  • Conditional Formatting Charts (Column, Bar, Pie, Pareto)
  • What If Analysis (Data Tables, Scenario Manager)
  • Custom Function Creation (LAMBDA, VBA)
  • Templates
  • Macros (VBA and Keyboard Recorded)

Learning Goals and Results

At the conclusion of the course, the participants will be able to:

  • Automate common tasks
  • Create and edit a macro
  • Audit workbooks to avoid errors
  • Export data
  • Share data through exports and the web

Time Investment

The class is 48 hours of instruction in 4-hour sessions over the course of 12 weeks.

Please Note: Course content and time investment can also be customized to an individual company’s needs.

CLASS SELECTION

Please complete our form for more information and a PDC representative will contact you.

Name*
This field is for validation purposes and should be left unchanged.

TRAINING OVERVIEW

CLASS APPLICATIONS

ABOUT US
JOIN OUR MAILING LIST
OUR PROGRAMS
CONTACT US
PDC BROCHURE