Excel Course for Everyday Excel Users

Beginners to Intermediate Users- Save time, money and boost job prospects
Course Created by Mach 42 Productions

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

This beginners to intermediate Excel course offers the following training:

  • How to figure out MS Excel formulas on any worksheet and fix errors (formula auditing!)
  • How to retrieve an Excel value based on another Excel value! (vlookup!)
  • A very effective way to automate your Excel report summaries!
  • Ways to structure and order your Excel report text!
  • A simple and effective way to clean your data! (string functions!)
  • An answer to the common question of how to calculate working days!
  • How to sum values based on criteria! (sumif!)
  • problem based/case study approach for each lecture!
  • All lectures independent and self contained- watch in any order!

Course Objectives

  • Gain more confidence using Excel to help you at work and increase productivity
  • Learn how to use several data analysis tools such as VLOOKUP and SUMIF and decipher formulas/fix errors on worksheets
  • Save lots of time by automating reports that use tables and text summaries
  • Clean up data using a combination of Excel functions saving you lots of time instead of manually cleansing data
  • Structure text on reports neatly to make your reports stand out
  • Enhance your job skills

Who Is This For?

  • This course is aimed at beginners to intermediate level users. It assumes a working basic knowledge of Excel.
  • The course is also suitable for junior level data and business analysts.
  • This course is also suitable for both under graduate and post graduates who want to enhance their job skills in a competitive market.
  • This course is also useful for those learning VBA separately and want to know more about front end Excel functions. Note this course does not teach any actual VBA.

Course Outline

Chapter 1: Introduction!

  • Lesson 1
    Introductory lecture

Chapter 2: How to do bullet points and new lines in the same cell

  • Lesson 2
    Bullet points and new lines…

Chapter 3: Cleaning data- How to substitute characters in text

  • Lesson 3
    Cleaning data- Using string…

Chapter 4: Automating reports- How to join formulas and text

  • Lesson 4
    Joining formulas and text

Chapter 5: How to calculate working days

  • Lesson 5
    Calculating the working day…
  • Lesson 6
    Adding working days to a date

Chapter 6: How to figure out formulas and fix errors

  • Lesson 7
    Formula Auditing

Chapter 7: How to sum a range of values based on one or more criteria

  • Lesson 8
    Using sumif() and sumifs() …

Chapter 8: How to retrieve a value based on a lookup of another value- vlookup

  • Lesson 9
    Using vlookup in Excel

Chapter 9: The end!

  • Lesson 10
    End lecture wrap up

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