Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
2 Hour(s) 46 Minute(s)
Language
English
Taught by
Corey @ Wisdify
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
Course Overview
In this fun and engaging course, you'll master keyboard shortcuts, VLOOKUPs, IF statements, PivotTables, and more!
This is not your grandma's Excel course! Our Excel course will give you the Excel skills to become an Excel ninja. You'll discover keyboard shortcuts, IF statements, VLOOKUP, PivotTables, and more!
WHAT MAKES OUR EXCEL COURSE UNIQUE?
Earn points as you complete the course and unlock your spirit animal
Engaging instructor that won't put you to sleep
G-rated humor and lighthearted lessons
ZERO FLUFF!
Real world application that you can start applying today
WHAT YOU'LL BE LEARNING
This course will help you master the most important and widely used formulas and functions in Excel. This course is beneficial to ANYONE who uses Excel. Here's what you'll master in the next 4 hours:
Keyboard shortcuts beyond the simple Ctrl+S or Ctrl+C
VLOOKUP, IF, and Nested IF statements
SUMIFS and COUNTIFS
Text formulas including LEFT, RIGHT, and TRIM
Date formulas including EOMONTH and EDATE
PivotTables and Slicers
Conditional Formatting, Remove Duplicates, and Text-to-Columns
By the end of this course, you'll be a total boss at Excel! Then you can take those skills to a whole new level by taking our Advanced Microsoft Excel course and Microsoft Excel VBA (Macros) course.
__________
NOTE: If you would like to receive CPE credit for this course, you must complete the final exam on our website. All lectures are compatible with Excel 2010, Excel 2013 or Excel 2016.
Course Content
- 7 section(s)
- 39 lecture(s)
- Section 1 Welcome!
- Section 2 Formatting & Keyboard Shortcuts
- Section 3 Formula Bootcamp Pt. I
- Section 4 Formula Bootcaomp Pt. II
- Section 5 Working w/ Data and Conditional Formatting
- Section 6 PivotTables & Slicers
- Section 7 Conclusion
What You’ll Learn
- Learn Excel in a fun, interactive, and entertaining manner (no sleeping in this course)
- Wow your team with powerful formulas such as VLOOUP, IF, SUMIFS, and more!
- Gain powerful insights into your data using PivotTables and Slicers
- Master keyboard shortcuts and become the Usain Bolt of Excel
- Organize and dissect large quantities of data using Text-to-Columns, Conditional Formatting, Sorting
- Practice your skills multiple times using real-life case studies
Skills covered in this course
Reviews
-
PPatricia Putri Art Syana
fun ways to learn, easy to follow, and very insightful
-
AAnanya Binnu
The course was really amazing and interesting. I learned a lot. It was a well structured course. It would have been more great if there were a lot more excel exercises, so that we can more efficiently practice tough concepts like VLOOKUP and nested IF statements.
-
IIsaac Reinhard Bonkey
Excelsior
-
DDavid Hendrickson
Yes - this is a good match - very practical and to the point!
