Accelerated Intermediate Excel

Overview:

This course focuses on exploring a wide range of Excel concepts that will give participants a broad platform to Excel proficiency. The program is broad rather than deep and is designed to give participants a range of topics from Data Management, to Formulas to Pivot Tables. Participants will work hands-on with the instructor on supplied data. This course now includes new content from Office 365 

Special Instructions:

This is a hands-on workshop and to be able to follow along, you will need to use your laptop computer with a working copy of Microsoft Excel. Microsoft Excel for PC, Version 2013 OR Version 2016/Office 365 will be used in the demonstration of techniques of this workshop. You may use older versions with some loss of functionality. Starter Edition will NOT be adequate for this workshop.

Course Content:

In this course, you will gain knowledge about the following topics:

Module 1 - Data Management

• Understand data types, and the options for handling dates, times and other kinds of data, and how to use them in formulae – learn tools like Text to Column for managing data inconsistency, and functions to clean up data
• Understand the TABLE feature and its importance as a dynamic dataset for manually entered as well as queried data

Module 2 – Functions And Formulas

• Introducing important Functions – The COUNTIFS and SUMIFS functions for conditional calculations
• Understand the VLOOKUP Function (Intermediate Applications only) for extracting information and merging tables
• Introducing the newer XLOOKUP Dynamic Array function from Office 365

Module 3 – Pivot Tables and More

• Maintaining Data discipline
• Creating Pivot Tables
• Configuring Pivot Table Fields for reporting
• Quick Analysis technique with Pivot Tables

Other Tips and Tricks will be sprinkled throughout the course

Learning Objectives:

Upon completing this course, you should be able to:

• Understand common data inconsistencies and how they affect analysis, and find ways to clean them up
• Work with some useful conditional functions and Lookup functions for data analysis
• Create and Pivot Tables and use them for reports
• Learn some useful shortcuts and spreadsheet tips

Who Will Benefit:

This course is designed for those who have basic knowledge of Excel and want to build a robust platform for proficiency in analytical and reporting tasks.