EXCEL FOR DATA ANALYSIS | A live online course with Senior Program Manager, Dynamics Product Group at Microsoft | ELVTR
A LIVE ONLINE COURSE
with Senior Program Manager,
Dynamics Product Group
at Microsoft
Dates:
Module 1: 29 NOV 2021 - 15 DEC 2021
Module 2: 3 JAN 2022 - 2 FEB 2022
Duration:
8 weeks
MONDAYS & WEDNESDAYS
5 PM PST / 8 PM EST

If you have data, you have the world. Take the mystery out of Excel and secure your place in today's data-centric workforce.

This is the only Excel certification course that also delivers expert-level training you'll rely on, no matter how far your career takes you.

Do you see yourself below?
Then this course is for you.

  • ANYONE WHO WORKS WITH DATA

     

    Set yourself apart with the ability to manage complex workbooks, perform large-scale data analysis, create pivot tables, and clearly present data sets.

  • EXCEL CERTIFICATION SEEKERS

     

    Get your resumé noticed for dozens of roles that require Excel. Prep for the Excel Associate or Excel Expert exam and go deeper with exam questions and practice.

  • FUTURE ANALYSTS

     

    Master how to structure and engage with data in Excel with over 20 hours of live instruction and real business applications. Plus, get your feet wet with Power BI!

  • NON-DEGREE CAREER STARTERS

     

    Not having a college degree shouldn't stunt your earning potential. Build job-ready spreadsheet and data skills and watch your value on the job market increase.

PREPARE TO ACCELERATE

Up your ante for all the jobs.

It's true: with more than 30 million users worldwide, Excel remains the world's most popular spreadsheet program.

In fact, people who are at ease with Excel can expect to earn up to $1,200 for every $1,000 earned by their colleagues. What better way to invest in your career than that?

You're not in this alone.

Since each class happens to live, you can ask questions and get help when you need it (there are weekly office hours, too).

With guided in-depth practice, real-life applications, and dozens of certification prep questions, there's nothing standing between you and Excel mastery.

 
ABOUT THE COURSE
01
MODULE 1:
BEYOND
THE BASICS

You're already using Excel, but are you getting its real value? In this module, you'll get coached through everything you need to know to use Excel like a pro.

02
MODULE 2:
ADVANCED TECHNIQUES

Make yourself promotion material. Module 2 is all about building skills to meet high-level data and financial needs, like complex analytics and data presentation.

03
CERTIFICATION

Prepare for Microsoft Excel certification from 70 graded exam questions. Improve your performance with focused prep for the Associate certification in Module 1 and Expert in Module 2.

Instructor
Rachel
Guthrie
LinkedIn Profile
  • Senior Program Manager, Dynamics Product Group at Microsoft and certified as a Microsoft Excel Expert
  • Uses Excel to empower lucrative investment decisions every day with strategic reporting and analytics
  • Developed a custom budget model for a Canadian oil company's first US acquisition
  • Designed and implemented key features for Microsoft's own internal executive reporting tool
  • Boasts over a decade of financial leadership at enterprises in industries including technology, oil and gas, and EdTech
  • Sailed for Canada as a Canadian Sailing Team athlete and was chosen as an alternate at two Olympic Games
Rachel Guthrie
Rachel Guthrie
COURSE INTRODUCTION
SYLLABUS

MODULE 1

Beyond the Basics

01
MON (11/29), 5 PM PST/8 PM EST
Introduction to Data Analysis in Excel

Data is rarely ready for analysis as-is. In this class, you'll learn the main principles of data analysis and how to prepare your data for Excel. You'll get familiar with the most popular data manipulation techniques.

  • Main principles of data analysis
  • Importing data into workbooks
  • Preparing data for analysis in Excel
  • Inserting and transposing data
  • Data formatting and manipulation

Application #1: Import the provided data set into your workbook and clean/manipulate it using TRIM and SUBSTITUTE functions.

+ 5 Microsoft Excel Associate certification prep questions

more
02
WED (12/1), 5 PM PST/8 PM EST
Calculations in Excel

This class is an introduction to widely used formulas and functions. You'll learn when and how to use each of them. You'll also learn how to use complex formulas with nesting techniques.

  • Formulas vs. functions: Elements and operators
  • Using formulas and addressing cells
  • Nesting techniques and other complex formulas
  • Project environment: How organizational structure and culture affects projects
  • Troubleshooting: $ operator, circular reference identification, and other common errors

Application #2: Apply the formulas learned in class to interact with a sample data set.

+ 5 Microsoft Excel Associate certification prep questions

more
03
MON (12/6), 5 PM PST/8 PM EST
Functions in Excel, Part 1

When you search for dates, how do you make sure that your results are really dates? What functions can you use to assist in statistical analysis? In this class, you'll take a deep dive into function categories for common applications.

  • Functions categories
  • ext functions: LEN, MID, CLEAN, LOWER, CONCATENATE
  • Date and time functions: DATEDIF, WEEKNUM, TODAY, NETWORKDAY
  • Logical functions: IF, IFERROR, AND/OR/NOT
  • Mathematical and statistical functions: SUM/AVERAGE/MAX/MIN, AVERAGEIFS, ROUND, SUBTOTALS

Application #3: Practice using the functions learned in class by following the instructions provided.

+ 5 Microsoft Excel Associate certification prep questions

more
04
WED (12/8), 5 PM PST/8 PM EST
Functions in Excel, Part 2

In this class, you'll get up close and personal with more complex functions used to structure data for analysis. Rachel will walk you through how to apply Excel functions when your dataset calls for it.

  • Indirect cell references: Functions ROW, COLUMN, INDIRECT, ADDRESS
  • Look up values with VLOOKUP/HLOOKUP, INDEX, or MATCH
  • Functions SUMIF/SUMIFS, COUNT/COUNTIF/COUNTIFS, COUNTA, SUMPRODUCT

Application #4: Practice using the functions learned in class by following instructions provided.

+ 5 Microsoft Excel Associate certification prep questions

more
05
MON (12/13), 5 PM PST/8 PM EST
Working with Tables in Excel

You'll learn how to use data tables, the gears that let you deftly change values to come up with different answers to a problem. Rachel will help you apply key manipulations on a data set.

  • Creating and formatting tables
  • Define/convert named table/range
  • Filters and slicers
  • Drop-down lists
  • Totals and subtotals
  • Sparklines and conditional formatting

Application #5: Using the dataset that you have prepared in Application #1, practice table manipulations by following the instructions.

+ 5 Microsoft Excel Associate certification prep questions

more
06
WED (12/15), 5 PM PST/8 PM EST
Dashboards in Excel

Your data dashboard is how your data enters the world to decision-makers. In this class, you will learn the principles of dashboard design and how to choose the best type of chart to visualize your data.

  • Dashboard design principles
  • Customize options and views
  • Types of charts
  • Creating and formatting charts and graphs
  • Combination charts
  • Adding trendlines

Application #6: Create a dashboard from a sample dataset to meet business requirements such as 8 QTR trend, variance, and margin analysis.

+ 5 Microsoft Excel Associate certification prep questions

more

MODULE 2

Advanced Techniques

07
MON (1/3), 5 PM PST/8 PM EST
Pivot Tables

Why are pivot tables such a big deal? You'll learn when you want to use this type of table and how to manipulate and reference them.

  • Creating and formatting pivot tables
  • Calculated fields
  • Grouping, slicing, and sorting
  • GETPIVOTDATA vs. direct cell reference
  • Creating pivot charts

Application #7: Using the dataset from the Tables exercise in the previous lesson, create a pivot table and perform manipulations learned in class.

+ 5 Microsoft Excel Expert certification prep questions

more
08
WEN (1/5), 5 PM PST/8 PM EST
Introduction to Macros

This class is all about macros: what they are, why we use them, and how to create and run them.

  • Understanding macros
  • Recording simple macros
  • Running macros
  • Editing macros
  • Copying macros to workbook and enabling them

Application #8: Practice the techniques learned in class to record a macro that will perform a set of given instructions.

+ 5 Microsoft Excel Expert certification prep questions

more
09
MON (1/10), 5 PM PST/8 PM EST
Business Analytics with Excel

Now that you're able to efficiently clean and manipulate your data, it's time for the fun stuff: data analysis. You'll learn how to use the data analysis tools built into Excel and how to apply them to common business cases.

  • What-if analysis: Goal seek and scenario manager
  • Data tables
  • Solver tool
  • Forecast sheet
  • Business case scenario

Application #9: Build a budget model following certain requirements to practice the tools you've learned so far.

+ 5 Microsoft Excel Expert certification prep questions

more
10
WED (1/12), 5 PM PST/8 PM EST
Excel Data Analysis Using Statistics

In this class, you'll learn the most commonly used techniques in statistics for data modeling. Then, you'll see how they're applied in a real business case scenario.

  • Hypothesis testing
  • ANOVA
  • Normal distribution
  • Business case scenario

Application #10: Work with a provided data set using the statistical tools taught in class.

+ 5 Microsoft Excel Expert certification prep questions

more
11
MON (1/17), 5 PM PST/8 PM EST
Data Analysis with Charts

The great thing about Excel is that it gives you a wider variety of charts to express more nuanced data. This class lets you practice advanced techniques in Excel charts such as Pareto, Waterfall and Tornado graphics.

  • Introduction to advanced excel charts
  • Dual axis charts
  • Actual vs. targets chart
  • Pareto chart (80/20 analysis)
  • Gantt chart, Waterfall chart, Tornado chart

Application #11: Practice building charts (pareto, waterfall, etc.) learned in class from a provided sample data set.

+ 5 Microsoft Excel Expert certification prep questions

more
12
WED (1/19), 5 PM PST/8 PM EST
Data Security in Excel

Learn how to secure your shared Excel workbook to prevent unwanted changes while allowing others to edit your data and reports. This class is all about controlled collaboration.

  • Data validation
  • Protect workbook, sheet, and cells
  • Encrypting file with passphrase
  • Hiding rows, columns, sheets
  • Workbook collaboration

Application #12: Practice methods learned in class to protect, view, and validate data in a sample workbook.

+ 5 Microsoft Excel Expert certification prep questions

more
13
MON (1/24), 5 PM PST/8 PM EST
Data Presentation + Pitching Yourself

You can do a ton of great work, but if you don't present it well, people just see a confusing dashboard of numbers. In this class, you'll learn techniques for clear communication as you prepare to present data analysis to stakeholders.

  • Storytelling principles
  • Pitching your findings to stakeholders
  • Elevating your data presentation skills
  • Accessibility considerations

Application #13: Learn how to “start with 'Why'”. Watch the provided video on your own and create a slide pitching “Why” a company would want to hire you. Then, record your pitch in a 45-second video.

more
14
WED (1/26), 5 PM PST/8 PM EST
Power Add-ins

There are four Excel add-ins that you'll need for large data sets. This class teaches you how to use them, and how to access other helpful add-ins.

  • Power query
  • Power pivot
  • Power view
  • Power map

Application #14: Follow instructions provided to create a mini-data model and generate specific visualizations in Excel from that model.

more
15
MON (1/31), 5 PM PST/8 PM EST
Advancing Your Skills

In this class, you will learn how to avoid common mistakes in data analysis and how to solve problems with your model.

  • Common mistakes and tips for data analysis
  • Troubleshooting and finding answers to your questions
  • Preparing for certifications
  • Next steps

Application #15: Complete the provided Microsoft Excel Associate and Microsoft Excel Expert exam questions.

more
+
WED (2/2), 5 PM PST/8 PM EST
Bonus Workshop: Visualizations with Power BI

Combined with Excel, Power BI gives you broad data analytics and visualization capabilities. Learn the basics of Power BI and how you can use it to create dynamic and interactive visualizations, from diverse data sources.

  • Why Power BI?
  • Basic concepts and terminology
  • Demo: Tools overview and data modeling

Application #16: Build a data model from a set of data provided in multiple formats. Then, generate a Power BI report using visualization techniques learned in class.

more
ENROLL
First name
This is required field!
Last name
This is required field!
Email
This is required field!
This is required field!
By registering and clicking “ENROLL”, you agree to our
Terms of Use, Privacy policy and Cookie Policy
 
 
 
 
ONE MOMENT...

Ways to take this course

Choose your level!

    • LIVE instruction & open office hours
    • Graded assignments & instructor feedback
    • Fundamentals of Excel & data analysis
    • MOS: Excel Associate certification prep
    • Advanced Excel for complex business needs
    • MOS: Excel Expert certification prep
  • Module 1
    • LIVE instruction & open office hours
    • Graded assignments & instructor feedback
    • Fundamentals of Excel & data analysis
    • MOS: Excel Associate certification prep
    •  
      Advanced Excel for complex business needs
    •  
      MOS: Excel Expert certification prep
  • Module 2
    • LIVE instruction & open office hours
    • Graded assignments & instructor feedback
    •  
      Fundamentals of Excel & data analysis
    • MOS: Excel Associate certification prep
    • Advanced Excel for complex business needs
    • MOS: Excel Expert certification prep
  • SAVE 15%
    Full course
    • LIVE instruction & open office hours
    • Graded assignments & instructor feedback
    • Fundamentals of Excel & data analysis
    • MOS: Excel Associate certification prep
    • Advanced Excel for complex business needs
    • MOS: Excel Expert certification prep