Get $1 credit for every $25 spent!

The Premium Google Sheets & Microsoft Excel Certification Bundle

Ending In:
Add to Cart - $39.99
Add to Cart ($39.99)
$2,200
98% off
wishlist
Courses
11
Lessons
285
Enrolled
112

What's Included

Product Details

Access
Lifetime
Content
6.0 hours
Lessons
108

Master Reporting Automation with Google Sheets

Build a Completely Automated Reporting Tool & Solve Any Business Modeling Task You Might Ever Experience

By Mariel Aim | in Online Courses

>All the work you're doing in a repetitive manner in Google Sheets or Excel could be automated. It requires no coding skills, add-ons, or special tools - all you need to know is how to execute advanced formula combinations that will do all the automation for you. This course focuses on teaching you the right skill set, so you could solve any business modeling task you might ever experience. You will learn the key formulas, practice them, build a complex but rewarding project, and then try to solve the challenges on your own. The course is designed to give you advanced-level skills that you will feel comfortable executing later in your own work.

4.7/5 average rating: ★ ★ ★ ★

  • Access 108 lectures & 6 hours of content 24/7
  • Make your files look professional & easy-to-track
  • Create formula combinations that will save your hours of time
  • Minimize manual reporting & focus on value-creating tasks
  • Learn tips & tricks to effective data visualization
  • Create an automated business forecasting framework that works
Mariel Aim | Head of Business Analytics in a High-Growth Technology Firm
4.7/5 Instructor Rating: ★ ★ ★ ★

Mariel Aim works for the European fastest growing technology firm Bolt as the Head of Business Analytics where she's responsible for the whole business analytics and financial planning domain of a business vertical with over €3B valuation. Prior, she has a background in consulting (specifically M&A) and hold an MBA in Economics with sub-focus on data science.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: beginner
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Google account

Course Outline

  • Your First Program
  • Introduction
    • Introduction - 5:01
    • Why Google Sheets, not Excel? - 3:00
    • Quick Example: How to Efficiently Automate Reporting - 1:52
    • Overview of Course Projects - 2:25
  • Learn and Practice the Key Formulas
    • Introduction - 1:10
    • Key Formula Combination - INDEX & MATCH - 7:02
    • Determining Year with TEXT - 2:07
    • Smart use of IF's - Dynamic SUMIF and AVERAGEIF - 7:51
    • Use of COUNTIF(S) - 3:38
    • Identify ROW & COLUMN Numbers - 2:14
    • RANK the Data - 1:52
    • Avoid Errors with IFERROR - 2:40
    • Improve Calculation Accuracy with AVERAGE.WEIGHTED - 2:20
    • Quiz 1: Key Formula Quiz
  • Learn and Practice the Key Formulas: Advanced Section
    • Introduction - 0:39
    • Pulling Data with INDIRECT & ADDRESS - 2:41
    • Use OFFSET for Dynamic Calculations - 4:34
    • IMPORTRANGE with INDEX & MATCH - 5:07
    • Advanced Formula: QUERY - 2:58
    • Advanced Formula: QUERY 2 - 3:44
    • Section Recap - 1:08
    • Quiz 2: Key Formula 2 Quiz
  • Putting Together the Project
    • Introduction - 2:43
    • Mapping Down the Metrics - 11:02
    • Defining the Week Periods and Week References - 3:59
    • Connecting the Formulas with INDEX & MATCH - 3:28
    • Setting Up Budget Connections and Calculations - 8:03
    • Formatting of Week Numbers - 1:53
    • Visual Formatting - 8:48
    • Quiz 3: Project Mapping Quiz
  • Adding the Forecasts
    • Introduction - 0:42
    • Defining Sheet Structure - 5:01
    • Setting Up Forecasting Formulas - 8:57
    • Advanced: Connecting Stable Metrics to Dataset - 11:48
    • Linking Targets with Actuals - 6:51
    • Defining Current Week through TODAY Formula - 3:09
    • Target Conversion from Weekly to Monthly - 5:28
    • Comparison between Targets and Budgets - 6:04
    • Notification for Reconciliation with Budgets - 8:40
    • Sections Recap - 1:19
    • Quiz 4: Forecasting Quiz
  • Building the Comparison Between Actuals and Forecasts
    • Introduction - 0:40
    • Defining Sheet Structure - 4:11
    • Connecting the Formulas - 2:48
    • Not Showing Data for Unpassed Weeks - 2:13
    • Calculating the Variances - 2:19
    • Conditional Formatting for Variances - 3:02
    • Conditional Color Notifications - 7:16
    • Final Touches - 1:25
    • Quiz 5: Comparison Building Quiz
  • Designing the Landing Page
    • Introduction - 0:27
    • What to Include in the Cover tab? - 7:00
    • Table of Contents - 3:05
    • Linking Key Information - 2:48
    • Use Your Brand Colours - 5:15
    • Section Recap - 1:32
    • Quiz 6: Landing Page Quiz
  • Reconciling Weekly Actuals with Monthly Budgets
    • Introduction - 1:03
    • Defining Sheet Structure - 5:57
    • Connecting the Data to the Tab - 5:16
    • Color Coding for Weekly Trends - 2:53
    • Color Coding for Monthly Budgets - 10:00
    • Final Touches - 1:39
    • Quiz 7: Actuals vs Budget Quiz
  • Setting Up Competitor and Market Size Tracking
    • Introduction - 0:56
    • Defining Sheet Structure - 1:39
    • Creating the Framework for Competitor Tracking - 3:08
    • Adding Formulas to Framework - 5:35
    • Estimating Competitor and Market Size - 10:27
    • Summary of Key Metrics - 8:34
    • Final Touches - 7:10
    • Connection with Other Tabs - 8:23
    • Sections Recap - 1:36
    • Quiz 8: Market Sizing Quiz
  • Professional and Effective Data Visualisation
    • Introduction - 1:41
    • Intro to the First Graph - 1:09
    • Data Visualisation Principles - 2:11
    • Graph I: Key Actuals with Targets - 17:55
    • Graph II: Monthly Actuals with Budgeted Forecasts - 12:16
    • Dynamic Table: Data Layout for Competitor Tracking - 10:57
    • Dynamic Table: Ranking for Competitor Tracking - 6:02
    • Graph III: Tracking Weekly Performance over Monthly Budget - 10:31
    • Final Touches - 0:47
    • Section Recap - 1:51
    • Quiz 9: Data Visualisation Quiz
  • Creating Dynamic and Reliable Data Connections
    • Introduction - 0:41
    • Status for Data Dump - 6:08
    • Dynamic Budget Connection with IMPORTRANGE - 4:15
    • Dynamic Budget Connection with QUERY - 4:13
    • Final Touches - 3:45
    • Quiz 10: Data Connections Quiz
  • Wrapping Up the Project
    • Introduction - 0:42
    • Adding Instructions - 1:39
    • Reviewing Links in Cover tab - 1:09
    • Final Touches on Whole File - 3:17
    • Protecting the Sheets - 3:29
    • Recap of Course Project - 1:51
    • Quiz 11: Project Wrap-Up Quiz
  • Further Development Tips and Tricks
    • Introduction - 0:49
    • Automating Data Dump through a Script - 2:37
    • Creating Multi-Level Reporting System - 3:15
    • Optimise Spreadsheet Performance - 1:40
    • Workaround for IMPORTRANGE Internal Error - 2:13
    • Manage Reporting Files through Scripts - 2:07
    • Section Recap - 1:07
    • Quiz 12: Tips and Tricks Quiz
  • Conclusion
    • Conclusion - 2:16
    • Bonus Lecture - 3:15

View Full Curriculum


Access
Lifetime
Content
2.0 hours
Lessons
28

Dynamic Quiz App Using Google Sheets as Source Google Script

Create Web Apps with Java Script & Google Script

By Laurence Svekis | in Online Courses

This course will help you build your own Dynamic and interactive quiz that uses only Google Sheet data to output the contents of the quiz, and JavaScript on your web page or website. You will be amazed at what you can do with just a few lines of code and how easy it is to connect Google Sheets to your website. This is a great solution to avoid backend code using only Google Script which is essentially JavaScript with a bunch of methods in the cloud.

4.3/5 average rating: ★ ★ ★ ★

  • Access 28 lectures & 2 hours of content 24/7
  • Connect website input form to Google Spreadsheet
  • Build a quiz application from scratch that uses Google Sheets as the data source
  • Add data from input form to Google Spreadsheet
Laurence Svekis | Instructor, Google Development Expert, Application Developer
4.3/5 Instructor Rating: ★ ★ ★ ★

Providing Web development courses and digital marketing strategy courses since 2002. Laurence Svekis is an innovative technology expert with a wide range of real-world experience providing smart digital solutions online for both small and enterprise-level businesses.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Google account

Course Outline

  • Introduction to creating web apps with JavaScript and Google Script
    • 0 Dynamic Quiz App Introduction - 2:26
    • 1 Development Setup - 6:04
    • 2 Spreadsheet Data as JSON - 5:21
    • 3 JavaScript Fetch Data - 5:15
    • 4 Get Sheet Data as Object - 6:00
    • 5 Get Sheet Data as Object 2 - 5:48
    • 6 Get Sheet Data as Object 3 - 3:17
    • 7 Multiple Sheets Promise All - 5:48
    • 8 Build your sheet data object - 6:53
    • 9 Client Side Create HTML from Data - 6:12
    • 10 Create Quiz Questions - 3:22
    • 11 Create Questions JavaScript - 7:21
    • 12 Output Answers to Questions - 5:49
    • 13 Add styling to output - 2:40
    • 14 First Run Output Builder - 1:43
    • 15 Check Answer Scoring - 5:19
    • 16 Game Over handling - 5:33
    • 17 Quiz Gameplay review - 8:07
    • 18 Create Your Quiz - 4:09
    • 19 Apps Script Setup - Use this - 5:55
    • 20 Apps Script add to Sheet - 9:05
    • 21 Connect to WebApp AJAX - 5:04
    • 22 JavaScript Form Builder - 7:33
    • 23 Form Data Post - 8:48
    • 24 WebApp Post Formdata - 4:26
    • 25 Quiz Creator Review and Tweaks - 7:08
    • 26 CORS error Debug - 6:08
    • 27 doGet Method - 3:44

View Full Curriculum


Access
Lifetime
Content
1.0 hours
Lessons
15

Go Fast with Google Sheets (Excel Alternative)

Up Your Efficiency for a Shorter Work Day with 1 Hour of Instruction on Google's Alternative to MS Excel

By Grant Klimaytys | in Online Courses

Have you ever wondered how much time you waste doing these things manually? The truth is many people spend too much time clicking, typing, and editing. A massive waste of time on repetitive tasks! This course will show you the main shortcuts you'll use every single day in Google Sheets. It's an online spreadsheet offered by Google as part of their GSuite. If you write or edit 1 spreadsheet each day, then you could save 45 minutes every day. That comes out to 5 working weeks every single year! Go fast now with Google Sheets.

  • Access 15 lectures & 1 hour of content 24/7
  • Be familiar with Google Sheets
  • Learn basic Sheets tips & shortcuts
  • Explore styling, auto cell fitting, & editing
  • Know how to insert time & date, select cells, cut & paste, all in a faster way
  • Discover formulas, using comments, & charting shortcuts
Grant Klimaytys | Former Google Engineer & Professional App Developer
4.2/5 Instructor Rating: ★ ★ ★ ★

Grant Klimaytys is an app developer, author, and eCourse teacher. After seeing his success both as a freelancer and with his own apps on the App Stores a lot of people asked me for his secrets. Rather than going through them individually, he decided to create app development courses listing out what he does and how. He is obsessed with breaking down hard to understand principles so students can learn fast and easily!

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: beginner
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Google account

Course Outline

  • Introduction
    • Introduction to Go Fast with Google Sheets - 1:27
    • Best Way to Use This Course - 1:19
  • Basic Sheets Tips and Shortcuts
    • From Blank Screen to Formatted Saved Spreadsheet - No Mouse - 2:43
    • Basic Cell Formatting and Cell Type Shortcuts - 3:48
    • Alignment and Border Shortcuts - 5:43
  • Intermediate Google Sheets Shortcuts
    • Consistent Styling Advice and Auto Cell Fitting - 2:31
    • Basic Editing Tips and Cell Insertion for Faster Workflow - 5:17
    • Basic Editing Assignment - 2:05
  • Advanced Google Sheets Tips and Shortcuts
    • Date and Time Insertion and Shortcuts - 4:35
    • Fast Movement and Selection - 4:04
    • Cut and Paste in Another Way - 0:34
  • BONUS: More Advanced Shortcuts
    • Fast Formulas Turning Calculations off and Auto Dollar Signs - 6:06
    • Viewing All Formulas and Using Comments - 5:17
    • Charting Shortcuts - 2:08
  • Thank You
    • Thank You and Where to go Next - 1:15

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 average rating: ★ ★ ★ ★

  • 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 by 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)


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 has an active Excel blog where he posts free Excel tutorials as well as an Excel podcast where he interviews fellow Excel experts and shares their insights.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: intermediate
  • Have questions on how digital purchases work? Learn more here

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.

4.6/5 average rating: ★ ★ ★ ★

  • 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 by 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)


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 has an active Excel blog where he posts free Excel tutorials as well as an Excel podcast where he interviews fellow Excel experts and shares their insights.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: beginner
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel

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
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 average rating: ★ ★ ★ ★

  • 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 by 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)


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 has an active Excel blog where he posts free Excel tutorials as well as an Excel podcast where he interviews fellow Excel experts and shares their insights.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: intermediate
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel

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
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 average rating: ★ ★ ★ ★

  • 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 by 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)


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 has an active Excel blog where he posts free Excel tutorials as well as an Excel podcast where he interviews fellow Excel experts and shares their insights.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: intermediate
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel

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
14

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

Clean Your Cluttered 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 average rating: ★ ★ ★ ★

  • 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 by 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)


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 has an active Excel blog where he posts free Excel tutorials as well as an Excel podcast where he interviews fellow Excel experts and shares their insights.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: advanced
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel

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
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 by 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)


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 has an active Excel blog where he posts free Excel tutorials as well as an Excel podcast where he interviews fellow Excel experts and shares their insights.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: beginner
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel

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


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 '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 by 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)


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 has an active Excel blog where he posts free Excel tutorials as well as an Excel podcast where he interviews fellow Excel experts and shares their insights.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: intermediate
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel

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
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. Some of the topics that will be discussed here are as follow: working with Google Sheet's checkbox, sparklines for Dashboards, using slicer on a table, add pop-up calendar date picker, coloring raws based on a cell value, and more.

  • 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
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: beginner
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel
  • Access to Google Sheets

Course Outline

  • 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



Terms

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