Microsoft Excel Bootcamp

Time & Location

Contact us to Schedule Courses
Virtual Instructor Led Hands on Courses

About the Course

Microsoft improved Excel significantly in the most recent version. Additions to the function library, Tables, a greatly improved charting engine, and an overhaul of PivotTable functionality are just a few of changes you will learn about in Excel Boot Camp. In addition, throughout the Excel Boot Camp, you and your team will learn various techniques for enhancing not only your efficiency, but also your effectiveness, when working with Excel.

COURSE CONTENT

EXCEL FOUNDATIONS

• 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

EXCEL FORMULAS AND FUNCTIONS

• 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

EXCEL PIVOT TABLES AND DATABASE FUNCTIONS

• 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

EXCEL CHARTING & SMARTART DIAGRAMS

• 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

Register
Price
Quantity
Total
  • March Mayhem Pricing
    $99
    +$12.87 HST
    $99
    +$12.87 HST
    0
    $0
Total$0

Share This Event