4.59 out of 5
4.59
588 reviews on Udemy

Microsoft Excel Bootcamp – Learn to Master Excel in 3hrs!

In this fun and engaging course, you'll master keyboard shortcuts, VLOOKUPs, IF statements, PivotTables, and more!
Instructor:
Joseph @ Wisdify
1,511 students enrolled
English [Auto]
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

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.

Welcome!

1
Introduction
2
Course materials
3
Workbook overview

Formatting & Keyboard Shortcuts

1
Font coloring & assumptions
2
Other formatting best practices
3
Keyboard shortcuts introduction
4
Basic keyboard shortcuts
5
Basic keyboard shortcuts II
6
The Almighty Alt key
7
Customizing the Quick Access Toolbar
8
Ctrl + Shift key
9
Quiz: Formatting & Keyboard Shortcuts

Formula Bootcamp Pt. I

1
Absolute cell references
2
SUMIFS pt. I
3
SUMIFS pt. II
4
COUNTIFS
5
VLOOKUP introduction
6
VLOOKUP formula
7
VLOOKUP common pitfalls
8
Case study 1 pt. I
9
Case study 1 pt. II
10
Quiz: Formula Bootcamp pt. I

Formula Bootcaomp Pt. II

1
IF statements
2
Nested IF statements
3
EDATE and EOMONTH
4
YEAR, MONTH, and DAY
5
LEFT, RIGHT, and MID
6
TRIM
7
Quiz: Formula Bootcamp pt. II

Working w/ Data and Conditional Formatting

1
Text-to-Columns
2
Remove duplicates
3
Conditional formatting pt. I
4
Conditional formatting pt. II
5
Conditional formatting pt. III
6
Quiz: Working with Data & Conditional Formatting

PivotTables & Slicers

1
Introduction
2
Drilling into our data
3
Formatting our PivotTable
4
Slicers
5
Case Study 2 pt. I
6
Case Study 2 pt. II
7
Case Study 2 pt. III
8
Quiz: PivotTables

Conclusion

1
Conclusion
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.6
4.6 out of 5
588 Ratings

Detailed Rating

Stars 5
354
Stars 4
198
Stars 3
31
Stars 2
4
Stars 1
1
10da656cb98b37cf5f37df68fa7452a8
30-Day Money-Back Guarantee

Includes

3 hours on-demand video
1 article
Full lifetime access
Access on mobile and TV
Certificate of Completion