Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udemy

Learn Microsoft Excel Fast - The Intermediate Excel Tutorial

via Udemy

This course may be unavailable.

Overview

Microsoft Certified Master Instructor - Microsoft Excel Functions - VLOOKUP - Sorting - Filtering - Charts - Formatting

What you'll learn:
  • Learn how to work with data
  • Learn how to import text data
  • Learn how to sort and filter data
  • Learn how to use the advanced filter
  • Learn how to use vlookup & freeze frames
  • Learn how to use find & replace to quickly update data
  • Learn how to convert delimited text into columns
  • Learn how to remove duplicates & validate data
  • Learn how to use "what-if" analysis & create forecasts
  • Learn how to consolidate, group, & sub-total data
  • Learn all about visually representing data & creating charts
  • Learn how to include sparklines, combo charts, & trendlines
  • Learn how to format your worksheets for printing
  • Learn the different ways of viewing your worksheets
  • Learn how to include headers & footers in your worksheets
  • Gain a thorough foundation in using Excel functions
  • Learn how to use logical functions
  • Learn how to use text functions
  • Learn how to use date & time functions
  • Learn how to use lookup & reference functions
  • Learn how to use information functions
  • Acquire skills using conditional formatting & custom views
  • Receive an entire section covering Google Drive

You canlearn Microsoft Excel easily and quicklyif it is taught correctly.

Developed by a Microsoft Certified Master Instructor, this course is the perfect course when you are ready to progress with yourMicrosoft Excelskills. Taught by auniversity professor withover twentyyears of experience teaching individuals of all ability levels "how to use" Microsoft Excel,Todd McLeod has designed, refined, and perfected thiscourse to make it easy for you to learn Microsoft Excel.

Providinga comprehensive curriculum of180video lectures, including 72 hands-on exercises, you will learn all of the following about Microsoft Excel:

  • Learn how to work with data

  • Learn how to import text data

  • Learn how to sort and filter data

  • Learn how to use the advanced filter

  • Learn how to use vlookup & freeze frames

  • Learn how to use find & replace to quickly update data

  • Learn how to convert delimited text into columns

  • Learn how to remove duplicates & validate data

  • Learn how to use "what-if" analysis & create forecasts

  • Learn how to consolidate, group, & sub-total data

  • Learn all about visually representing data & creating charts

  • Learn how to include sparklines, combo charts, & trendlines

  • Learn how to format your worksheets for printing

  • Learn the different ways of viewing your worksheets

  • Learn how to include headers & footers in your worksheets

  • Gain a thorough foundation in using Excel functions

  • Learn how to use logical functions

  • Learn how to use text functions

  • Learn how to use date & time functions

  • Learn how to use lookup & reference functions

  • Learn how to use information functions

  • Acquire skills using conditional formatting & custom views

  • Gain insight into using Office365 online

  • Work with a comprehensive set of 72"hands-on exercises"

  • Receive solutionsto all of the "hands-on exercises"

  • download all of the Excel project files that are used in the videos.

This class is guaranteed tohelp you progress with yourMicrosoft Excel skills.

Once enrolled,you will have access to this Excel course for the rest of your life.

Described as “fun” and “amazing” and “life changing,” Todd McLeod’s Excel training will forevertransform the way you work with numbers. Try this course for yourself andsee how quickly and easily you too can advance your Microsoft Excel skills.


Taught by

Todd McLeod

Reviews

4.6 rating at Udemy based on 79 ratings

Start your review of Learn Microsoft Excel Fast - The Intermediate Excel Tutorial

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.