Don't Fear the Job Interview - Guide to Excel

Does the job require you to Know Excel? This Will Get you Ready
Course Created by Bill Jelen
Host of MrExcel.com website. Microsoft MVP in Excel for 10 years. Author of 43 books about Microsoft Excel and a frequent speaker at accounting conferences.

  •   Lifetime access to all lessons!
  •   30 days money back guarantee!
  •   Accessible via iPhone, iPad and Android (soon!)

You have an interview this afternoon where one of the requirements is that you "know Excel". But - it has been years since you last saw Excel, and that was only for a few weeks in school. This course will teach you what you need to know to sound confident in the interview. When the interviewer asks if you know pivot tables, you can say that you've seen them get created and you understand how they work. Then the interviewer asks for some of your favorite Excel formulas, you will tell him or her that it is VLOOKUP. In just one hour, you will learn the lingo, see the new Excel 2010 interface, and have a confident understanding of what can be done in Excel.

Course Objectives

  • Understand the basics of Excel
  • Confidently talk about data analysis including pivot tables.
  • Explain the all-important VLOOKUP function in Excel.

Who Is This For?

  • Job-seekers who need to get through the interview where they have to know Excel.
  • Anyone recently hired, where everyone around you is an Excel ninja.
  • People who need a massive refresher on how Excel is used in the real world.

Course Outline

Chapter 1: Getting Started With Excel

  • Lesson 1
    Introduction
    01:58
  • Lesson 2
    Open Excel
    07:38

Chapter 2: Creating a Conference Room Sign-Up

  • Lesson 3
    Case Study: Conference Room…
    13:38
  • Lesson 4
    Fitting Data
    09:02

Chapter 3: Formulas in Excel

  • Lesson 5
    Creating Formulas in Excel
    09:40

Chapter 4: Charts and Graphs

  • Lesson 6
    Creating Charts & Graphs
    04:26

Chapter 5: Sorting, Filtering, Subtotals

  • Lesson 7
    Sort, Freeze Panes, and Filter
    05:41
  • Lesson 8
    Quickly add Subtotals and 1…
    03:46

Chapter 6: Troubleshooting Excel Annoyances

  • Lesson 9
    09-Annoyances
    05:07

Chapter 7: Wrap-Up

  • Lesson 10
    Wrap Up
    02:09

  •   Lifetime access to all lessons!
  •   30 days money back guarantee!
  •   Accessible via iPhone, iPad and Android (soon!)