Master Microsoft Excel Rapidly in this Comprehensive Course
Learning Excel requires only mastering a handful of high-volume skills. This is a 100% example-based Microsoft Excel course focused on speed, automation and efficiency (the keys to becoming a power-user). Learn how to build models, write formulas, and perform analysis today in just 2.5 hours.
What's in the Course?
1. Excel 101, Formatting & Basic Formulas
Learn how to write basic formulas and design clean, automated spreadsheets that are easy to navigate.
2. Ditch the Mouse & Increase Speed 300%
Master high-volume keyboard shortcuts that will enable you to navigate Excel without the mouse to crank up your speed 3X.
3. Clean, Manipulate & Analyze Data Sets
Clean, analyze and uncover insights in large data sets using Microsoft Excel's data analysis functions.
4. Visualize & Present Data
Learn how to create beautiful tables, charts and dual axis charts to simplify large sets of data.
5. Write Conditional Statements
Use conditional statements like IF & VLOOKUP to investigate specific questions and combine data sets.
Examine the volatility of results in complex "what if" scenarios using the goal seek function and sensitivity tables.
7. Slide & Dice Data Using Pivot Tables
Analyze massive data sets in seconds without writing any formulas using Excel's Pivot Tables.
Who is Eric Andrews?
In addition to teaching this course, Eric is a senior financial analyst and business intelligence consultant with over 5 years of experience in the finance, technology and education industries. Most recently, he ran financial planning & analysis at iD Tech, a Silicon Valley-based startup with 125+ employees, and prior to that worked at Bank of America Merrill Lynch & Hewlett Packard.
Most Popular Blog Posts
As a finance professional, I built the curriculum based on the skills needed to succeed in today’s business environment, and I’ve excluded what you really don’t need to know. This course is a hack to develop advanced power-user skills in Microsoft Excel 2016 in a very short period of time.