This is not your grandma’s Microsoft Excel course. Our CPE qualifying online Excel course will only teach you the most important Excel formulas and functions to conquer any spreadsheet or analysis.
Course objectives
Excel is the most used, yet most underutilized, business tool. Conquering Excel can put you years ahead of your peers. We’ll start by spending quite a bit of time learning keyboard shortcuts which are key to maximizing your efficiency.
After this, you’ll learn powerful functions such as IF statements, VLOOKUPs, SUMIFS, Conditional Formatting and other powerful tools. We finish the course by learning how to create PivotTables. We have left out all the fluff and get right to the heart of Excel.
At completion, you’ll have the tools to master pretty much any analysis in Excel!
Some key things you’ll learn:
- Keyboard shortcuts
- SUMIFS and COUNTIFS formulas
- IF, Nested IF, and VLOOKUP formulas
- Conditional Formatting and other data tools
- PivotTables and PivotCharts with Slicers
- And more!
We also recommend taking our Excel VBA Macros Bootcamp which is a fantastic complement to this course.
Additional info
Format: 3-6 minute videos, quizzes, and a final exam
CPEs: 5.0
Field of study: Computer Software & App
Prerequisites: You should have a beginner knowledge of Excel (e.g. SUM, AVERAGE, Charts, etc.)
We also recommend taking our Excel VBA Macros Bootcamp after which is a great complement to this course.
Cost: If you are an accountant, please click here to access your free course.
