Find the best online courses
Back to course list
Mastering Excel with a Microsoft Certified Master Instructor
  • Level: Expert
  • Duration: 12h 15m 31s
  • Release date: 2021-09-28
  • Author: Todd McLeod
  • Provider: Udemy

Mastering Excel with a Microsoft Certified Master Instructor

Description
Content

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 master 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 master Microsoft Excel.Providing a comprehensive curriculum of 140 video lectures, including 51 hands-on exercises with solutions, you will learn all of the following about Microsoft Excel: Learn fundamentals of financeLearn about the time value of money.Learn how to work with financial functionsLearn how to calculate present value and future value.Learn how to calculate loan payments, loan amortization, and annuity payments.Learn about Net Present Value (NPV) and learn how to calculate it.Learn about Internal Rate of Rate (IRR) and learn how to calculate it.Learn to use pivot tables and master the art of data visualization.Learn to use the "data model" power pivot tool to advance your data analysis.Learn to use "Get and Transform" power query.Learn to transform data with split by delimiter.Learn to replace, extract, and format data.Learn to append and merge data.Learn to work with  merge and joins.Learn to create inner joins and outer joins.Learn to use data visualization.Learn to create 3-D Maps.Learn to collaborate more effectively in Excel.Learn to automate Excel with macros.Learn to integrate Excel with other software.Learn about Object Linking and Embedding (OLE).This course will also provided you with a comprehensive set of 51 "hands-on exercises" and solutions to all of the "hands-on exercises" You can also download all of the Excel project files that are used in the videos.This class is guaranteed to help you master 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 Excel. Try this course for yourself and see how quickly and easily you too can master Microsoft Excel.