Get $1 credit for every $25 spent!

The All-In-One Microsoft Excel Certification Training Bundle

Ending In:
Add to Cart - $33.99
Add to Cart ($33.99)
$2,000
98% off
wishlist
Courses
10
Lessons
657
Enrolled
805

What's Included

Product Details

Access
Lifetime
Content
6.0 hours
Lessons
85

Advanced Excel Dashboards & Data Visualization Masterclass

Learn Advanced Skills To Create Excel Dashboards & Data Visualizations

By Jordan Goldmeier | in Online Courses

In this course, you will take a quick dive into concepts such as Array Formulas and formula-driven developments. As you progress, you will see how each module builds from top to bottom. Also, you will be exposed to often overlooked features such as Excel's form controls, which can drive tremendous interactivity. At the same time, you will run through the rules of data visualization, making sure that what you build communicates its message. By the end of this course, you won't just be good at data visualization and dashboards, but also, you will become a master Excel builder.

4.3/5 average rating: ★ ★ ★ ★

  • Access 85 lectures & 6 hours of content 24/7
  • Learn advanced skills to create dashboards & data visualizations in Excel
  • Quickly create dashboards, reports & interactive applications without macros
  • Use Microsoft Excel with confidence
  • Get downloadable Excel workbooks to practice on
  • Attain personal Excel support from professional Excel trainers
  • Become expert at creating interactive analysis
  • Be more productive at using Microsoft Excel
  • Increase your Microsoft Excel skills & knowledge within hours
  • Test your skills with different real life quizzes, homework, practice activities, & assignments
NOTE: Software NOT included.
Jordan Goldmeier | Chief Data Anarchist
4.3/5 Instructor Rating: ★ ★ ★ ★

Jordan Goldmeier is an internationally recognized analytics professional and data visualization expert, author and speaker. A former chief operations officer at Excel.TV, he has spent years in the data training trenches. He is the author of Advanced Excel Essentials and Dashboards for Excel, and currently working on this 3rd book, Becoming a Data Head (Wiley, 2021), on helping managers communicate, challenge, and understand data science with a common language and expectation.

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

  • Excel for Windows 2010, 2013, 2016, 2019
  • Office 365
  • Excel for Mac 2011 and 2016

Course Outline

  • Your First Program
  • 1 - Introduction
    • 1.1 Introduction - 0:49
    • 1.2 Why Even Use Excel? - 7:35
    • 1.3 Why Dashboards + Datavis? - 5:23
    • 1.4 Interactive Dashboards in Excel - 10:19
    • 1.5 Quiz
  • 2 - Thinking Outside the Cell
    • 2.1 Thinking Outside the Cell - 6:47
    • 2.2 Why develop differently - 3:40
    • 2.3 Inserting the camera tool - 2:57
    • 2.4 How to use the camera tool - 7:54
    • 2.5 Development Principles - 12:49
    • 2.6 Quiz
  • 3 - Working with Formulas
    • 3.1 Formula Editing Tips - 11:52
    • 3.2 Excel Calculation Engine - 9:08
    • 3.3 Writing Better Formulas - 11:10
    • 3.6 Quiz
  • 4 - Advanced Formulas for Dashboards & Decisions
    • 4.1 Lookup Functions - 2:44
    • 4.2 How to use VLOOKUP - 3:24
    • 4.3 How to use INDEX/MATCH - 6:28
    • 4.4 Combining formulas - 4:24
    • 4.5 How to use Array Formulas - 2:49
    • 4.6 Array Formulas Demo - 20:44
    • 4.7 Section Review - 2:20
    • 4.8 Quiz
    • 4.9 Practice
  • 5 - Excel Tables are the Best!
    • 5.1 Introduction to Excel Tables - 3:43
    • 5.2 Inserting a New Excel Table - 8:35
    • 5.3 Working with Tables - 7:29
    • 5.4 Excel Tables Demo - 4:34
    • 5.5 Rules for using Excel Tables - 2:35
    • 5.6 Quiz
    • 5.7 Practice
  • 6 - Sorting and Decision Functions
    • 6.1 Introduction to Sorting Functions - 19:20
    • 6.2 Creating Filters with SUMPRODUCT - 1:38
    • 6.3 Filtering on Excel Tables - 17:26
    • 6.4 Data Aggregation - 13:26
    • 6.5 Section Summary - 2:12
    • 6.6 Quiz
    • 6.7 Practice
  • 7 - Form Controls for Interactivity
    • 7.1 The DEVELOPER Tab - 1:32
    • 7.2 Excel Form Controls - 3:44
    • 7.3 Form Controls Demo - 14:55
    • 7.4 Form Control Basics - 1:59
    • 7.5 Creating a Scrollable Table - 7:26
    • 7.6 Quiz
    • 7.7 Practice
  • 8 - Formula-driven Development
    • 8.1 Introduction to Formula-driven Development - 29:11
    • 8.2 The Information-Transformation-Presentation Dynamic - 5:06
    • 8.3 Quiz
  • 9 - Creating an Interactive Legend Dashboard
    • 9.1 Section Introduction - 1:50
    • 9.2 Creating an Interactive Legend - 7:18
    • 9.3 Perfecting the Interactive Legend - 16:50
    • 9.4 Maintaining the Interactive Legend - 3:11
    • 9.5 Practice
  • 10 - Creating an Interactive Chart Dashboard
    • 10.1 Section Introduction - 0:38
    • 10.2 Setting up an Interactive Chart - 6:56
    • 10.3 Formatting the Interactive Chart - 5:04
    • 10.4 Maintaining the Interactive Chart - 2:51
    • 10.5 Practice
  • 11 - Interactive Tornado Dashboard with Drill Downs
    • 11.1 Section Introduction - 0:41
    • 11.2 Setting up the Interactive Dashboard - 15:27
    • 11.3 Formatting the Interactive Dashboard - 1:49
    • 11.4 Maintaining the Interactive Dashboard - 2:58
    • 11.5 Practice 1
    • 11.6 Practice 2
  • 12 - Data Visualization
    • 12.1 Introduction to Visual Perception - 8:22
    • 12.2 The Gestalt Laws of Grouping - 4:37
    • 12.3 Preattentive Attributes - 2:34
    • 12.4 The Problem with Pie Charts - 1:45
    • 12.5 Introduction to Infographics - 2:01
    • 12.6 Quiz
  • 13 - Special Charts
    • 13.1 Expanding the Chart Library - 0:26
    • 13.2 Dual Axis Band Chart - 4:21
    • 13.3 Shaded Area Banded Chart - 4:31
    • 13.4 Limit and Control Charts - 3:11
  • 14 - Bullet Charts
    • 14.1 Introduction to Bullet Charts in Excel - 1:28
    • 14.2 Bullet Chart Demo - 7:00
    • 14.3 Horizontal Bullet Chart Trick - 4:03
    • 14.4 Practice
  • 15 - Infographics in Excel
    • 15.1 Introduction to Infographics in Excel - 1:17
    • 15.2 Progress Meter Chart - 8:44
    • 15.3 Donut Chart - 6:01
    • 15.4 "Waffle" Chart - 5:58
    • 15.5 Bringing it all together with the CAMERA - 2:13
    • 15.6 Practice
  • 16 - Conclusion
    • Continue Learning! - 2:38

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 | Data Analyst, MS Office Expert & PMP, Instructor/Programmer
4.4/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

  • 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
20

Master all the MS Excel Macros and the basics of Excel VBA

Learn Automation of Tasks with Excel Macros & Excel VBA

By Yassin Marco | in Online Courses

This course has been created to help you learn all the basics that are around the use of VBA with Microsoft Excel. With this course, you will first learn the power of Macros with Microsoft Excel. This will allow you to automate the majority of the task that you are currently doing on Microsoft Excel. Then, you will understand how to properly record your own macro, and learn all the programming behind a macro. Another important aspect of this course is that it will help you learn by practice. Each element enables you to sharpen your skills in Excel Macro and Excel VBA.

4.1/5 stars on Amazon: ★ ★ ★ ★

  • Access 20 lectures & 4 hours of content 24/7
  • Create plenty of small projects to learn the basics of VBA
  • Learn the best way to write a VBA code on Excel
  • Be able to automate different tasks with VBA on Excel
  • Understand VBA programming structure & concepts
  • Understand how to use the macro recorder
  • Enhance your current Excel projects with VBA programming
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

  • The Basics
    • Introduction - 5:15
    • What is Excel VBA - 5:51
    • Understanding how an object oriented language work - 4:54
    • Introduction to Excel for Developpers - 2:23
  • Macro Creation
    • Introduction to Macros Part 1 - 13:42
    • Introduction to Macros Part 2 - 13:58
    • Introduction to Macros Part 3 - 32:20
    • Introduction to Macros Part 4 - 13:16
    • Introduction to Macros Part 5 - 27:32
    • Introduction to Macros Part 6 - 10:07
  • VBA Programming
    • VBA Programming Part 1 - 6:40
    • VBA Programming Part 2 - 13:28
    • VBA Programming Part 3 - 12:53
    • VBA Programming Part 4 - 17:00
    • VBA Programming Part 5 - 10:16
    • VBA Programming Part 6 - 18:32
  • VBA and Details
    • VBA and details Part 1 - 19:54
    • VBA and details Part 2 - 12:00
    • VBA and details Part 3 - 11:16
    • Conclusion - 3:29

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. Here, you will learn about the Power Excel landscape, explore what these Excel tools are all about, and why they are changing the world of self-service business intelligence. Take your Excel game to new heights and join the leading edge of analytics and business intelligence

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.
Maven Analytics | Award-Winning Analytics & Business Intelligence 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 | Founder, Maven Analytics
4.6/5 Instructor Rating: ★ ★ ★ ★

Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics and data visualization.

He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 25,000+ students in more than 150 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.

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: all levels

Requirements

  • Version of Excel that is compatible with Power Pivot (Excel 2013/2016/2019 Standalone, Office 365, Enterprise E3/E5, Office Professional 2016, etc.)
  • Experience with Excel PivotTables

Course Outline

  • 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
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 several ways. This is especially useful for including in your portfolio or resume, so future employers can feel confident in your skillset.

  • 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
NOTE: Software NOT included.
Maven Analytics | Award-Winning Analytics & Business Intelligence 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 | Founder, Maven Analytics
4.6/5 Instructor Rating: ★ ★ ★ ★

Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics and data visualization.

He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 25,000+ students in more than 150 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.

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: all levels

Requirements

  • Microsoft Excel

Course Outline

  • 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 and implement the same B.I. tools used by professional analysts & data scientists
NOTE: Software NOT included.
Maven Analytics | Award-Winning Analytics & Business Intelligence 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 | Founder, Maven Analytics
4.6/5 Instructor Rating: ★ ★ ★ ★

Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics and data visualization.

He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 25,000+ students in more than 150 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.

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: all levels

Requirements

  • Any device with basic specifications

Course Outline

  • 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
  • Analyze 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.
Maven Analytics | Award-Winning Analytics & Business Intelligence 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 | Founder, Maven Analytics
4.6/5 Instructor Rating: ★ ★ ★ ★

Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics and data visualization.

He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 25,000+ students in more than 150 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.

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

  • 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
46

Data Science with Stocks, Excel and Machine Learning

Snag the Most In-Demand Role in the Tech Field Today

By Mammoth Interactive | in Online Courses

Start a career in data science by learning how to combine your Excel knowledge with Python programming, machine learning, and data science. Take your spreadsheets to the next level by learning the essentials of coding specifically tailored for data science in Excel. Completely tailored for beginners, this is a life-changing course you don't want to miss.

  • Access 46 lectures & 4 hours of content 24/7
  • Understand basic machine learning concepts
  • Get a quick introduction to Python
  • Project track stocks in Excel
  • Explore linear regression on stock data in Excel
NOTE: Software NOT included.
Mammoth Interactive | Top-Rated Instructor
4.2/5 Instructor Rating: ★ ★ ★ ★

Mammoth Interactive produces XBOX 360, iPhone, iPad, Android, HTML 5, ad-games, and more. It's owned by top-rated instructor John Bura. Mammoth Interactive recently sold a game to Nickelodeon! John has been contracted by many different companies to provide game design, audio, programming, level design, and project management. To this day John has 40 commercial games that he has contributed to. Several of the games he has produced have risen to number 1 in Apple's app store. In his spare time, John likes to play ultimate Frisbee, cycle and work out.

John Bura | Best Selling Instructor, Web/App/Game Developer
4.2/5 Instructor Rating: ★ ★ ★ ★

John Bura has been programming games since 1997 and teaching since 2002. John is the owner of the game development studio Mammoth Interactive. This company produces XBOX 360, iPhone, iPad, android, HTML 5, ad-games and more. Mammoth Interactive recently sold a game to Nickelodeon! John has been contracted by many different companies to provide game design, audio, programming, level design and project management. To this day John has 40 commercial games that he has contributed to. Several of the games he has produced have risen to number 1 in the Apple's app store. In his spare time John likes to play ultimate Frisbee, cycle and work out.

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

  • Intro to Mammoth Interactive
    • 00 About Mammoth Interactive - 1:05
    • 01 How to Learn Online Effectively - 13:39
  • 00 Welcome to the Course
    • Course Overview - 5:43
    • Source Files
  • 01 Project - Track Stocks in Excel
    • 01.00 What You'll Learn - 2:01
    • 01.01 Pull In Stock Data - 8:21
    • 01.02 Pull In More Stock Information - 5:08
    • 01.03 Calculate Equity And Returns - 11:56
    • 01.04 Calculate Selling Strategy - 9:25
    • 01.05 Calculate Total Returns - 4:28
    • 01 Source Files
  • 02A Other Techniques of Stock Prediction in Excel
    • 02.01 Pull Historical Stock Data - 2:31
    • 02.02 Predict Stocks With Moving Average - 9:34
    • 02.03 Visualize Accuracy - 3:48
    • 02.04 What Is Exponential Smoothing - 4:15
    • 02.05 Predict Stocks With Exponential Smoothing - 7:37
    • 02A Source Files
  • 02B Linear Regression on Stock Data in Excel
    • 02.00 What You'll Learn - 1:46
    • 02.01 Pull Historical Stock Data - 5:49
    • 02.02 What Is Linear Regression - 4:45
    • 02.03 Linear Regression On Stock Data In Excel - 8:04
    • 02.04 Check Accuracy Of Linear Regression - 12:53
    • 02B Source Files
  • 03A Machine Learning Project Introduction
    • 03.00 What You'll Learn - 2:01
    • 03.01 Build Models On The Web - 5:05
    • 03.02 What Libraries Will We Use - 5:56
    • Source Files
  • 03B Your First Machine Learning Stock Prediction Project
    • 03.01 Scrape Data Via API - 16:42
    • 03.02 Define Variables - 11:36
    • 03.03 Split Dataset For Training And Testing - 7:33
    • 03.04 Build A Linear Regression Model - 9:16
    • 03.05 Predict Stock Prices - 10:14
    • 03.06 Calculate Model Accuracy - 14:17
    • 03.07 Predict To Buy Or To Sell - 7:23
    • 03 Source Files
  • 04 Deep Learning Project for Stock Market Prediction
    • 04.00 Recurrent Neural Networks - 6:23
    • 04.01 Import Stock Data - 9:19
    • 04.02 What Is Shaping Data - 5:18
    • 04.03 Shape Training And Testing Data - 12:06
    • 04.04 What Is Scaling Data - 6:35
    • 04.05 Scale Data For Training - 11:24
    • 04.06 What Is Keras - 3:24
    • 04.07 Build A Keras Model - 14:03
    • 04.08 Scale And Shape Data For Testing - 5:33
    • 04.09 Test The Model - 5:15
    • 04 Source Files

View Full Curriculum


Access
Lifetime
Content
6.0 hours
Lessons
84

Microsoft Excel (365): Crash Course

Speed Up Your Data Work with Beginner to Advanced Content on Excel

By Earn and Excel | in Online Courses

It is a perfect course for you if you are about to start a new role or project, or perhaps you are preparing for or a fairly in-depth interview in the next few days and you want to spend a few evenings or the weekend to bolster your Excel skills! The course is presented by the highly experienced Andrew Dove an accounting professional from the UK and covers the most important Excel topics that professionals need to be accomplished in. This course will help you get the best out of Excel.

4.3/5 average rating: ★ ★ ★ ★

  • Access 84 lectures & 6 hours of content 24/7
  • Learn introductory topics such as the Excel interface, sheets, rows, columns & data types
  • Get comfortable with Functions (Basic, Copying Functions, Named Ranges)
  • Format the sheet, numbers, rows, cells & more Sort, filter, & validate data
  • Learn advanced functions such as VLOOKUPS, INDEX, MATCH, IF, & more
  • Consolidate data with Power Query
  • Speed up your work by recording and tweaking Macros
NOTE: Software NOT included.
Earn and Excel
4.4/5 Instructor Rating: ★ ★ ★ ★

Earn and Excel is a collective of highly experienced professionals from the UK and North America who have packed decades of skills and experiences into easily digestible training courses on Excel, Business Intelligence, Data Analysis, Microsoft Office, Accounting, and Marketing Analytics.

They have all had long careers as professionals first and foremost so this allows them to truly empathize with your challenges in the workplace. Their goal is not to just teach you the theory but to impart practical skills you can begin to implement immediately.

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

  • 1 Starting Excel
    • Course Materials
    • 1.1 Starting Excel - 1:29
    • 1.2 Understanding Excel Interface - 4:29
    • 1.3 Getting Familiar with The Excel Workbook and Worksheets - 1:33
    • 1.4 Explaining the Ribbon - 5:45
    • 1.5 Saving an Excel File - 2:54
  • 2 What you can enter
    • 2.1 Combined What you can enter in a cell - 7:42
    • 2.2 Relative and Absolute Cell Referencing - 3:12
    • 2.3 Entering Formula - 1:56
    • 2.4 Order of Operations - 2:59
    • 2.5 Date Serial Numbers - 4:24
  • 3 Sheets, rows and columns
    • 3.1 Copy and Drag - 1:41
    • 3.2 Working with rows and columns - 10:18
    • 3.3 Working with sheets - 5:27
  • 4 Functions, ranges and shortcuts
    • 4.1 Functions - 3:49
    • 4.2 SUM Function - 3:23
    • 4.3 Copy and Drag Formula - 4:56
    • 4.4 More basic functions - 2:48
    • 4.5 Named Ranges - 8:42
    • 4.6 Names Constants and Formula - 3:52
    • 4.7 Shortcuts - 3:43
    • 4.8 More Shortcuts - 6:49
  • 5 Formatting and conditional formatting
    • Course Materials
    • 5.1 Formatting Font - 4:57
    • 5.2 Formatting Alignment - 2:59
    • 5.3 Formatting Borders - 2:42
    • 5.4 Formatting Numbers - 3:17
    • 5.5 Conditional Formatting PreConfigured - 4:45
    • 5.6 Conditional Formatting with Formula - 11:04
    • 5.7 Conditional Formatting Dialogue Box Formula Trick - 3:15
  • 6 Printing
    • 6.1 Icons Shapes and Formatting - 8:52
    • 6.2 Printing Page Layout - 8:43
    • 6.3 Printing Headers Footers - 2:31
  • 7 Managing data
    • 7.1 Data Sort - 5:55
    • 7.2 Filtering - 5:35
    • 7.3 Tables - 6:43
    • 7.4 Text to Columns - 5:20
    • 7.5 Flash Fill - 2:53
    • 7.6 Data Validation - 5:22
    • 7.7 Group and Outline - 4:05
    • 7.8 Freeze Panes - 1:47
  • 8 Managing text and working with formulas and functions
    • 8.1 Relative and Absolute Referencing - 5:47
    • 8.2 VLOOKUP - 6:51
    • 8.3 Index Match - 6:35
    • 8.4 IF - 2:10
    • 8.5 Nested If - 3:18
    • 8.6 Countif Countifs - 6:56
    • 8.7 SUMIF SUMIFS - 5:25
    • 8.8 LEN - 1:59
    • 8.9 RIGHT LEFT MID - 5:07
    • 8.11 Common Error Types - 2:18
    • 8.10 SEARCH - 1:50
    • 8.12 IFERROR - 3:08
  • 9 Charts
    • 9.1 Chart Basics - 5:09
    • 9.2 Chart Series and Column Charts - 5:27
    • 9.3 Bar Charts - 5:16
    • 9.4 Pie Charts - 4:28
    • 9.5 Composite Charts - 3:17
  • 10 Pivot tables, Power Query and Dashboards
    • 10.1 Power Query Intro - 4:46
    • 10.2 Power Query Consolidation - 2:47
    • 10.3 Pivot Tables - 2:12
    • 10.4 Setting up a Pivot Table - 4:22
    • 10.5 Pivot Table Field Settings - 4:06
    • 10.6 Pivot Table Calculated Fields - 1:55
    • 10.7 Pivot Table Groupings - 2:10
    • 10.8 Pivot Table Slicers and Timelines - 4:52
    • 10.9.1 Dashboards Part 1 - 6:26
    • 10.9.2 Dashboards Part 2 - 7:45
  • 11 Macros
    • 11.1 What is a macro - 1:58
    • 11.2 Recording a Macro - 1:44
    • 11.3 Relative and Absolute Macros - 6:00
  • 12 Intro to VBE and VBA
    • 12.1 Introduction to VBE - 8:19
    • 12.2 Object Model - 9:11
    • 12.3 Module Worksheets Classes - 7:50
    • 12.4 Variables and Constants - 10:23
    • 12.5 Vba Formatting - 10:38
    • 12.6a If Statement - 7:08
    • 12.6b Select Case - 6:25
    • 12.7a For Loop - 10:13
    • 12.7b DoWhile DoUntil Loop - 2:47
    • 12.7c ForEach Loop - 4:54
    • 12.8a Errors - 6:00
    • 12.8b Errors - 4:24
    • 12.9 Consolidate - 6:33

View Full Curriculum


Access
Lifetime
Content
1.0 hours
Lessons
8

Excel for HR Dashboard and Analytics

Automate Excel 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 | Data Analyst, MS Office Expert & PMP, Instructor/Programmer
4.4/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

  • 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



Terms

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