Learn Microsoft Excel Fast - The Advanced Excel Course

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

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.
Description
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 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).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.

Overview

Section 1: Introduction

Lecture 1 Welcome

Lecture 2 Course resources

Lecture 3 Course files

Lecture 4 Versions

Section 2: Financial functions I

Lecture 5 Financial health

Lecture 6 Time is money

Lecture 7 Future value I

Lecture 8 Future value II

Lecture 9 Future value III

Lecture 10 Future value IV

Lecture 11 Present value

Lecture 12 Present value II

Section 3: Exercises - Ninja Level 19

Lecture 13 Hands-on exercise #1

Lecture 14 Hands-on exercise #2

Lecture 15 Hands-on exercise #3

Lecture 16 Hands-on exercise #4

Lecture 17 Hands-on exercise #5

Lecture 18 Hands-on exercise #6

Lecture 19 Hands-on exercise #7

Section 4: Financial functions II

Lecture 20 Loan payment

Lecture 21 Loan amortization

Lecture 22 Annuity payment

Lecture 23 Payment & interest

Lecture 24 NPV

Lecture 25 IRR

Section 5: Exercises - Ninja Level 20

Lecture 26 Hands-on exercise #1

Lecture 27 Hands-on exercise #2

Lecture 28 Hands-on exercise #3

Lecture 29 Hands-on exercise #4

Lecture 30 Hands-on exercise #5

Section 6: Pivot tables

Lecture 31 Introduction

Lecture 32 Pivoting your data

Lecture 33 Data into information

Lecture 34 Adding information to a table

Lecture 35 Refreshing pivot tables

Lecture 36 Nesting with pivot tables

Lecture 37 Grouping in pivot tables

Lecture 38 Using slicers in pivot tables

Lecture 39 Using timelines in pivot tables

Lecture 40 Creating pivot charts

Lecture 41 Recommended pivot tables

Section 7: Exercises - Ninja Level 21

Lecture 42 Hands-on exercise #1

Lecture 43 Hands-on exercise #2

Lecture 44 Hands-on exercise #3

Lecture 45 Hands-on exercise #4

Lecture 46 Hands-on exercise #5

Lecture 47 Hands-on exercise #6

Lecture 48 Hands-on exercise #7

Section 8: Data model (power pivot)

Lecture 49 Introduction

Lecture 50 Add to data model

Lecture 51 Creating relationships

Lecture 52 Calculated columns

Lecture 53 Writing a measure

Lecture 54 Pivot your data

Section 9: Exercises - Ninja Level 22

Lecture 55 Hands-on exercise #1

Lecture 56 Hands-on exercise #2

Section 10: Get & transform (power query)

Lecture 57 Orientation

Lecture 58 1,048,576+ records

Lecture 59 Excel broke

Lecture 60 1,048,576+ records II

Lecture 61 Get csv files

Lecture 62 Adding data

Lecture 63 Get txt files

Lecture 64 Get xlsx files, single sheets

Lecture 65 Get xlsx files, many sheets

Lecture 66 Data preparation

Lecture 67 Get txt, csv, accd, xlsx

Lecture 68 Get web

Lecture 69 Get JSON

Section 11: Exercises - Ninja Level 23

Lecture 70 Hands-on exercise #1

Lecture 71 Hands-on exercise #2

Lecture 72 Hands-on exercise #3

Lecture 73 Hands-on exercise #4

Lecture 74 Hands-on exercise #5

Section 12: Transforming data

Lecture 75 Overview

Lecture 76 Split by delimiter

Lecture 77 Pivot

Lecture 78 Unpivot

Lecture 79 Replace

Lecture 80 Extract

Lecture 81 Format

Section 13: Exercises - Ninja Level 24

Lecture 82 Hands-on exercise #1

Lecture 83 Hands-on exercise #2

Lecture 84 Hands-on exercise #3

Lecture 85 Hands-on exercise #4

Lecture 86 Hands-on exercise #5

Lecture 87 Hands-on exercise #6

Lecture 88 Hands-on exercise #7

Section 14: Append & merge

Lecture 89 Append

Lecture 90 Append updating

Lecture 91 Merge & joins

Lecture 92 Left outer join

Lecture 93 Right outer join

Lecture 94 Full outer join

Lecture 95 Inner join

Lecture 96 Left anti join

Lecture 97 Right anti join

Section 15: Exercises - Ninja Level 25

Lecture 98 Hands-on exercise #1

Lecture 99 Hands-on exercise #2

Lecture 100 Hands-on exercise #3

Lecture 101 Hands-on exercise #4

Lecture 102 Hands-on exercise #5

Lecture 103 Hands-on exercise #6

Lecture 104 Hands-on exercise #7

Lecture 105 Hands-on exercise #8

Section 16: Data visualization

Lecture 106 Overview

Lecture 107 3-D map

Lecture 108 3-D map II

Lecture 109 3-D map III

Lecture 110 3-D map IV

Lecture 111 3-D map animation

Lecture 112 Themes

Lecture 113 Defined names

Lecture 114 Defined names & tables

Lecture 115 Defined names management

Lecture 116 Formula auditing

Lecture 117 Error checking

Lecture 118 Evaluate formula

Lecture 119 Watch window

Lecture 120 Calculation

Section 17: Exercises - Ninja Level 26

Lecture 121 Hands-on exercise #1

Lecture 122 Hands-on exercise #2

Lecture 123 Hands-on exercise #3

Lecture 124 Hands-on exercise #4

Lecture 125 Hands-on exercise #5

Lecture 126 Hands-on exercise #6

Section 18: Collaborating

Lecture 127 Signature line

Lecture 128 Comments

Lecture 129 Protect (lock)

Section 19: Exercises - Ninja Level 27

Lecture 130 Hands-on exercise #1

Section 20: Automation

Lecture 131 Understanding macros

Lecture 132 Relative reference macros

Section 21: Exercises - Ninja Level 28

Lecture 133 Hands-on exercise #1

Section 22: Excel & Word integration (OLE)

Lecture 134 Object linking & embedding (OLE)

Section 23: Exercises - Ninja Level 29

Lecture 135 Hands-on exercise #1

Section 24: Farewell

Lecture 136 Congratulations

Lecture 137 Bonus lecture

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