Ultimate Excel Training Course – Intro to Advanced Pro

Ultimate Excel Training Course – Intro to Advanced Pro, available at $69.99, has an average rating of 4.63, with 124 lectures, based on 1600 reviews, and has 60366 subscribers.

You will learn about Microsoft Excel – From Intro to Advanced Pro Knowledge Financial Modeling in Excel 100+ Navigation Shortcuts and Formatting Tips In Excel Over 100+ Formula and Functions In Excel Charts and Graphs In Excel Create Beautiful Dashboards Including Sales Funnels Pivot Tables and Slicers in Excel Macros In Excel All of our lessons include real life examples so you'll know how to apply the formula, functions, charts, graphs, pivot tables, macros and more! This course is ideal for individuals who are Business Professionals in Finance, Accounting, Investment Banking, and FP&A Roles or Finance and Accounting Professionals and Students or Entrepreneurs or Anyone looking to accelerate their career by becoming a financial modeling pro in Excel It is particularly useful for Business Professionals in Finance, Accounting, Investment Banking, and FP&A Roles or Finance and Accounting Professionals and Students or Entrepreneurs or Anyone looking to accelerate their career by becoming a financial modeling pro in Excel.

Enroll now: Ultimate Excel Training Course – Intro to Advanced Pro

Summary

Title: Ultimate Excel Training Course – Intro to Advanced Pro

Price: $69.99

Average Rating: 4.63

Number of Lectures: 124

Number of Published Lectures: 124

Number of Curriculum Items: 124

Number of Published Curriculum Objects: 124

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Microsoft Excel – From Intro to Advanced Pro Knowledge
Financial Modeling in Excel
100+ Navigation Shortcuts and Formatting Tips In Excel
Over 100+ Formula and Functions In Excel
Charts and Graphs In Excel
Create Beautiful Dashboards Including Sales Funnels
Pivot Tables and Slicers in Excel
Macros In Excel
All of our lessons include real life examples so you'll know how to apply the formula, functions, charts, graphs, pivot tables, macros and more!

Who Should Attend

Business Professionals in Finance, Accounting, Investment Banking, and FP&A Roles
Finance and Accounting Professionals and Students
Entrepreneurs
Anyone looking to accelerate their career by becoming a financial modeling pro in Excel

Target Audiences

Business Professionals in Finance, Accounting, Investment Banking, and FP&A Roles
Finance and Accounting Professionals and Students
Entrepreneurs
Anyone looking to accelerate their career by becoming a financial modeling pro in Excel

15+ Hours of Ultimate Microsoft Excel Training from beginner to advanced. Take this Excel course and become proficient in Excel overnight. Taught hands on from a Silicon Valley CFO with advanced Excel financial modeling knowledge. Over 115+ lessons and examples are taught in this course to provide a practical and hands-on approach.

In this course you’ll learn 100+ navigation shortcuts and formatting tips, how to write over 60+ formula in Excel, use functions, learn Excel macros, learn VBA, charts and graphs, and develop beautiful and advanced dashboards. As part of this course you will receive access to the full course materials including over 7 complete workbooks with over 115+ Excel worksheet lessons which accompany each lesson and contain the shortcuts, formula, and course explanations so that you can follow along on your own time. Each course section has it’s own exercises so that you can test your knowledge.

Take this course if you’re looking for a complete course with end-to-end Excel training. You can pick and choose which lessons you’d like to watch as each lesson contains its own worksheet and video to follow along.

There are 6 parts and a total of 8 workbooks as follows:

Excel Course Part 1 – Navigation & Formatting

Excel Course Part 1.1 – Navigation & Formatting – Data Set Example

Excel Course Part 2 – Functions

Excel Course Part 3 – Formula

Excel Course Part 4 – Charts & Graphs

Excel Course Part 4.1 – Charts & Graphs – Dashboards

Excel Course Part 5 – Pivot Tables

Excel Course Part 6 – Macros

Accelerate your career with our Ultimate Excel Training course today!

Course Curriculum

Chapter 1: NAVIGATION AND FORMATTING TIPS IN EXCEL

Lecture 1: Introduction and Course Overview

Lecture 2: Toggle Between Excel Files

Lecture 3: Copy, Cut, Paste Special

Lecture 4: Navigation Tips And Highlighting Data

Lecture 5: Auto-Sum Adjacent Rows/Columns

Lecture 6: Create Multiple Rows In A Cell

Lecture 7: Insert, Delete, Hide, Move Columns

Lecture 8: Insert, Delete, Hide, Move Rows

Lecture 9: Datestamp And Timestamp

Lecture 10: Show Formulas Shortcut

Lecture 11: Quick Save Shortcut

Lecture 12: Quick Undo Shortcut

Lecture 13: Turn Off & On Formula Calculations

Lecture 14: Hide Excel Sheets & Make Very Hidden

Lecture 15: Change Window Size

Lecture 16: Open Duplicate Window

Lecture 17: Formatting Text

Lecture 18: Formatting Cells

Lecture 19: Copy Cell Above Shortcut

Lecture 20: Find Keywords

Lecture 21: Navigating Excel Sheet Tabs

Lecture 22: Modify Multiple Tab Zoom Levels

Lecture 23: Navigate To A Specific Cell

Lecture 24: Show The Desktop Shortcut

Lecture 25: Add & Remove Filters

Lecture 26: 20+ Formatting Tips

Lecture 27: 20+ Date Formula

Lecture 28: Workday Formula

Lecture 29: Common Excel Errors

Lecture 30: Copy Vs. Cut

Lecture 31: Precedents And Dependents

Lecture 32: Group And Ungroup Rows And Columns

Lecture 33: Protect Ranges & Worksheets

Lecture 34: Screenshots In Excel

Lecture 35: Sorting Data

Lecture 36: Remove Duplicate Values

Lecture 37: Text To Columns

Lecture 38: Conditional Formatting

Chapter 2: FUNCTIONS IN EXCEL

Lecture 1: Goal Seek

Lecture 2: Data Validation

Lecture 3: Scenario Manager

Lecture 4: Name Manager

Lecture 5: Advanced Filter

Lecture 6: Dependable Drop Down Lists

Lecture 7: Indirect

Lecture 8: Fuzzy Lookup

Chapter 3: FORMULA IN EXCEL

Lecture 1: UPPER, LOWER, PROPER FORMULA

Lecture 2: TRANSPOSE FORMULA

Lecture 3: SUMIF FORMULA

Lecture 4: COUNTIF FORMULA

Lecture 5: AVERAGEIF FORMULA

Lecture 6: SUMIFS FORMULA

Lecture 7: COUNTIFS FORMULA

Lecture 8: AVERAGEIFS FORMULA

Lecture 9: SUMPRODUCT FORMULA

Lecture 10: INDEX FORMULA

Lecture 11: MATCH FORMULA

Lecture 12: SUMIF WITH INDEX(MATCH) FORMULA

Lecture 13: INDEX(MATCH) and DGET FORMULA

Lecture 14: TEXTJOIN FORMULA

Lecture 15: MIN, MAX, MEDIAN FORMULA

Lecture 16: MINIFS, MAXIFS FORMULA

Lecture 17: IF FORMULA

Lecture 18: IF(AND) FORMULA

Lecture 19: IF(OR) FORMULA

Lecture 20: ABSOLUTE FORMULA

Lecture 21: ROUND FORMULA

Lecture 22: NPV FORMULA

Lecture 23: IRR FORMULA

Lecture 24: NPV VS. IRR FORMULA

Lecture 25: PMT FORMULA

Lecture 26: PRINCIPAL PAYMENT (PPMT) FORMULA

Lecture 27: APPLICATION OF PMT, IPMT & PPMT FORMULA

Lecture 28: IPMT FORMULA

Lecture 29: EFFECT FORMULA

Lecture 30: DEPRECIATION FORMULA

Lecture 31: RATE FORMULA

Lecture 32: PV FORMULA

Lecture 33: FUTURE VALUE (FV) FORMULA

Lecture 34: SLOPE FORMULA

Lecture 35: VLOOKUP FORMULA

Lecture 36: HLOOKUP FORMULA

Lecture 37: OFFSET FORMULA

Lecture 38: LEFT, RIGHT FORMULA

Lecture 39: COLUMN FORMULA

Lecture 40: ROW FORMULA

Lecture 41: COLUMNS FORMULA

Lecture 42: ROWS FORMULA

Lecture 43: FORMULA TEXT FORMULA

Lecture 44: COUNTBLANK FORMULA

Lecture 45: DMIN FORMULA

Lecture 46: DMAX FORMULA

Lecture 47: FIXED FORMULA

Lecture 48: FIND FORMULA

Lecture 49: RAND FORMULA

Lecture 50: RANDBETWEEN FORMULA

Lecture 51: TRIM FORMULA

Instructors

Commerce Curve
Accelerate Your Career – Hands-on Finance/Accounting Courses

Rating Distribution

1 stars: 25 votes
2 stars: 30 votes
3 stars: 188 votes
4 stars: 579 votes
5 stars: 778 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu