Get $1 credit for every $25 spent!

The Premium 2021 Microsoft Excel & Data Certification Bundle

Ending In:
Add to Cart - $69.99
Add to Cart ($69.99)
$2,376
97% off
wishlist
Courses
24
Lessons
1,355
Enrolled
257

What's Included

Product Details

Access
Lifetime
Content
3.0 hours
Lessons
19

MS Excel/Excel 2020: The Complete Introduction to Excel

Gain Basic Knowledge on How to Use Microsoft Excel

By Yassin Marco | in Online Courses

The course is created around a very simple concept. To learn you need to practice as much as you can. This is why from the moment that you will enter the course and start your Excel journey you will have a lot of examples and cases. Not only this will help you become a better user of Microsoft Excel but it will also give you the confidence to start using the app by yourself to be able to create way more advanced applications that will be able to perform different tasks.

4.1/5 average rating: ★ ★ ★ ★

  • Access 19 lectures & 3 hours of content 24/7
  • Learn the basics of Excel
  • Understand the difference between a function & a formula
  • Create charts from your data
  • Create pivot tables
Note: Software NOT included
Yassin Marco
4.1/5 Instructor Rating: ★ ★ ★ ★

Yassin has a BS in international management and multiple certifications in management and IT. He works on a daily basis with various Microsoft apps and is a specialist in excel as well as in various other fields such as online business creation and promotion, marketing, and many more. Also, he has a passion for finances and has helped many people in taking their first steps in the trading and investing world, from basic financial coaching to advanced Stock/Forex data analysis.

He has developed a passion for coaching and educating and has helped more than 380,000+ students on multiple online platforms. Teaching in English and French, he has been able to reach across to people spanning from over 198 countries.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft Excel

Course Outline

  • Your First Program
  • Introduction
    • Intro - 9:30
  • Starting out
    • The Basics of Excel - 15:38
    • Relative Vs Absolute cell References - 9:38
    • Difference Between a Function and a Formula - 2:44
    • Basic Excel Formulas - 4:50
    • Project 1 - 7:49
  • Functions
    • Introduction to Excel Functions - 9:08
    • IF Function - 10:10
    • VLOOKUP Function - 10:39
    • Project 2 - 10:06
  • Charts and Data
    • Visually representing Data - 10:01
    • Creating and Using Charts - 9:02
    • Importing Data From the Web - 13:57
    • Project 3 - 13:10
  • Introduction to Pivot Tables
    • Introduction to Pivot Tables - 16:44
  • Final Project Creating a Gradebook
    • Step 1 Creating the Architecture of the APP - 10:39
    • Step 2 Writing the Functions - 11:12
    • Step 3 Manipulating the Data and Tests - 10:04
  • Final Words
    • Final Words - 2:10

View Full Curriculum


Access
Lifetime
Content
7.0 hours
Lessons
90

Microsoft Excel: Intro to Power Query, Power Pivot & DAX

Get Up & Running with Excel's Data Modeling & Business Intelligence Tools

By Maven Analytics | in Online Courses

This course will introduce you to Microsoft Excel's powerful data modeling and business tools Power Query, Power Pivot, and Data Analysis Expressions (DAX). If you're looking to become a power Excel user and supercharge your analytics, then this is the A-Z guide that you're looking for.

4.7/5 average rating: ★ ★ ★ ★

  • Access 90 lectures & 7 hours of content 24/7
  • Use sample data from a fictional supermarket chain to get hands-on w/ Power Query
  • Practice shaping, blending, & exploring project files
  • Cover the fundamentals of database design & normalization
  • Explore & analyze your data model using Power Pivot & DAX
  • Cover basic DAX syntax & learn some of the most powerful and commonly used functions
Note: Software NOT included.
Excel Maven | Award-Winning Analytics & BI Training
4.6/5 Instructor Rating: ★ ★ ★ ★

Excel Maven transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014, they've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.

Chris Dutton is a certified Excel MOS Expert, edtech entrepreneur, and best-selling analytics instructor. As founder and COO of Maven Analytics, Chris' work has been featured by Microsoft, HuffPost, Entrepreneur, and the New York Times, reaching more than 500,000 students around the world. A leader in analytics education, Maven Analytics empowers everyday people to change the world with data.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft Excel

Course Outline

  • Your First Program
  • Getting Started
    • Course Structure & Outline - 1:22
    • IMPORTANT: Versions & Compatibility - 3:15
    • DOWNLOAD: Course Resources - 1:16
    • Setting Expectations - 1:53
  • Intro to "Power Excel"
    • The "Power Excel" Workflow - 3:50
    • "Best Thing to Happen to Excel in 20 Years" - 8:18
    • When to use Power Query & Power Pivot - 0:44
    • QUIZ: Intro to "Power Excel"
    • HOMEWORK: Intro to "Power Excel"
  • Connecting & Shaping Data with Power Query
    • Introduction - 0:27
    • Meet Power Query (aka "Get & Transform") - 2:40
    • The Query Editor - 3:17
    • Data Loading Options - 1:40
    • IMPORTANT: Regional Formatting
    • Basic Table Transformations - 8:06
    • Text-Specific Tools - 10:17
    • Number-Specific Tools - 7:41
    • Date-Specific Tools - 7:39
    • PRO TIP: Creating a Rolling Calendar - 5:02
    • Adding Index & Conditional Columns - 7:44
    • Grouping & Aggregating Data - 7:10
    • Pivoting & Unpivoting - 8:52
    • Modifying Workbook Queries - 4:18
    • Merging Queries - 7:43
    • Appending Queries - 5:49
    • Connecting to a Folder of Files - 9:32
    • Power Query Best Practices - 2:44
    • QUIZ: Power Query
    • HOMEWORK: Power Query
  • Data Modeling & Normalization
    • Introduction - 0:28
    • Meet Excel's "Data Model" - 3:38
    • Data vs. Diagram View - 2:33
    • Database Normalization - 4:14
    • Data Tables vs. Lookup Tables - 5:40
    • Relationships vs. Merged Tables - 2:07
    • Creating Table Relationships - 6:54
    • Modifying Table Relationships - 2:06
    • Active vs. Inactive Relationships - 3:55
    • Relationship Cardinality - 5:46
    • Connecting Multiple Data Tables - 5:59
    • Filter Direction - 5:08
    • Hiding Fields from Client Tools - 4:59
    • Defining Hierarchies - 3:53
    • Data Model Best Practices - 1:38
    • QUIZ: Data Modeling 101
    • HOMEWORK: Data Modeling 101
  • Power Pivot & DAX 101
    • Introduction - 0:29
    • Creating a "Power" PivotTable - 5:27
    • "Power" Pivots vs. "Normal" Pivots - 2:48
    • Intro to Data Analysis Expressions (DAX) - 1:12
    • Calculated Columns - 8:39
    • DAX Measures = Supercharged Calculated Fields - 2:24
    • Creating Implicit Measures - 1:59
    • Creating Explicit Measures (AutoSum) - 7:08
    • Creating Explicit Measures (Power Pivot) - 7:42
    • Understanding Filter Context - 9:18
    • Step-by-Step Measure Calculation - 12:06
    • RECAP: Calculated Columns vs. Measures - 2:29
    • Power Pivot Best Practices - 1:50
    • QUIZ: Power Pivot & DAX 101
    • HOMEWORK: Power Pivot & DAX 101
  • Common DAX Functions
    • Introduction - 0:27
    • DAX Formula Syntax & Operators - 4:05
    • Common DAX Function Categories - 3:54
    • Basic Math & Stats Functions - 12:45
    • COUNT, COUNTA, DISTINCTCOUNT & COUNTROWS - 10:35
    • HOMEWORK: Math & Stats Functions
    • Logical Functions (IF/AND/OR) - 16:49
    • SWITCH & SWITCH(TRUE) - 10:33
    • Text Functions - 10:53
    • HOMEWORK: Logical & Text Functions
    • The CALCULATE Function - 14:39
    • Adding Filter Context with FILTER (Part 1) - 9:20
    • Adding Filter Context with FILTER (Part 2) - 14:23
    • Removing Filter Context with ALL - 9:06
    • HOMEWORK: CALCULATE, FILTER & ALL
    • Joining Data with RELATED - 3:39
    • Iterator ("X") Functions: SUMX - 12:20
    • Iterator ("X") Functions: RANKX - 5:33
    • HOMEWORK: Iterator Functions
    • Basic Date & Time Functions - 4:58
    • Time Intelligence Formulas - 17:02
    • HOMEWORK: Time Intelligence
    • Speed & Performance Considerations - 3:02
    • DAX Best Practices - 2:03
    • QUIZ: Common DAX Functions
  • Wrapping Up
    • Introduction - 0:53
    • Data Visualization Options - 4:35
    • SNEAK PEEK: PowerBI - 5:55
    • More from Maven Analytics

View Full Curriculum


Access
Lifetime
Content
1.0 hours
Lessons
19

Excel Pro Tips: Data Visualization

Think Outside the Pie Chart & Explore Some of Excel’s Most Powerful Visualization Tools

By Maven Analytics | in Online Courses

This Excel Data Visualization course is all about bringing data to life, using some of Excel's most powerful visualization tools. The 18 lectures of this course won't be talking about your basic pie charts and line graphs. You will be introduced to Excel's unique features like filled maps, sparklines, custom templates, dynamic visuals, interactive form controls, and much more. If you want to create clear and effective charts and graphs and interactive reports and dashboards, this course is for you.

4.7/5 average rating: ★ ★ ★ ★

  • Access 19 lectures & 1 hour of content 24/7
  • Explore Excel's most powerful visualization tools
  • Know about Excel's unique features like filled maps, sparklines, custom templates. dynamic visuals, interactive form controls & more
  • Create clear & effective charts and graphs as well as interactive reports and dashboards
Note: Software NOT included.
Excel Maven | Award-Winning Analytics & BI Training
4.6/5 Instructor Rating: ★ ★ ★ ★

Excel Maven transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014, they've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.

Chris Dutton is a certified Excel MOS Expert, edtech entrepreneur, and best-selling analytics instructor. As founder and COO of Maven Analytics, Chris' work has been featured by Microsoft, HuffPost, Entrepreneur, and the New York Times, reaching more than 500,000 students around the world. A leader in analytics education, Maven Analytics empowers everyday people to change the world with data.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft Excel

Course Outline

  • Your First Program
  • Getting Started
    • Course Structure & Outline - 1:41
    • DOWNLOAD: Course Resources
    • Setting Expectations - 1:45
  • Visualization Tips
    • Introduction - 0:24
    • Chart Properties (Move & Size) - 5:08
    • Hidden Chart Source Data - 2:43
    • Filled Maps (Excel 2016+) - 5:10
    • Customizing Charts to Tell a Story - 8:53
    • Adding Sparklines - 7:44
    • Custom Chart Templates - 6:06
    • Heat Maps with Color Scales - 7:11
    • Analyzing Distribution with Histograms - 9:28
    • Goal Pacing with Gauge Charts - 10:26
    • Highlighting Time Periods - 8:05
    • Dynamic Source Ranges - 12:08
    • Interactive Form Controls - 11:48
    • QUIZ: Visualization Tips
  • Wrapping Up
    • Resources & Next Steps
    • More from Maven Analytics

View Full Curriculum


Access
Lifetime
Content
8.0 hours
Lessons
113

Microsoft Excel: Advanced Formulas & Functions

Master 75+ Excel Formula & Functions with Hands-On Demos

By Maven Analytics | in Online Courses

It's time to show Excel who's boss! Whether you're starting from square one or aspiring to become an absolute Excel wizard, this is the right place for you. This course will give you a deep understanding of the advanced formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. Through hands-on, contextual examples, you'll learn why these formulas are awesome and how they can be applied in a number of ways.

4.7/5 average rating: ★ ★ ★ ★

  • Access 113 lectures & 8 hours of content 24/7
  • Easily build dynamic tools & Excel dashboards to filter, display, & analyze your data
  • Go rogue & design your own formula-based formatting rules
  • Join datasets from multiple sources in seconds w/ lookup, index, & match functions
  • Pull real-time data from APIs directly into Excel
  • Manipulate dates, times, text, & arrays
  • Automate tedious & time-consuming analytics tasks using cell formulas and functions in Excel
Note: Software NOT included.
Excel Maven | Award-Winning Analytics & BI Training
4.6/5 Instructor Rating: ★ ★ ★ ★

Excel Maven transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014, they've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.

Chris Dutton is a certified Excel MOS Expert, edtech entrepreneur, and best-selling analytics instructor. As founder and COO of Maven Analytics, Chris' work has been featured by Microsoft, HuffPost, Entrepreneur, and the New York Times, reaching more than 500,000 students around the world. A leader in analytics education, Maven Analytics empowers everyday people to change the world with data.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft Excel

Course Outline

  • Your First Program
  • Getting Started
    • Course Structure & Outline - 1:28
    • DOWNLOAD: Course Resources
    • Setting Expectations - 7:12
  • Excel Formulas 101
    • Introduction - 1:48
    • Formula Syntax - 11:03
    • Fixed & Relative References - 8:42
    • Common Error Types - 8:47
    • Formula Auditing: Trace Precedents & Dependents - 10:14
    • Formula Auditing: Evaluate Formula & Error Checking - 7:48
    • Ctrl Shortcuts - 7:30
    • Function Shortcuts - 9:44
    • Alt Key Tips - 4:16
    • BONUS: Mac Shortcuts
    • PRO TIP: Data Validation - 6:12
    • Congrats, You're a Developer! - 5:07
    • QUIZ: Formulas 101
    • HOMEWORK: Formulas 101 - 0:46
  • Conditional Statements & Logical Operators
    • Introduction - 1:23
    • Anatomy of the IF Statement - 4:01
    • Nested IF Statements - 4:53
    • AND/OR Operators - 8:47
    • NOT (<>) Operators - 3:17
    • Addressing Errors with IFERROR - 4:03
    • Common IS Statements - 4:00
    • QUIZ: Conditional Statements & Logical Operators
    • HOMEWORK: Conditional Statements & Logical Operators - 0:44
  • Statistical Functions
    • Introduction - 1:09
    • Basic Stats Functions - 5:17
    • SMALL/LARGE & RANK/PERCENTRANK - 6:15
    • RAND() & RANDBETWEEN - 2:12
    • The SUMPRODUCT Function - 3:55
    • SUMPRODUCT Demo - 4:57
    • COUNTIFS/SUMIFS/AVERAGEIFS - 4:49
    • DEMO: Basic Dashboards with Stats Functions - 8:09
    • Combining COUNTIF & SUMPRODUCT - 7:57
    • PRO TIP: Data Profiling - 16:06
    • QUIZ: Statistical Functions
    • HOMEWORK: Statistical Functions - 0:35
  • Lookup & Reference Functions
    • Introduction - 1:18
    • Named Arrays - 3:30
    • ROW/ROWS & COLUMN/COLUMNS - 3:18
    • VLOOKUP & HLOOKUP - 5:53
    • DEMO: Joining Data with VLOOKUP - 6:23
    • Combining IFERROR & VLOOKUP - 4:30
    • VLOOKUP Range Options - 6:18
    • Approximate Match Lookups - 5:05
    • The INDEX Function - 1:59
    • The MATCH Function - 2:32
    • Combining INDEX & MATCH - 6:08
    • Combining MATCH & VLOOKUP - 4:47
    • UPDATE: VLOOKUP Correction - 5:05
    • SNEAK PEEK: XLOOKUP (Office 365 Only) - 4:29
    • DEMO: Building Dashboards with XLOOKUP - 18:16
    • Selecting List Items with CHOOSE - 13:15
    • The OFFSET Function - 2:05
    • Combining OFFSET & COUNTA - 2:58
    • DEMO: Building a Scrolling Chart with OFFSET - 9:51
    • QUIZ: Lookup & Reference Functions
    • HOMEWORK: Lookup & Reference Functions - 0:54
  • Text Functions
    • Introduction - 0:50
    • UPPER, LOWER, PROPER & TRIM - 3:32
    • CONCATENATE (&) - 3:26
    • LEFT, MID, RIGHT & LEN - 3:31
    • TEXT & VALUE - 4:20
    • SEARCH & FIND - 5:04
    • Categorizing Data with IF(ISNUMBER(SEARCH)) - 5:39
    • Combining RIGHT, LEN & SEARCH - 5:43
    • The SUBSTITUTE Function - 2:21
    • QUIZ: Text Functions
    • HOMEWORK: Text Functions - 0:59
  • Date & Time Functions
    • Introduction - 2:08
    • Understanding DATEVALUE - 5:05
    • Date Formatting & Fill Series - 3:39
    • TODAY() & NOW() - 2:16
    • YEAR/MONTH/DAY & HOUR/MINUTE/SECOND - 3:04
    • The EOMONTH Function - 6:17
    • The YEARFRAC Function - 2:27
    • WEEKDAY, WORKDAY & NETWORKDAYS - 7:22
    • The DATEDIF Function - 4:23
    • DEMO: Budget Pacing Tool - 11:07
    • QUIZ: Date & Time Functions
    • HOMEWORK: Date & Time Functions - 0:35
  • Formula-Based Formatting
    • Introduction - 1:26
    • Creating and Managing Formula-Based Rules - 4:39
    • DEMO: Highlighting Rows with MOD - 3:50
    • DEMO: Formatting Cells Based on Values - 3:29
    • DEMO: Formatting Cells with Stats Functions - 5:28
    • DEMO: Formatting Cells with Text & Conditional Functions - 5:08
    • QUIZ: Formula-Based Formatting
    • HOMEWORK: Formula-Based Formatting - 0:34
  • Basic Array Formulas
    • Introduction - 1:24
    • READ ME: Array Formulas are Changing!
    • Rules of Array Formulas - 3:24
    • Pros & Cons of Array Formulas - 2:15
    • Vertical, Horizontal & 2-D Array Constants - 6:26
    • Using Array Constants in Formulas - 3:38
    • Named Array Constants - 4:31
    • The TRANSPOSE Function - 4:21
    • Linking Data: Array vs. Non-Array Comparison - 2:36
    • DEMO: Returning the "X" Largest Values - 3:09
    • DEMO: Counting Characters Across Cells - 1:52
    • DEMO: Creating a "MAX IF" Function (Part 1) - 3:09
    • DEMO: Creating a "MAX IF" Function (Part 2) - 6:54
    • The Double Unary Operator ("--") - 3:49
    • QUIZ: Array Formulas
    • HOMEWORK: Array Formulas - 2:09
  • Extra Bonus Functions
    • Introduction - 1:38
    • The INDIRECT Function - 10:55
    • The HYPERLINK Function - 6:19
    • WEBSERVICE & FILTERXML: Weather Underground - 7:16
    • WEBSERVICE & FILTERXML: Open Weather Map - 9:14
    • QUIZ: Badass Bonus Functions
  • Wrapping Up
    • More from Maven Analytics

View Full Curriculum


Access
Lifetime
Content
10.0 hours
Lessons
116

Up & Running with Power BI Desktop

Transform, Analyze & Visualize Data Using Microsoft Power BI Desktop

By Maven Analytics | in Online Courses

If you're looking for a comprehensive, hands-on guide to learning Microsoft Power BI Desktop, you've come to the right place. Power BI is quickly becoming the world's most powerful self-service business intelligence platform, and an absolutely essential tool for data professionals and beginners alike. With Power BI you can connect to hundreds of data sources, build complex relational models, and design stunning, interactive dashboards from scratch.

4.6/5 average rating: ★ ★ ★ ★

  • Access 116 lectures & 10 hours of content 24/7
  • Build professional-quality business intelligence reports from the ground up
  • Understand the business intelligence workflow from end-to-end
  • Blend and transform raw data into beautiful interactive dashboards
  • Design implement the same B.I. tools used by professional analysts & data scientists
Note: Software NOT included.
Excel Maven | Award-Winning Analytics & BI Training
4.6/5 Instructor Rating: ★ ★ ★ ★

Excel Maven transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014, they've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.

Chris Dutton is a certified Excel MOS Expert, edtech entrepreneur, and best-selling analytics instructor. As founder and COO of Maven Analytics, Chris' work has been featured by Microsoft, HuffPost, Entrepreneur, and the New York Times, reaching more than 500,000 students around the world. A leader in analytics education, Maven Analytics empowers everyday people to change the world with data.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Power BI
  • Microsoft Excel

Course Outline

  • Your First Program
  • Getting Started
    • Course Structure & Outline - 1:43
    • DOWNLOAD: Course Resources
    • Introducing the Adventure Works Project - 3:02
    • Setting Expectations - 2:21
  • Introducing Power BI Desktop
    • Introduction - 0:26
    • Meet Power BI - 5:30
    • Downloading Power BI & Adjusting Settings - 4:05
    • IMPORTANT: Regional Settings
    • The Power BI Interface & Workflow - 2:34
    • Helpful Resources - 1:44
    • UPDATE: New Power BI Ribbon (2020) - 7:15
    • QUIZ: Introducing Power BI Desktop
  • Connecting & Shaping Data
    • Introduction - 0:30
    • Types of Data Connectors - 3:53
    • The Query Editor - 4:28
    • Basic Table Transformations - 10:03
    • Text-Specific Tools - 14:54
    • Number-Specific Tools - 8:37
    • Date-Specific Tools - 8:53
    • PRO TIP: Creating a Rolling Calendar - 7:08
    • Index & Conditional Columns - 8:30
    • Grouping & Aggregating Data - 7:33
    • Pivoting & Unpivoting - 8:04
    • Merging Queries - 6:41
    • Appending Queries - 6:29
    • PRO TIP: Appending Files from a Folder - 7:38
    • Data Source Settings - 5:05
    • Query Refresh Settings - 3:06
    • Additional Data Types & Categories - 7:19
    • Defining Hierarchies - 4:35
    • PRO TIP: Importing Models from Excel - 5:40
    • Data Connection Best Practices - 2:09
    • QUIZ: Connecting & Shaping Data
    • HOMEWORK: Connecting & Shaping Data
    • HOMEWORK SOLUTION: Connecting & Shaping Data - 12:36
  • Creating a Data Model
    • Introduction - 0:19
    • What is a "Data Model"? - 5:17
    • Database Normalization - 4:07
    • Data Tables vs. Lookup Tables - 7:25
    • Relationships vs. Merged Tables - 2:31
    • Creating Table Relationships - 4:34
    • "Snowflake" Schemas - 3:09
    • Managing & Editing Relationships - 2:44
    • Active vs. Inactive Relationships - 2:45
    • Relationship Cardinality - 5:08
    • Connecting Multiple Data Tables - 8:26
    • Understanding Filter Flow - 6:33
    • Two-Way Filters (Use with Caution!) - 13:16
    • Hiding Fields from Report View - 4:15
    • UPDATE: New Model View - 8:32
    • Data Model Best Practices - 1:34
    • QUIZ: Creating a Data Model
    • HOMEWORK: Creating a Data Model
    • HOMEWORK SOLUTION: Creating a Data Model - 14:09
  • Adding Calculated Fields with DAX
    • Introduction - 0:32
    • Meet DAX - 1:03
    • Intro to Calculated Columns - 7:33
    • Intro to Measures - 2:51
    • RECAP: Calculated Columns vs. Measures - 1:34
    • Adding Columns & Measures - 3:12
    • Implicit vs. Explicit Measures - 6:27
    • Filter Context Examples - 8:07
    • Step-by-Step Measure Calculation - 2:39
    • DAX Syntax & Operators - 3:49
    • Common DAX Function Categories - 3:16
    • Basic Date & Time Functions - 12:24
    • Logical Functions - 10:06
    • Text Functions - 9:24
    • Joining Data with RELATED - 8:54
    • Basic Math & Stats Functions - 14:01
    • COUNT Functions - 7:46
    • IMPORTANT: Order Line Items - 6:21
    • The CALCULATE Function - 13:06
    • CALCULATE & ALL - 9:25
    • CALCULATE & FILTER - 9:37
    • Iterator ("X") Functions - 12:27
    • DAX Time Intelligence Formulas - 12:29
    • DAX Best Practices - 2:57
    • QUIZ: Adding Calculated Fields
    • HOMEWORK: Adding Calculated Fields
    • HOMEWORK SOLUTION: Adding Calculated Fields - 15:05
  • Visualizing Data with Reports
    • Introduction - 0:29
    • The "Report" View - 5:33
    • Adding Simple Objects - 3:07
    • Inserting Basic Charts & Visuals - 5:47
    • UPDATE: Conditional Formatting - 2:58
    • Formatting Options - 9:51
    • Report Filtering Options - 11:09
    • DEMO: Matrix Visuals - 6:38
    • DEMO: Date Slicers - 7:14
    • DEMO: Cards & KPIs - 9:24
    • DEMO: Text Cards - 6:14
    • DEMO: Map Visuals - 7:15
    • DEMO: Treemaps - 3:21
    • DEMO: Line & Area Charts - 6:23
    • DEMO: Trend Lines & Forecasts - 5:36
    • DEMO: Gauge Charts - 6:43
    • Editing Report Interactions - 6:38
    • Adding Drillthrough Filters - 5:08
    • Adding Report Bookmarks - 5:49
    • "What-If" Parameters - 11:47
    • Managing & Viewing Roles - 5:27
    • PREVIEW: Custom Visuals (Log-In Required) - 2:05
    • PREVIEW: Designing for Phone vs. Desktop - 2:54
    • PREVIEW: Publishing to Power BI Service - 2:27
    • Data Visualization Best Practices - 1:35
    • QUIZ: Visualizing Data with Reports
    • HOMEWORK: Visualizing Data with Reports
    • HOMEWORK SOLUTION: Visualizing Data with Reports - 7:22
  • NEW: Artificial Intelligence (AI) Visuals
    • The Q&A Visual - 10:54
    • The Key Influencers Visual (Part 1) - 12:34
    • The Key Influencers Visual (Part 2) - 5:11
    • IMPORTANT: Correlation vs. Causation - 4:24
    • The Decomposition Tree Visual - 8:59
  • Wrapping Up
    • More from Maven Analytics
    • REFERENCE: Monthly Power BI Updates

View Full Curriculum


Access
Lifetime
Content
5.0 hours
Lessons
85

Microsoft Excel: Data Analysis with Excel Pivot Tables

Master Excel Pivot Tables & Pivot Charts with Hands-On Demos

By Maven Analytics | in Online Courses

Pivot Tables are an essential tool for anyone who works with data in Excel. Pivots allow you to explore and analyze raw data quickly, revealing powerful insights and trends otherwise buried in the noise. In other words, they give you answers. Whether you're exploring product sales, analyzing marketing tactics, or wonder how Boston condo prices have trended over the past 15 years, Excel Pivot Tables provide fast, accurate, and intuitive solutions to even the most complicated questions. This course will give you a deep, 100% comprehensive understanding of Pivot Tables and Pivot Charts.

4.6/5 average rating: ★ ★ ★ ★

  • Access 85 lectures & 5 hours of content 24/7
  • Cover raw data structure, table layouts & styles
  • Explore design & formatting options
  • Understand sorting, filtering, & grouping tools
  • Anaylze data from a number of real-world case studies including San Diego burrito ratings, shark attack records, MLB team statistics, & more
Note: Software NOT included.
Excel Maven | Award-Winning Analytics & BI Training
4.6/5 Instructor Rating: ★ ★ ★ ★

Excel Maven transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014, they've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.

Chris Dutton is a certified Excel MOS Expert, edtech entrepreneur, and best-selling analytics instructor. As founder and COO of Maven Analytics, Chris' work has been featured by Microsoft, HuffPost, Entrepreneur, and the New York Times, reaching more than 500,000 students around the world. A leader in analytics education, Maven Analytics empowers everyday people to change the world with data.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft Excel

Course Outline

  • Your First Program
  • Getting Started
    • Course Structure & Outline - 1:32
    • Getting to Know the IMDb Movie Database - 2:21
    • Setting Expectations - 1:14
  • PivotTable 101
    • Why PivotTables? - 4:10
    • Structuring the Source Data - 2:00
    • Inserting Your First PivotTable - 3:13
    • Navigating the Field List - 7:43
    • Analyze & Design Options - 1:33
    • Selecting, Clearing, Moving & Copying Pivots - 5:14
    • Refreshing & Updating Pivots - 7:30
    • PRO TIP: Dealing with Growing Source Data - 6:49
    • Removing & Reviving Data from Cache - 5:41
    • How PivotTables ACTUALLY Work - 3:39
    • QUIZ: PivotTable 101
    • HOMEWORK: PivotTable 101
  • PivotTable Formatting
    • Number Formatting - 2:12
    • PRO TIP: Formatting Empty Cells - 1:41
    • Table Layouts & Styles - 5:30
    • PRO TIP: Using Tabular Layouts to Create New Tables - 2:20
    • Customizing Headers & Labels - 1:16
    • Adding Conditional Formats - 6:51
    • PRO TIP: Data Bars with Invisible Text - 2:13
    • Advanced Conditional Formatting - 6:51
    • QUIZ: PivotTable Formatting
    • HOMEWORK: PivotTable Formatting
  • Sorting, Filtering & Grouping
    • Basic Sorting Options - 5:01
    • PRO TIP: Incorrect Alphabetical Sorting - 2:01
    • Label Filters & Manual Selections - 8:15
    • PRO TIP: Label Filters with Wildcards - 3:15
    • Value Filters - 3:10
    • PRO TIP: Enabling Multiple Filters - 2:42
    • Grouping Data - 3:23
    • Automatic Date Grouping - 4:25
    • Filtering with Slicers & Timelines - 4:51
    • Breaking Out Report Filter Pages - 4:13
    • QUIZ: Sorting, Filtering & Grouping
    • HOMEWORK: Sorting, Filtering & Grouping
  • Calculated Values & Fields
    • Summarizing Values - 4:45
    • PRO TIP: Avoiding the "Count Of" Trap - 3:49
    • "Show Values As" Calculations - 3:35
    • Show Values As: % of Column/Row - 3:47
    • Show Values As: % of Parent - 3:02
    • Show Values As: Difference From - 4:41
    • Show Values As: Running Total - 2:44
    • Show Values As: Rank - 2:36
    • Show Values As: Index - 8:06
    • Inserting Calculated Fields - 6:30
    • Calculations in Pivots vs. Raw Data - 4:32
    • Calculating Using Counts (Part 1) - 7:20
    • Calculating Using Counts (Part 2) - 4:19
    • Calculated Items (NOT RECOMMENDED) - 6:11
    • Solve Order & List Formula Tools - 4:54
    • QUIZ: Calculated Values & Fields
    • HOMEWORK: Calculated Values & Fields
  • Data Visualization with Pivot Charts
    • Intro to PivotCharts - 2:26
    • DEMO: Column Chart - 4:13
    • DEMO: Pie & Donut Charts - 5:46
    • DEMO: Clustered Bar Chart - 3:25
    • PRO TIP: Prevent Charts from Resizing with Cells - 4:45
    • Changing Chart Types on the Fly - 3:18
    • DEMO: Stacked Area Chart - 5:46
    • PivotChart Layouts & Styles - 4:03
    • Moving PivotCharts to New Sheets - 2:09
    • Applying Slicers & Timelines to Multiple Charts - 5:01
    • DEMO: Building a Dynamic Dashboard - 13:22
    • QUIZ: PivotCharts
    • HOMEWORK: PivotCharts
  • PivotTable Case Studies
    • Setting Expectations - 1:45
    • U.S. Voters (2012) - 10:33
    • HOMEWORK: U.S. Voters (2012)
    • San Francisco Salaries - 13:06
    • HOMEWORK: San Francisco Salaries
    • Shark Attack Records - 10:31
    • HOMEWORK: Shark Attack Records
    • Stock Market Data - 12:25
    • HOMEWORK: Stock Market Data
    • Baseball Team Statistics - 14:16
    • HOMEWORK: Baseball Team Statistics
    • San Diego Burrito Ratings - 16:40
    • HOMEWORK: San Diego Burrito Ratings
    • Daily Weather Conditions - 12:41
    • HOMEWORK: Daily Weather Conditions
    • Spartan Race Facebook Posts - 14:37
    • HOMEWORK: Spartan Race Facebook Posts
  • Wrapping Up
    • More from Maven Analytics

View Full Curriculum


Access
Lifetime
Content
4.0 hours
Lessons
61

Microsoft Excel: Data Visualization with Excel Charts & Graphs

Master 20+ Charts & Graphs in Excel with Hands-On Demos

By Maven Analytics | in Online Courses

Ask people what comes to mind when they think of Excel and odds are they'll say, "spreadsheets". However, Excel is an incredibly powerful, robust, and dynamic data visualization platform. This course will give you a deep, comprehensive understanding of Excel's latest data visualization tools and techniques. You'll learn when, why, and how to use each chart type, discover key data visualization best practices, and learn through interactive, hands-on demos and exercises every step of the way.

4.6/5 average rating: ★ ★ ★ ★

  • Access 61 lectures & 4 hours of content 24/7
  • Understand when, why & how to use 20+ chart types in Excel
  • Learn advanced Excel tools like automated dashboards, scrolling charts, dynamic formats, & more
  • Master unique tips, tools and case studies that you won't find in any other Excel course
  • Build 10+ Excel projects designed to take your data visualization skills to the next level
Note: Software NOT included.
Excel Maven | Award-Winning Analytics & BI Training
4.6/5 Instructor Rating: ★ ★ ★ ★

Excel Maven transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014, they've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.

Chris Dutton is a certified Excel MOS Expert, edtech entrepreneur, and best-selling analytics instructor. As founder and COO of Maven Analytics, Chris' work has been featured by Microsoft, HuffPost, Entrepreneur, and the New York Times, reaching more than 500,000 students around the world. A leader in analytics education, Maven Analytics empowers everyday people to change the world with data.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft Excel

Course Outline

  • Your First Program
  • Getting Started
    • Course Structure & Outline - 1:27
    • Bonus Homework Exercises
    • Setting Expectations - 2:02
  • Data Visualization Best Practices
    • Key Principles & The 10-Second Rule - 2:45
    • The Good, The Bad & The Ugly - 3:44
    • Three Key Questions - 1:49
  • Chart Formatting & Customization
    • Chart Elements, Layouts & Styles - 6:20
    • Chart Formatting Options - 5:26
    • Changing Chart Types & Adding a Secondary Axis - 3:03
    • Creating, Modifying & Applying Custom Templates - 4:06
    • QUIZ: Chart Customization
  • Mastering Basic Charts & Graphs
    • Bar & Column Charts - 8:49
    • HOMEWORK: Bar & Column Charts
    • Histogram & Pareto Charts - 5:58
    • HOMEWORK: Histogram & Pareto Charts
    • Line Charts & Trendlines - 5:16
    • HOMEWORK: Line Charts & Trendlines
    • Area Charts - 4:41
    • HOMEWORK: Area Charts
    • Pies, Donuts & Race Tracks - 12:04
    • HOMEWORK: Pies, Donuts & Race Tracks
    • Scatter Plots - 7:30
    • Bubble Charts - 6:36
    • HOMEWORK: Scatter Plots & Bubble Charts
    • Box & Whisker Charts - 6:05
    • HOMEWORK: Box & Whisker Charts
    • Tree Maps & Sunbursts - 6:36
    • HOMEWORK: Tree Maps & Sunbursts
    • Waterfall Charts - 3:17
    • Funnel Charts - 3:42
    • HOMEWORK: Waterfall & Funnel Charts
    • Radar Charts - 7:56
    • HOMEWORK: Radar Charts
    • Stock Charts - 7:18
    • HOMEWORK: Stock Charts
    • Heat Maps - 4:41
    • HOMEWORK: Heat Maps
    • Surface & Contour Charts - 7:35
    • HOMEWORK: Surface & Contour Charts
    • Geospatial Maps with Power Map - 5:28
    • HOMEWORK: Power Map
    • Basic Combo Charts - 7:57
    • HOMEWORK: Combo Charts
    • Sparklines - 2:07
    • HOMEWORK: Sparklines
    • QUIZ: Basic Charts & Graphs
  • Next-Level Data Viz Demos
    • Setting Expectations - 1:40
    • DEMO: Custom Image Overlay Charts - 6:01
    • DEMO: Adding Binary Values to Highlight Ranges - 5:02
    • DEMO: Automation with OFFSET & COUNTA - 7:08
    • DEMO: Adding Interactive Elements with Form Controls - 12:30
    • DEMO: Animating Changes Over Time - 14:20
    • DEMO: Building a Dynamic Dashboard (Part 1) - 16:10
    • DEMO: Building a Dynamic Dashboard (Part 2) - 12:08
    • DEMO: Dynamic Value-Based Formatting - 10:09
    • DEMO: Dynamically Highlighting a Data Series - 10:26
    • DEMO: Building a Custom Pacing Chart - 10:22
    • DEMO: Building a Custom Gauge Chart - 9:58
    • DEMO: Visualizing Percentages with Arrays - 7:16
    • QUIZ: Next-Level Data Viz
  • Wrapping Up
    • More from Maven Analytics

View Full Curriculum


Access
Lifetime
Content
4.0 hours
Lessons
23

Microsoft Excel: Learn MS Excel for Data Analysis

Use Excel for Data Analysis by Creating Your Own Excel Apps

By Yassin Marco | in Online Courses

The way this class has been designed to offer the student an easy way to learn Microsoft Excel and the basics of data analysis at the same time. Indeed, not only this course is teaching you all the basic concepts and functions of Microsoft Excel but at the same time, you will have all the required knowledge to create basic Apps that can be used to analyze data. The course is divided into big projects. This way, each time that you learn a new concept you will create a project around it. This will help you not only have a better understanding of the concept but also be able to see in what real-life situations a certain concept can be useful.

4.2/5 average rating: ★ ★ ★ ★

  • Access 23 lectures & 4 hours of content 24/7
  • Write down basic Excel formulas
  • Understand how to think outside of the box to create powerful excel projects
  • Make basic data analysis with Excel
  • Work with massive amount of data
Note: Software NOT included
Yassin Marco
4.1/5 Instructor Rating: ★ ★ ★ ★

Yassin has a BS in international management and multiple certifications in management and IT. He works on a daily basis with various Microsoft apps and is a specialist in excel as well as in various other fields such as online business creation and promotion, marketing, and many more. Also, he has a passion for finances and has helped many people in taking their first steps in the trading and investing world, from basic financial coaching to advanced Stock/Forex data analysis.

He has developed a passion for coaching and educating and has helped more than 380,000+ students on multiple online platforms. Teaching in English and French, he has been able to reach across to people spanning from over 198 countries.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft Excel

Course Outline

  • Your First Program
  • Intro
    • Introduction - 9:30
    • What is Data analysis - 9:17
  • The bases of Excel
    • Excel important functions to know - 20:01
    • Condition formating - 10:49
  • Project 1: Project analysis
    • Creating our Data base - 27:57
    • Defining our Goals - 8:23
    • Extraction of basic Data (part 1) - 18:19
    • Extraction of basic Data (Part 2) - 8:33
    • Extraction of advanced Data - 15:41
    • Creation of a Dashboard (part 1) - 12:21
    • Creation of a Dashboard (part 2) - 13:44
  • Project 2 Evaluation of a stock
    • Importation and creation of a Data Base - 3:25
    • Defining the goal of the analysis - 4:33
    • Extraction of Data - 11:05
    • Generating a simulation with our results - 7:34
    • Creation of a Dashboard and results evaluation - 5:30
  • Project 3: Creation of a HR management APP
    • Creation of a Data Base - 8:01
    • Defining all the goals of the APP - 2:52
    • Creation of the APP (part 1) - 22:32
    • Creation of the APP (part 2) - 6:29
    • Creation of the APP (part 3) - 16:15
    • Creation of the APP (part 4) - 10:17
  • Conclusion
    • Conclusion - 2:21

View Full Curriculum


Access
Lifetime
Content
4.0 hours
Lessons
33

Microsoft Excel: Basic/Advanced Excel Formulas

Learn More Than 80 Excel Functions, Formulas & Tips

By Yassin Marco | in Online Courses

If you want to improve your Excel skills, learn to use new functions, or simply interested in becoming better in this amazing Microsoft app then this course is for you. This course teaches you how to properly work with more than 80+ Excel functions and formulas. Also, all of those formulas are presented with clear examples so you will be able to use them to create your own programs.

4.1/5 average rating: ★ ★ ★ ★

  • Access 33 lectures & 4 hours of content 24/7
  • Understand the basics of Microsoft Excel
  • Learn how to properly work with Microsoft Excel
  • Get different tips & tricks of this amazing Excel app
  • Learn new functions & formulas and be able to use them every time that you work with Microsoft Excel
Note: Software NOT included
Yassin Marco
4.1/5 Instructor Rating: ★ ★ ★ ★

Yassin has a BS in international management and multiple certifications in management and IT. He works on a daily basis with various Microsoft apps and is a specialist in excel as well as in various other fields such as online business creation and promotion, marketing, and many more. Also, he has a passion for finances and has helped many people in taking their first steps in the trading and investing world, from basic financial coaching to advanced Stock/Forex data analysis.

He has developed a passion for coaching and educating and has helped more than 380,000+ students on multiple online platforms. Teaching in English and French, he has been able to reach across to people spanning from over 198 countries.
  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft Excel

Course Outline

  • Your First Program
  • Introduction
    • introduction - 5:47
    • Principal types of Excel functions - 9:11
  • Date and Time Functions
    • Date and Time Functions Part 1 - 8:43
    • Date and Time Functions Part 2 - 7:57
    • Date and Time Functions Part 3 - 7:58
    • Date and Time Functions part 4 - 8:25
  • Financial Functions
    • Financial Functions Part 1 - 20:30
    • Financial Functions Part 2 - 10:42
    • Financial Functions Part 3 - 12:07
    • Financial Functions Part 4 - 6:42
    • Financial Functions Part 5 - 13:07
    • Financial Functions Part 6 - 6:40
  • Informational Functions
    • Informational Functions Part 1 - 8:08
    • Informational Functions Part 2 - 7:36
    • Informational Functions Part 3 - 6:06
    • Informational Functions Part 4 - 7:02
  • Logical Functions
    • Logical Functions Part 1 - 10:29
    • Logical Functions Part 2 - 8:50
  • Lookups and References
    • Lookups and References Part 1 - 6:03
    • Lookups and References Part 2 - 9:03
    • Lookups and References Part 3 - 6:46
    • Lookups and References Part 4 - 1:40
  • Math Functions
    • Math Functions Part 1 - 8:13
    • Math Functions Part 2 - 7:12
    • Math Functions Part 3 - 10:53
    • Math Functions Part 4 - 7:09
    • Math Functions Part 5 - 6:54
  • Statistical Functions
    • Statistical Functions Part 1 - 6:23
    • Statistical Functions Part 2 - 7:49
    • Statistical Functions Part 3 - 7:32
    • Statistical Functions Part 4 - 6:51
    • Statistical Functions Part 5 - 6:38
  • Conclusion
    • Conclusion - 6:36

View Full Curriculum


Access
Lifetime
Content
3.0 hours
Lessons
37

Project Finance Ninja Course

Build Project Finance Models From Scratch & Discover Their Economic Feasibilit

By Yoda Learning | in Online Courses

Project Finance Ninja Course is for students and professionals pursuing careers in investment banking, private equity, corporate finance, and equity research. It will give you an in-depth understanding of financial statements and modeling. This course pulls no punches — it is the exact same comprehensive training program top investment banks and financial institutions use to prepare analysts and associates for calculating the risk involved in financial projects and defining the boundaries and scope of the project. Project Finance Ninja Course, will introduce you to several useful tools that can be applied by project managers to operate project-based financing.

4.6/5 average rating: ★ ★ ★ ★

  • Access 37 lectures & 3 hours of content 24/7
  • Apply a structured & systematic approach to financing projects
  • Understand the creation of flags
  • Calculate Escalation Rate, IRR, & NPV
  • Take substantiate investment decisions
  • Build schedules using the BASE approach
  • Build the schedule for Revenue Forecast, Capital Expenditure, Annual & Accumulated Depreciation
  • Recognize the top key characteristics of a robust project & later identify the weakest links in the transaction
Note: Software NOT included
Yoda Learning
4.3/5 Instructor Rating: ★ ★ ★ ★

Yoda Learning is a team of 12+ industry professionals focused on developing project-based learning solutions, which allows students to accrue real-world experience and learn in an engaging and practical manner. Its courses encompass everything from web and mobile app development to data analytics and design.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: advanced

Requirements

  • Basic knowledge of accounting

Course Outline

  • Your First Program
  • Introduction
    • Introduction - 3:38
  • Component Model
    • 0201 Introduction of Component & Download Case Study - 2:23
    • 0203 Creation of Flags Part 2 (Start Date and End Date) Final - 10:27
    • 0202 Creation of Flags Part 1 (Holiday Expense) - 6:26
    • 0204 Creation of Flags Part 3 (Recurring Expense) - 6:57
    • 0205 Calculation of Escalation Rate - 8:21
    • 0206 Building Schedules using BASE Approach - 4:21
    • 0207 Constructing a Depreciation Cap - 4:25
    • 0210 Preparing a Loan Repayment Schedule - 5:12
    • 0212 Calculation of IRR & NPV - 10:56
    • 0209 Creating a Waterfall Structure - 5:53
    • 0211 Using VLOOKUP with True - 5:37
    • 0208 Building a Circularity Switch - 8:16
  • Financial Model
    • 0301 Model Preview & Download Case Study - 4:05
    • 0302 Project Details and Assumptions Sheet - 10:40
    • 0305 Building the schedule for Capital Expenditure - 4:44
    • 0303 Sheet Preview and Building Dynamic Timeline - 6:43
    • 0304 Building the schedule for Revenue Forecast - 4:59
    • 0305 Building the schedule for Capital Expenditure - 4:44
    • 0306 Building the schedule for Annual & Accumulated Depreciation - 5:27
    • 0307 Building the schedule for Financial Structure - 3:59
    • 0308 Building the schedule for Equity - 1:01
    • 0309 Building the schedule for Government Grant - 0:59
    • 0310 Building the schedule for Debt - 13:01
    • 0311 Building the schedule for Other Operational Costs - 2:14
    • 0312 Building the schedule for Working Capital - 7:00
    • 0313 Building the schedule for Dividend - 2:52
    • 0314 Building the schedule for Tax - 1:48
    • 0315 Linking the Income Statement - 4:46
    • 0316 Linking the Balance Sheet - 4:06
    • 0317 Linking the Cash Flow Statement - 4:37
    • 0318 Building the schedule for Cash Surplus and Cash Overdraft - 9:23
    • 0319 Key Concepts for the Calculation of IRR & NPV & Download Case Study - 7:51
    • 0320 Calculating Unlevered IRR - 3:59
    • 0321 Calculating Unlevered NPV - 8:12
    • 0322 Calculating Levered IRR - 3:25
    • 0323 Calculating Levered NPV - 3:03

View Full Curriculum


Access
Lifetime
Content
2.0 hours
Lessons
46

Power Query for Excel & Power BI

2 Hours of Content on Power Query, Excel, BI, and SQL Server Data Tools

By Yoda Learning | in Online Courses

According to a Forbes survey, business users spend up to 80% of their time on data preparation, delaying the time to data analysis and decision making. Power Query is one of the most important data preparation tools. It acts as an ETL tool that can extract data across a wide variety of sources, transform it quickly and easily, and then load it directly into your table/data model. This course will teach you everything you need to know to import, merge, shape, and clean data. Power Query Course learning means you will spend negligible time in data preparation.

4.6/5 average rating: ★ ★ ★ ★

  • Access 46 lectures & 2 hours of content 24/7
  • Get data from a single file (Excel, Text, CSV, & more)
  • Import multiple files from a given folder
  • Get data from other sources like a table/range from the web & current workbook
  • Sort & filter columns
  • Convert data types – text, numbers, dates
  • Split or merge columns
  • Merge two queries like joining in SQL
  • Add calculated columns
  • Unpivot data to use pivot tables
Note: Software NOT included
Yoda Learning
4.3/5 Instructor Rating: ★ ★ ★ ★

Yoda Learning is a team of 12+ industry professionals focused on developing project-based learning solutions, which allows students to accrue real-world experience and learn in an engaging and practical manner. Its courses encompass everything from web and mobile app development to data analytics and design.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Excel 2010+ and Power BI

Course Outline

  • Your First Program
  • Download Practice Files
    • Practice Files
  • Section 01: Getting Ready
    • 1_Introduction to Power Query - What is it? How to access it? - 3:05
    • 2_Power Query User Interface - A Walkthrough - 2:58
    • 3_Power BI - Nov 2019 Update - 0:53
    • 4_M-Query Basics - Reading Commands in Power Query Editor - 2:23
    • 5_Activate your Applied Steps Panel - 0:46
    • Feedback
    • 6_Getting the List of all M-Query Commands - 2:47
    • 7_Importing Data (incl Use First Rows as Header) - 2:48
    • Course Feedback
  • Section 02: Data Preparation - Part 1 (Blending)
    • 1_Combine or Merge Multiple Files from a Folder - 6:02
    • 2_Importing Data from the Web - 7:04
    • 3_Merge Queries vs. Append Queries - 2:34
    • 4_JOIN Types for Beginners - 3:59
    • 5_Understanding JOIN Concept and its Types - 6:21
    • 6_JOIN in Action - Basic Example - 5:57
    • 7_Quick DOs and DONTs for Merge Queries - 3:05
    • 8_Merging Queries with more than 1 KeyID Column - 6:35
    • 9_Fuzzy Lookup - 5:37
    • Course Feedback
  • Section 03: Data Preparation - Part 2 (Cleaning)
    • 1_Using First Rows as Header - 1:43
    • 2_Cleaning Up Data with Case Change, TRIM, CLEAN - 3:29
    • 3_Working with Data Types - 2:29
    • 4_Fill Down Feature - 1:59
    • 5_Removing Duplicates and Blank Rows - 4:05
    • 6_Split Column - Part 1 (Delimiter and By Position) - 4:44
    • 7_Split Column - Part 2 (Digit vs Non-Digit) - 3:24
    • 8_Split Column - Part 3 (Split to Rows) - 4:53
    • 9_Rectify Date Format using Data Type (Locale) - 5:12
    • 10_Working with Column From Examples Feature - 3:56
    • 11_Adding a Conditional Column - 3:22
    • 12_Merge Columns (Concatenate) - 1:48
    • 13_Replace Values and Extract Characters - 5:46
    • Course Feedback
  • Section 04: Data Preparation - Part 3 (Re-Structuring)
    • 1_Unpivot Column - Cross Tab vs. Flat File - 3:57
    • 2_Group By - Basic to Advanced - 4:51
    • 3_Pivot Column - An Overview - 3:39
    • 4_Transpose - 2:20
    • Course Feedback
  • Section 05: Data Preparation - Part 4 (ETL Project)
    • Project - Find Top 3 Analysts - 8:52
    • Course Feedback
  • Section 06: Bonus Tricks
    • 1_Copy Data from Power Query Tables - 0:47
    • 2_Column Profiling and Distribution - 3:01
    • 3_Duplicate and Rename Queries - 0:57
    • 4_Index Column - 1:01
    • Course Feedback

View Full Curriculum


Access
Lifetime
Content
3.0 hours
Lessons
30

Visual Storytelling with Power BI

Learn Data Modeling Basics, Visualization & Analytics, and More

By Yoda Learning | in Online Courses

Power BI helps to create business insights into an everyday routine. You don’t need to be any professional or administrator for creating analytical reports and so on. This self-service BI tool enables you to transform, visualize, and analyze your data. It also allows you to gain decision-enabling insights with higher speed, ease, efficiency, and understanding. In this course, you'll learn powerful features and applications like changing data dimensions and measures, calculated columns, custom visualization, DAX formula language, data drill down, binned tables, and much more.

4.6/5 average rating: ★ ★ ★ ★

  • Access 30 lectures & 3 hours of content 24/7
  • Blend & transform raw data
  • Create interactive dashboards & reports
  • Create impeccable visuals/charts
  • Understand business intelligence workflow
  • Create data models
  • Use DAX formulas to perform calculations
Note: Software NOT included
Yoda Learning
4.3/5 Instructor Rating: ★ ★ ★ ★

Yoda Learning is a team of 12+ industry professionals focused on developing project-based learning solutions, which allows students to accrue real-world experience and learn in an engaging and practical manner. Its courses encompass everything from web and mobile app development to data analytics and design.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: intermediate

Requirements

  • Power BI
  • Basic knowledge of Excel’s Pivot Table & basic charts
  • Basic knowledge of graphs, charts, & visualizations

Course Outline

  • Your First Program
  • Section 1: Introduction
    • How to Download Power BI for free
    • Power BI and Power Query User Interface
    • Power BI Components
    • Power BI - Case Studies
    • Power BI Visualization - UI (Coming Soon)
    • General Formatting Concepts (Coming Soon)
  • Section 2: Charts and Visuals (Part 1)
    • Slicer - Part 1 - 4:46
    • Slicer - Part 2 (Advanced) - 2:44
    • Matrix - Part 1 of 2 - 7:47
    • Matrix - Part 2 of 2 - 4:41
    • Table - 2:51
    • Pie and Donut - 3:44
    • Clustered Bar and Clustered Column - Part 1 - 9:49
    • Clustered Bar and Clustered Column - Part 2 - 2:49
    • Ribbon - 2:57
    • Stacked Bar and Stacked Column - 4:57
    • Treemap - 4:11
    • Line and Area - Part 1 - 4:13
    • Line and Area - Part 2 - 4:49
    • 100% Stacked Bar and Column - 4:05
    • Card and Multi-Row Card - 4:41
    • Stacked Area - 2:30
    • Course Feedback
  • Power BI - Webinar
    • Power BI - Different Charts, Tips, and Tricks - 89:35
  • Section 3: Charts and Visuals (Part 2)
    • Scatter: Top Tricks - 7:22
    • Ask a Question (Q&A) - 2:51
    • Decomposition Tree - 7:02
    • Course Feedback
  • Section 4: Visualization Tricks
    • Edit Interactions - 4:12
    • Course Feedback

View Full Curriculum


Access
Lifetime
Content
3.0 hours
Lessons
74

Tableau Training & Certification

Analyze Trends Visually & Make Quick Decisions with 3 Hours of Content on Tableau Essential

By Yoda Learning | in Online Courses

Data Visualization is a powerful aspect of business analytics. It helps to detect patterns, trends, and outliers in groups of data. Good data visualization is the art of presenting the data in a manner that even a non-analyst can understand it. It places meaning into complicated datasets so that their message is clear and concise. In this course, you'll learn how to use Tableau, one of the best data visualization software in the market. You can enjoy real-time data analytics by directly connecting your data to Tableau from the data warehouse.

4.6/5 average rating: ★ ★ ★ ★

  • Access 74 lectures & 3 hours of content 24/7
  • Learn how to prepare & process data
  • Code & visualize data
  • Work with different file formats
  • Understand complex business problems
  • Know methods to apply statistical & visualizing skills
  • Learn dashboard functionalities like Actions, Navigation, & Parameters
  • Learn about different chart types
Note: Software NOT included
Yoda Learning
4.3/5 Instructor Rating: ★ ★ ★ ★

Yoda Learning is a team of 12+ industry professionals focused on developing project-based learning solutions, which allows students to accrue real-world experience and learn in an engaging and practical manner. Its courses encompass everything from web and mobile app development to data analytics and design.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: intermediate

Requirements

  • Some knowledge of graphs and charts
  • Familiarity with Excel and SQLs

Course Outline

  • Your First Program
  • Section 01: Introduction
    • 0101 Introduction - 0:44
    • 0102 Tableau Products - 2:50
    • 0103 Tableau Course Structure - 1:19
    • 0104 Superstore Dataset Explained - 0:57
    • 0105 Tableau Gallery - 1:47
    • Feedback 01 | Tableau - Training and Certification
  • Section 02: The Business Challenge 1 - Imagine Yourself as a Tableau Developer
    • Download the Practice File
    • 0201 Analyzing Business Case in Excel - 1:36
    • 0202 Connecting to a Data File - 3:20
    • 0203 Segment Wise Sales and Region Wise Profit - 8:01
    • 0204 Map View and Scatter Plot - 8:09
    • 0205 Profit Margin by State and Customers - 5:49
    • Feedback 02 | Tableau - Training and Certification
  • Section 03: Live vs. Extract and Discrete vs. Continuous
    • 0301 Session Introduction - 0:45
    • 0302 Live and Extract Connections - Theory - 0:54
    • 0303 Working with Live Connection - 2:24
    • 0304 Working with Extract Connection - 1:29
    • 0305 Discrete vs. Continuous - Part 1 - 3:41
    • 0306 Discrete vs. Continuous - Part 2 - 1:33
    • 0307 Quick Recap - 0:27
    • Feedback 03 | Tableau - Training and Certification
  • Section 04: Dashboard Making Techniques
    • Download the Practice File
    • 0401 Session Introduction - 0:29
    • 0402 Sales and Profit by State - 3:45
    • 0403 Calculated Fields - 1:51
    • 0404 Global Filters - 4:58
    • 0405 Linking Sheets and Creating Action Filter - 3:18
    • Feedback 04 | Tableau - Training and Certification
  • Section 05: Data Joining and Blending
    • 0501 Introduction to JOINS - 6:23
    • Feedback 05 | Tableau - Training and Certification
  • Section 06: The Business Challenge 2 - Actual Sales vs. Target Sales
    • Download the Practice Files
    • 0601 Actual Sales vs. Target Sales - 9:02
    • 0602 Difference between Actual Sales vs. Target Sales - 2:33
    • Feedback 06 | Tableau - Training and Certification
  • Section 07: Data Visualization - Basic Charts
    • Download the Practice Files
    • 0701 Session Introduction - 0:52
    • 0702 Bar Chart - 5:39
    • 0703 Line and Highlight Tables - 5:49
    • 0704 Map View and Dual Axis New - 5:31
    • 0705 Pie, Stacked Bar, and Tree Map - 4:50
    • Feedback 07 | Tableau - Training and Certification
  • Section 08: Data Visualization - Advanced Charts
    • Download the Practice Files
    • 0801 Advanced Charts 1 (Donut, Dual Axis) - 10:35
    • 0802 Advanced Charts 2 (Whisker Plot, Word Cloud, Lollypop, Gantt, Waterfall) - 9:46
    • 0803 Scatterplot - 5:28
    • 0804 Bubble Chart - 2:24
    • 0805 Pareto Chart - 6:33
    • Feedback 08 | Tableau - Training and Certification
  • Section 09: Hierarchies, Groups, and Sets
    • Download the Practice Files
    • 0901 Hierarchies Groups and Sets - 13:27
    • 0903 Global Parameters and Filters - 10:55
    • 0904 Bins - 3:14
    • 0905 Table Calculation - 5:51
    • 0906 Calculated Fields - 9:53
    • Feedback 09 | Tableau - Training and Certification
  • Section 10: LOD
    • Download the Practice File
    • 1001 Getting Started with LOD - 0:33
    • 1002 Aggregation vs Granularity - 3:16
    • 1003 LOD Include - 5:54
    • 1004 LOD Exclude - Part 1 - 3:26
    • 1005 LOD Exclude - Part 2 - 5:07
    • 1006 A Quick Recap - 0:49
    • Feedback 10 | Tableau - Training and Certification
  • Section 11: The Business Challenge 3 - Venture Capital Fund
    • Download the Practice File
    • 1101 Session Introduction - 0:55
    • 1102 Understanding Business Case - 2:14
    • 1103 Working On Sheets - Part 1 - 1:46
    • 1104 Working On Sheets - Analyzing Top Growth [Part 2] - 7:15
    • 1105 Higher Revenue vs. Lower Expenses - 7:38
    • 1106 Formatting Sheets - 9:37
    • 1107 Dashboard Formatting Part 1 - 3:28
    • 1108 Dashboard Formatting Part 2 - 7:34
    • 1109 Final Words - 0:34
    • Feedback 11 | Tableau - Training and Certification

View Full Curriculum


Access
Lifetime
Content
2.0 hours
Lessons
59

Python for Finance

Python Basics, Numpy, Pandas, Matplotlib, & More — Perform Financial Tasks Using Python

By Yoda Learning | in Online Courses

This course aims to keep you at the top of the emerging FinTech industry by teaching you how to use Python programming to perform your financial tasks. At the end of this Python to Finance Course, you will be able to implement your machine learning models to make predictions on financial data. This course will guide you through everything you need to know about Python for Finance. It will start the journey with the fundamentals of Python. You will then proceed to learn about the core libraries used in the Py-Finance domain, including Numpy, Pandas, Matplotlib, and much more!

  • Access 59 lectures & 2 hours of content 24/7
  • Use Python programming to perform your financial tasks
  • Understand the fundamentals of Python
  • Learn about the core libraries used in the Py-Finance domain
  • Implement your machine learning models to make predictions on financial data
Note: Software NOT included
Yoda Learning
4.3/5 Instructor Rating: ★ ★ ★ ★

Yoda Learning is a team of 12+ industry professionals focused on developing project-based learning solutions, which allows students to accrue real-world experience and learn in an engaging and practical manner. Its courses encompass everything from web and mobile app development to data analytics and design.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: advanced

Requirements

  • Any device with basic specifications

Course Outline

  • Your First Program
  • Section 01: Introduction
    • Course Overview - 4:22
    • Why Python for Finance? - 8:01
    • Why Spyder for Python? - 4:16
    • Environment Setup
    • Feedback 01 | Python for Finance
  • Section 02: Python Basics
    • Python Introduction - 2:38
    • Data Types - 8:54
    • Functions - 4:15
    • Conditions Loops - 6:57
    • Python Assignment
    • Feedback 02 | Python for Finance
  • Section 03: Numpy
    • What is Numpy? - 2:38
    • How To Install Python Libraries? - 3:23
    • Arrays - 4:26
    • Indexing and Operations - 6:40
    • Numpy Assignment
    • Feedback 03 | Python for Finance
  • Section 04: Pandas Data Handling
    • What is Pandas? - 4:50
    • Series - 3:38
    • Dataframe - 5:13
    • Moving Average - 5:14
    • Pandas Assignment
    • Feedback 04 | Python for Finance
  • Section 05: Matplotlib Visual Analysis
    • What is Matplotlib? - 3:09
    • Types of Plots - 3:30
    • Creating Plots for Python - Part 1 - 5:37
    • Creating Plots for Python - Part 2 - 6:54
    • Matplotlib Assignment
    • Seaborn - 3:04
    • Feedback 05 | Python for Finance
  • Section 06: Scikit-learn Prediction
    • What is Scikit-learn? - 2:26
    • Types of Models - 3:27
    • Prediction Models - 3:07
    • What is Regression in Finance? - 2:22
    • Linear Regression - 2:33
    • Prediction - Data Preprocessing - 4:47
    • Prediction - Regression - 4:56
    • Scikit-learn Assignment
    • Feedback 06 | Python for Finance
  • Section 07: S&P-500 Price Prediction
    • Overview - 2:55
    • S&P 500 Stock Price Prediction
    • Data Processing - 2:01
    • Prediction Part 1 - 3:45
    • Prediction Part 2 - 2:40
    • Project Solution
    • Feedback 07 | Python for Finance
  • Section 08: Risk Analysis of Credit Card Defaulter
    • Introduction - 3:16
    • Risk Analysis of Credit Card Defaulter
    • Data Processing - 3:36
    • Prediction - 5:24
    • Credit Card Defaulter Project Solution
    • Feedback 08 | Python for Finance
  • Section 09: Bonus Resources
    • Applications in Industry - 4:03
    • Guide to Resources - 2:27
    • Tutorial Links
    • Dataset Links
    • Feedback 09 | Python for Finance
  • Section 10: Conclusion
    • Conclusion - 2:06
    • Feedback 10 | Python for Finance

View Full Curriculum


Access
Lifetime
Content
1.0 hours
Lessons
8

Excel for HR Dashboard & Analytics

AutomateExcel Tasks & Create a Powerful Analysis for HR and L&D Data on Real-Life Business Problems

By Yoda Learning | in Online Courses

The job of HR is not an easy task. Analytics is an essential part of the process of acquiring good talent, engaging them, and retaining them. Most of the processes involved are time-sensitive and repetitive. Hence, there is a dire need to automate such tasks. HR Analytics in Excel helps businesses make data-driven decisions in a meaningful way. This course will help you do just that. This course is self-paced to learn effective and interactive creation of Human Resource (HR) and Learning & Development (L&D) dashboards. Impress your management with the right data handling and report automation techniques.

4.6/5 average rating: ★ ★ ★ ★

  • Access 8 lectures & 1 hour of content 24/7
  • Create & use a Pivot table and charts effectively
  • Learn how to analyze expense claims
  • Do data cleaning for emails
  • Analyze Google Forms survey
  • Understand the working of different tools with real-life business problems
Note: Software NOT included
Yoda Learning
4.3/5 Instructor Rating: ★ ★ ★ ★

Yoda Learning is a team of 12+ industry professionals focused on developing project-based learning solutions, which allows students to accrue real-world experience and learn in an engaging and practical manner. Its courses encompass everything from web and mobile app development to data analytics and design.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • VLOOKUP Basics
  • Pivot Table in Depth
  • Excel 2010 or later

Course Outline

  • Your First Program
  • HR Dashboard and Analytics
    • Analyzing Expense Claims - Part 1 - 13:31
    • Analyzing Expense Claims - Part 2 - 2:43
    • Analyzing HR Survey (Google Forms) - 10:15
    • Data Cleaning for Email and Attendance - 4:14
    • Reconcile Names of Different Spellings - 5:47
    • 360 Degree Feedback (Reporting) - 6:51
    • Allocating Hours (Trainers) - 8:12
    • Feedback | Excel for HR

View Full Curriculum


Access
Lifetime
Content
1.0 hours
Lessons
11

Excel for Sales Dashboard & Analytics

Prepare Your Sales Reports & Perform Analytics

By Yoda Learning | in Online Courses

This course uses multiple mini-projects to teach you how to work with multiple Excel techniques to prepare your sales reports and perform analytics. With 11 lectures, you'll be able to use your potential knowledge on more Excel tricks to better analyze and interpret your data.

  • Access 11 lectures & 1 hour of content 24/7
  • Learn sales visualization techniques without using charts
  • Find correct sales by extracting Bank Account Codes from unclean data dumps
  • Combine Sales Ledgers of multiple months & automate the process for next months
  • Analyze 3-years' sales using Pivot Table
  • Allocate sales to different agents
  • Consolidate sales of multiple products, multiple agents from different sheets
Note: Software NOT included
Yoda Learning
4.3/5 Instructor Rating: ★ ★ ★ ★

Yoda Learning is a team of 12+ industry professionals focused on developing project-based learning solutions, which allows students to accrue real-world experience and learn in an engaging and practical manner. Its courses encompass everything from web and mobile app development to data analytics and design.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft Excel

Course Outline

  • Your First Program
  • Excel for Sales Dashboard and Analytics
    • Sales Data Visualization (without Charts) - 4:41
    • Data Consolidation - 5:41
    • After Sales Support - (TAT) - 4:07
    • After Sales Support (Warranty Date Expiry) - 1:53
    • Sales Allocation by Sales Person - 8:36
    • Pivot 1 - 3y Sales (Append Files) - 4:37
    • Pivot 2 - 3y Sales (Analysis) - 11:10
    • Commission Calculation (Date Buckets) - 10:12
    • Sales Analysis by Ticket Size - 3:14
    • Region-Wise Bank Accounts for Sales Collection - 7:58
    • Feedback | Excel for Sales

View Full Curriculum


Access
Lifetime
Content
1.0 hours
Lessons
30

DAX Made Easy

Best of Data Analysis Expressions (DAX) for Beginners in 90 Minutes

By Yoda Learning | in Online Courses

Data Analysis Expressions (DAX) is the formula language of Power BI, Power Pivot, and SSAS (Tabular models). DAX is a functional language (executed code is contained inside a function). Learning DAX is much like discovering how to use formulas in Excel. This course covers all the essentials functions/parameters that make DAX unique. If you are learning DAX from scratch or already know the basics, this course will help you all to master Power BI.

3.7/5 average rating: ★ ★ ★ ★ ★

  • Access 30 lectures & 1 hour of content 24/7
  • Understand how the DAX engine works
  • Use DAX to model & analyze your data
  • Aggregate & filter with ease
Note: Software NOT included

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft Excel

Course Outline

  • Your First Program
  • Introduction
    • Download Practice Files for this Course
    • Learning Path - 3:02
    • DAX | Feedback 01
  • Essential DAX Concepts - Part 1
    • Download the Practice Files for this Section
    • Implicit vs Explicit Measure - 1:50
    • Calculated Column vs Measure - 3:04
    • Evaluation Context = Filter and Row Context - 4:11
    • DAX | Feedback 02
  • Essential DAX Concepts - Part 2
    • Download the Practice Files for this Section
    • Table Relationship (Basics) - 5:49
    • DAX | Feedback 03
  • Working with DAX
    • Download the Practice Files for this Section
    • DISTINCTCOUNT - 2:29
    • COUNTROWS - 1:26
    • Column vs Measure using SUMX (Iterator) - 4:38
    • Why SUM Measure? - 2:44
    • CALCULATE - 2:23
    • FILTER - 3:11
    • Unique Date Table using CALENDAR - 3:18
    • DATEADD - 5:44
    • SAMEPERIODLASTYEAR - 3:18
    • DATESINPERIOD - 6:29
    • TOTALYTD - 4:11
    • ALL, ALLSELECTED - 8:05
    • DIVIDE - 3:39
    • RELATED - 3:30
    • SUMMARIZE - 6:00
    • ADDCOLUMNS - 2:05
    • DISTINCT - 2:25
    • FORMAT - 1:36

View Full Curriculum


Access
Lifetime
Content
1.0 hours
Lessons
11

New Microsoft Excel & Office 365 Features

Increase Your Productivity with All New MS Excel 2019 & Office 365 Features and Save Time!

By Yoda Learning | in Online Courses

Now that you already have the basic knowledge of using Excel, this course will help you improve your speed and save time in your future projects. With 11 lectures, this course will cover all new Microsoft Excel 2019 and Office 365 features. Not only you'll be faster, but also you will be productive by learning more.

  • Access 11 lectures & 1 hour of content 24/7
  • Learn about CONCAT function & see if TEXTJOIN is more powerful than the CONCAT function
  • Check basic to intermediate examples on Filter function in Office 365 Excel
  • Learn about the function IFs & SWITCH formula
  • Concatenate different values based on the IDs using TEXTJOIN & IF functions
Note: Software NOT included
Yoda Learning
4.3/5 Instructor Rating: ★ ★ ★ ★

Yoda Learning is a team of 12+ industry professionals focused on developing project-based learning solutions, which allows students to accrue real-world experience and learn in an engaging and practical manner. Its courses encompass everything from web and mobile app development to data analytics and design.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft Office 365

Course Outline

  • Your First Program
  • Topics
    • CONCAT and TEXTJOIN - 4:15
    • FILTER - 6:45
    • IFS and SWITCH - 5:19
    • LET - 3:00
    • MAXIFS and MINIFS - 3:31
    • Project: TEXTJOIN and IF - 7:20
    • SEQUENCE - 1:59
    • SORT - 6:09
    • SORTBY - 1:38
    • UNIQUE - 2:50
    • Excel 2019 & Office 365 | Course Feedback

View Full Curriculum


Access
Lifetime
Content
1.0 hours
Lessons
10

Google Sheets for Excel Users

Organize Your Information Into Neat Spreadsheets in Both Google Sheets & Excel

By Yoda Learning | in Online Courses

If you're dealing with a bunch of data, sorting and organizing will help you a lot. This course will teach you how to use Google Sheets and organize your information into neat spreadsheets. You can use many of these skills in Excel too!

  • Access 10 lectures & 1 hour of content 24/7
  • Know the 5 ways to use Google Sheet’s Checkbox
  • Use Sparklines for Dashboards
  • Learn how to use Slicer on a table
  • Create a “pop-up” Calendar Date Picker
  • Create a Heatmap with Conditional Formatting
  • Use AI Explore to create charts & reports
Note: Software NOT included
Yoda Learning
4.3/5 Instructor Rating: ★ ★ ★ ★

Yoda Learning is a team of 12+ industry professionals focused on developing project-based learning solutions, which allows students to accrue real-world experience and learn in an engaging and practical manner. Its courses encompass everything from web and mobile app development to data analytics and design.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft Excel
  • Access to Google Sheets

Course Outline

  • Your First Program
  • Topics
    • Download the Practice Files for this Course
    • Working with Google Sheet's Checkbox - 3:20
    • Sparklines for Dashboards - 6:17
    • Using Slicer on a Table - 2:40
    • Add a Pop-Up Calendar Date Picker - 2:29
    • Coloring Rows Based On a Cell Value - 3:48
    • Creating Heatmap with Conditional Formatting - 1:00
    • Star Rating System on Google Sheet - 3:28
    • Google Sheets' AI Explore Feature - 1:54
    • Google Sheets | Course Feedback

View Full Curriculum


Access
Lifetime
Content
4.0 hours
Lessons
46

360° Financial Modeling & Valuation Course

Learn Industry Best Practices & Common Pitfalls in Financial Modeling

By Yoda Learning | in Online Courses

Don’t just learn how to develop financial statements and theories behind the valuation. Learn the techniques that wow industry leaders and become hot in the job market with this 360° Financial Modeling & Valuation course. With 4 hours of video content, you'll get a great overview of financial modeling and how to build client-ready deliverables from scratch. You'll learn formatting protocols, statements, forecast drivers, and more.

  • Access 46 lectures & 4 hours of content 24/7
  • Build a 3-statement financial model with valuation in 3 phases
  • Build client-ready deliverables from scratch
  • Become better with Excel shortcuts, industry best practices, time-saving tips & more
  • Create a report-like presentation
  • Complement your statements with CAGR, Horizontal & Vertical Analysis
  • Learn the fundamental drivers of each line-item in their respective schedules
  • Perform Discounted Cash Flow Valuation where you learn to calculate FCFF & WACC
Yoda Learning
4.3/5 Instructor Rating: ★ ★ ★ ★

Yoda Learning is a team of 12+ industry professionals focused on developing project-based learning solutions, which allows students to accrue real-world experience and learn in an engaging and practical manner. Its courses encompass everything from web and mobile app development to data analytics and design.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Any device with basic specifications

Course Outline

  • Your First Program
  • Downloadable Practice Sheet
    • Practice Problem
  • OVERVIEW OF FINANCIAL MODELING
    • Course Introduction - 4:01
    • Financial Statement Analysis- Breaking Down - 3:46
    • Working with Financial statements - Part 1 - 6:02
    • Activity - Basic Level - 5:39
    • Working with Financial statements - Part 2 - 1:49
    • Activity - Advance Level - 5:05
    • Ratio Analysis Overview - 10:35
    • Valuation Overview - 6:02
    • Relative Valuation Overview - 5:59
  • INCOME STATEMENT
    • Creating an Income Statement - 5:16
    • Continuing with assumptions - 3:57
    • Building the format of the Income Statement - 4:25
    • Building Formulas to Forecast Tax Expense and Minority Interest line Item - 2:37
    • Working with CAGR Calculation - 4:17
  • REVENUE MODEL
    • Overview of the Revenue Model - 6:25
    • Building a Revenue Model - 5:55
    • Calculating Average Revenue Per Store - 5:47
  • BALANCE SHEET
    • Constructing Balance Sheet Format_1 - 5:03
    • Developing Balance Sheet and its Elements - 7:10
    • Working with CAGR and Trend Analysis Calculation - 5:43
    • Building Assumption for the Asset Side of the Balance Sheet - 9:41
    • Forecasting the Balance Sheet for the Liability Side - 6:40
    • Other Liability Items - 10:29
  • CASH FLOW STATEMENT
    • Introduction to the Cash Flow Statement - 10:08
    • Designing and Structuring the Cash Flow Statement - 6:31
    • Linking the Line Items in the cashflow - 6:52
    • Add End 03
  • WORKING CAPITAL AND CAPEX & DEPREICIATION
    • Dealing with Working Capital, Capex, and Depreciation (WCCD) - 6:57
    • Getting the Format Ready - Approach 1 - 3:53
    • Building Formula for Each Line Item - 4:37
    • Getting the Format Ready - Approach 2 - 5:55
    • Forecasting Current Assets - 10:59
    • Creating a Waterfall Formula - 2:48
    • Forecasting Line items in the Working Capital Calculations - 6:13
    • Forecasting Working Captical Schedule - 6:00
    • Forecasting Capex and Depreciation Schedule - 11:44
  • DCF VALUATION
    • Introduction to DCF Method - 5:11
    • Forecasting of the Dividend Schedule - 3:49
    • Valuation - 6:08
    • Compounding, Discounting and Layers of Complexity of the DCF - 4:16
    • Calculating the Cost of Each Capital - 10:02
    • Building the Valuation Sheet - 10:41
    • Calculating the Cash Flows Related to DCF - 5:49
    • Building Sensitivity Analysis and Schedule of Valuation - 8:15
    • Session Conclusion - 11:45

View Full Curriculum


Access
Lifetime
Content
2.0 hours
Lessons
46

Alteryx Online Course

Get Started with 25 Essential Alteryx Tools for Beginners

By Yoda Learning | in Online Courses

This course is for everyone who is a beginner or familiar with Alteryx Designer. In this course, you'll walk you through the basics of Alteryx. With 46 lectures, this course will cover 25 essential tools that will help you to automate your task and increase productivity in your day-to-day.

4.5/5 average rating: ★ ★ ★ ★

  • Access 46 lectures & 2 hours of content 24/7
  • Explore the essential tools for Alteryx
  • Learn with before & after examples
  • Automate your tasks
  • Increase your productivity in your day to day
Note: Software NOT included
Yoda Learning
4.3/5 Instructor Rating: ★ ★ ★ ★

Yoda Learning is a team of 12+ industry professionals focused on developing project-based learning solutions, which allows students to accrue real-world experience and learn in an engaging and practical manner. Its courses encompass everything from web and mobile app development to data analytics and design.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Alteryx Designer

Course Outline

  • Your First Program
  • Section 1: Introduction
    • Understanding Repeatable Workflow - 2:23
    • Alteryx User Interface - 2:51
    • Feedback 01 | Alteryx Online Course
  • Section 2: Input/Output Tools
    • Input Data - 4:10
    • Text Input - 2:08
    • Browse - 3:14
    • Output Data - 2:58
    • Feedback 02 | Alteryx Online Course
  • Section 3: Preparation Tools
    • Select - 3:08
    • Formula - 5:34
    • Multi Field Formula - 1 and 2 - 5:27
    • Multi Row Formula - 4:16
    • Data Cleansing - 3:13
    • Sort - 2:15
    • Filter - 3:53
    • Unique - 2:17
    • Sample - 3:22
    • Feedback 03 | Alteryx Online Course
  • Section 4: Join Tools
    • Find and Replace - 3:43
    • Understanding JOIN Concept and its Types - 6:22
    • JOINS - In Action - 4:36
    • Union - 3:48
    • JOIN + UNION - 2:10
    • Feedback 04 | Alteryx Online Course
  • Section 5: Parse Tools
    • Text to Columns - 3:22
    • DateTime - 3:58
    • Feedback 05 | Alteryx Online Course
  • Section 6: Transform Tools
    • Transpose - 3:11
    • Cross Tab - 3:18
    • Summarize - 4:00
    • Feedback 06 | Alteryx Online Course
  • Section 7: Documentation and Developer Tools
    • Container - 2:06
    • Using Alteryx Examples - 0:55
    • Dynamic Rename - 2:28
    • Feedback 07 | Alteryx Online Course
  • Section 8: Alteryx Shortcuts
    • Top 15 Shortcuts - 4:54
    • Feedback 08 | Alteryx Online Course
  • Section 9: Project: US Sales by 4 business segments
    • 3 Years Sales Data - 17:09
    • Feedback 09 | Alteryx Online Course
  • Section 10: Alteryx Tips and Tricks
    • Combining Data from Multiple Files - 2:04
    • Data Profiling - 3:16
    • Data Cleansing Tool - 4:15
    • Container Tool - 3:57
    • Comment & Container Tool - 2:22
    • Multi-Row Formula tool - 3:48
    • Feedback 10 | Alteryx Online Course

View Full Curriculum


Access
Lifetime
Content
8.0 hours
Lessons
166

Excel VBA Tutorials: Learn Excel Programming Language

Automate Repetitive Tasks Using Excel VBA with Just One Click

By Yoda Learning | in Online Courses

Many people waste their valuable time with repetitive tasks in Excel. They find that they don’t understand how to use macros in Excel, let alone how to create macros in Excel. If only they knew these tasks could be automated with a single click with Excel VBA (Visual Basic for Applications). A single click can save hundreds of hours of work. All it takes to learn Excel VBA and VBA code (programming language) is a problem solver mindset. This course will show you how to automate tasks. as well as how to create projects that interact with users and other applications in real-time.

  • Access 166 lectures & 8 ours of content 24/7
  • Create macros in Excel
  • Automate tasks using VBA
  • Create projects that interact with users & other applications in real-time
  • Learn about Excel programming, forms, & Macros
Note: Software NOT included
Yoda Learning
4.3/5 Instructor Rating: ★ ★ ★ ★

Yoda Learning is a team of 12+ industry professionals focused on developing project-based learning solutions, which allows students to accrue real-world experience and learn in an engaging and practical manner. Its courses encompass everything from web and mobile app development to data analytics and design.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft Excel

Course Outline

  • Your First Program
  • Instructions Manual
    • Course Manual
  • Downloadable Files:
    • Downloadable Working files and Case studies
  • INTRODUCTION 1
    • Why learn Macros? - 4:19
    • Activate "Developer" tab - 2:03
    • Saving a Macro-enabled WorkBook (XLSM) - 2:54
    • Macro Security Settings - 2:14
    • Course Feedback
    • Developer tab - Essential Buttons - 0:54
    • Head & Tail of a Macros (Sub Procedure & User Defined Function) - 4:03
    • "Click Here" button to run a Macro - 1:46
    • Excel VBA Macro Quiz #1
  • INTRODUCTION 2
    • Macros - Record & Run - 5:10
    • Macros - Viewing the code - 2:42
    • Macro-free vs. Macro-enabled Workbook - 0:55
    • Visual Basic Editor (VBE) - 3:19
    • Personal Macro WB - 5:22
    • Ways to Run a Macro - 2:47
    • Course Feedback
    • Excel VBA Macro Quiz #2
  • GOOGLE
    • Using Google to locate useful VBA codes - 1 - 7:45
    • Using VBE and Macro Recorder to customize Macro code - 4:48
    • Using Google to locate useful VBA codes - 2 - 6:31
    • Course Feedback
  • OBJECTS, PROPERTIES, METHODS
    • Objects, Properties, Values, Methods and Parameters 1 - 2:20
    • Objects, Properties, Values, Methods and Parameters 2 - 1:58
    • Course Feedback
    • Excel VBA Macro Quiz #3 - OBJECTS, PROPERTIES, METHODS
  • WORKSPACE
    • Code Color & Activating Edit Toolbar w. Comments - 3:01
    • Edit Toolbar - Indent, Bookmark - 1:49
    • Code writing shortcuts incl. Intellisense - 1:59
    • Testing the Code - 2:59
    • Immediate Window 01 - 3:07
    • Course Feedback
    • Excel VBA Macro Quiz #4 - WORKSPACE
  • RANGE & CELLS OBJECT
    • Range Selection - Method 1 - 4:58
    • Range Selection - Method 2 & 3 - 3:22
    • Advantage of Range Selection - Method 2 & 3 - 5:51
    • Range Selection (Rows & Columns) - Method 4 - 0:54
    • Assigning values to selected range of cells - 2:02
    • Exercise 1 - Assigning values to selected range of cells - 1:35
    • Exercise 2- Assigning values to selected range of cells - 0:46
    • Multiple Range Selection - Method 5 - 2:02
    • Multiple Range Selection - Method 6 - 2:21
    • Range Selection Ways - Others - 2:05
    • Course Feedback
    • Excel VBA Macro Quiz #5_1 - RANGE & CELLS OBJECT
    • Excel VBA Macro Quiz #5_2 - RANGE & CELLS OBJECT
    • Excel VBA Macro Quiz #5_3 - RANGE & CELLS OBJECT
  • ABSOLUTE vs RELATIVE REFERENCE
    • Offset - Basics - 1:54
    • Using Relative Reference in Macros - 3:12
    • Course Feedback
    • Excel VBA Macro Quiz #6 - ABSOLUTE vs RELATIVE REFERENCE
  • RANGE NAVIGATION
    • Navigating between a range of cells - Part 1 - 2:15
    • Navigating between a range of cells - Part 2 - 1:20
    • Navigating between a range of cells - Part 3 - 1:50
    • Exercise - Finding Last Row No. - 4:19
    • Exercise - Finding Last Column No. - 3:43
    • Exercise - Finding Next Row No. - 1:25
    • Course Feedback
    • Excel VBA Macro Quiz #7 - RANGE NAVIGATION
  • VARIABLE DECLARATION
    • Variable Decl 01 - 4:29
    • Variable Decl 02 - 2:04
    • Pvt vs Public 01 - 2:17
    • Pvt vs Public 02 - 5:34
    • Option Explicit - 4:31
    • Difference - DIM vs. SET - 2:04
    • Course Feedback
    • Excel VBA Macro Quiz #8 - VARIABLE DECLARATION
  • LOOPS
    • "For...Next" - 3:28
    • "If...Else...End If" nested within "For...Next" - 5:25
    • "Do…While" - 7:32
    • "Do…Until" - 3:01
    • "For Each...Next" - 4:10
    • "If...End If" nested within "For Each...Next" - 4:48
    • Exercise - "Do While" and Loop Counter - 11:57
    • "With…End With" - Example 1 - 1:26
    • "With…End With" - Example 2 - 2:38
    • "Select…Case" - Demonstration - 2:22
    • "Select…Case" - Explanation - 5:20
    • Course Feedback
    • Excel VBA Loop - Macro Quiz #9
  • OPTIMIZING CODE EFFICIENCY
    • Speed up the code running - 1 - 3:17
    • Speed up the code running - 2 - 2:34
    • Speed up the code running - 3 - 2:23
    • Course Feedback
    • Excel VBA Macro Quiz #10 OPTIMIZING CODE EFFICIENCY
  • EVENTS
    • Introduction - 1:50
    • Events - Workbook Open and Worksheet Activate - 4:42
    • Exercise 1 - Tracking Workbook Opens - 8:29
    • Exercise 2 - Tracking Workbook Save - 3:47
    • Event - Worksheet Before Double Click - 6:55
    • Event - Worksheet Change - 4:39
    • Event - Worksheet Calculate - 2:42
    • Pivot Table - Refresh - Work Sheet Activate - 3:56
    • Course Feedback
    • Excel VBA Macro Quiz #11 Events
  • INPUT BOX
    • Introduction - 2:34
    • Input Box - 1 - 5:13
    • Input Box - 2 - 5:38
    • Input Box - 3 - 2:55
    • Input Box - 4 - 6:55
    • Course Feedback
    • Excel VBA Macro Quiz #12 INPUT BOX
  • MSG BOX
    • Introduction to Msg box in excel vba - 1:36
    • MsgBox - 1 - 3:49
    • MsgBox - 2 - 6:28
    • MsgBox - 3 - 1:24
    • MsgBox - 4 - 2:18
    • Course Feedback
    • Excel VBA Macros Quiz #13_1 MSG Box
    • Excel VBA Macros Quiz #13_2 MSG Box
  • ACTIVEX CONTROLS
    • Form Controls vs ActiveX Controls - 3:50
    • MouseMove Event w. Appln Statusbar - 4:46
    • Excel VBA Macros Quiz #14 ACTIVEX CONTROLS
  • USER FORMS
    • Introduction - 1:03
    • User Form - Basics - 3:45
    • Exercise - Part 1 of 4 - 1:44
    • Exercise - Part 2 of 4 - 6:18
    • Exercise - Part 3 of 4 - 3:59
    • Exercise - Part 4 of 4 - 11:23
    • Option Button - 1 - 5:14
    • Option Button - 2 - 6:19
    • Multi Page - Introduction - 1:35
    • Multi Page - 1 - 5:48
    • Multi Page - 2 - 3:22
    • Multi Page - 3 - 6:35
    • Check Box 01 - 6:39
    • Combo Box - Method 1 - 2:21
    • Combo Box - Method 2 - 4:59
    • Excel VBA Macros Quiz #15_1 USER FORMS
    • Excel VBA Macros Quiz #15_2 USER FORMS
    • Excel VBA Macros Quiz #15_3 USER FORMS
  • USER DEFINED FUNCTIONS
    • UDF Intro 01 - 2:57
    • UDF Example 1 - ScoreResult with IF END IF - 3:54
    • UDF Example 2 - CellComments - 4:06
    • UDF Samples - Series A - 4:58
    • UDF Samples - Series B - 0:59
    • Excel VBA Macros Quiz #16 USER DEFINED FUNCTIONS
  • MIS PROJECTS
    • Split Workbook - 9:12
    • Protect - Unprotect Sheets - 3:11
    • Index of Hyperlinks to all Sheets - 5:29
    • Extract all Comments of a WorkBook to a new WorkSheet - 7:06
    • Project- Automate,Comment,Insertion and Extraction - 3:55
    • Count Cells by Color - 3:09
    • Combine WorkSheets - 7:35
  • Case Study
    • 01 Case Study- Intro - 1:59
    • 02 Case Study - Demo - 4:11
    • 03 Create the first UserForm - 6:48
    • 04 Write the first line of code - 3:26
    • 05 VBA code to match Username and Password - 5:15
    • 06 Continue with UserForm - 4:43
    • 07 VBA code for the second UserForm - 4:49
    • 08 Unload and Hide UserForm - 2:34
    • 09 Setting of the third UserForm - 8:01
    • 010 Validation for the third UserForm - Part 1 - 2:53
    • 011 VBA code to enable a button - 4:20
    • 012 Validation for the third UserForm - Part 2 - 5:02
    • 013 VBA code for the third UserForm - 7:45
    • 014 Configuring the Previous button - 1:47
    • 015 Submit Data and hide content in excel sheet - 5:11
    • 016 Capture data from the UserForm - 3:47
    • 017 Create a Table Format - 3:29
    • 018 VBA code to send Email - 3:25
    • 019 Send an Email - 2:54
    • 020 Finishing touch to the project - 5:44
    • 021 Testing the code - 3:14

View Full Curriculum


Access
Lifetime
Content
4.0 hours
Lessons
47

SAS Programming Online Course

Become a Data Expert Using the SAS Data Science Tools

By Yoda Learning | in Online Courses

This SAS Programming course has an industry recommended learning path. Giving you a quick briefing about SAS, it is a powerful statistical Language. SAS is the market leader of Business Analytics and one of the most used languages Commercially. A software suite with various Capabilities like Advanced and Predictive analysis. SAS Programming helps you with Business Intelligence. With SAS Certification you’ll be able to become a Data Expert using the SAS Data Science tools.

  • Access 47 lectures & 4 hours of content 24/7
  • Get a complete knowledge on SAS Programming
  • Learn about SAS Analysis, Statistics interpretation, Data Management, Data analysis & Predictive Modeling
  • Learn to make Bar Charts and Scatter Plot
  • Establish your career in data science
Note: Software NOT included
Yoda Learning
4.3/5 Instructor Rating: ★ ★ ★ ★

Yoda Learning is a team of 12+ industry professionals focused on developing project-based learning solutions, which allows students to accrue real-world experience and learn in an engaging and practical manner. Its courses encompass everything from web and mobile app development to data analytics and design.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: intermediate

    Requirements

    • Any device with basic specifications

Course Outline

  • Your First Program
  • Introduction
    • 1 Introduction to SAS - 4:12
    • 2 Introduction to SAS Software - 2:59
    • 3 Introduction to SAS Programs - 4:24
    • 4 Introduction to SAS Data set - 5:27
    • 5 Operators - Comparison, Logical, Special Part 1 - 7:43
    • 6 Operators - Comparison, Logical, Special Part 2 - 9:03
  • Reading and Exporting Data
    • 7 Reading Data Set - 2:25
    • 8 Reading Excel file using the libname statement - 4:04
    • 9 Reading excel file using the import wizard - 2:27
    • 10 Reading excel file using the proc import statement - 3:29
    • 11 Exporting the data set using Export Wizard - 2:37
    • 12 Exporting the data set using PROC Export - 1:27
    • 13 Reading text files - 4:37
    • 14 Reading CSV files - 4:53
  • Data Manipulation
    • 15 Data lines - 4:29
    • 16 What is Program Data Vector (PDV) - 13:17
    • 17 Sub setting variables - 4:28
    • 18 Sub setting the data with if-else statement - 2:50
    • 19 Creating variables conditionally - 3:48
    • 20 IF vs WHERE - 5:37
    • 21 Combining SAS data sets vertically using PROC Append - 5:51
    • 22 Combining SAS data sets vertically using Concatenation - 7:02
    • 23 Sorting using PROC - 5:33
    • 24 Combining SAS data sets horizontally using Merge statement - 5:09
    • 25 Enhancing reports and Producing summary reports in HTML and PDF formats - 12:12
    • 26 Functions - 15:51
    • 27 Processing Iterative data - 8:34
    • 28 Arrays and PROC Transpose Part 1 - 7:54
    • 29 Arrays and PROC Transpose Part 2 - 9:10
  • Macros in SAS
    • 30 Introduction to the Macro Facility - 8:09
    • 31 Macro Variables - 6:16
    • 32 Different ways to define Macro Variables - 8:14
    • 33 Macro functions - 12:13
    • 34 Macro Definitions - 10:23
    • 35 Creating a Macro Definition - 5:09
    • 36 Iterative Processing - 6:25
    • 37 PROC SQL with business scenarios - 5:05
    • 38 INTO Statement - 6:07
    • 39 Union and Joins in SAS - 8:23
  • Business Scenarios
    • 40 Business Scenario Date function - 8:38
    • 41 Business Scenarios Substr function - 6:20
    • 42 Business Scenarios Converting Variable Types Part 1 - 6:52
    • 43 Business Scenarios Converting Variable Types Part 2 - 3:27
    • 44 Business Scenarios Validating and Cleaning the data Part 1 - 3:26
    • 45 Business Scenarios Validating and Cleaning the data Part 2 - 5:43
    • 46 Business Scenarios Do-loop - 6:01
    • 47 Business Scenarios Calculating the salary total by department - 6:22

View Full Curriculum


Access
Lifetime
Content
8.0 hours
Lessons
175

Advanced Excel Crash Course

Learn Excel Online for MIS Reporting, Data Cleaning, Data Analysis, Charting, & Time-Saver Tricks with Examples

By Yoda Learning | in Online Courses

These Advanced Excel Tutorials are targeted to save you years! This online crash course will propel you from the current proficiency level to a level where you can train professional users and explore a very satisfying and rewarding career opportunity.

4.6/5 average rating: ★ ★ ★ ★

  • Access 175 lectures & 8 hours of content 24//7
  • Learn best usage of shortcuts, formatting tricks & cell referencing
  • Build simple models
  • Learn data cleaning techniques
  • Summarize your data with Pivot Tables
  • Explore dynamic dashboards
Note: Software NOT included
Yoda Learning
4.3/5 Instructor Rating: ★ ★ ★ ★

Yoda Learning is a team of 12+ industry professionals focused on developing project-based learning solutions, which allows students to accrue real-world experience and learn in an engaging and practical manner. Its courses encompass everything from web and mobile app development to data analytics and design.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: advanced

Requirements

  • Microsoft Excel

Course Outline

  • Your First Program
  • Downloadable Files
    • Excel Case Studies - Please Download
    • eBook - Become an Excel Ninja.
  • 001 Handpicked Ninja Shortcuts
    • Introduction
    • 0101 How to use this section? - 1:16
    • 0102 The "ONE" Universal shortcut & a faster Copy-Paste technique - 3:22
    • 0103 AutoFill selected cell(s) with pre-defined formula/text/no. - 1:15
    • 0104 Navigating across Worksheets; Data Table selection & manoeuvring - 4:32
    • 0105 Adding/Deleting/Selecting Rows/Columns - 3:06
    • 0106 For "Formula" One Speedstars - 6:18
    • 0107 Formatting cells - 4:36
    • 0108 Using Quick Access Toolbar (QAT) - 4:43
    • Formula auditing magic - 4:51
    • Excel Shortcut Quiz #1
  • 002 Formula Warm-Up
    • 0201 MAX() in Financial Modeling - 2:43
    • 0202 LARGE() & SMALL() - for bidding/auction pricing strategies - 2:37
    • 0203 Advanced ROUND() Tricks with ROUNDUP() & ROUNDDOWN() - 1 of 2 - 3:42
    • 0204 Advanced ROUND() Tricks with ROUNDUP() & ROUNDDOWN() - 2 of 2 - 6:36
    • 0205 COUNT() vs. COUNTA() vs. COUNTBLANK() vs. COUNTIFS() - 3:19
    • 0206 SUMPRODUCT() for weighted average computation - 3:33
    • 0207 POWER() vs. Caret sign ( ^ ) - 2:38
    • Excel Formula Warm-Up Quiz #2
  • 003 Formatting Tricks
    • 0301 Formatting Tricks incl. Special Custom Formats - 5:16
    • 0302 Format Painter - "Uninterrupted Click-ability" - 1:55
    • 0303 Defining Cell Style - for "one-click" universal change - 4:00
    • 0304 Transferring (Merging) Cell Style from one workbook to another - 1:15
    • 0305 Cell drag-n-drop Auto Fill Options + Activation Setting - 1:19
    • 0306 Cell drag-n-drop Auto Fill Options - Yr-end, Month-end, AlphaNumeric, Fill - Justify - 2:46
    • 0307 Cell drag-n-drop Auto Fill Options vs. EOMONTH() - End of Year/Quarter/Month - 1:11
    • 0308 Paste Special - Transpose vs. TRANSPOSE() - 4:17
    • Excel Formatting Tricks Quiz #3
  • 004 Cell Referencing ($) - Relative & Absolute
    • 0401 Cell Referencing ($) - 1 of 2 - 3:01
    • 0402 Cell Referencing ($) - 2 of 2 - 3:19
    • Cell Referencing using - Practice 1 - 4:22
    • Cell Referencing using - Practice 2 - 4:34
    • Cell Referencing using - Special Trick - 2:48
    • Excel Cell Referencing Quiz #4
  • 005 Go To - Special "magic wand"
    • 0501 Go To (Special) - Formulas with Errors - 2:39
    • 0502 Go To (Special) - Formulas without Errors - 2:01
    • 0503 Go To (Special) w. Ctrl+Enter - 2:07
    • 0504 Go To (Special) - Fill Intermittent Blank Cells - Case 1 - 5:58
    • 0505 Go To (Special) - Fill Intermittent Blank Cells - Case 2 - 2:03
    • 0506 Go To (Special) - Visible Cells w. Shortcut - 2:23
    • Review our Course
    • Short Excel Go To - Special Quiz #5
  • 006 Sort (Vertical, Horizontal, Custom), Filter & Advanced Filter
    • 0601 Vertical Sort - 1-level & 2-level - 2:23
    • 0602 Custom Sort - 5:16
    • 0603 Sort Trick - add alternate blank rows in-between existing rows - 2:57
    • 0604 Horizontal Sorting (Left to Right) - auto-realigning 100s of columns - 3:28
    • 0605 Filter - Basics - 3:36
    • 0606 Filter - Choosing the dataset correctly - 1:25
    • 0607 Filter analysis w. shortcuts - 2:51
    • 0608 Filter - SUBTOTAL() for calculations - 5:04
    • 0609 Filter - SUBTOTAL() 9 vs. 109 series - 2:39
    • 0610 Filter - Applying 2 or more Filters simultaneously on the same sheet - 2:18
    • 0611 Filter - Color Filter & Text Filter - 1:12
    • 0612 Advanced Filter - Basics - 4:28
    • 0613 Advanced Filter - Differential Criteria - 4:09
    • 0614 Advanced Filter - More parameters - 3:08
    • Excel Sort, Filter & Advanced Filter Quiz #6
  • 007 Working with Dates
    • 0701 Dates - Important Concepts 1 of 2 - 3:15
    • 0702 Dates - Important Concepts 2 of 2 - 4:04
    • 0703 Date Formulas - DAY(), MONTH(), YEAR(), DATE() - 2:14
    • 0704 Date Formulas - TEXT() - 3:05
    • 0705 Date Formulas - WEEKDAY(), WORKDAY(), NETWORKDAYS() - 3:51
    • 0706 Date Formulas - WORKDAY.INTL() for deadline/due date calculations w. custom weekends/holidays - 4:51
    • 0707 Date Formulas - NETWORKDAY.INTL() for no. of business days calculations w. custom weekends/holidays - 1:43
    • Excel Date Quiz #7_1
    • 0708 Date Formulas - TODAY() and NOW() w. Shortcut - 1:29
    • 0709 Date Formulas - EOMONTH() for Financial Modeling, Budgets, Due Dates - 3:40
    • 0710 Date Formulas - EDATE() for Financial Modeling, Budgets, Due Dates - 3:54
    • Excel Date Quiz #7_2
  • 008 Data (Cell Input) Validation
    • 0801 Data Validation - Drop Down List using hard coded text & pre-defined range - 2:36
    • 0802 Data Validation - Drop Down List using named range - 3:50
    • 0803 Data Validation - Numbers w. Error Alert and Input Message - 1:36
    • 0804 Data Validation - Dates w. Error Alert and Circle Invalid Data - 3:51
    • 0805 Data Validation - Text Length w. Error Alert - 1:35
    • 0806 Data Validation - Custom w. formula logic - 2:00
    • Excel Data Validation Quiz #8
  • 009 Setting up work area view
    • 0901 Grouping/UnGrouping Columns and Rows - 1 of 2 - 2:57
    • 0902 Grouping/UnGrouping Columns and Rows - 2 of 2
    • 0903 Grouping Trick: Changing placement of Grouping Button
    • 0904 Cell Gridlines: Turning On/Off - 0:49
    • 0905 Trick - Hide/Unhide Rows and Columns - 5:31
    • Excel View (Freeze Panes) Quiz #9
    • Review our Course
  • 010 Pivot Table
    • 1001 Pivot Table - Why should you learn? - 3:57
    • 1002 Pivot Table - Pre-requisites - 2:24
    • 1003 Pivot Table - How to create one? - 2:39
    • 1004 Pivot Table - Exploring Pivot Table grid (Fields) - 3:20
    • 1005 Pivot Table - Value Field Settings - "Summarize Values By" - Sum, Average, Count, Max etc. - 5:04
    • 1006 Pivot Table - Value Field Settings - "Show Values As" - Percentage (%) of Grand Total - 2:21
    • 1007 Pivot Table - Value Field Settings - "Show Values As" - Percentage (%) of Column/Row Total - 4:48
    • Excel Pivot Table Quiz #10_2
    • Excel Pivot Table Quiz #10_1
    • 1008 Pivot Table - Grouping - Numbers - 3:37
    • 1009 Pivot Table - Grouping - Dates [Years, Months etc.] - 4:07
    • 1011 Pivot Table - Refresh vs. Refresh All, Change Data Source and creating Dynamic Table Data Source - 6:17
    • 1012 Pivot Table - Auto Refresh - 0:40
    • 1013 Pivot Table - Pivot Chart Shortcut and Sparklines - 2:11
    • 1014 Pivot Table - Drill Down option - 0:59
    • 1015 Pivot Table - Report Filter - Generating 100s of reports in few seconds - 3:38
    • 1016 Pivot Table - Slicer vs. Report Filter - 2:32
    • 1017 Pivot Table - Practice - Sales Data Analysis - 1 of 2I (%, Grouping, Chart, Report Filter Pages) - 7:57
    • 1018 Pivot Table - Practice - Sales Data Analysis - 2 of 2 (Slicer) - 3:08
    • 1019 Pivot Table - Practice - Closing Stock Analysis - 6:58
    • Excel Pivot Table Quiz #10_4
  • 011 Lookups (1D, 2D, 3D, Reverse) & Conditional Calculations (Sum, Average, Count, Special Running T
    • 1106 MATCH() match_type: -1 vs. 0 vs. 1 - 3:45
    • 1107 2-D Lookup (Vertical + Horizontal) - VLOOKUP w. MATCH - 5:51
    • 1108 2-D Lookup - VLOOKUP w. MATCH - Framework - 1:18
    • 1109 2-D Lookup - VLOOKUP w. MATCH - Common Mistake #1 - 3:47
    • 1110 2-D Lookup - VLOOKUP w. MATCH - Common Mistake #2 - 2:19
    • 1111 2-D Lookup - VLOOKUP w. MATCH - Practice Exercise - 6:11
    • 1112 2-D Lookup (Horizontal + Vertical) - HLOOKUP w. MATCH - 6:47
    • 1113 INDIRECT() - Basics - 4:17
    • 1114 INDIRECT() w. Range Naming - Applications - 5:59
    • 1115 3-D Lookup - VLOOKUP() w. MATCH() w. INDIRECT() - Question - 4:17
    • 1116 3-D Lookup - VLOOKUP() w. MATCH() w. INDIRECT() - Answer - 7:09
    • 1117 Reverse Lookup - Question - 3:26
    • 1118 Reverse Lookup - INDEX() w. MATCH() - 1 of 2 - 8:12
    • 1119 Reverse Lookup - INDEX() w. MATCH() - 2 of 2 - 6:05
    • 1120 SUMIFS(): Conditional Summation (1 criteria) - 5:02
    • 1121 SUMIFS(): Conditional Summation (2 criteria) - 4:15
    • 1122 SUMIFS(): Conditional Summation (3 criteria) w. date range - 5:58
    • 1123 SUMIFS(): Condition based Selective Cumulative Running Total - 5:40
    • 1124 COUNTIFS() - Single/Multiple Criteria: Duplicate Count, Instance No. - 6:08
    • 1125 AVERAGEIFS() - to be updated - 1:23
    • OFFSET() with MATCH() - 15:08
    • Excel Lookup Quiz #11_1
    • Excel Lookup Quiz #11_2
    • Excel Lookup Quiz #11_3
    • Excel Lookup Quiz #11_4
    • Excel Lookup Quiz #11_5
    • Excel Lookup Quiz #11_6
    • Excel Lookup Quiz #11_7
    • New Lecture
    • Review our Course
    • New Lecture
    • Fuzzy Lookup
  • 012 Data Cleaning / "Sanitizing" & Text Formulas
    • 1205 Text Formulas – REPT() for artifical Column Chart in a Cell - 1:14
    • 1206 Text Formulas – REPT() & LEN() for adding leading zeroes before incomplete Cheque Nos. - 4:28
    • 1207 Joining data strings using CONCATENATE, & - to be updated - 4:55
    • 1208 Find & Replace – Using Wildcard character ( * ) - 3:07
    • 1209 Find & Replace – Using Wildcard character ( ? ) - 2:22
    • 1210 Find & Replace – Neutralising Wildcard characters to remove them from data - 2:37
    • 1211 Find & Replace – Word vs. Excel - 6:04
    • 1212 Find & Replace – Cell Format - 4:29
    • 1215 Text to Columns – Cleaning up numbers w. trailing minus sign - 2:32
    • 1216 Text to Columns – Cleaning up numbers w. leading "Dr/Cr" text - 2:01
    • 1217 Text to Columns – Correcting invalid Dates (DMY) - 3:23
    • 1218 Text to Columns – Correcting invalid Dates (YMD) - 3:17
    • 1219 Text Formulas – LEFT(), RIGHT() & SEARCH() - 1 of 2 - 4:17
    • 1220 Text Formulas – LEFT(), RIGHT() & SEARCH() - 2 of 2 - 2:25
    • 1221 Text Formulas – MID() & LEN() - 3:41
    • 1222 Text Formulas – REPLACE() & SUBSTITUTE()
    • 1223 FlashFill for Data Cleaning in Excel
    • Excel Data Cleaning Quiz #12_1
    • Excel Data Cleaning Quiz #12_2
    • Excel Data Cleaning Quiz #12_3
    • Excel Data Cleaning Quiz #12_4
    • Excel Data Cleaning Quiz #12_5
  • 014 Conditional Formatting
    • 1405 Conditional Formatting: Formula based (Colored rows based in user input) - 4:10
    • 1406 Conditional Formatting: Formula based w. AND() - 2-way input Coloring - 5:20
    • 1407 Conditional Formatting: Formula based w. COUNTIFS() - Highlighting inputs if from restricted list - 4:12
    • Excel Conditional Formatting Quiz #14_1
    • Excel Conditional Formatting Quiz #14_2
  • 015 What-If Analysis
    • 1501 What IF Analysis – Using Form Control Buttons from Developer Tab (Spin Bar, Scroll Bar) - 5:06
    • 1502 What IF Analysis – Limitations of Spin Bar, Scroll Bar - 4:01
    • Excel What-If Analysis Quiz #15_1
    • 1503 What IF Analysis – Scenario Managers - to be updated
    • 1504 What IF Analysis – Goal Seek - 4:31
    • Excel What-If Analysis Quiz #15_2
    • 1505 What IF Analysis – Data Tables Basics (Sensitivity Analysis) - 2 Inputs & 1 Output - 8:20
    • 1506 What IF Analysis – Data Tables Basics (Sensitivity Analysis) - with PMT for Loan EMI - 5:20
    • 1507 What IF Analysis – Data Tables Basics (Sensitivity Analysis) - 2 Inputs & multiple Output - Question - 2:38
    • 1508 What IF Analysis – Data Tables Basics (Sensitivity Analysis) - 2 Inputs & multiple Output - Answer - 10:06

View Full Curriculum



Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.