Excel Bootcamp for Accountants
CPEs : 5.0
Access all courses starting at $25/m
Course Objective:
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
PivotTables and PivotCharts with Slicers
Conditional Formatting and other data tools
And more!
We also recommend taking our Excel VBA Macros Bootcamp which is a fantastic complement to this course.
Access all courses starting at $25/m
Additional Info:
Format
3-6 minute videos, quizzes, and a final exam
Field of study
Computer Software & App
CPEs
5.0.
Led by :
Dianne Russell
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.