Learn Microsoft Excel Fast - The Advanced Excel Course

Last updated 4/2022
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz
Language: English | Size: 13.05 GB | Duration: 11h 33m
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.

Homepage

https://www.udemy.com/course/master-excel/

Buy Premium From My Links To Get Resumable Support,Max Speed & Support Me

Links are Interchangeable – No Password – Single Extraction

Learn Microsoft Excel Fast – The Advanced Excel Course

IntraWEB Ultimate 15.6.2

Windows Phone Application Sketch Book

Hidemaru Editor 9.39

Dry Humping A Guide to Dating, Relating, and Hooking Up Without the Booze [Audiobook]

Udemy – Mimo Multiple Antenna Systems