Microsoft Excel Bootcamp

5.0 CPEComputer Software & Applications

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.

VIDEO COURSE

This course is free

Create a free account to enroll and earn CPE. No credit card required.

Create free account Already enrolled? Sign in to continue

About this course

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!

What you’ll learn

Upon completion of this course, you will be able to:

Fundamental and advanced Excel techniques, including formulas, functions, and formatting.
The power of keyboard shortcuts to significantly improve your efficiency.
How to build clear, accurate, and professional spreadsheets by mastering formatting standards.
Practical use of essential formulas like VLOOKUP, SUMIFS, COUNTIFS, and absolute cell references.
Advanced techniques for dynamic and scalable spreadsheet modeling.
Real-world application of Excel in case studies to solve complex problems with ease.

Course content

7 lessons · 46 steps · 2h 43m of video

01LESSON 1Welcome3 items

02LESSON 2Formatting & Keyboard Shortcuts10 items

03LESSON 3Formula Bootcamp pt. I10 items

04LESSON 4Formula Bootcamp pt. II7 items

05LESSON 5Working with Data & Conditional Formatting6 items

06LESSON 6PivotTables8 items

07LESSON 7Conclusion1 item

Locked

Final assessment

Course access is required to take this assessment.

21 questions70% to passUnlimited attempts

On course completion: 5.0 CPE and a certificate

Course details

CPE: 5.0
Field of study: Computer Software & Applications
Course level: Not specified
Delivery method: QAS™ Self Study
Prerequisites: You should have a beginner knowledge of Excel (e.g. SUM, AVERAGE, Charts, etc.). <strong>We also recommend taking our <a href="https://wisdify.com/bootcamps/excel-vba-macros-course/">Excel VBA Macros Bootcamp</a> after which is a great complement to this course.</strong>
Advance preparation: Not specified
Course content: 7 lessons · 46 steps
Assessment: Final assessment · 21 questions · pass 70%
Completion deadline: 365 days from enrollment
Last updated: August 2017
Registration: A free Wisdify account and course enrollment are required.