Learn Microsoft Excel Fast - The Intermediate Excel Tutorial

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
Requirements
All versions of Microsoft Excel work for this course. The instructor will be using Microsoft Excel 2016.
Description
You can learn Microsoft Excel easily and quickly if it is taught correctly.Developed by a Microsoft Certified Master Instructor, this course is the perfect course when you are ready to progress with your Microsoft Excel skills. Taught by a university professor with over twenty years of experience teaching individuals of all ability levels "how to use" Microsoft Excel, Todd McLeod has designed, refined, and perfected this course to make it easy for you to learn Microsoft Excel.Providing a comprehensive curriculum of 180 video lectures, including 72 hands-on exercises, you will learn all of the following about Microsoft Excel:
Learn how to work with dataLearn how to import text dataLearn how to sort and filter dataLearn how to use the advanced filterLearn how to use vlookup & freeze framesLearn how to use find  & replace to quickly update dataLearn how to convert delimited text into columnsLearn how to remove duplicates & validate dataLearn how to use "what-if" analysis & create forecastsLearn how to consolidate, group, & sub-total dataLearn all about visually representing data & creating chartsLearn how to include sparklines, combo charts, & trendlinesLearn how to format your worksheets for printingLearn the different ways of viewing your worksheetsLearn how to include headers & footers in your worksheetsGain a thorough foundation in using Excel functionsLearn how to use logical functionsLearn how to use text functionsLearn how to use date & time functionsLearn how to use lookup & reference functionsLearn how to use information functionsAcquire skills using conditional formatting & custom viewsGain insight into using Office365 onlineWork with a comprehensive set of 72 "hands-on exercises"Receive solutions to all of the "hands-on exercises"download all of the Excel project files that are used in the videos.This class is guaranteed to help you progress with your Microsoft 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 forever transform the way you work with numbers. Try this course for yourself and see how quickly and easily you too can advance your Microsoft Excel skills.

Overview

Section 1: Introduction

Lecture 1 Welcome

Lecture 2 Course outline

Lecture 3 Course files

Lecture 4 Versions

Section 2: Working With Data

Lecture 5 Acquiring Data

Lecture 6 Importing Text Data

Lecture 7 Sort

Lecture 8 Vlookup

Lecture 9 Freeze frames

Lecture 10 Vlookup & Sort

Lecture 11 Filter

Lecture 12 Advanced Filter

Lecture 13 Find & Replace

Section 3: Exercises - Ninja Level 2

Lecture 14 Hands-On Exercise #1

Lecture 15 Hands-On Exercise #2

Lecture 16 Hands-On Exercise #3

Lecture 17 Hands-On Exercise #4

Lecture 18 Hands-On Exercise #5

Lecture 19 Hands-On Exercise #6

Lecture 20 Hands-On Exercise #7

Lecture 21 Hands-On Exercise #8

Lecture 22 Hands-On Exercise #9

Lecture 23 Hands-On Exercise #10

Section 4: Progressing With Data

Lecture 24 Overview

Lecture 25 Text to Columns

Lecture 26 Flash Fill

Lecture 27 Remove Duplicates

Lecture 28 Data Validation

Lecture 29 Consolidate

Lecture 30 What If - Goal Seek

Lecture 31 What If - Scenario

Lecture 32 What If - Data Table

Lecture 33 Forecasts

Section 5: Exercises - Ninja Level 3

Lecture 34 Hands-On Exercise #1

Lecture 35 Hands-On Exercise #2

Lecture 36 Hands-On Exercise #3

Lecture 37 Hands-On Exercise #4

Lecture 38 Hands-On Exercise #5

Lecture 39 Hands-On Exercise #6

Lecture 40 Hands-On Exercise #7

Lecture 41 Hands-On Exercise #8

Lecture 42 Hands-On Exercise #9

Lecture 43 Hands-On Exercise #10

Section 6: Displaying Data

Lecture 44 Overview

Lecture 45 Group

Lecture 46 Subtotal

Lecture 47 Visually Representing Data

Lecture 48 Chart Creation

Lecture 49 Chart Creation II

Lecture 50 Chart Formatting

Lecture 51 Chart Formatting II

Lecture 52 Chart Sparklines

Lecture 53 Combo Chart

Lecture 54 Chart Trendlines

Section 7: Exercises - Ninja Level 4

Lecture 55 Hands-On Exercise #1

Lecture 56 Hands-On Exercise #2

Lecture 57 Hands-On Exercise #3

Lecture 58 Hands-On Exercise #4

Lecture 59 Hands-On Exercise #5

Section 8: Viewing & Printing

Lecture 60 Split Window

Lecture 61 Multiple Windows

Lecture 62 Helpful Printing Views

Lecture 63 Page Break Adjustments

Lecture 64 Including Layout Items

Lecture 65 Exploring Page Setup

Lecture 66 Adding a Header & Footer

Lecture 67 Printing & Printing To File

Section 9: Exercises - Ninja Level 5

Lecture 68 Hands-On Exercise #1

Lecture 69 Hands-On Exercise #2

Lecture 70 Hands-On Exercise #3

Lecture 71 Hands-On Exercise #4

Lecture 72 Hands-On Exercise #5

Lecture 73 Hands-On Exercise #6

Lecture 74 Hands-On Exercise #7

Lecture 75 Hands-On Exercise #8

Section 10: Functions - Logical

Lecture 76 Overview

Lecture 77 NA

Lecture 78 IFNA

Lecture 79 IF

Lecture 80 IFERROR

Lecture 81 TRUE & FALSE

Lecture 82 NOT

Lecture 83 AND

Lecture 84 OR

Lecture 85 XOR

Section 11: Exercises - Ninja Level 6

Lecture 86 Hands-On Exercise #1

Lecture 87 Hands-On Exercise #2

Lecture 88 Hands-On Exercise #3

Lecture 89 Hands-On Exercise #4

Lecture 90 Hands-On Exercise #5

Lecture 91 Hands-On Exercise #6

Section 12: Functions - Text

Lecture 92 Overview

Lecture 93 Capitalization

Lecture 94 Joining Text

Lecture 95 Replacing Text

Lecture 96 Finding Text

Lecture 97 Text Length

Lecture 98 Text Equality

Lecture 99 Trimming Text

Section 13: Exercises - Ninja Level 7

Lecture 100 Hands-On Exercise #1

Lecture 101 Hands-On Exercise #2

Lecture 102 Hands-On Exercise #3

Lecture 103 Hands-On Exercise #4

Lecture 104 Hands-On Exercise #5

Lecture 105 Hands-On Exercise #6

Lecture 106 Hands-On Exercise #7

Section 14: Functions - Date & Time

Lecture 107 Dates & Times

Lecture 108 Current Date Time

Lecture 109 Created Date Time

Lecture 110 Extracting Date Time

Lecture 111 Finding Durations

Lecture 112 Finding The Future

Section 15: Exercises - Ninja Level 8

Lecture 113 Hands-On Exercise #1

Lecture 114 Hands-On Exercise #2

Lecture 115 Hands-On Exercise #3

Lecture 116 Hands-On Exercise #4

Lecture 117 Hands-On Exercise #5

Lecture 118 Hands-On Exercise #2

Section 16: Functions - Lookup & Reference

Lecture 119 Overview

Lecture 120 VLOOKUP

Lecture 121 HLOOKUP

Lecture 122 INDEX

Lecture 123 MATCH

Lecture 124 CHOOSE

Lecture 125 TRANSPOSE

Lecture 126 ROW(S) COLUMN(S)

Lecture 127 References

Section 17: Exercises - Ninja Level 9

Lecture 128 Hands-On Exercise #1

Lecture 129 Hands-On Exercise #2

Lecture 130 Hands-On Exercise #3

Lecture 131 Hands-On Exercise #4

Section 18: Functions - Information

Lecture 132 INFO

Lecture 133 CELL

Lecture 134 ISEVEN & ISODD

Lecture 135 NA & ISNA

Lecture 136 ISERROR & ISERR

Lecture 137 Checking Contents 1

Lecture 138 Checking Contents 2

Lecture 139 Top 10 Functions

Section 19: Exercises - Ninja Level 10

Lecture 140 Hands-On Exercise #1

Lecture 141 Hands-On Exercise #2

Lecture 142 Hands-On Exercise #3

Lecture 143 Hands-On Exercise #4

Section 20: Full Completion

Lecture 144 Overview

Lecture 145 Custom Views

Lecture 146 Conditional Formatting

Lecture 147 Objects & Equations

Lecture 148 Selection Pane

Lecture 149 Translating

Lecture 150 Proofing

Lecture 151 Insights

Section 21: Exercises - Ninja Level 11

Lecture 152 Hands-On Exercise #1

Lecture 153 Hands-On Exercise #2

Lecture 154 Hands-On Exercise #3

Lecture 155 Hands-On Exercise #4

Lecture 156 Hands-On Exercise #5

Lecture 157 Hands-On Exercise #6

Section 22: Office 365

Lecture 158 Cloud Based Apps

Lecture 159 MS Office vs Office 365

Lecture 160 Functions and Charting

Lecture 161 VLOOKUP

Section 23: Exercises - Ninja Level 12

Lecture 162 Hands-On Exercise #1

Lecture 163 Hands-On Exercise #2

Section 24: Google Drive

Lecture 164 Introduction

Lecture 165 Functions & Charting

Lecture 166 VLOOKUP

Section 25: Exercises - Ninja Level 13

Lecture 167 Hands-On Exercise #1

Lecture 168 Hands-On Exercise #2

Section 26: Good To Know

Lecture 169 Protecting Yourself Online

Lecture 170 Scrolling Sheets

Lecture 171 File Extensions

Lecture 172 Ethnocentricity

Lecture 173 Where We’ve Been

Section 27: Congratulations

Lecture 174 Congratulations

Lecture 175 Bonus lecture

This course is for individuals who already have a basic understanding of Microsoft Excel.