Master Excel with a Microsoft Certified Master Instructor.
You canmaster Microsoft Excel easily and quicklyif it is taught correctly.
Developed by a Microsoft Certified Master Instructor, this course will help you master Microsoft Excel.
Taught by auniversity professor withover twentyyears of experience teaching individuals of all ability levels how to use Microsoft Excel,Todd McLeod has designed and refined thiscourse to make it easy for you to master Microsoft Excel.
Providinga comprehensive curriculum of140 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-DMaps.
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 solutionsto all of the "hands-on exercises"
download all of the Excel project files that are used in the videos.
This class is guaranteed tohelp 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 forevertransform the way you work with Excel. Try this course for yourself andsee how quickly and easily you too can master Microsoft Excel.