Learn Excel - The Excel Tutorial for Beginners

  • 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 provides a solid introduction to the fundamental skills necessary to use Microsoft Excel. 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 92 video lectures, including 45 hands-on exercises, you will learn all of the following about Microsoft Excel:

  • Learn how to navigate around Excel

  • Learn how to enter and edit data in Excel

  • Learn how to adjust the way data and information are displayed in Excel

  • Learn how to write formulas quickly and easily with the point-and-click method

  • Learn how to use relative, absolute, and mixed references in Excel

  • Learn how to create powerful calculations with Excel functions

  • Learn how to format worksheets in Excel for impact and appeal

  • Learn how to "transpose data" - switching the columns and rows in Excel

  • Learn how to use "paste special" to copy data from the web and get it into Excel

  • Learn how to insert pictures, shapes, word art, symbols, hierarchy charts & relationship charts

  • Learn how to include hyperlinks to external resources and call-out text boxes

  • Learn tips and tricks about Excel, as well as Excel shortcuts

As bonus material, you will also be provided with

  • a comprehensive set of 45 "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 teach you Microsoft Excel. 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 beginners
  • Learn how to enter and edit data in Excel Learn how to adjust the way data and information are displayed in Excel Learn how to write formulas quickly and easily with the point-and-click method Learn how to use relative, absolute, and mixed references in Excel Learn how to create powerful calculations with Excel functions Learn how to format worksheets in Excel for impact and appeal Learn how to "transpose data" - switching the columns and rows in Excel Learn how to use "paste special" to copy data from the web and get it into Excel Learn how to insert pictures, shapes, word art, symbols, hierarchy charts & relationship charts Learn how to include hyperlinks to external resources and call-out text boxes Learn tips and tricks about Excel, as well as Excel shortcuts Learn the fundamentals of using Microsoft Excel 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 provides a solid introduction to the fundamental skills necessary to use Microsoft Excel. 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 92 video lectures, including 45 hands-on exercises, you will learn all of the following about Microsoft Excel: Learn how to navigate around Excel Learn how to enter and edit data in Excel Learn how to adjust the way data and information are displayed in Excel Learn how to write formulas quickly and easily with the point-and-click method Learn how to use relative, absolute, and mixed references in Excel Learn how to create powerful calculations with Excel functions Learn how to format worksheets in Excel for impact and appeal Learn how to " transpose data " - switching the columns and rows in Excel Learn how to use "paste special" to copy data from the web and get it into Excel Learn how to insert pictures, shapes, word art, symbols, hierarchy charts & relationship charts Learn how to include hyperlinks to external resources and call-out text boxes Learn tips and tricks about Excel, as well as Excel shortcuts As bonus material, you will also be provided with a comprehensive set of 45 "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 teach you Microsoft Excel. 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 beginners Show more Show less Course content 13 sections • 93 lectures • 8h 24m total length Expand all sections Introduction 6 lectures • 34min Welcome Preview 04:09 Understanding Spreadsheets Preview 05:47 Understanding Versions 07:49 How To Succeed 09:21 Course Resources 04:38 Accelerate Learning 02:20 Exercises - Ninja Level 1 5 lectures • 23min Quiz - Introduction Preview 04:27 Hands-on Exercise #1 02:20 Hands-on Exercise #2 04:12 Hands-on Exercise #3 05:24 Hands-on Exercise #4 06:51 Writing Formulas 6 lectures • 40min Workbooks and Worksheets Preview 06:16 Finding Your Way Around Excel 06:37 Mouse Pointer Awareness 05:12 Writing Formulas 11:23 Relative, Absolute, & Mixed References Preview 05:39 Ranges & Names 05:20 Exercises - Ninja Level 2 11 lectures • 51min Quiz - Getting Started 03:22 Hands-On Exercise #1 04:01 Hands-On Exercise #2 01:27 Hands-On Exercise #3 02:52 Hands-On Exercise #4 02:03 Hands-On Exercise #5 03:23 Hands-On Exercise #6 Preview 05:27 Hands-On Exercise #7 05:44 Hands-On Exercise #8 06:28 Hands-On Exercise #9 07:37 Hands-On Exercise #10 08:17 Formatting 9 lectures • 46min Overview 03:19 Content & Form Preview 04:49 Format Cells - Number 07:18 Format Cells - Alignment 07:28 Format Cells - Font 06:37 Format Cells - Border 02:47 Format Cells - Fill 04:48 Clear Formats 06:24 Format As Table 02:11 Exercises - Ninja Level 3 7 lectures • 43min Hands-On Exercise #1 05:17 Hands-On Exercise #2 03:40 Hands-On Exercise #3 04:38 Hands-On Exercise #4 08:06 Hands-On Exercise #5 02:27 Hands-On Exercise #6 05:54 Hands-On Exercise #7 13:08 Home & Insert 10 lectures • 51min Overview 02:56 Copy As Picture 02:59 Paste 06:40 Paste Special 04:07 Format Columns & Rows 04:57 Styles 03:12 Pictures & Shapes 06:20 Smart Art, Word Art, & Symbol 10:28 Link & Text Box 06:31 Add-Ins 02:48 Exercises - Ninja Level 4 9 lectures • 57min Hands-On Exercise #1 01:25 Hands-On Exercise #2 08:42 Hands-On Exercise #3 10:17 Hands-On Exercise #4 08:12 Hands-On Exercise #5 07:30 Hands-On Exercise #6 03:00 Hands-On Exercise #7 05:45 Hands-On Exercise #8 05:09 Hands-On Exercise #9 07:09 Layout Essentials 6 lectures • 41min Overview 10:15 Background 08:56 Stacking Order 03:22 Align, Group, Rotate 03:31 Zooming In & Out 02:58 Templates 12:24 Exercises - Ninja Level 5 5 lectures • 10min Hands-On Exercise #1 01:29 Hands-On Exercise #2 00:58 Hands-On Exercise #3 04:20 Hands-On Exercise #4 02:03 Hands-On Exercise #5 01:16 3 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:'67814a13abcee634',m:'b89f619af716312ba930d8e7204947e61c10ac12-1627844218-1800-AZTxD4h6iF7VuGPHUlihHkcv4o9Q2fhMxyuLLo2fvaLophcFgbjhZDF0SR+1q93X0SRrh6YMOuAfcmkb9mBFlOx+plpjnZqJ8gQlXPCxOCx5faDBu3l0ryQFGgWGPaB1f0PUQIUX/iX7l/CdiDkbF1MuGvQTY7zDUK4svwl6aOyz',s:[0xffbc5e9f4a,0x968d4f1990],}})();
  • Learn how to adjust the way data and information are displayed in Excel Learn how to write formulas quickly and easily with the point-and-click method Learn how to use relative, absolute, and mixed references in Excel Learn how to create powerful calculations with Excel functions Learn how to format worksheets in Excel for impact and appeal Learn how to "transpose data" - switching the columns and rows in Excel Learn how to use "paste special" to copy data from the web and get it into Excel Learn how to insert pictures, shapes, word art, symbols, hierarchy charts & relationship charts Learn how to include hyperlinks to external resources and call-out text boxes Learn tips and tricks about Excel, as well as Excel shortcuts Learn the fundamentals of using Microsoft Excel 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 provides a solid introduction to the fundamental skills necessary to use Microsoft Excel. 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 92 video lectures, including 45 hands-on exercises, you will learn all of the following about Microsoft Excel: Learn how to navigate around Excel Learn how to enter and edit data in Excel Learn how to adjust the way data and information are displayed in Excel Learn how to write formulas quickly and easily with the point-and-click method Learn how to use relative, absolute, and mixed references in Excel Learn how to create powerful calculations with Excel functions Learn how to format worksheets in Excel for impact and appeal Learn how to " transpose data " - switching the columns and rows in Excel Learn how to use "paste special" to copy data from the web and get it into Excel Learn how to insert pictures, shapes, word art, symbols, hierarchy charts & relationship charts Learn how to include hyperlinks to external resources and call-out text boxes Learn tips and tricks about Excel, as well as Excel shortcuts As bonus material, you will also be provided with a comprehensive set of 45 "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 teach you Microsoft Excel. 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 beginners Show more Show less Course content 13 sections • 93 lectures • 8h 24m total length Expand all sections Introduction 6 lectures • 34min Welcome Preview 04:09 Understanding Spreadsheets Preview 05:47 Understanding Versions 07:49 How To Succeed 09:21 Course Resources 04:38 Accelerate Learning 02:20 Exercises - Ninja Level 1 5 lectures • 23min Quiz - Introduction Preview 04:27 Hands-on Exercise #1 02:20 Hands-on Exercise #2 04:12 Hands-on Exercise #3 05:24 Hands-on Exercise #4 06:51 Writing Formulas 6 lectures • 40min Workbooks and Worksheets Preview 06:16 Finding Your Way Around Excel 06:37 Mouse Pointer Awareness 05:12 Writing Formulas 11:23 Relative, Absolute, & Mixed References Preview 05:39 Ranges & Names 05:20 Exercises - Ninja Level 2 11 lectures • 51min Quiz - Getting Started 03:22 Hands-On Exercise #1 04:01 Hands-On Exercise #2 01:27 Hands-On Exercise #3 02:52 Hands-On Exercise #4 02:03 Hands-On Exercise #5 03:23 Hands-On Exercise #6 Preview 05:27 Hands-On Exercise #7 05:44 Hands-On Exercise #8 06:28 Hands-On Exercise #9 07:37 Hands-On Exercise #10 08:17 Formatting 9 lectures • 46min Overview 03:19 Content & Form Preview 04:49 Format Cells - Number 07:18 Format Cells - Alignment 07:28 Format Cells - Font 06:37 Format Cells - Border 02:47 Format Cells - Fill 04:48 Clear Formats 06:24 Format As Table 02:11 Exercises - Ninja Level 3 7 lectures • 43min Hands-On Exercise #1 05:17 Hands-On Exercise #2 03:40 Hands-On Exercise #3 04:38 Hands-On Exercise #4 08:06 Hands-On Exercise #5 02:27 Hands-On Exercise #6 05:54 Hands-On Exercise #7 13:08 Home & Insert 10 lectures • 51min Overview 02:56 Copy As Picture 02:59 Paste 06:40 Paste Special 04:07 Format Columns & Rows 04:57 Styles 03:12 Pictures & Shapes 06:20 Smart Art, Word Art, & Symbol 10:28 Link & Text Box 06:31 Add-Ins 02:48 Exercises - Ninja Level 4 9 lectures • 57min Hands-On Exercise #1 01:25 Hands-On Exercise #2 08:42 Hands-On Exercise #3 10:17 Hands-On Exercise #4 08:12 Hands-On Exercise #5 07:30 Hands-On Exercise #6 03:00 Hands-On Exercise #7 05:45 Hands-On Exercise #8 05:09 Hands-On Exercise #9 07:09 Layout Essentials 6 lectures • 41min Overview 10:15 Background 08:56 Stacking Order 03:22 Align, Group, Rotate 03:31 Zooming In & Out 02:58 Templates 12:24 Exercises - Ninja Level 5 5 lectures • 10min Hands-On Exercise #1 01:29 Hands-On Exercise #2 00:58 Hands-On Exercise #3 04:20 Hands-On Exercise #4 02:03 Hands-On Exercise #5 01:16 3 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:'67814a13abcee634',m:'b89f619af716312ba930d8e7204947e61c10ac12-1627844218-1800-AZTxD4h6iF7VuGPHUlihHkcv4o9Q2fhMxyuLLo2fvaLophcFgbjhZDF0SR+1q93X0SRrh6YMOuAfcmkb9mBFlOx+plpjnZqJ8gQlXPCxOCx5faDBu3l0ryQFGgWGPaB1f0PUQIUX/iX7l/CdiDkbF1MuGvQTY7zDUK4svwl6aOyz',s:[0xffbc5e9f4a,0x968d4f1990],}})();
  • Learn how to write formulas quickly and easily with the point-and-click method Learn how to use relative, absolute, and mixed references in Excel Learn how to create powerful calculations with Excel functions Learn how to format worksheets in Excel for impact and appeal Learn how to "transpose data" - switching the columns and rows in Excel Learn how to use "paste special" to copy data from the web and get it into Excel Learn how to insert pictures, shapes, word art, symbols, hierarchy charts & relationship charts Learn how to include hyperlinks to external resources and call-out text boxes Learn tips and tricks about Excel, as well as Excel shortcuts Learn the fundamentals of using Microsoft Excel 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 provides a solid introduction to the fundamental skills necessary to use Microsoft Excel. 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 92 video lectures, including 45 hands-on exercises, you will learn all of the following about Microsoft Excel: Learn how to navigate around Excel Learn how to enter and edit data in Excel Learn how to adjust the way data and information are displayed in Excel Learn how to write formulas quickly and easily with the point-and-click method Learn how to use relative, absolute, and mixed references in Excel Learn how to create powerful calculations with Excel functions Learn how to format worksheets in Excel for impact and appeal Learn how to " transpose data " - switching the columns and rows in Excel Learn how to use "paste special" to copy data from the web and get it into Excel Learn how to insert pictures, shapes, word art, symbols, hierarchy charts & relationship charts Learn how to include hyperlinks to external resources and call-out text boxes Learn tips and tricks about Excel, as well as Excel shortcuts As bonus material, you will also be provided with a comprehensive set of 45 "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 teach you Microsoft Excel. 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 beginners Show more Show less Course content 13 sections • 93 lectures • 8h 24m total length Expand all sections Introduction 6 lectures • 34min Welcome Preview 04:09 Understanding Spreadsheets Preview 05:47 Understanding Versions 07:49 How To Succeed 09:21 Course Resources 04:38 Accelerate Learning 02:20 Exercises - Ninja Level 1 5 lectures • 23min Quiz - Introduction Preview 04:27 Hands-on Exercise #1 02:20 Hands-on Exercise #2 04:12 Hands-on Exercise #3 05:24 Hands-on Exercise #4 06:51 Writing Formulas 6 lectures • 40min Workbooks and Worksheets Preview 06:16 Finding Your Way Around Excel 06:37 Mouse Pointer Awareness 05:12 Writing Formulas 11:23 Relative, Absolute, & Mixed References Preview 05:39 Ranges & Names 05:20 Exercises - Ninja Level 2 11 lectures • 51min Quiz - Getting Started 03:22 Hands-On Exercise #1 04:01 Hands-On Exercise #2 01:27 Hands-On Exercise #3 02:52 Hands-On Exercise #4 02:03 Hands-On Exercise #5 03:23 Hands-On Exercise #6 Preview 05:27 Hands-On Exercise #7 05:44 Hands-On Exercise #8 06:28 Hands-On Exercise #9 07:37 Hands-On Exercise #10 08:17 Formatting 9 lectures • 46min Overview 03:19 Content & Form Preview 04:49 Format Cells - Number 07:18 Format Cells - Alignment 07:28 Format Cells - Font 06:37 Format Cells - Border 02:47 Format Cells - Fill 04:48 Clear Formats 06:24 Format As Table 02:11 Exercises - Ninja Level 3 7 lectures • 43min Hands-On Exercise #1 05:17 Hands-On Exercise #2 03:40 Hands-On Exercise #3 04:38 Hands-On Exercise #4 08:06 Hands-On Exercise #5 02:27 Hands-On Exercise #6 05:54 Hands-On Exercise #7 13:08 Home & Insert 10 lectures • 51min Overview 02:56 Copy As Picture 02:59 Paste 06:40 Paste Special 04:07 Format Columns & Rows 04:57 Styles 03:12 Pictures & Shapes 06:20 Smart Art, Word Art, & Symbol 10:28 Link & Text Box 06:31 Add-Ins 02:48 Exercises - Ninja Level 4 9 lectures • 57min Hands-On Exercise #1 01:25 Hands-On Exercise #2 08:42 Hands-On Exercise #3 10:17 Hands-On Exercise #4 08:12 Hands-On Exercise #5 07:30 Hands-On Exercise #6 03:00 Hands-On Exercise #7 05:45 Hands-On Exercise #8 05:09 Hands-On Exercise #9 07:09 Layout Essentials 6 lectures • 41min Overview 10:15 Background 08:56 Stacking Order 03:22 Align, Group, Rotate 03:31 Zooming In & Out 02:58 Templates 12:24 Exercises - Ninja Level 5 5 lectures • 10min Hands-On Exercise #1 01:29 Hands-On Exercise #2 00:58 Hands-On Exercise #3 04:20 Hands-On Exercise #4 02:03 Hands-On Exercise #5 01:16 3 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:'67814a13abcee634',m:'b89f619af716312ba930d8e7204947e61c10ac12-1627844218-1800-AZTxD4h6iF7VuGPHUlihHkcv4o9Q2fhMxyuLLo2fvaLophcFgbjhZDF0SR+1q93X0SRrh6YMOuAfcmkb9mBFlOx+plpjnZqJ8gQlXPCxOCx5faDBu3l0ryQFGgWGPaB1f0PUQIUX/iX7l/CdiDkbF1MuGvQTY7zDUK4svwl6aOyz',s:[0xffbc5e9f4a,0x968d4f1990],}})();
  • Learn how to use relative, absolute, and mixed references in Excel Learn how to create powerful calculations with Excel functions Learn how to format worksheets in Excel for impact and appeal Learn how to "transpose data" - switching the columns and rows in Excel Learn how to use "paste special" to copy data from the web and get it into Excel Learn how to insert pictures, shapes, word art, symbols, hierarchy charts & relationship charts Learn how to include hyperlinks to external resources and call-out text boxes Learn tips and tricks about Excel, as well as Excel shortcuts Learn the fundamentals of using Microsoft Excel 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 provides a solid introduction to the fundamental skills necessary to use Microsoft Excel. 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 92 video lectures, including 45 hands-on exercises, you will learn all of the following about Microsoft Excel: Learn how to navigate around Excel Learn how to enter and edit data in Excel Learn how to adjust the way data and information are displayed in Excel Learn how to write formulas quickly and easily with the point-and-click method Learn how to use relative, absolute, and mixed references in Excel Learn how to create powerful calculations with Excel functions Learn how to format worksheets in Excel for impact and appeal Learn how to " transpose data " - switching the columns and rows in Excel Learn how to use "paste special" to copy data from the web and get it into Excel Learn how to insert pictures, shapes, word art, symbols, hierarchy charts & relationship charts Learn how to include hyperlinks to external resources and call-out text boxes Learn tips and tricks about Excel, as well as Excel shortcuts As bonus material, you will also be provided with a comprehensive set of 45 "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 teach you Microsoft Excel. 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 beginners Show more Show less Course content 13 sections • 93 lectures • 8h 24m total length Expand all sections Introduction 6 lectures • 34min Welcome Preview 04:09 Understanding Spreadsheets Preview 05:47 Understanding Versions 07:49 How To Succeed 09:21 Course Resources 04:38 Accelerate Learning 02:20 Exercises - Ninja Level 1 5 lectures • 23min Quiz - Introduction Preview 04:27 Hands-on Exercise #1 02:20 Hands-on Exercise #2 04:12 Hands-on Exercise #3 05:24 Hands-on Exercise #4 06:51 Writing Formulas 6 lectures • 40min Workbooks and Worksheets Preview 06:16 Finding Your Way Around Excel 06:37 Mouse Pointer Awareness 05:12 Writing Formulas 11:23 Relative, Absolute, & Mixed References Preview 05:39 Ranges & Names 05:20 Exercises - Ninja Level 2 11 lectures • 51min Quiz - Getting Started 03:22 Hands-On Exercise #1 04:01 Hands-On Exercise #2 01:27 Hands-On Exercise #3 02:52 Hands-On Exercise #4 02:03 Hands-On Exercise #5 03:23 Hands-On Exercise #6 Preview 05:27 Hands-On Exercise #7 05:44 Hands-On Exercise #8 06:28 Hands-On Exercise #9 07:37 Hands-On Exercise #10 08:17 Formatting 9 lectures • 46min Overview 03:19 Content & Form Preview 04:49 Format Cells - Number 07:18 Format Cells - Alignment 07:28 Format Cells - Font 06:37 Format Cells - Border 02:47 Format Cells - Fill 04:48 Clear Formats 06:24 Format As Table 02:11 Exercises - Ninja Level 3 7 lectures • 43min Hands-On Exercise #1 05:17 Hands-On Exercise #2 03:40 Hands-On Exercise #3 04:38 Hands-On Exercise #4 08:06 Hands-On Exercise #5 02:27 Hands-On Exercise #6 05:54 Hands-On Exercise #7 13:08 Home & Insert 10 lectures • 51min Overview 02:56 Copy As Picture 02:59 Paste 06:40 Paste Special 04:07 Format Columns & Rows 04:57 Styles 03:12 Pictures & Shapes 06:20 Smart Art, Word Art, & Symbol 10:28 Link & Text Box 06:31 Add-Ins 02:48 Exercises - Ninja Level 4 9 lectures • 57min Hands-On Exercise #1 01:25 Hands-On Exercise #2 08:42 Hands-On Exercise #3 10:17 Hands-On Exercise #4 08:12 Hands-On Exercise #5 07:30 Hands-On Exercise #6 03:00 Hands-On Exercise #7 05:45 Hands-On Exercise #8 05:09 Hands-On Exercise #9 07:09 Layout Essentials 6 lectures • 41min Overview 10:15 Background 08:56 Stacking Order 03:22 Align, Group, Rotate 03:31 Zooming In & Out 02:58 Templates 12:24 Exercises - Ninja Level 5 5 lectures • 10min Hands-On Exercise #1 01:29 Hands-On Exercise #2 00:58 Hands-On Exercise #3 04:20 Hands-On Exercise #4 02:03 Hands-On Exercise #5 01:16 3 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:'67814a13abcee634',m:'b89f619af716312ba930d8e7204947e61c10ac12-1627844218-1800-AZTxD4h6iF7VuGPHUlihHkcv4o9Q2fhMxyuLLo2fvaLophcFgbjhZDF0SR+1q93X0SRrh6YMOuAfcmkb9mBFlOx+plpjnZqJ8gQlXPCxOCx5faDBu3l0ryQFGgWGPaB1f0PUQIUX/iX7l/CdiDkbF1MuGvQTY7zDUK4svwl6aOyz',s:[0xffbc5e9f4a,0x968d4f1990],}})();
  • Learn how to create powerful calculations with Excel functions Learn how to format worksheets in Excel for impact and appeal Learn how to "transpose data" - switching the columns and rows in Excel Learn how to use "paste special" to copy data from the web and get it into Excel Learn how to insert pictures, shapes, word art, symbols, hierarchy charts & relationship charts Learn how to include hyperlinks to external resources and call-out text boxes Learn tips and tricks about Excel, as well as Excel shortcuts Learn the fundamentals of using Microsoft Excel 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 provides a solid introduction to the fundamental skills necessary to use Microsoft Excel. 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 92 video lectures, including 45 hands-on exercises, you will learn all of the following about Microsoft Excel: Learn how to navigate around Excel Learn how to enter and edit data in Excel Learn how to adjust the way data and information are displayed in Excel Learn how to write formulas quickly and easily with the point-and-click method Learn how to use relative, absolute, and mixed references in Excel Learn how to create powerful calculations with Excel functions Learn how to format worksheets in Excel for impact and appeal Learn how to " transpose data " - switching the columns and rows in Excel Learn how to use "paste special" to copy data from the web and get it into Excel Learn how to insert pictures, shapes, word art, symbols, hierarchy charts & relationship charts Learn how to include hyperlinks to external resources and call-out text boxes Learn tips and tricks about Excel, as well as Excel shortcuts As bonus material, you will also be provided with a comprehensive set of 45 "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 teach you Microsoft Excel. 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 beginners Show more Show less Course content 13 sections • 93 lectures • 8h 24m total length Expand all sections Introduction 6 lectures • 34min Welcome Preview 04:09 Understanding Spreadsheets Preview 05:47 Understanding Versions 07:49 How To Succeed 09:21 Course Resources 04:38 Accelerate Learning 02:20 Exercises - Ninja Level 1 5 lectures • 23min Quiz - Introduction Preview 04:27 Hands-on Exercise #1 02:20 Hands-on Exercise #2 04:12 Hands-on Exercise #3 05:24 Hands-on Exercise #4 06:51 Writing Formulas 6 lectures • 40min Workbooks and Worksheets Preview 06:16 Finding Your Way Around Excel 06:37 Mouse Pointer Awareness 05:12 Writing Formulas 11:23 Relative, Absolute, & Mixed References Preview 05:39 Ranges & Names 05:20 Exercises - Ninja Level 2 11 lectures • 51min Quiz - Getting Started 03:22 Hands-On Exercise #1 04:01 Hands-On Exercise #2 01:27 Hands-On Exercise #3 02:52 Hands-On Exercise #4 02:03 Hands-On Exercise #5 03:23 Hands-On Exercise #6 Preview 05:27 Hands-On Exercise #7 05:44 Hands-On Exercise #8 06:28 Hands-On Exercise #9 07:37 Hands-On Exercise #10 08:17 Formatting 9 lectures • 46min Overview 03:19 Content & Form Preview 04:49 Format Cells - Number 07:18 Format Cells - Alignment 07:28 Format Cells - Font 06:37 Format Cells - Border 02:47 Format Cells - Fill 04:48 Clear Formats 06:24 Format As Table 02:11 Exercises - Ninja Level 3 7 lectures • 43min Hands-On Exercise #1 05:17 Hands-On Exercise #2 03:40 Hands-On Exercise #3 04:38 Hands-On Exercise #4 08:06 Hands-On Exercise #5 02:27 Hands-On Exercise #6 05:54 Hands-On Exercise #7 13:08 Home & Insert 10 lectures • 51min Overview 02:56 Copy As Picture 02:59 Paste 06:40 Paste Special 04:07 Format Columns & Rows 04:57 Styles 03:12 Pictures & Shapes 06:20 Smart Art, Word Art, & Symbol 10:28 Link & Text Box 06:31 Add-Ins 02:48 Exercises - Ninja Level 4 9 lectures • 57min Hands-On Exercise #1 01:25 Hands-On Exercise #2 08:42 Hands-On Exercise #3 10:17 Hands-On Exercise #4 08:12 Hands-On Exercise #5 07:30 Hands-On Exercise #6 03:00 Hands-On Exercise #7 05:45 Hands-On Exercise #8 05:09 Hands-On Exercise #9 07:09 Layout Essentials 6 lectures • 41min Overview 10:15 Background 08:56 Stacking Order 03:22 Align, Group, Rotate 03:31 Zooming In & Out 02:58 Templates 12:24 Exercises - Ninja Level 5 5 lectures • 10min Hands-On Exercise #1 01:29 Hands-On Exercise #2 00:58 Hands-On Exercise #3 04:20 Hands-On Exercise #4 02:03 Hands-On Exercise #5 01:16 3 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:'67814a13abcee634',m:'b89f619af716312ba930d8e7204947e61c10ac12-1627844218-1800-AZTxD4h6iF7VuGPHUlihHkcv4o9Q2fhMxyuLLo2fvaLophcFgbjhZDF0SR+1q93X0SRrh6YMOuAfcmkb9mBFlOx+plpjnZqJ8gQlXPCxOCx5faDBu3l0ryQFGgWGPaB1f0PUQIUX/iX7l/CdiDkbF1MuGvQTY7zDUK4svwl6aOyz',s:[0xffbc5e9f4a,0x968d4f1990],}})();
  • Learn how to format worksheets in Excel for impact and appeal Learn how to "transpose data" - switching the columns and rows in Excel Learn how to use "paste special" to copy data from the web and get it into Excel Learn how to insert pictures, shapes, word art, symbols, hierarchy charts & relationship charts Learn how to include hyperlinks to external resources and call-out text boxes Learn tips and tricks about Excel, as well as Excel shortcuts Learn the fundamentals of using Microsoft Excel 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 provides a solid introduction to the fundamental skills necessary to use Microsoft Excel. 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 92 video lectures, including 45 hands-on exercises, you will learn all of the following about Microsoft Excel: Learn how to navigate around Excel Learn how to enter and edit data in Excel Learn how to adjust the way data and information are displayed in Excel Learn how to write formulas quickly and easily with the point-and-click method Learn how to use relative, absolute, and mixed references in Excel Learn how to create powerful calculations with Excel functions Learn how to format worksheets in Excel for impact and appeal Learn how to " transpose data " - switching the columns and rows in Excel Learn how to use "paste special" to copy data from the web and get it into Excel Learn how to insert pictures, shapes, word art, symbols, hierarchy charts & relationship charts Learn how to include hyperlinks to external resources and call-out text boxes Learn tips and tricks about Excel, as well as Excel shortcuts As bonus material, you will also be provided with a comprehensive set of 45 "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 teach you Microsoft Excel. 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 beginners Show more Show less Course content 13 sections • 93 lectures • 8h 24m total length Expand all sections Introduction 6 lectures • 34min Welcome Preview 04:09 Understanding Spreadsheets Preview 05:47 Understanding Versions 07:49 How To Succeed 09:21 Course Resources 04:38 Accelerate Learning 02:20 Exercises - Ninja Level 1 5 lectures • 23min Quiz - Introduction Preview 04:27 Hands-on Exercise #1 02:20 Hands-on Exercise #2 04:12 Hands-on Exercise #3 05:24 Hands-on Exercise #4 06:51 Writing Formulas 6 lectures • 40min Workbooks and Worksheets Preview 06:16 Finding Your Way Around Excel 06:37 Mouse Pointer Awareness 05:12 Writing Formulas 11:23 Relative, Absolute, & Mixed References Preview 05:39 Ranges & Names 05:20 Exercises - Ninja Level 2 11 lectures • 51min Quiz - Getting Started 03:22 Hands-On Exercise #1 04:01 Hands-On Exercise #2 01:27 Hands-On Exercise #3 02:52 Hands-On Exercise #4 02:03 Hands-On Exercise #5 03:23 Hands-On Exercise #6 Preview 05:27 Hands-On Exercise #7 05:44 Hands-On Exercise #8 06:28 Hands-On Exercise #9 07:37 Hands-On Exercise #10 08:17 Formatting 9 lectures • 46min Overview 03:19 Content & Form Preview 04:49 Format Cells - Number 07:18 Format Cells - Alignment 07:28 Format Cells - Font 06:37 Format Cells - Border 02:47 Format Cells - Fill 04:48 Clear Formats 06:24 Format As Table 02:11 Exercises - Ninja Level 3 7 lectures • 43min Hands-On Exercise #1 05:17 Hands-On Exercise #2 03:40 Hands-On Exercise #3 04:38 Hands-On Exercise #4 08:06 Hands-On Exercise #5 02:27 Hands-On Exercise #6 05:54 Hands-On Exercise #7 13:08 Home & Insert 10 lectures • 51min Overview 02:56 Copy As Picture 02:59 Paste 06:40 Paste Special 04:07 Format Columns & Rows 04:57 Styles 03:12 Pictures & Shapes 06:20 Smart Art, Word Art, & Symbol 10:28 Link & Text Box 06:31 Add-Ins 02:48 Exercises - Ninja Level 4 9 lectures • 57min Hands-On Exercise #1 01:25 Hands-On Exercise #2 08:42 Hands-On Exercise #3 10:17 Hands-On Exercise #4 08:12 Hands-On Exercise #5 07:30 Hands-On Exercise #6 03:00 Hands-On Exercise #7 05:45 Hands-On Exercise #8 05:09 Hands-On Exercise #9 07:09 Layout Essentials 6 lectures • 41min Overview 10:15 Background 08:56 Stacking Order 03:22 Align, Group, Rotate 03:31 Zooming In & Out 02:58 Templates 12:24 Exercises - Ninja Level 5 5 lectures • 10min Hands-On Exercise #1 01:29 Hands-On Exercise #2 00:58 Hands-On Exercise #3 04:20 Hands-On Exercise #4 02:03 Hands-On Exercise #5 01:16 3 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:'67814a13abcee634',m:'b89f619af716312ba930d8e7204947e61c10ac12-1627844218-1800-AZTxD4h6iF7VuGPHUlihHkcv4o9Q2fhMxyuLLo2fvaLophcFgbjhZDF0SR+1q93X0SRrh6YMOuAfcmkb9mBFlOx+plpjnZqJ8gQlXPCxOCx5faDBu3l0ryQFGgWGPaB1f0PUQIUX/iX7l/CdiDkbF1MuGvQTY7zDUK4svwl6aOyz',s:[0xffbc5e9f4a,0x968d4f1990],}})();
  • Learn how to "transpose data" - switching the columns and rows in Excel Learn how to use "paste special" to copy data from the web and get it into Excel Learn how to insert pictures, shapes, word art, symbols, hierarchy charts & relationship charts Learn how to include hyperlinks to external resources and call-out text boxes Learn tips and tricks about Excel, as well as Excel shortcuts Learn the fundamentals of using Microsoft Excel 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 provides a solid introduction to the fundamental skills necessary to use Microsoft Excel. 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 92 video lectures, including 45 hands-on exercises, you will learn all of the following about Microsoft Excel: Learn how to navigate around Excel Learn how to enter and edit data in Excel Learn how to adjust the way data and information are displayed in Excel Learn how to write formulas quickly and easily with the point-and-click method Learn how to use relative, absolute, and mixed references in Excel Learn how to create powerful calculations with Excel functions Learn how to format worksheets in Excel for impact and appeal Learn how to " transpose data " - switching the columns and rows in Excel Learn how to use "paste special" to copy data from the web and get it into Excel Learn how to insert pictures, shapes, word art, symbols, hierarchy charts & relationship charts Learn how to include hyperlinks to external resources and call-out text boxes Learn tips and tricks about Excel, as well as Excel shortcuts As bonus material, you will also be provided with a comprehensive set of 45 "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 teach you Microsoft Excel. 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 beginners Show more Show less Course content 13 sections • 93 lectures • 8h 24m total length Expand all sections Introduction 6 lectures • 34min Welcome Preview 04:09 Understanding Spreadsheets Preview 05:47 Understanding Versions 07:49 How To Succeed 09:21 Course Resources 04:38 Accelerate Learning 02:20 Exercises - Ninja Level 1 5 lectures • 23min Quiz - Introduction Preview 04:27 Hands-on Exercise #1 02:20 Hands-on Exercise #2 04:12 Hands-on Exercise #3 05:24 Hands-on Exercise #4 06:51 Writing Formulas 6 lectures • 40min Workbooks and Worksheets Preview 06:16 Finding Your Way Around Excel 06:37 Mouse Pointer Awareness 05:12 Writing Formulas 11:23 Relative, Absolute, & Mixed References Preview 05:39 Ranges & Names 05:20 Exercises - Ninja Level 2 11 lectures • 51min Quiz - Getting Started 03:22 Hands-On Exercise #1 04:01 Hands-On Exercise #2 01:27 Hands-On Exercise #3 02:52 Hands-On Exercise #4 02:03 Hands-On Exercise #5 03:23 Hands-On Exercise #6 Preview 05:27 Hands-On Exercise #7 05:44 Hands-On Exercise #8 06:28 Hands-On Exercise #9 07:37 Hands-On Exercise #10 08:17 Formatting 9 lectures • 46min Overview 03:19 Content & Form Preview 04:49 Format Cells - Number 07:18 Format Cells - Alignment 07:28 Format Cells - Font 06:37 Format Cells - Border 02:47 Format Cells - Fill 04:48 Clear Formats 06:24 Format As Table 02:11 Exercises - Ninja Level 3 7 lectures • 43min Hands-On Exercise #1 05:17 Hands-On Exercise #2 03:40 Hands-On Exercise #3 04:38 Hands-On Exercise #4 08:06 Hands-On Exercise #5 02:27 Hands-On Exercise #6 05:54 Hands-On Exercise #7 13:08 Home & Insert 10 lectures • 51min Overview 02:56 Copy As Picture 02:59 Paste 06:40 Paste Special 04:07 Format Columns & Rows 04:57 Styles 03:12 Pictures & Shapes 06:20 Smart Art, Word Art, & Symbol 10:28 Link & Text Box 06:31 Add-Ins 02:48 Exercises - Ninja Level 4 9 lectures • 57min Hands-On Exercise #1 01:25 Hands-On Exercise #2 08:42 Hands-On Exercise #3 10:17 Hands-On Exercise #4 08:12 Hands-On Exercise #5 07:30 Hands-On Exercise #6 03:00 Hands-On Exercise #7 05:45 Hands-On Exercise #8 05:09 Hands-On Exercise #9 07:09 Layout Essentials 6 lectures • 41min Overview 10:15 Background 08:56 Stacking Order 03:22 Align, Group, Rotate 03:31 Zooming In & Out 02:58 Templates 12:2