Having strong foundations in Excel is a critical skill that most business professionals require at a basic level in order to be effective and efficient at data analysis. This needs to go beyond a training course that simply teaches how to calculate a mortgage and perform other basic functions that will most likely never be used, or an online course that covers generic use of data.
This virtual classroom training dives into the most important elements of Excel to give participants confidence while working in the application, including: moving around a spreadsheet, writing basic formulas like SUM, COUNT, RANK, UNIQUE, IFERROR, and conditional formulas, formatting cells, understanding absolute and relative ranges, and creating basic charts and PivotTables. We use examples that are very common in retail and CPG, so it also helps participants learn some best practices in analyzing and calculating key measures in their data.
There are many hands-on workshops in this fast-paced session. We can adjust focus areas based on the unique needs of your organization with an emphasis on specific topic areas. We can also use data and examples from your business to increase relevancy.
Optimum class size: 10-15 participants (maximum 25)
Length of session: 120-150 minutes
Cost: Starts at $3,000 USD (includes development, customization, delivery, student notes, hands-on workshops). Multiple sessions of the same topic are at a reduced price.
Core Competency: DATA AND ANALYTICS
This session can be combined with other training topics to create a virtual training series over days, weeks or months.
KEY LEARNING OBJECTIVES:
- To explain the keys to help you move efficiently and effectively through Excel worksheets
- To identify the steps needed to sort data
- To list some common Excel formulas and the nomenclature for each (SUM, COUNT, RANK, SUMIF, ISERROR)
- To describe how to create and format basic charts in Excel
- To explain when to use PivotTables and how to make a basic PivotTable
Best 3-hour lecture / class I've ever attended!
Time went by too quickly.
I learned many new things (i.e. formula building, shortcuts, and emphasis on what I'm trying to say or do in Excel).
Handouts are incredibly helpful and I will go back to reference them.