Progressing With Excel - The Intermediate Excel Tutorial

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course 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 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

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.

Expected Outcomes

  1. 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 Show more Show less 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 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 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. Show more Show less Course content 28 sections • 181 lectures • 15h 51m total length Expand all sections Introduction 6 lectures • 33min Welcome Preview 04:12 Prerequisites Preview 04:24 Understanding Versions 07:49 How To Succeed 09:21 Course Resources 04:38 Accelerate Learning 02:20 Exercises - Ninja Level 1 1 lecture • 7min Hands-On Exercise 06:51 Working With Data 9 lectures • 1hr 4min Acquiring Data 06:46 Importing Text Data 06:56 Sort 06:19 Vlookup Preview 04:56 Freeze frames 04:47 Vlookup & Sort 09:24 Filter 10:23 Advanced Filter 06:27 Find & Replace 08:18 Exercises - Ninja Level 2 10 lectures • 52min Hands-On Exercise #1 06:38 Hands-On Exercise #2 03:19 Hands-On Exercise #3 02:28 Hands-On Exercise #4 08:37 Hands-On Exercise #5 07:29 Hands-On Exercise #6 05:46 Hands-On Exercise #7 06:35 Hands-On Exercise #8 03:16 Hands-On Exercise #9 03:08 Hands-On Exercise #10 04:59 Progressing With Data 10 lectures • 1hr 2min Overview 03:34 Text to Columns 07:34 Flash Fill 06:22 Remove Duplicates Preview 02:28 Data Validation 04:13 Consolidate 04:44 What If - Goal Seek Preview 04:04 What If - Scenario 04:54 What If - Data Table 10:34 Forecasts 13:34 Exercises - Ninja Level 3 10 lectures • 1hr 24min Hands-On Exercise #1 15:20 Hands-On Exercise #2 10:30 Hands-On Exercise #3 04:50 Hands-On Exercise #4 05:31 Hands-On Exercise #5 04:29 Hands-On Exercise #6 07:18 Hands-On Exercise #7 08:10 Hands-On Exercise #8 12:22 Hands-On Exercise #9 06:36 Hands-On Exercise #10 09:07 Displaying Data 11 lectures • 1hr 14min Overview 02:11 Group 09:34 Subtotal 06:20 Visually Representing Data 07:37 Chart Creation Preview 05:42 Chart Creation II 07:57 Chart Formatting 06:57 Chart Formatting II 08:58 Chart Sparklines 05:44 Combo Chart 11:25 Chart Trendlines 01:45 Exercises - Ninja Level 4 5 lectures • 29min Hands-On Exercise #1 08:37 Hands-On Exercise #2 03:10 Hands-On Exercise #3 09:13 Hands-On Exercise #4 04:50 Hands-On Exercise #5 03:30 Viewing & Printing 8 lectures • 33min Split Window 03:40 Multiple Windows 05:38 Helpful Printing Views 04:28 Page Break Adjustments 03:32 Including Layout Items 04:29 Exploring Page Setup 04:33 Adding a Header & Footer 03:48 Printing & Printing To File 03:16 Exercises - Ninja Level 5 8 lectures • 33min Hands-On Exercise #1 03:44 Hands-On Exercise #2 02:54 Hands-On Exercise #3 01:55 Hands-On Exercise #4 02:11 Hands-On Exercise #5 02:03 Hands-On Exercise #6 04:43 Hands-On Exercise #7 05:56 Hands-On Exercise #8 09:27 18 more sections Instructor Todd McLeod Tenured College Professor 4.5 Instructor Rating 49,738 Reviews 335,783 Students 19 Courses I am a tenured professor in California. I have taught at both the college and university level. I have also taught in multiple disciplines including business, information systems, computer science, and online education. In 1997, I was one of the first professors at the university to teach online. I did post-graduate work in online education at UC San Diego. I co-founded and taught in the “Online Teacher’s Training Program” which trained professors how to teach online. In 2008, I was selected as one of the best instructors in the entire California Community College system. Currently, when measured by the number of students served, I am the world’s leading trainer in Google’s new programming language which is one of the fastest growing, highest paying programming languages in America. In addition, I have started three businesses (two of them profitable, so far). My background in business, information systems, computer science, online education, and real-world entrepreneurship has prepared me to teach all of these courses. I look forward to helping you learn great skills to improve your life. Better skills, better life. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678177471ded2c6a',m:'1c6b74c80465aeb63ba8a9c1333a71c2bbbd12c4-1627846070-1800-AT8mHUY26Nrvn2DkMg8f4FeoKLqZGVyUZBb8ULvY/2x9KUZ1kMk43nLlsonfgiu6FLFWTLaHHPkSJncKPazpmZF0IdrN/qLVyd+y/X3UQMH4fwc6SB3pEHRYPVO/Au9d1XJtedLbrDpq+TGZ7nh62CI=',s:[0x377ee022b0,0xbff54d669e],}})();
  2. 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 Show more Show less 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 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 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. Show more Show less Course content 28 sections • 181 lectures • 15h 51m total length Expand all sections Introduction 6 lectures • 33min Welcome Preview 04:12 Prerequisites Preview 04:24 Understanding Versions 07:49 How To Succeed 09:21 Course Resources 04:38 Accelerate Learning 02:20 Exercises - Ninja Level 1 1 lecture • 7min Hands-On Exercise 06:51 Working With Data 9 lectures • 1hr 4min Acquiring Data 06:46 Importing Text Data 06:56 Sort 06:19 Vlookup Preview 04:56 Freeze frames 04:47 Vlookup & Sort 09:24 Filter 10:23 Advanced Filter 06:27 Find & Replace 08:18 Exercises - Ninja Level 2 10 lectures • 52min Hands-On Exercise #1 06:38 Hands-On Exercise #2 03:19 Hands-On Exercise #3 02:28 Hands-On Exercise #4 08:37 Hands-On Exercise #5 07:29 Hands-On Exercise #6 05:46 Hands-On Exercise #7 06:35 Hands-On Exercise #8 03:16 Hands-On Exercise #9 03:08 Hands-On Exercise #10 04:59 Progressing With Data 10 lectures • 1hr 2min Overview 03:34 Text to Columns 07:34 Flash Fill 06:22 Remove Duplicates Preview 02:28 Data Validation 04:13 Consolidate 04:44 What If - Goal Seek Preview 04:04 What If - Scenario 04:54 What If - Data Table 10:34 Forecasts 13:34 Exercises - Ninja Level 3 10 lectures • 1hr 24min Hands-On Exercise #1 15:20 Hands-On Exercise #2 10:30 Hands-On Exercise #3 04:50 Hands-On Exercise #4 05:31 Hands-On Exercise #5 04:29 Hands-On Exercise #6 07:18 Hands-On Exercise #7 08:10 Hands-On Exercise #8 12:22 Hands-On Exercise #9 06:36 Hands-On Exercise #10 09:07 Displaying Data 11 lectures • 1hr 14min Overview 02:11 Group 09:34 Subtotal 06:20 Visually Representing Data 07:37 Chart Creation Preview 05:42 Chart Creation II 07:57 Chart Formatting 06:57 Chart Formatting II 08:58 Chart Sparklines 05:44 Combo Chart 11:25 Chart Trendlines 01:45 Exercises - Ninja Level 4 5 lectures • 29min Hands-On Exercise #1 08:37 Hands-On Exercise #2 03:10 Hands-On Exercise #3 09:13 Hands-On Exercise #4 04:50 Hands-On Exercise #5 03:30 Viewing & Printing 8 lectures • 33min Split Window 03:40 Multiple Windows 05:38 Helpful Printing Views 04:28 Page Break Adjustments 03:32 Including Layout Items 04:29 Exploring Page Setup 04:33 Adding a Header & Footer 03:48 Printing & Printing To File 03:16 Exercises - Ninja Level 5 8 lectures • 33min Hands-On Exercise #1 03:44 Hands-On Exercise #2 02:54 Hands-On Exercise #3 01:55 Hands-On Exercise #4 02:11 Hands-On Exercise #5 02:03 Hands-On Exercise #6 04:43 Hands-On Exercise #7 05:56 Hands-On Exercise #8 09:27 18 more sections Instructor Todd McLeod Tenured College Professor 4.5 Instructor Rating 49,738 Reviews 335,783 Students 19 Courses I am a tenured professor in California. I have taught at both the college and university level. I have also taught in multiple disciplines including business, information systems, computer science, and online education. In 1997, I was one of the first professors at the university to teach online. I did post-graduate work in online education at UC San Diego. I co-founded and taught in the “Online Teacher’s Training Program” which trained professors how to teach online. In 2008, I was selected as one of the best instructors in the entire California Community College system. Currently, when measured by the number of students served, I am the world’s leading trainer in Google’s new programming language which is one of the fastest growing, highest paying programming languages in America. In addition, I have started three businesses (two of them profitable, so far). My background in business, information systems, computer science, online education, and real-world entrepreneurship has prepared me to teach all of these courses. I look forward to helping you learn great skills to improve your life. Better skills, better life. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678177471ded2c6a',m:'1c6b74c80465aeb63ba8a9c1333a71c2bbbd12c4-1627846070-1800-AT8mHUY26Nrvn2DkMg8f4FeoKLqZGVyUZBb8ULvY/2x9KUZ1kMk43nLlsonfgiu6FLFWTLaHHPkSJncKPazpmZF0IdrN/qLVyd+y/X3UQMH4fwc6SB3pEHRYPVO/Au9d1XJtedLbrDpq+TGZ7nh62CI=',s:[0x377ee022b0,0xbff54d669e],}})();
  3. 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 Show more Show less 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 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 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. Show more Show less Course content 28 sections • 181 lectures • 15h 51m total length Expand all sections Introduction 6 lectures • 33min Welcome Preview 04:12 Prerequisites Preview 04:24 Understanding Versions 07:49 How To Succeed 09:21 Course Resources 04:38 Accelerate Learning 02:20 Exercises - Ninja Level 1 1 lecture • 7min Hands-On Exercise 06:51 Working With Data 9 lectures • 1hr 4min Acquiring Data 06:46 Importing Text Data 06:56 Sort 06:19 Vlookup Preview 04:56 Freeze frames 04:47 Vlookup & Sort 09:24 Filter 10:23 Advanced Filter 06:27 Find & Replace 08:18 Exercises - Ninja Level 2 10 lectures • 52min Hands-On Exercise #1 06:38 Hands-On Exercise #2 03:19 Hands-On Exercise #3 02:28 Hands-On Exercise #4 08:37 Hands-On Exercise #5 07:29 Hands-On Exercise #6 05:46 Hands-On Exercise #7 06:35 Hands-On Exercise #8 03:16 Hands-On Exercise #9 03:08 Hands-On Exercise #10 04:59 Progressing With Data 10 lectures • 1hr 2min Overview 03:34 Text to Columns 07:34 Flash Fill 06:22 Remove Duplicates Preview 02:28 Data Validation 04:13 Consolidate 04:44 What If - Goal Seek Preview 04:04 What If - Scenario 04:54 What If - Data Table 10:34 Forecasts 13:34 Exercises - Ninja Level 3 10 lectures • 1hr 24min Hands-On Exercise #1 15:20 Hands-On Exercise #2 10:30 Hands-On Exercise #3 04:50 Hands-On Exercise #4 05:31 Hands-On Exercise #5 04:29 Hands-On Exercise #6 07:18 Hands-On Exercise #7 08:10 Hands-On Exercise #8 12:22 Hands-On Exercise #9 06:36 Hands-On Exercise #10 09:07 Displaying Data 11 lectures • 1hr 14min Overview 02:11 Group 09:34 Subtotal 06:20 Visually Representing Data 07:37 Chart Creation Preview 05:42 Chart Creation II 07:57 Chart Formatting 06:57 Chart Formatting II 08:58 Chart Sparklines 05:44 Combo Chart 11:25 Chart Trendlines 01:45 Exercises - Ninja Level 4 5 lectures • 29min Hands-On Exercise #1 08:37 Hands-On Exercise #2 03:10 Hands-On Exercise #3 09:13 Hands-On Exercise #4 04:50 Hands-On Exercise #5 03:30 Viewing & Printing 8 lectures • 33min Split Window 03:40 Multiple Windows 05:38 Helpful Printing Views 04:28 Page Break Adjustments 03:32 Including Layout Items 04:29 Exploring Page Setup 04:33 Adding a Header & Footer 03:48 Printing & Printing To File 03:16 Exercises - Ninja Level 5 8 lectures • 33min Hands-On Exercise #1 03:44 Hands-On Exercise #2 02:54 Hands-On Exercise #3 01:55 Hands-On Exercise #4 02:11 Hands-On Exercise #5 02:03 Hands-On Exercise #6 04:43 Hands-On Exercise #7 05:56 Hands-On Exercise #8 09:27 18 more sections Instructor Todd McLeod Tenured College Professor 4.5 Instructor Rating 49,738 Reviews 335,783 Students 19 Courses I am a tenured professor in California. I have taught at both the college and university level. I have also taught in multiple disciplines including business, information systems, computer science, and online education. In 1997, I was one of the first professors at the university to teach online. I did post-graduate work in online education at UC San Diego. I co-founded and taught in the “Online Teacher’s Training Program” which trained professors how to teach online. In 2008, I was selected as one of the best instructors in the entire California Community College system. Currently, when measured by the number of students served, I am the world’s leading trainer in Google’s new programming language which is one of the fastest growing, highest paying programming languages in America. In addition, I have started three businesses (two of them profitable, so far). My background in business, information systems, computer science, online education, and real-world entrepreneurship has prepared me to teach all of these courses. I look forward to helping you learn great skills to improve your life. Better skills, better life. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678177471ded2c6a',m:'1c6b74c80465aeb63ba8a9c1333a71c2bbbd12c4-1627846070-1800-AT8mHUY26Nrvn2DkMg8f4FeoKLqZGVyUZBb8ULvY/2x9KUZ1kMk43nLlsonfgiu6FLFWTLaHHPkSJncKPazpmZF0IdrN/qLVyd+y/X3UQMH4fwc6SB3pEHRYPVO/Au9d1XJtedLbrDpq+TGZ7nh62CI=',s:[0x377ee022b0,0xbff54d669e],}})();
  4. 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 Show more Show less 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 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 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. Show more Show less Course content 28 sections • 181 lectures • 15h 51m total length Expand all sections Introduction 6 lectures • 33min Welcome Preview 04:12 Prerequisites Preview 04:24 Understanding Versions 07:49 How To Succeed 09:21 Course Resources 04:38 Accelerate Learning 02:20 Exercises - Ninja Level 1 1 lecture • 7min Hands-On Exercise 06:51 Working With Data 9 lectures • 1hr 4min Acquiring Data 06:46 Importing Text Data 06:56 Sort 06:19 Vlookup Preview 04:56 Freeze frames 04:47 Vlookup & Sort 09:24 Filter 10:23 Advanced Filter 06:27 Find & Replace 08:18 Exercises - Ninja Level 2 10 lectures • 52min Hands-On Exercise #1 06:38 Hands-On Exercise #2 03:19 Hands-On Exercise #3 02:28 Hands-On Exercise #4 08:37 Hands-On Exercise #5 07:29 Hands-On Exercise #6 05:46 Hands-On Exercise #7 06:35 Hands-On Exercise #8 03:16 Hands-On Exercise #9 03:08 Hands-On Exercise #10 04:59 Progressing With Data 10 lectures • 1hr 2min Overview 03:34 Text to Columns 07:34 Flash Fill 06:22 Remove Duplicates Preview 02:28 Data Validation 04:13 Consolidate 04:44 What If - Goal Seek Preview 04:04 What If - Scenario 04:54 What If - Data Table 10:34 Forecasts 13:34 Exercises - Ninja Level 3 10 lectures • 1hr 24min Hands-On Exercise #1 15:20 Hands-On Exercise #2 10:30 Hands-On Exercise #3 04:50 Hands-On Exercise #4 05:31 Hands-On Exercise #5 04:29 Hands-On Exercise #6 07:18 Hands-On Exercise #7 08:10 Hands-On Exercise #8 12:22 Hands-On Exercise #9 06:36 Hands-On Exercise #10 09:07 Displaying Data 11 lectures • 1hr 14min Overview 02:11 Group 09:34 Subtotal 06:20 Visually Representing Data 07:37 Chart Creation Preview 05:42 Chart Creation II 07:57 Chart Formatting 06:57 Chart Formatting II 08:58 Chart Sparklines 05:44 Combo Chart 11:25 Chart Trendlines 01:45 Exercises - Ninja Level 4 5 lectures • 29min Hands-On Exercise #1 08:37 Hands-On Exercise #2 03:10 Hands-On Exercise #3 09:13 Hands-On Exercise #4 04:50 Hands-On Exercise #5 03:30 Viewing & Printing 8 lectures • 33min Split Window 03:40 Multiple Windows 05:38 Helpful Printing Views 04:28 Page Break Adjustments 03:32 Including Layout Items 04:29 Exploring Page Setup 04:33 Adding a Header & Footer 03:48 Printing & Printing To File 03:16 Exercises - Ninja Level 5 8 lectures • 33min Hands-On Exercise #1 03:44 Hands-On Exercise #2 02:54 Hands-On Exercise #3 01:55 Hands-On Exercise #4 02:11 Hands-On Exercise #5 02:03 Hands-On Exercise #6 04:43 Hands-On Exercise #7 05:56 Hands-On Exercise #8 09:27 18 more sections Instructor Todd McLeod Tenured College Professor 4.5 Instructor Rating 49,738 Reviews 335,783 Students 19 Courses I am a tenured professor in California. I have taught at both the college and university level. I have also taught in multiple disciplines including business, information systems, computer science, and online education. In 1997, I was one of the first professors at the university to teach online. I did post-graduate work in online education at UC San Diego. I co-founded and taught in the “Online Teacher’s Training Program” which trained professors how to teach online. In 2008, I was selected as one of the best instructors in the entire California Community College system. Currently, when measured by the number of students served, I am the world’s leading trainer in Google’s new programming language which is one of the fastest growing, highest paying programming languages in America. In addition, I have started three businesses (two of them profitable, so far). My background in business, information systems, computer science, online education, and real-world entrepreneurship has prepared me to teach all of these courses. I look forward to helping you learn great skills to improve your life. Better skills, better life. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678177471ded2c6a',m:'1c6b74c80465aeb63ba8a9c1333a71c2bbbd12c4-1627846070-1800-AT8mHUY26Nrvn2DkMg8f4FeoKLqZGVyUZBb8ULvY/2x9KUZ1kMk43nLlsonfgiu6FLFWTLaHHPkSJncKPazpmZF0IdrN/qLVyd+y/X3UQMH4fwc6SB3pEHRYPVO/Au9d1XJtedLbrDpq+TGZ7nh62CI=',s:[0x377ee022b0,0xbff54d669e],}})();
  5. 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 Show more Show less 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 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 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. Show more Show less Course content 28 sections • 181 lectures • 15h 51m total length Expand all sections Introduction 6 lectures • 33min Welcome Preview 04:12 Prerequisites Preview 04:24 Understanding Versions 07:49 How To Succeed 09:21 Course Resources 04:38 Accelerate Learning 02:20 Exercises - Ninja Level 1 1 lecture • 7min Hands-On Exercise 06:51 Working With Data 9 lectures • 1hr 4min Acquiring Data 06:46 Importing Text Data 06:56 Sort 06:19 Vlookup Preview 04:56 Freeze frames 04:47 Vlookup & Sort 09:24 Filter 10:23 Advanced Filter 06:27 Find & Replace 08:18 Exercises - Ninja Level 2 10 lectures • 52min Hands-On Exercise #1 06:38 Hands-On Exercise #2 03:19 Hands-On Exercise #3 02:28 Hands-On Exercise #4 08:37 Hands-On Exercise #5 07:29 Hands-On Exercise #6 05:46 Hands-On Exercise #7 06:35 Hands-On Exercise #8 03:16 Hands-On Exercise #9 03:08 Hands-On Exercise #10 04:59 Progressing With Data 10 lectures • 1hr 2min Overview 03:34 Text to Columns 07:34 Flash Fill 06:22 Remove Duplicates Preview 02:28 Data Validation 04:13 Consolidate 04:44 What If - Goal Seek Preview 04:04 What If - Scenario 04:54 What If - Data Table 10:34 Forecasts 13:34 Exercises - Ninja Level 3 10 lectures • 1hr 24min Hands-On Exercise #1 15:20 Hands-On Exercise #2 10:30 Hands-On Exercise #3 04:50 Hands-On Exercise #4 05:31 Hands-On Exercise #5 04:29 Hands-On Exercise #6 07:18 Hands-On Exercise #7 08:10 Hands-On Exercise #8 12:22 Hands-On Exercise #9 06:36 Hands-On Exercise #10 09:07 Displaying Data 11 lectures • 1hr 14min Overview 02:11 Group 09:34 Subtotal 06:20 Visually Representing Data 07:37 Chart Creation Preview 05:42 Chart Creation II 07:57 Chart Formatting 06:57 Chart Formatting II 08:58 Chart Sparklines 05:44 Combo Chart 11:25 Chart Trendlines 01:45 Exercises - Ninja Level 4 5 lectures • 29min Hands-On Exercise #1 08:37 Hands-On Exercise #2 03:10 Hands-On Exercise #3 09:13 Hands-On Exercise #4 04:50 Hands-On Exercise #5 03:30 Viewing & Printing 8 lectures • 33min Split Window 03:40 Multiple Windows 05:38 Helpful Printing Views 04:28 Page Break Adjustments 03:32 Including Layout Items 04:29 Exploring Page Setup 04:33 Adding a Header & Footer 03:48 Printing & Printing To File 03:16 Exercises - Ninja Level 5 8 lectures • 33min Hands-On Exercise #1 03:44 Hands-On Exercise #2 02:54 Hands-On Exercise #3 01:55 Hands-On Exercise #4 02:11 Hands-On Exercise #5 02:03 Hands-On Exercise #6 04:43 Hands-On Exercise #7 05:56 Hands-On Exercise #8 09:27 18 more sections Instructor Todd McLeod Tenured College Professor 4.5 Instructor Rating 49,738 Reviews 335,783 Students 19 Courses I am a tenured professor in California. I have taught at both the college and university level. I have also taught in multiple disciplines including business, information systems, computer science, and online education. In 1997, I was one of the first professors at the university to teach online. I did post-graduate work in online education at UC San Diego. I co-founded and taught in the “Online Teacher’s Training Program” which trained professors how to teach online. In 2008, I was selected as one of the best instructors in the entire California Community College system. Currently, when measured by the number of students served, I am the world’s leading trainer in Google’s new programming language which is one of the fastest growing, highest paying programming languages in America. In addition, I have started three businesses (two of them profitable, so far). My background in business, information systems, computer science, online education, and real-world entrepreneurship has prepared me to teach all of these courses. I look forward to helping you learn great skills to improve your life. Better skills, better life. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678177471ded2c6a',m:'1c6b74c80465aeb63ba8a9c1333a71c2bbbd12c4-1627846070-1800-AT8mHUY26Nrvn2DkMg8f4FeoKLqZGVyUZBb8ULvY/2x9KUZ1kMk43nLlsonfgiu6FLFWTLaHHPkSJncKPazpmZF0IdrN/qLVyd+y/X3UQMH4fwc6SB3pEHRYPVO/Au9d1XJtedLbrDpq+TGZ7nh62CI=',s:[0x377ee022b0,0xbff54d669e],}})();
  6. 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 Show more Show less 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 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 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. Show more Show less Course content 28 sections • 181 lectures • 15h 51m total length Expand all sections Introduction 6 lectures • 33min Welcome Preview 04:12 Prerequisites Preview 04:24 Understanding Versions 07:49 How To Succeed 09:21 Course Resources 04:38 Accelerate Learning 02:20 Exercises - Ninja Level 1 1 lecture • 7min Hands-On Exercise 06:51 Working With Data 9 lectures • 1hr 4min Acquiring Data 06:46 Importing Text Data 06:56 Sort 06:19 Vlookup Preview 04:56 Freeze frames 04:47 Vlookup & Sort 09:24 Filter 10:23 Advanced Filter 06:27 Find & Replace 08:18 Exercises - Ninja Level 2 10 lectures • 52min Hands-On Exercise #1 06:38 Hands-On Exercise #2 03:19 Hands-On Exercise #3 02:28 Hands-On Exercise #4 08:37 Hands-On Exercise #5 07:29 Hands-On Exercise #6 05:46 Hands-On Exercise #7 06:35 Hands-On Exercise #8 03:16 Hands-On Exercise #9 03:08 Hands-On Exercise #10 04:59 Progressing With Data 10 lectures • 1hr 2min Overview 03:34 Text to Columns 07:34 Flash Fill 06:22 Remove Duplicates Preview 02:28 Data Validation 04:13 Consolidate 04:44 What If - Goal Seek Preview 04:04 What If - Scenario 04:54 What If - Data Table 10:34 Forecasts 13:34 Exercises - Ninja Level 3 10 lectures • 1hr 24min Hands-On Exercise #1 15:20 Hands-On Exercise #2 10:30 Hands-On Exercise #3 04:50 Hands-On Exercise #4 05:31 Hands-On Exercise #5 04:29 Hands-On Exercise #6 07:18 Hands-On Exercise #7 08:10 Hands-On Exercise #8 12:22 Hands-On Exercise #9 06:36 Hands-On Exercise #10 09:07 Displaying Data 11 lectures • 1hr 14min Overview 02:11 Group 09:34 Subtotal 06:20 Visually Representing Data 07:37 Chart Creation Preview 05:42 Chart Creation II 07:57 Chart Formatting 06:57 Chart Formatting II 08:58 Chart Sparklines 05:44 Combo Chart 11:25 Chart Trendlines 01:45 Exercises - Ninja Level 4 5 lectures • 29min Hands-On Exercise #1 08:37 Hands-On Exercise #2 03:10 Hands-On Exercise #3 09:13 Hands-On Exercise #4 04:50 Hands-On Exercise #5 03:30 Viewing & Printing 8 lectures • 33min Split Window 03:40 Multiple Windows 05:38 Helpful Printing Views 04:28 Page Break Adjustments 03:32 Including Layout Items 04:29 Exploring Page Setup 04:33 Adding a Header & Footer 03:48 Printing & Printing To File 03:16 Exercises - Ninja Level 5 8 lectures • 33min Hands-On Exercise #1 03:44 Hands-On Exercise #2 02:54 Hands-On Exercise #3 01:55 Hands-On Exercise #4 02:11 Hands-On Exercise #5 02:03 Hands-On Exercise #6 04:43 Hands-On Exercise #7 05:56 Hands-On Exercise #8 09:27 18 more sections Instructor Todd McLeod Tenured College Professor 4.5 Instructor Rating 49,738 Reviews 335,783 Students 19 Courses I am a tenured professor in California. I have taught at both the college and university level. I have also taught in multiple disciplines including business, information systems, computer science, and online education. In 1997, I was one of the first professors at the university to teach online. I did post-graduate work in online education at UC San Diego. I co-founded and taught in the “Online Teacher’s Training Program” which trained professors how to teach online. In 2008, I was selected as one of the best instructors in the entire California Community College system. Currently, when measured by the number of students served, I am the world’s leading trainer in Google’s new programming language which is one of the fastest growing, highest paying programming languages in America. In addition, I have started three businesses (two of them profitable, so far). My background in business, information systems, computer science, online education, and real-world entrepreneurship has prepared me to teach all of these courses. I look forward to helping you learn great skills to improve your life. Better skills, better life. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678177471ded2c6a',m:'1c6b74c80465aeb63ba8a9c1333a71c2bbbd12c4-1627846070-1800-AT8mHUY26Nrvn2DkMg8f4FeoKLqZGVyUZBb8ULvY/2x9KUZ1kMk43nLlsonfgiu6FLFWTLaHHPkSJncKPazpmZF0IdrN/qLVyd+y/X3UQMH4fwc6SB3pEHRYPVO/Au9d1XJtedLbrDpq+TGZ7nh62CI=',s:[0x377ee022b0,0xbff54d669e],}})();
  7. 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 Show more Show less 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 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 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. Show more Show less Course content 28 sections • 181 lectures • 15h 51m total length Expand all sections Introduction 6 lectures • 33min Welcome Preview 04:12 Prerequisites Preview 04:24 Understanding Versions 07:49 How To Succeed 09:21 Course Resources 04:38 Accelerate Learning 02:20 Exercises - Ninja Level 1 1 lecture • 7min Hands-On Exercise 06:51 Working With Data 9 lectures • 1hr 4min Acquiring Data 06:46 Importing Text Data 06:56 Sort 06:19 Vlookup Preview 04:56 Freeze frames 04:47 Vlookup & Sort 09:24 Filter 10:23 Advanced Filter 06:27 Find & Replace 08:18 Exercises - Ninja Level 2 10 lectures • 52min Hands-On Exercise #1 06:38 Hands-On Exercise #2 03:19 Hands-On Exercise #3 02:28 Hands-On Exercise #4 08:37 Hands-On Exercise #5 07:29 Hands-On Exercise #6 05:46 Hands-On Exercise #7 06:35 Hands-On Exercise #8 03:16 Hands-On Exercise #9 03:08 Hands-On Exercise #10 04:59 Progressing With Data 10 lectures • 1hr 2min Overview 03:34 Text to Columns 07:34 Flash Fill 06:22 Remove Duplicates Preview 02:28 Data Validation 04:13 Consolidate 04:44 What If - Goal Seek Preview 04:04 What If - Scenario 04:54 What If - Data Table 10:34 Forecasts 13:34 Exercises - Ninja Level 3 10 lectures • 1hr 24min Hands-On Exercise #1 15:20 Hands-On Exercise #2 10:30 Hands-On Exercise #3 04:50 Hands-On Exercise #4 05:31 Hands-On Exercise #5 04:29 Hands-On Exercise #6 07:18 Hands-On Exercise #7 08:10 Hands-On Exercise #8 12:22 Hands-On Exercise #9 06:36 Hands-On Exercise #10 09:07 Displaying Data 11 lectures • 1hr 14min Overview 02:11 Group 09:34 Subtotal 06:20 Visually Representing Data 07:37 Chart Creation Preview 05:42 Chart Creation II 07:57 Chart Formatting 06:57 Chart Formatting II 08:58 Chart Sparklines 05:44 Combo Chart 11:25 Chart Trendlines 01:45 Exercises - Ninja Level 4 5 lectures • 29min Hands-On Exercise #1 08:37 Hands-On Exercise #2 03:10 Hands-On Exercise #3 09:13 Hands-On Exercise #4 04:50 Hands-On Exercise #5 03:30 Viewing & Printing 8 lectures • 33min Split Window 03:40 Multiple Windows 05:38 Helpful Printing Views 04:28 Page Break Adjustments 03:32 Including Layout Items 04:29 Exploring Page Setup 04:33 Adding a Header & Footer 03:48 Printing & Printing To File 03:16 Exercises - Ninja Level 5 8 lectures • 33min Hands-On Exercise #1 03:44 Hands-On Exercise #2 02:54 Hands-On Exercise #3 01:55 Hands-On Exercise #4 02:11 Hands-On Exercise #5 02:03 Hands-On Exercise #6 04:43 Hands-On Exercise #7 05:56 Hands-On Exercise #8 09:27 18 more sections Instructor Todd McLeod Tenured College Professor 4.5 Instructor Rating 49,738 Reviews 335,783 Students 19 Courses I am a tenured professor in California. I have taught at both the college and university level. I have also taught in multiple disciplines including business, information systems, computer science, and online education. In 1997, I was one of the first professors at the university to teach online. I did post-graduate work in online education at UC San Diego. I co-founded and taught in the “Online Teacher’s Training Program” which trained professors how to teach online. In 2008, I was selected as one of the best instructors in the entire California Community College system. Currently, when measured by the number of students served, I am the world’s leading trainer in Google’s new programming language which is one of the fastest growing, highest paying programming languages in America. In addition, I have started three businesses (two of them profitable, so far). My background in business, information systems, computer science, online education, and real-world entrepreneurship has prepared me to teach all of these courses. I look forward to helping you learn great skills to improve your life. Better skills, better life. Show more Show less