Find the best online courses
Back to course list
Microsoft Excel - From Beginner to Expert in 6 Hours
  • Level: All Levels
  • Duration: 06h 34m 56s
  • Release date: 2013-05-12
  • Author: Todd McLeod
  • Provider: Udemy

Microsoft Excel - From Beginner to Expert in 6 Hours

Description
Content

This training provides you everything you need to know about Microsoft Excel. From the fundamentals, to the most advanced features, after taking this online class you will be able to use Microsoft Excel at an expert level. You can learn Microsoft Excel easily and quickly if it is taught correctly. Developed by a Microsoft Certified Master Instructor, this course provides comprehensive coverage on Microsoft Excel. 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 master Microsoft Excel. In only five hours of videos, provided to you in 75 separate video lectures so that no one online video is too long, 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 visually represent your data with charts and graphs in Excel Learn how to use Excel data tools like sorting, subtotaling, and filtering Learn how to "freeze columns and rows" with freeze panes in Excel Learn how to remove duplicates from data in Excel Learn how to "transpose data" - switching the columns and rows in Excel Learn how to use Excel to leverage data with Pivot Tables & Pivot Charts Learn how to format worksheets in Excel for impact and appeal Learn how to automate Excel tasks with time-saving macros Learn how to integrate Microsoft Excel with Microsoft Word Learn how to use passwords in Excel to protect your work in multiple scenarios Learn tips and tricks about Excel, as well as Excel secrets and shortcuts Learn how to use printing and sharing in Excel As bonus material, you will also learn two very incredible, and super valuable, skills: how to harvest data from the web how to create online forms which allow you to gather data from individuals As an additional bonus, you can download all of the Excel project files that are used in the videos so that you can get a “hands-on” approach to learning the material. You will also be shown how to find and download free "Excel templates" which are spreadsheet templates that you can use like "budget templates" or a "calendar template" or a "schedule template." Another great aspect of this course is that, at the end of this Excel class, you will be given a CERTIFICATE OF COMPLETION. This course has a quiz after every video so if you need to prove that you have learned the material, or if you’re 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 quizzes. 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.