Tags
Language
Tags
June 2025
Su Mo Tu We Th Fr Sa
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 1 2 3 4 5
    Attention❗ To save your time, in order to download anything on this site, you must be registered 👉 HERE. If you do not have a registration yet, it is better to do it right away. ✌

    ( • )( • ) ( ͡⚆ ͜ʖ ͡⚆ ) (‿ˠ‿)
    SpicyMags.xyz

    Learn Microsoft Excel Fast - The Advanced Excel Course

    Posted By: ELK1nG
    Learn Microsoft Excel Fast - The Advanced Excel Course

    Learn Microsoft Excel Fast - The Advanced Excel Course
    Last updated 4/2022
    MP4 | Video: h264, 1280x720 | 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.