Microsoft Excel - Beginner To Advanced - Models & Templates

Learn 40+ Excel formulas and 30+ Excel shortcuts for building models, business cases, and personal finance templates.

What you'll learn

Master Microsoft Excel from Early Beginner to Advanced Users

Learn how to use Excel to Manage Corporate Finance & Accounting to Small Business Finance & Accounting

Gain Skills to Create Budget, Net Worth, Spending, and Debt Excel Trackers & Templates.

Build a Solid Understanding of the Basics, Giving You the Ability to Apply Across a Variety of Uses

Impress Your Boss with Your Skills and Efficiency - Create Models to Simplify Your Job

Manage Millions of Data in Seconds

Requirements

No Prior Microsoft Excel Knowledge Needed

Description

From the earliest beginner to the mid-skilled Microsoft Excel user, this course is for all those:who want to impress their bosswho aspire to grow in their careerwho desire to create a side hustle with Microsoft Excelwho see the power in knowing a software used globallywho want to create visual trackers to help them improve their livesUnderstanding how to use Microsoft Excel well is a skill that keeps giving.  Becoming the person in your office who can create the visually stunning dashboards, the efficient processes, and the transparent reports gives you exposure at your company.Knowing Microsoft Excel creates an opportunity to make additional side income as well, creating business cases for start-ups, doing consulting work, and selling your own templates.Creating personal finance and other goal-related Microsoft Excel templates gives you the ability to see where you are and monitor your progress, resulting in further inspiration to hit your targets.In this course, you'll receive 40 lectures, 30+ associated data sets and templates with those lectures, 40+ formulas, and 30+ shortcuts.All videos and files are downloadable and yours to keep forever.As a student, you'll receive all future updates for free.With over two decades of experience using Microsoft Excel, this course is packed with every valuable tool I've learnt.  All lectures allow you to follow along with the given file in the Resources section, or you have the option to build these files from scratch for a more thorough learning experience.Enjoy!

Overview

Section 1: Introduction

Lecture 1 Introduction: What Can Excel Do?

Section 2: Microsoft Excel Fundamentals for Beginners

Lecture 2 Microsoft Excel Basics

Lecture 3 Patterns - Inserting - Pasting - Transposing Data

Lecture 4 Grouping Data

Lecture 5 Conditional Formatting

Lecture 6 Filter Data

Lecture 7 Copy Visible Cells Only

Lecture 8 Creating a Drop-Down List

Lecture 9 Changing Multiple Worksheets Simultaneously

Lecture 10 CSV Delimited to Excel Format

Section 3: Formula Mastery

Lecture 11 Intro to Formulas

Lecture 12 SUM vs SUBTOTAL

Lecture 13 SUBTOTAL v AVERAGE v MIN v MAX v MEDIAN v AVERAGEIF

Lecture 14 TRUE-FALSE Check

Lecture 15 IF Statements (IF, IFS, IFERORROR, SUMIF)

Lecture 16 CONCATENATE-SUMIF

Lecture 17 LEFT-RIGHT-MID

Lecture 18 VLOOKUP

Lecture 19 HLOOKUP

Lecture 20 XLOOKUP

Lecture 21 SUMPRODUCT

Lecture 22 15 Formulas to Know

Lecture 23 ROUND CEILING FLOOR

Lecture 24 IRR NPV PMT NPER

Lecture 25 Fixing Errors

Section 4: Microsoft Excel Keyboard Shortcuts

Lecture 26 30+ Keyboard Shortcuts

Section 5: Pivot Tables

Lecture 27 Creating a Pivot Table

Lecture 28 Removing Duplicate Data with Pivot Tables

Lecture 29 Reordering Data in Pivot Tables

Lecture 30 GETPIVOTDATA Formula

Section 6: Charts

Lecture 31 Charts

Section 7: Use Case: Key Metrics Templates

Lecture 32 Monthly Productivity Report

Section 8: Use Case: Money Templates (Budget-Net Worth, Compounding & Calculators)

Lecture 33 Create a Budget-Net Worth Tracker - Part 1

Lecture 34 Adding a Spending Tracker to the Budget Tracker

Lecture 35 Adding the Chart Dashboard to the Budget Tracker

Lecture 36 Compounding Template

Lecture 37 Debt Amortization Calculator

Lecture 38 Determine Your Retirement Value Calculator

Section 9: Use Case: Business Cases

Lecture 39 Business Cases (Investment & Make vs. Buy)

Section 10: Microsoft Excel Premade Templates

Lecture 40 Premade Excel Templates

Beginner to Intermediate Excel User who Wants to Learn how to use Excel for Accounting, Finance, Money Management, Business Case Modeling, Template Creation & Efficiency Improvement