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

Gain insight into using Office365 online

Receive an entire bonus 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 onlineReceive an entire bonus section covering Google Drive

As bonus material, you will also be provided with 

a comprehensive set of 72 "hands-on exercises"solutions to all of the "hands-on exercises"

If you need to prove that you have learned the material, or if you are an employer or supervisor that needs to ensure that someone has actually done the work, this is easily done by looking at the results of these "hands-on exercises."

As an additional bonus, you can 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. You will always be able to come back to this Excel class to review material or to learn new material about how to use Excel. 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 learn Microsoft Excel.

Who this course is for:

This course is for intermediate users.

Homepage:

https://www.udemy.com/course/excel-courses/