Expired

Mastering Excel with a Microsoft Certified Master Instructor

Deal Score+2
Deal Score+2

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 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 finance
  • Learn about the time value of money.
  • Learn how to work with financial functions
  • Learn 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.

What you’ll learn

  • Learn how to more effectively manage finances.
  • Learn all about financial functions in Microsoft Excel.
  • Learn how to calculate the future value of cash flows.
  • Learn how to calculate the present value of cash flows.
  • Learn how to calculate a loan payment.
  • Learn how to create a loan amortization schedule.
  • Learn how to calculate an annuity payment.
  • Learn how to calculate payment and interest.
  • Learn all about NPV (net present value) and learn how to calculate it.
  • Learn all about IRR (internal rate of return) and learn how to calculate it.
  • Learn how to create pivot tables and how to work with pivot tables.
  • Learn how to group data in pivot tables.
  • Learn how to use slicers and timelines in pivot tables.
  • Learn how to work with the data model power pivot.
  • Learn how to use “get and transform” to work with data.
  • Learn how to transform data
  • Learn how to split by delimiter, pivot, unpivot, replace, extract, and format data
  • Learn how to work with “append and merge”
  • Learn all about merges and joins include outer joins and inner joins
  • Learn how to work with data visualization in Microsoft Excel
  • Learn how to create a 3-D map
  • Learn how to use Microsoft Excel collaboration tools
  • Learn how to automate Microsoft Excel with macros
  • Learn how to use Object linking & embedding (OLE)

Requirements

All versions of Microsoft Excel work for this course. The instructor will be using Microsoft Excel 2016.

Who this course is for:

  • This course is for individuals who already have a good understanding of Microsoft Excel.
×

Report Post

Tags: