Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS AWS Certified Developer - Associate CompTIA Security+
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 15 hours on-demand video
  • 167 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Finance & Accounting Financial Modeling & Analysis Excel

Ultimate Excel Training Course - Intro to Advanced Pro

Accelerate Your Career. Navigation Shortcuts, Formatting Tips, Functions, Formula, Charts, Graphs, Pivot Tables, Macros!
Rating: 4.5 out of 54.5 (1,251 ratings)
59,935 students
Created by Commerce Curve
Last updated 6/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll 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!

Requirements

  • No specific requirements. Our lessons are taught with step by step instructions.

Description

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!

Who this course is for:

  • 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

Course content

6 sections • 124 lectures • 15h 14m total length

  • Preview03:01
  • Preview01:11
  • Preview06:25
  • Preview04:07
  • Preview01:04
  • Preview00:55
  • Preview02:45
  • Preview02:16
  • Preview00:16
  • Preview01:33
  • Preview00:21
  • Preview00:20
  • Preview02:28
  • Preview02:40
  • Preview01:41
  • Preview01:36
  • Preview01:48
  • Preview01:56
  • Preview00:39
  • Preview01:14
  • Navigating Excel Sheet Tabs
    02:14
  • Modify Multiple Tab Zoom Levels
    01:27
  • Navigate To A Specific Cell
    01:44
  • Show The Desktop Shortcut
    00:41
  • Preview00:53
  • 20+ Formatting Tips
    19:50
  • 20+ Date Formula
    33:43
  • Preview07:57
  • Common Excel Errors
    11:34
  • Copy Vs. Cut
    03:13
  • Preview03:58
  • Preview06:53
  • Preview05:31
  • Preview03:16
  • Preview09:02
  • Preview05:02
  • Preview05:43
  • Preview29:10

  • Preview15:44
  • Data Validation
    26:19
  • Scenario Manager
    15:46
  • Name Manager
    07:17
  • Advanced Filter
    05:36
  • Dependable Drop Down Lists
    15:09
  • Indirect
    14:06
  • Fuzzy Lookup
    05:34

  • UPPER, LOWER, PROPER FORMULA
    04:07
  • TRANSPOSE FORMULA
    05:40
  • SUMIF FORMULA
    04:24
  • COUNTIF FORMULA
    04:37
  • AVERAGEIF FORMULA
    04:13
  • SUMIFS FORMULA
    06:30
  • COUNTIFS FORMULA
    06:39
  • AVERAGEIFS FORMULA
    05:45
  • SUMPRODUCT FORMULA
    34:16
  • INDEX FORMULA
    13:01
  • MATCH FORMULA
    05:13
  • Preview09:52
  • Preview13:05
  • TEXTJOIN FORMULA
    14:05
  • MIN, MAX, MEDIAN FORMULA
    03:04
  • MINIFS, MAXIFS FORMULA
    07:24
  • IF FORMULA
    04:20
  • IF(AND) FORMULA
    07:40
  • IF(OR) FORMULA
    06:00
  • ABSOLUTE FORMULA
    03:09
  • ROUND FORMULA
    09:17
  • NPV FORMULA
    08:42
  • Preview20:14
  • NPV VS. IRR FORMULA
    02:45
  • PMT FORMULA
    11:40
  • PRINCIPAL PAYMENT (PPMT) FORMULA
    08:01
  • APPLICATION OF PMT, IPMT & PPMT FORMULA
    14:11
  • IPMT FORMULA
    06:33
  • EFFECT FORMULA
    06:14
  • DEPRECIATION FORMULA
    08:00
  • RATE FORMULA
    08:19
  • PV FORMULA
    07:07
  • FUTURE VALUE (FV) FORMULA
    06:02
  • SLOPE FORMULA
    07:33
  • Preview10:52
  • Preview13:28
  • Preview13:12
  • LEFT, RIGHT FORMULA
    08:16
  • COLUMN FORMULA
    01:58
  • ROW FORMULA
    02:11
  • Preview02:15
  • ROWS FORMULA
    01:36
  • FORMULA TEXT FORMULA
    03:48
  • COUNTBLANK FORMULA
    01:54
  • DMIN FORMULA
    05:19
  • DMAX FORMULA
    04:23
  • FIXED FORMULA
    03:44
  • FIND FORMULA
    06:09
  • RAND FORMULA
    03:00
  • RANDBETWEEN FORMULA
    02:43
  • Preview02:15
  • RANK FORMULA
    04:06
  • CHOOSE FORMULA
    06:01
  • CORREL FORMULA
    06:03
  • FORECAST FORMULA
    05:47
  • FREQUENCY FORMULA
    04:26
  • ISNUMBER FORMULA
    03:45
  • CONVERT COLUMN TO NUMBER FORMULA
    04:22
  • STRIP NON-NUMERIC CHARACTERS FORMULA
    02:47
  • SUM OF BOTTON N VALUES FORMULA
    04:41

  • Line Chart
    04:34
  • Column Chart
    04:48
  • Preview05:05
  • Timeline Chart
    06:37
  • Timeline Gantt Chart
    10:30
  • Win/Loss Sparklines Chart
    04:30
  • Preview12:36
  • Geo Heat Map
    07:04
  • Dashboards
    01:13:43

  • Pivot Tables
    09:07
  • Slicers
    04:18
  • Pivot Tables - Combining Data From Multiple Sheets
    09:42
  • Pivot Tables - Create Report Filter Pages
    07:29

  • Table Of Contents With Macro
    05:02
  • Automate Database Reports (Formula Method)
    07:33
  • Automate Database Reports (Record Macro)
    12:55
  • Remove Foreign Language Characters
    07:57
  • Combine Multiple Workbooks Into A Single Workbook
    08:14

Instructor

Commerce Curve
Accelerate Your Career - Hands-on Finance/Accounting Courses
Commerce Curve
  • 4.5 Instructor Rating
  • 1,316 Reviews
  • 67,284 Students
  • 9 Courses

Commerce Curve is a finance educational channel for accounting and finance professionals, students, and entrepreneurs.

We post content to help you accelerate your career by teaching you the practical, hands-on skills which you don't learn in school.

Our courses include topics on accounting, finance, financial modeling, Excel and more.

Reach us at commercecurve@gmail.com

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.