Get $1 credit for every $25 spent!

The 2020 Master Microsoft Excel & Power BI Certification Bundle

Ending In:
Add to Cart - $34.99
Add to Cart ($34.99)
$1,592
97% off
wishlist
Courses
9
Lessons
470
Enrolled
969

What's Included

Product Details

Access
Lifetime
Content
10 hours
Lessons
116

Up & Running with Power BI Desktop

Transform, Analyze & Visualize Data Using Microsoft Power BI Desktop

By Excel Maven | 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.

18,197 positive ratings from 71,106 students enrolled

  • 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 and implement the same B.I. tools used by professional analysts & data scientists
Note: Software NOT included.

Maven Analytics | Award-Winning Analytics & BI Training

4.6/5 Instructor Rating: ★ ★ ★ ★

Maven Analytics 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.

312,248 Total Students
90,903 Reviews

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: all levels

Requirements

  • Any device with basic specifications

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
10.0 hours
Lessons
230

Microsoft Excel: Excel with Excel Pivot Tables Bootcamp

Analyze Lots of Data & Tell a Story in a Quick and Interactive Way

By My Excel Online | in Online Courses

This is the most comprehensive Excel Pivot Table online course ever made which has over 200 short and precise tutorials. In no time you will be able to analyze lots of data and tell a story in a quick and interactive way, learn how to build stunning Dashboards, and get noticed by top management & prospective employers. The course is just over 10 hours long so you can become an awesome analyst and advanced Excel user within 1 week!

986 positive ratings from 32,012 students enrolled

  • Access 230 lectures & 10 hours of content 24/7
  • Set up your data & create a Pivot Table in less than 3 minutes
  • Create an Interactive Dashboard w/ Slicers & Pivot Charts
  • Put your key business metrics like Year to Date Sales, Monthly Variations & Top 10 Customers in an interactive Pivot Table
Note: Software NOT included.

Bryan Hong | Data Analysis Ninja

4.3/5 Instructor Rating: ★ ★ ★ ★

Bryan Hong is the author of 101 Excel Series paperback books and is also an IT Software Developer for more than 10 years. His courses focus on Excel Formulas, Power Query, Power BI, Excel Charts, Macros and much more. His passion lies in helping his students in whatever means possible, whether it be reaching them via courses or by books.

Certifications
  • Microsoft Certified Professional Developer (MCPD): Web Developer
  • Microsoft Certified Technology Specialist (MCTS): Windows Applications
  • Microsoft Certified Systems Engineer (MCSE)
  • Microsoft Certified Systems Administrator (MCSA)
45,191 Total Students 2,812 Reviews



John Michaloudis | Chief Inspirational Officer, MyExcelOnline

4.4/5 Instructor Rating: ★ ★ ★ ★

John Michaloudis has taught over 50,000 students on Udemy alone plus over 100,000 people on his website - MyExcelOnline. He have an active Excel blog where he posts free Excel tutorials as well as an Excel podcast where he interviews fellow Excel experts and share their insights.

73,980 Total Students
3,839 Reviews

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification 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

  • DESIGN & CUSTOMIZE YOUR PIVOT TABLE
    • Tabular Format - 2:17
    • No Gaps - 2:23
    • Formatting - 1:20
    • Excel Tables - 2:38
    • Clean Your Data Set - 2:11
    • Inserting a Pivot Table - 3:14
    • Field List - 1:33
    • Field List Areas - 5:18
    • Drill down to audit - 1:35
    • Sort Field List from A to Z - 0:37
    • Double click on any label to show more fields - 0:46
    • Defer Layout Update - 0:48
    • Pivot cache explained - 0:53
    • Refresh a Pivot Table - 1:12
    • Refresh All - 2:20
    • Refresh External Data - 4:51
    • Import from Access database - 2:19
    • Change Data Source - 3:03
    • Clear Filter and Clear Pivot - 1:10
    • Select and Format - 3:08
    • Move a Pivot Table - 0:53
    • Pivot Table Styles - 3:35
    • Customise Styles - 4:05
    • Use a customised style in another workbook - 1:20
    • Subtotals - 0:48
    • Grand Totals - 0:54
    • Report Layout - 2:41
    • Blank Rows - 0:32
    • Show the Classic Pivot Table layout - 1:00
    • Expand and Collapse Buttons - 4:19
    • Move and Remove Fields and Items - 2:32
    • Show or Hide Field List - 0:20
    • Show or Hide Field Headers - 0:19
    • Change Count of to Sum of - 1:01
    • Number formatting - 1:34
    • Field name formatting - 2:09
    • Predetermined number formatting - 1:21
    • Change Sum views in label areas - 0:44
    • Indent rows in Compact Layout - 0:52
    • Change layout of a report filter - 1:18
    • Format error values - 0:42
    • Format empty cells - 1:20
    • Keep column widths upon refresh - 0:46
    • Automatically refresh a pivot table - 0:48
    • Printing a pivot table on two pages - 1:13
    • Show report filter on multiple pages - 2:15
  • VALUE FIELD SETTINGS > SUMMARIZE VALUES BY
    • Create multiple subtotals - 1:36
    • Count - 2:19
    • Average - 2:35
    • Maximum - 1:55
    • Minimum - 1:18
    • Product - 3:31
    • CountNumbers - 2:26
    • StdDevp - 6:59
    • VarP - 3:28
    • Show Various Grand Totals - 2:28
    • Shortcuts to Value Field Settings - 2:12
    • See all pivot Items - 5:52
    • Show a unique count - 2:29
  • VALUE FIELD SETTINGS > SHOW VALUES AS
    • Percentage of Grand Total - 2:01
    • Percentage of Column Total - 2:08
    • Percentage of Row Total - 1:47
    • Percentage Of - 3:56
    • Percentage of Parent Row Total - 3:12
    • Percentage of Parent Column Total - 2:16
    • Percentage of Parent Total - 2:44
    • Difference From - 4:47
    • Percentage Difference From - 4:11
    • Running Total In - 2:12
    • Percentage Running Total In - 2:51
    • Rank Smallest to Largest - 2:14
    • Rank Largest to Smallest - 2:14
    • Index - 3:38
    • Shortcuts to Show Values As - 1:08
  • BUSINESS CASE - SHOW VALUES AS
    • Percentage of Revenue - 2:31
    • Actual v Plan Variation - 4:36
  • GROUPING
    • Group by Date - 2:38
    • Grouping by Months - 1:43
    • Grouping by Quarters and Years - 1:41
    • Group by Sales ranges - 3:11
    • Group by Text fields - 2:09
    • Group by Time - 1:38
    • Shortcuts to Grouping - 1:32
    • Grouping by Half Years - 1:48
    • Grouping by a Date that starts on a Monday - 1:53
    • Grouping by a custom date - 1:41
    • Grouping by a fiscal year and quarter - 6:29
    • Errors when grouping by dates - 2:46
    • Group two pivot tables in the same workbook - 3:45
    • Fixing the problem of counting grouped sales - 0:38
    • Display dates that have no data - 0:52
  • BUSINESS CASE - GROUPING
    • Min and Max Bank Balance - 4:35
    • Quarterly Comparative Report - 6:37
  • SORT
    • Sorting by Largest or Smallest - 1:51
    • Sort an Item Row - 1:24
    • Sort Manually - 1:53
    • Sort using a Custom List - 3:13
    • Override a Custom List sort - 1:20
    • Sort rows from A to Z and values by Z to A - 1:16
    • Sort new items added to your data source - 1:11
    • Clear a Sort - 0:21
    • Sort Largest to Smallest Grand Totals - 0:19
  • FILTER
    • Filter by Dates - 6:41
    • Filter by Labels - Text - 2:35
    • Filter by Labels - Numerical Text - 2:44
    • Filter by Values - 3:50
    • Filter by Vales - Top or Bottom 10 Items - 2:06
    • Filter by Values - Top or Bottom Percent - 1:39
    • Filter by Values - Top or Bottom Sum - 1:42
    • Filter by Report Filter - 3:31
    • Shortcuts to Filter - 1:36
    • Keep or hide selected items - 0:57
    • Filter by Text wildcards - 3:19
    • Filter by multiple fields - 1:00
    • Apply multiple filters - 1:45
    • Filter by multiple values - 1:06
    • Include new items in manual filter - 1:50
    • Clear filters with one click - 1:30
    • Add a filter for the column items - 0:32
  • BUSINESS CASE - FILTER
    • Top 5 Expense Report - 2:22
    • Top 25 percent of Channel Partners - 2:10
  • SLICERS (NEW IN EXCEL 2010)
    • Insert a Slicer - 3:54
    • Slicer Styles - 2:18
    • Creating a custom style - 5:30
    • Copying a custom style in to a new workbook - 1:33
    • Slicer Settings - 4:42
    • Slicer Size and Properties - 2:56
    • Slicer Connections for multiple pivot tables - 3:16
    • Different ways to filter a Slicer - 1:14
    • Use one slicer for two pivot tables - 1:19
    • Lock the workbook but not the slicer - 1:25
    • Interactive employee photos with Slicers! - 9:20
  • BUSINESS CASE - SLICERS
    • Select a monthly PnL report with a Slicer - 4:13
    • Base, Best and Worst case Forecast - 5:02
  • CALCULATED FIELDS & ITEMS
    • Creating a Calculated Field - 3:58
    • Use an existing calculated field - 2:16
    • Editing a calculated field - 1:56
    • Excel formulas and Calculated Fields - 2:59
    • Creating a Calculated Item - 4:05
    • Use an existing calculated item - 1:36
    • Editing a Calculated Item - 2:18
    • Excel formulas and Calculated Items - 1:50
    • Calculated Item on Column Labels - 2:06
    • Shortcomings of Calculated Items - 2:03
    • Solve Order for Calculated Items - 4:04
    • List Formulas - 1:05
    • Remove a Calculated Field temporarily - 0:52
    • Order of operations - 1:49
  • BUSINESS CASE - CALCULATED FIELDS
    • Creating a PnL Pivot Table report - 8:18
    • Actual v Plan with Calculated Fields - 6:29
  • PIVOT CHARTS
    • Insert a Pivot Chart - 3:16
    • Insert a Slicer with a Pivot Chart - 1:52
    • Pivot Chart Designs - 3:48
    • Pivot Chart Layouts - 4:57
    • Pivot Chart Formats - 5:50
    • Limitations of Pivot Charts and workarounds - 1:54
    • Saving a Pivot Chart template - 1:28
    • Shortcuts to formatting a Pivot Chart - 1:16
    • Link chart title to a pivot cell - 0:58
    • Copying a second chart - 0:51
    • Put a chart on a separate page with F11 - 0:40
    • Insert Pivot Chart straight from the data source - 0:51
    • Paste Pivot Chart to your email as a picture - 1:05
    • Paste Pivot Chart To Powerpoint - 1:34
    • Printing a Pivot Chart - 1:20
    • Include a Sparkline with your pivot table - 1:16
    • Chart Do's and Dont's - 2:37
    • Use Slicers to change chart types - 8:00
    • Workaround to creating a Scatter graph - 2:20
  • BUSINESS CASE - PIVOT CHARTS
    • PnL Pivot table report with Graphs - 8:14
    • Pivot Table Slicer and Chart EXCEL Dashboard - 15:47
  • CONDITIONAL FORMATTING PIVOT TABLES
    • Intro to conditional formatting - 2:35
    • Highlight Cell Rules based on values - 1:20
    • Highlight Cell Rules based on text labels - 0:47
    • Highlight Cell Rules based on date labels - 1:15
    • Top and Bottom Rules - 3:24
    • Data Bars, Color Scales and Icon Sets - 5:42
    • Format cells that contain - For Bonuses - 1:38
    • Format Top ranked values - 1:32
    • Format values above the average - 1:37
    • Use a formula to determine which cells to format - 2:39
    • Use selected cells to format multiple fields - 1:31
    • All cells showing values - 1:31
    • Control Conditional Formatting with Slicers - 2:46
    • Show text in the Pivot Table Values area - 4:43
    • Conditionally Formatting Blank Cells - 1:06
  • BUSINESS CASE - CONDITIONAL FORMATTING
    • Accounts Receivable Ageing Report Matrix - 6:09
    • Conditionally Format your sales results - 3:25
  • GETPIVOTDATA formula
    • Intro to GETPIVOTDATA - 4:51
    • Create a custom report with GETPIVOTDATA - 5:17
    • Reference Dates with GETPIVOTDATA - 3:09
    • Data validation with GETPIVOTDATA - 2:45
    • Shortfalls of GETPIVOTDATA - 1:40
    • Grand Totals to the left of the pivot table - 3:11
  • BUSINESS CASE - GETPIVOTDATA
    • Live forecasting with GETPIVOTDATA - 7:16
    • Channel analysis with GETPIVOTDATA - 5:22
  • MACROS
    • Adding the Developer tab - 2:32
    • Record a simple macro to Refresh a pivot table - 4:18
    • Date filter macro - 4:20
    • Different pivot table views macro - 4:34
    • Top 10 macro - 3:23
    • Add macro to quick access toolbar - 1:13
  • DATA MANAGEMENT
    • Reducing file memory by copying existing pivot table - 1:21
    • Reducing file memory by deleting the data source - 1:38
    • Reducing file memory by saving file as XLSB - 0:50
    • Reducing file memory by keeping data in Access - 2:05
    • Compatibility Issues with Excel 2007 and Excel 2010 - 1:12
    • Sharing a Pivot Table via OneDrive - 2:41
  • BONUS VIDEOS
    • Sales Forecasting with Calculated Fields - 4:11
    • Consolidate with a Pivot Table - 4:38
    • Frequency Distribution with a Pivot Table - 2:09
    • Break Even Model with a Pivot Table - 2:57
    • Several slicer custom styles for you to use - 1:56
    • Interactive Balance Sheet Pivot Table - 12:13
    • Monthly Sales Manager Performance - 4:27
    • Reconciling customer payments - 1:34
  • NEW EXCEL 2013 PIVOT TABLE FEATURES
    • Cosmetic Changes - 2:05
    • Recommended Pivot Tables - 1:58
    • Distinct Count - 1:50
    • Timeline Slicer - 4:15
    • Data Model - 6:58
  • NEW EXCEL 2016 PIVOT TABLE FEATURES
    • Multiselect Slicers - 0:33
    • Group Periods - 1:46
    • Pivot Chart Expand and Collapse - 1:11
    • 3D Maps - 1:45
  • NEW EXCEL 2019 & OFFICE 365 PIVOT TABLE FEATURES
    • Which Excel Version - 1:52
    • Personalize the default Pivot Table layout - 5:30
    • Automatic relationship detection - 5:38
    • Automatic time grouping - 2:50
    • Search in the Pivot Table - 1:25

View Full Curriculum


Access
Lifetime
Content
1.0 hours
Lessons
16

Microsoft Excel: Master Power BI Dashboards in 70 Minutes

Everything You Need to Know About Power BI & Data Visualization

By Bryan Hong | in Online Courses

Last time you opened an Excel Power BI Dashboard and are overwhelmed by the number of things to do. You don't know how to make the best use of your time. But it doesn't have to be this way! This 1-hour course will help you understand how BI works and how to use it to your advantage for processing data and creating reports. Whether it's for business or personal related projects, this course will help anyone use Bi freely and easily.

4.7/5 rating from 2,297 students enrolled: ★ ★ ★ ★

  • Access 16 lectures & 1 hour of content 24/7
  • Create your own Power BI Dashboard from scratch in just 70 minutes
  • Understand the essence of the Power BI visualizations, & see them in action
  • See how Power BI is used w/ real examples
  • Understand how Power Query, Power View, & Power Pivot are used together
Note: Software NOT included.

Bryan Hong | Data Analysis Ninja

4.3/5 Instructor Rating: ★ ★ ★ ★

Bryan Hong is the author of 101 Excel Series paperback books and is also an IT Software Developer for more than 10 years. His courses focus on Excel Formulas, Power Query, Power BI, Excel Charts, Macros and much more. His passion lies in helping his students in whatever means possible, whether it be reaching them via courses or by books.

Certifications
  • Microsoft Certified Professional Developer (MCPD): Web Developer
  • Microsoft Certified Technology Specialist (MCTS): Windows Applications
  • Microsoft Certified Systems Engineer (MCSE)
  • Microsoft Certified Systems Administrator (MCSA)
45,191 Total Students 2,812 Reviews



John Michaloudis | Chief Inspirational Officer, MyExcelOnline

4.4/5 Instructor Rating: ★ ★ ★ ★

John Michaloudis has taught over 50,000 students on Udemy alone plus over 100,000 people on his website - MyExcelOnline. He have an active Excel blog where he posts free Excel tutorials as well as an Excel podcast where he interviews fellow Excel experts and share their insights.

73,980 Total Students
3,839 Reviews

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification 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

  • Introduction
    • Excel Power BI Introduction - 3:26
    • Excel Power Query Introduction - 4:43
    • Excel Power Pivot Introduction - 1:03
    • Excel Power View Introduction - 1:34
  • Download Files
    • Exercise Files
  • Master Power BI Dashboards in 70 Minutes!
    • Install Power BI and Sign Up - 2:44
    • The Big Picture - 1:40
    • Power BI - Get Data - 6:43
    • Power BI - Modelling Data - 3:00
    • Power BI - Visualization - 4:35
    • Advanced - Real World Example - 5:44
    • Advanced - Get Data - 13:03
    • Advanced - Modelling Data - 5:06
    • Advanced - Visualization with multiple charts - 11:14
    • Advanced - Publishing - 4:34
    • Your Project - Create your own Dashboard! - 1:08

View Full Curriculum


Access
Lifetime
Content
1.0 hours
Lessons
20

Excel: Top 50 Microsoft Excel Formulas in 50 Minutes

Auto Calculate Data by Mastering the Top Excel Formulas

By Bryan Hong | in Online Courses

If you're working with a lot of data, going manual to calculate them one by one is probably not a good idea. That is why Microsoft Excel is packed with formulas. It allows you to design better spreadsheets — sort, calculate, format, group, and visualize data. This then results in more efficient data translation, less complexity, and reduced errors. This course will help you master the top 50 formulas you can use in Excel so you can simply 'play along' with data.

  • Access 20 lectures & 1 hour of content 24/7
  • Gain full control of Excel formulas
  • Understand the use & need of these formulas
  • Get the hang of using them by doing real-life exercises
Note: Software NOT included.

Bryan Hong | Data Analysis Ninja

4.3/5 Instructor Rating: ★ ★ ★ ★

Bryan Hong is the author of 101 Excel Series paperback books and is also an IT Software Developer for more than 10 years. His courses focus on Excel Formulas, Power Query, Power BI, Excel Charts, Macros and much more. His passion lies in helping his students in whatever means possible, whether it be reaching them via courses or by books.

Certifications
  • Microsoft Certified Professional Developer (MCPD): Web Developer
  • Microsoft Certified Technology Specialist (MCTS): Windows Applications
  • Microsoft Certified Systems Engineer (MCSE)
  • Microsoft Certified Systems Administrator (MCSA)
45,191 Total Students 2,812 Reviews



John Michaloudis | Chief Inspirational Officer, MyExcelOnline

4.4/5 Instructor Rating: ★ ★ ★ ★

John Michaloudis has taught over 50,000 students on Udemy alone plus over 100,000 people on his website - MyExcelOnline. He have an active Excel blog where he posts free Excel tutorials as well as an Excel podcast where he interviews fellow Excel experts and share their insights.

73,980 Total Students
3,839 Reviews

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification 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

  • Introduction
    • How to Get the Most from this Course - 0:57
  • Downloadable Workbooks
    • Exercise Files
  • Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!
    • Text Formulas In Excel - 7:53
    • Text Formulas Exercise - 0:21
    • Text Formulas Exercise - Answers - 1:08
    • Mathematical Formulas In Excel - 4:01
    • Mathematical Formulas Exercise - 0:16
    • Mathematical Formulas Exercise - Answers - 1:00
    • Date and Time Formulas In Excel - 5:04
    • Date and Time Formulas Exercise - 0:17
    • Date and Time Formulas Exercise - Answers - 0:59
    • Logic Formulas In Excel - 12:20
    • Logic Formulas Exercise - 0:15
    • Logic Formulas Exercise - Answers - 0:41
    • Financial Formulas In Excel - 5:54
    • Financial Formulas Exercise - 0:13
    • Financial Formulas Exercise - Answers - 2:15
    • Informational Formulas In Excel - 3:58
    • Informational Formulas Exercise - 0:40
    • Informational Formulas Exercise - Answers - 1:26

View Full Curriculum


Access
Lifetime
Content
2.0 hours
Lessons
25

Microsoft Excel: Master Power Query in 120 Minutes

Discover the Power of Formulas, Analytical Tools, Tables & More

By Bryan Hong | in Online Courses

The course covers all of Excel's must-know features for importing, cleaning up and transforming messy data that gets downloaded from an external data source or an Excel file. No matter if you are a beginner or an advanced user of Excel, you are sure to benefit from this course which goes through every single analytical & data cleansing tool that is available in Microsoft Excel. In no time you will be able to clean lots of data and report it in a quick and interactive way, learn how to work with various transformation Formulas, create consolidated monthly reports with the press of a button, WOW your boss with stunning Excel visuals and get noticed by top management & prospective employers!

4.2/5 rating from 2,531 students enrolled: ★ ★ ★ ★

  • Access 25 lectures & 2 hours of content 24/7
  • Clean & transform lots of data quickly
  • Import data from various external sources, folders & Excel workbooks
  • Sort, filter, & merge your data
Note: Software NOT included.

Bryan Hong | Data Analysis Ninja

4.3/5 Instructor Rating: ★ ★ ★ ★

Bryan Hong is the author of 101 Excel Series paperback books and is also an IT Software Developer for more than 10 years. His courses focus on Excel Formulas, Power Query, Power BI, Excel Charts, Macros and much more. His passion lies in helping his students in whatever means possible, whether it be reaching them via courses or by books.

Certifications
  • Microsoft Certified Professional Developer (MCPD): Web Developer
  • Microsoft Certified Technology Specialist (MCTS): Windows Applications
  • Microsoft Certified Systems Engineer (MCSE)
  • Microsoft Certified Systems Administrator (MCSA)
45,191 Total Students 2,812 Reviews



John Michaloudis | Chief Inspirational Officer, MyExcelOnline

4.4/5 Instructor Rating: ★ ★ ★ ★

John Michaloudis has taught over 50,000 students on Udemy alone plus over 100,000 people on his website - MyExcelOnline. He have an active Excel blog where he posts free Excel tutorials as well as an Excel podcast where he interviews fellow Excel experts and share their insights.

73,980 Total Students
3,839 Reviews

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification 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

  • Introduction
    • Excel Power Query - Introduction - 3:04
    • Excel Power Query - Query Editor Ribbon - 8:38
  • Downloadable Files
    • Exercise Files
  • Master Power Query in 120 Minutes!
    • Transform Data - Trim in Excel Power Query - 5:26
    • Transform Data - Format Dates and Values in Excel Power Query - 2:15
    • Transform Data - Parsing URLs in Excel Power Query - 5:25
    • Transform Data - Split Text Fields in Excel Power Query - 9:34
    • Transform Data - Group By in Excel Power Query - 2:57
    • Transform Data - Unpivoting Columns in Excel Power Query - 5:19
    • Transform Data - Pivoting Columns in Excel Power Query - 2:18
    • Transform Data - Split Columns into Other Columns in Excel Power Query - 4:04
    • Transform Data - Filtering Rows in Excel Power Query - 5:03
    • Transform Data - Sorting Columns in Excel Power Query - 2:20
    • Transform Data - Transform and Add Columns in Excel Power Query - 6:41
    • From Folder - Import From Folder in Excel Power Query - 6:32
    • From Folder - Doing Auto Cleanup in Excel Power Query - 6:56
    • From Folder - Extract Data from Forms in Excel Power Query - 13:25
    • From Workbook - Extract Multiple Criteria in Excel Power Query - 4:39
    • From Workbook - Extract Multiple Worksheets in Excel Power Query - 4:03
    • Joins - Intro to Joins - 3:31
    • Joins - Merging - 7:42
    • Joins - Full Outer Join - 5:43
    • Joins - Right Anti Join - 8:50
    • Power Query - Convert Reports into Pivot Tables - 5:03
    • Power Query - Modulo - 5:44

View Full Curriculum


Access
Lifetime
Content
1.0 hours
Lessons
14

Microsoft Excel: Master M Language - Power Query in 60 Minutes

Clean Your Dirty Data & Showcase the Things You Can Do in Excel Power Query

By Bryan Hong | in Online Courses

If you're already familiar with the basics of Power Query, it's now time to advance to Data Cleansing. This 1-hour course will teach you data cleansing techniques using various Excel features. You will learn the structure of the M code, how to create your own formulas, and see them in action with real examples.

4.2/5 rating from 2,531 students enrolled: ★ ★ ★ ★

  • Access 14 lectures & 1 hour of content 24/7
  • Get an overview of the M code &
  • Learn how to use M functions
  • Know the various uses of Power Query M
Note: Software NOT included.

Bryan Hong | Data Analysis Ninja

4.3/5 Instructor Rating: ★ ★ ★ ★

Bryan Hong is the author of 101 Excel Series paperback books and is also an IT Software Developer for more than 10 years. His courses focus on Excel Formulas, Power Query, Power BI, Excel Charts, Macros and much more. His passion lies in helping his students in whatever means possible, whether it be reaching them via courses or by books.

Certifications
  • Microsoft Certified Professional Developer (MCPD): Web Developer
  • Microsoft Certified Technology Specialist (MCTS): Windows Applications
  • Microsoft Certified Systems Engineer (MCSE)
  • Microsoft Certified Systems Administrator (MCSA)
45,191 Total Students 2,812 Reviews



John Michaloudis | Chief Inspirational Officer, MyExcelOnline

4.4/5 Instructor Rating: ★ ★ ★ ★

John Michaloudis has taught over 50,000 students on Udemy alone plus over 100,000 people on his website - MyExcelOnline. He have an active Excel blog where he posts free Excel tutorials as well as an Excel podcast where he interviews fellow Excel experts and share their insights.

73,980 Total Students
3,839 Reviews

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification 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

  • Introduction
    • Excel M Language - Introduction - 2:41
    • Enabling M in Excel Power Query - 2:18
  • Downloadable Workbooks
    • Exercise Files
  • Master M Language - Power Query in 60 Minutes!
    • Finding the list of M functions - 2:28
    • Using M Functions - 9:58
    • Simple Expressions - 7:35
    • Simple Expressions - Nested Expressions - 2:54
    • Variables - 7:59
    • Functions - 6:05
    • Functions - Reusable Functions - 2:12
    • Functions - Invoking - 0:35
    • Functions - Passing Functions - 8:11
    • Functions - The Keyword Each - 2:40
    • Your Project - 1:07

View Full Curriculum


Access
Lifetime
Content
1.0 hours
Lessons
15

SQL: Master SQL Database Queries in Just 90 Minutes

Become a Microsoft SQL Database Query Advanced User Within Hours

By Bryan Hong | in Online Courses

If you want to get better at Microsoft SQL so you get a better paying job or just get answers and insights from your data fast, then you are in the right place! With 15 lectures, this course will cover the must-know SQL queries and features. From simple table queries up to writing subqueries. After this class, you will be able to get valuable data insights anytime from your raw data.

4.1/5 rating from 2,759 students enrolled: ★ ★ ★ ★

  • Access 15 lectures & 1 hour of content 24/7
  • Become more productive at using SQL
  • Understand the essence of queries without memorizing them
  • Use SQL to get insights & answers from raw data
Note: Software NOT included.

Bryan Hong | Data Analysis Ninja

4.3/5 Instructor Rating: ★ ★ ★ ★

Bryan Hong is the author of 101 Excel Series paperback books and is also an IT Software Developer for more than 10 years. His courses focus on Excel Formulas, Power Query, Power BI, Excel Charts, Macros and much more. His passion lies in helping his students in whatever means possible, whether it be reaching them via courses or by books.

Certifications
  • Microsoft Certified Professional Developer (MCPD): Web Developer
  • Microsoft Certified Technology Specialist (MCTS): Windows Applications
  • Microsoft Certified Systems Engineer (MCSE)
  • Microsoft Certified Systems Administrator (MCSA)
45,191 Total Students 2,812 Reviews



John Michaloudis | Chief Inspirational Officer, MyExcelOnline

4.4/5 Instructor Rating: ★ ★ ★ ★

John Michaloudis has taught over 50,000 students on Udemy alone plus over 100,000 people on his website - MyExcelOnline. He have an active Excel blog where he posts free Excel tutorials as well as an Excel podcast where he interviews fellow Excel experts and share their insights.

73,980 Total Students
3,839 Reviews

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification 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

  • Introduction
    • What We are Going to Cover In This Course - 1:25
    • All About SQL - 4:07
  • Downloadable Files
    • Exercise Files
  • SQL: Master SQL Database Queries in Just 90 Mins!
    • Your SQL Training Ground - 3:50
    • Running the Initial SQL File - 4:31
    • Data Manipulation - 8:03
    • Simple Queries - 13:11
    • Simple Queries (Solution) - 5:19
    • More Simple Queries - 10:58
    • More Simple Queries (Solution) - 5:39
    • Joins - 9:21
    • Joins (Solution) - 10:05
    • Subqueries - 5:01
    • Subqueries (Solution) - 6:14
    • More SQL Examples and Exercises! - 9:09

View Full Curriculum


Access
Lifetime
Content
1.0 hours
Lessons
8

Microsoft Excel: Top 50 Excel Keyboard Shortcuts in 20 Minutes

Learn the Must-Know Excel Keyboard Shortcuts to Save Time in Excel

By Bryan Hong | in Online Courses

If you learn only 5 Excel keyboard shortcuts and apply them each day, you will save hours each week, which means you can go home or log off early for once! In this course, there are several modules so you can work on your weaknesses and enhance your strengths as well as practice files, quizzes, and a list of all 50 Excel Keyboard Shortcuts for Windows & Mac that you can print off and keep. From formatting to UI shortcuts, this course got it covered.

REVIEW_SITE_NAME: ★ ★ ★ ★

  • Access 8 lectures & 1 hour of content 24/7
  • Increase your Microsoft Excel & pivot table skills
  • Cut your working hours by using shortcuts
  • Easily format cells, sort data & more
Note: Software NOT included.

Bryan Hong | Data Analysis Ninja

4.3/5 Instructor Rating: ★ ★ ★ ★

Bryan Hong is the author of 101 Excel Series paperback books and is also an IT Software Developer for more than 10 years. His courses focus on Excel Formulas, Power Query, Power BI, Excel Charts, Macros and much more. His passion lies in helping his students in whatever means possible, whether it be reaching them via courses or by books.

Certifications
  • Microsoft Certified Professional Developer (MCPD): Web Developer
  • Microsoft Certified Technology Specialist (MCTS): Windows Applications
  • Microsoft Certified Systems Engineer (MCSE)
  • Microsoft Certified Systems Administrator (MCSA)
45,191 Total Students 2,812 Reviews



John Michaloudis | Chief Inspirational Officer, MyExcelOnline

4.4/5 Instructor Rating: ★ ★ ★ ★

John Michaloudis has taught over 50,000 students on Udemy alone plus over 100,000 people on his website - MyExcelOnline. He have an active Excel blog where he posts free Excel tutorials as well as an Excel podcast where he interviews fellow Excel experts and share their insights.

73,980 Total Students
3,839 Reviews

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification 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

  • Introduction
    • Why You Will Love this Excel Course - 1:28
  • Downloadable Files
    • Printable Cheat Sheet and Exercise Files
  • Microsoft Excel: Top 50 Excel Keyboard Shortcuts in 20 Minutes!
    • Formatting Excel Keyboard Shortcuts - 1:47
    • Table Excel Keyboard Shortcuts - 2:09
    • Editing Excel Keyboard Shortcuts - 4:46
    • Formula Excel Keyboard Shortcuts - 3:03
    • Workbook Excel Keyboard Shortcuts - 1:31
    • Handy Excel Keyboard Shortcuts - 4:52

View Full Curriculum


Access
Lifetime
Content
1.0 hours
Lessons
26

Excel: Master Excel Charts in An Hour

Learn How to Take Raw Data and Create Meaningful Charts in Excel

By Bryan Hong | in Online Courses

Creating a report from raw data and putting it into charts should not be a troublesome task. At least, not anymore with this 1-hour course. With 26 lectures, this course will discuss basic to advanced charts. From your common line chart up to trendlines and waterfall chart. Start making insightful reports and visuals with Excel now!

  • Access 26 lectures & 1 hour of content 24/7
  • Understand the nature of each chart
  • Know the importance of making charts & diagrams
  • Use the charts to make a report from your data
Note: Software NOT included.

Bryan Hong | Data Analysis Ninja

4.3/5 Instructor Rating: ★ ★ ★ ★

Bryan Hong is the author of 101 Excel Series paperback books and is also an IT Software Developer for more than 10 years. His courses focus on Excel Formulas, Power Query, Power BI, Excel Charts, Macros and much more. His passion lies in helping his students in whatever means possible, whether it be reaching them via courses or by books.

Certifications
  • Microsoft Certified Professional Developer (MCPD): Web Developer
  • Microsoft Certified Technology Specialist (MCTS): Windows Applications
  • Microsoft Certified Systems Engineer (MCSE)
  • Microsoft Certified Systems Administrator (MCSA)
45,191 Total Students 2,812 Reviews



John Michaloudis | Chief Inspirational Officer, MyExcelOnline

4.4/5 Instructor Rating: ★ ★ ★ ★

John Michaloudis has taught over 50,000 students on Udemy alone plus over 100,000 people on his website - MyExcelOnline. He have an active Excel blog where he posts free Excel tutorials as well as an Excel podcast where he interviews fellow Excel experts and share their insights.

73,980 Total Students
3,839 Reviews

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification 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

  • Downloadable Workbooks
    • Exercise Files
  • Basic Charts
    • Charts - 100 percent Stacked Bar Chart - 2:03
    • Charts - Logarithmic Scale - 2:33
    • Charts - 100 Percent Stacked Column Chart - 2:54
    • Charts - Line Chart - 1:36
    • Charts - Organizational Chart - 5:04
    • Charts - Bubble Chart - 2:51
    • Charts - Clustered Bar Chart - 2:07
    • Charts - Sparklines Win Loss - 1:44
    • Charts - Candlestick Chart - 2:10
    • Charts - Stacked Column Chart - 2:10
    • Charts - Scatter Chart - 2:42
    • Charts - Sparklines High and Low Points - 2:12
    • Charts - Pie Chart - 1:49
    • Charts - Radar Charts - 2:12
  • Advanced Charts
    • Advanced Chart - Histogram Chart - 4:35
    • Advanced Charts - Interactive Vertical Column - 9:34
    • Advanced Chart - Box and Whisker Chart - 2:54
    • Advanced Charts - Overlap Graphs - 4:26
    • Advanced Charts - Marker Options - 2:13
    • Advanced Charts - Treemap Chart - 2:07
    • Advanced Chart - Pareto Chart - 2:40
    • Advanced Charts -Waterfall Chart - 3:36
    • Advanced Charts - Trendlines - 1:34
    • Advanced Charts - Area Chart - 4:08
    • Advanced Chart - Sunburst Chart - 4:25

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.