Learn Microsoft Excel Fast - The Advanced Excel Course

Learn Microsoft Excel Fast - The Advanced Excel Course

Master Excel with a Microsoft Certified Master Instructor.

You can master Microsoft Excel easily and quickly if it is taught correctly.

Developed by a Microsoft Certified Master Instructor, this course will help you master 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 and refined 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).

• Receive 51 "hands-on exercises"

• Receive solutions to all of the "hands-on exercises"

• download all of the Excel project files that are used in the videos.

This class is guaranteed to help you master Microsoft Excel.

Once enrolled, you will have access to this Excel course for the rest of your life. 

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.

Microsoft Certified Master Instructor - Financial Functions - NPV - IRR - Amortization - Pivot Tables - Data Analysis

Url: View Details

What you will 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.

Rating: 4.125

Level: Expert Level

Duration: 11.5 hours

Instructor: Todd McLeod