1.  Excel Foundations

This session will lay the foundation for the day including critical aspects of Excel every user must know.  It will cover the features necessary to develop strong strategic Excel skills including: 

·        Customizing the Quick Access Toolbar

·        Moving through the Excel Ribbon Tabs

·        Number-crunching worksheets

·        Inserting headings and labels

·        Adding rows and columns with =AUTOSUM

·        AVERAGE and other common functions

·        Building your own formulas from scratch

·        Checking your math with the Status Bar

·        Customizing the appearance of charts

·         And more....

2.  Excel Formulas and Functions

The objective of the session is to help students grasp the structure, or 'grammar', of common and powerful functions. This enables students apply that grammar to the functions they use on the job, making it easier to learn new functions on their own. 

·        Formulas and functions basics

·        Review of basic formula & function construction

·        Working with Relative Addressing and Absolution References

·        Understanding Order of Operations

·        Using the Function Library

·        Understanding Array formulas

·        Using IF functions

·        Building an automatic Subtotal Report

·        Using the IF variants of common functions: SUMIF, COUNTIF, AVERAGEIF to build a manual subtotal report

·        Working with Date and Time functions    

3.  Excel Pivot Tables and Database Functions

The focus of this module is on using Excel to maintain lists of records – sorting and filtering, controlling data accuracy and using the data to generate reports and interactive analysis tools. 

·        Working with Excel lists and tables

·        Converting a list or range to an Excel Table

·        Using the Total row

·        Removing duplicate records

·        Sorting and filtering a table

·        Formatting a table

·        Understanding and building pivot tables

·        Deciding when and how to use a Pivot Table to analyze data

·        Editing an existing Pivot Table

·        Creating a Pivot Table from scratch

·        Manipulating data in a Pivot Table

·        Working with Data Validation Rules to create database consistency

·        Using database functions and Advanced filter tools 

4.  Excel Charting & SmartArt Diagrams

For many users, charting is their main task in Excel taking their own or other users’ data and turning it into charts that help the countless rows and columns of numbers make sense. This module demonstrates how to build the most popular chart types, and how to decide which one works best with the data at hand and the “story” the user needs to tell about that data.  

·        Building charts from Excel data

·        Understanding charting terminology &concepts

·        Choosing the best chart type for any situation

·        Manually formatting chart elements

·        Editing chart source data

·        Generating SmartArt diagrams

·        Building a SmartArt diagram

·        Adding and removing diagram elements

·        Promoting and demoting elements within a diagram

·        Formatting a SmartArt diagram 

‍