Danh mục
Development
Web Development Data Storage Git Automation Database Design Web Scraping
Business
Business Analysis Communication Project Management Sales Forecasting Business Strategy Operations Management Human Resources Oil and Gas Industry
Finance & Accounting
IT & Software
Office Productivity
SAP Word Excel PowerPoint Excel VBA SharePoint
Personal Development
Persuasion Notion Workspace Mind Mapping
Design
Design Sketching Typography Game Design Digital Art zBrush 3D Animation
Marketing
SEO Marketing Strategy YouTube Marketing Digital Marketing Facebook Marketing Growth Hacking Twitter Marketing Instagram Marketing
Lifestyle
Beer Brewing Beauty Home Repair Energy Healing Bartending Leather Crafting Makeup Artistry Hypnotherapy
Music
Piano Guitar Singing Music Production Acoustic Guitar Fingerstyle Guitar Music Theory Bass Guitar
Duocmmo Tedu Tin học văn phòng Khoá học miễn phí Tất cả khoá học
Get link khoá học
Trang chủ
Tin học văn phòng
Excel
The Ultimate Microsoft Excel Mastery Bundle - 8 Courses

The Ultimate Microsoft Excel Mastery Bundle - 8 Courses

Loại khoá học: Tin học văn phòng

Master Microsoft Excel with this huge-value beginner to advanced eight-course bundle and become an Excel power user!

image
50.000 VND
100 VND
Đầy Đủ Bài Giảng
Học Online Tiện Lợi
Kích Hoạt Nhanh 2-5 Phút
Thanh toán tự động
Được phép tải xuống

Tổng quan

Nội dung khoá học

Đánh giá

Mô tả

**This bundle includes practice exercises, downloadable files, and LIFETIME access**


Let us take you on a journey from being an Excel novice to an Excel expert with this amazing value 8-course training bundle. By the end of this training, you will be able to clean, summarize, and analyze data easily, as well as create PivotTables, charts, macros, and so much more!


We'll take you on a no-nonsense journey to learn specific functions, formulas, and tools that Excel has to help conduct business or data analysis. We'll also look at three advanced Excel features: Power Pivot, Power Query, and DAX. This suite of Excel functions allows you to manipulate, analyze, and evaluate millions of rows of data from Excel or other databases.


This ultimate Excel course bundle is designed for students of all levels. If you are brand new to Microsoft Excel, this course can get you started on your journey. If you already have a good understanding of Excel, you can further your skills with the more advanced courses in this bundle. This is the only Excel training you are ever going to need!


All courses include practice exercises and follow-along instructor files so you can immediately apply what you learn.


What's included?


Excel 2021 for Beginners

  • Become familiar with what’s new in Excel 2021

  • Navigate the Excel 2021 interface

  • Utilize useful keyboard shortcuts to increase productivity

  • Create your first Excel spreadsheet

  • Use basic and intermediate Excel formulas and functions

  • Effectively apply formatting to cells and use conditional formatting

  • Use Excel lists and master sorting and filtering

  • Work efficiently by using the cut, copy, and paste options

  • Link to other worksheets and workbooks

  • Analyze data using charts

  • Insert pictures in a spreadsheet

  • Work with views, zooms, and freezing panes

  • Set page layout and print options

  • Protect and share workbooks

  • Save your workbook in different file formats


Excel 2021 Intermediate

  • Designing better spreadsheets and controlling user input

  • How to use logical functions to make better business decisions

  • Constructing functional and flexible lookup formulas

  • How to use Excel tables to structure data and make it easy to update

  • Extracting unique values from a list

  • Sorting and filtering data using advanced features and new Excel formulas

  • Working with date and time functions

  • Extracting data using text functions

  • Importing data and cleaning it up before analysis

  • Analyzing data using PivotTables

  • Representing data visually with PivotCharts

  • Adding interactions to PivotTables and PivotCharts

  • Creating an interactive dashboard to present high-level metrics

  • Auditing formulas and troubleshooting common Excel errors

  • How to control user input with data validation

  • Using WhatIf analysis tools to see how changing inputs affect outcomes.


Excel 2021 Advanced

  • Using the NEW dynamic array functions to perform tasks

  • Creating advanced and flexible lookup formulas

  • Using statistical functions to rank data and to calculate the MEDIAN and MODE

  • Producing accurate results when working with financial data using math functions

  • Creating variables and functions with LET and LAMBDA

  • Analyzing data with advanced PivotTable and PivotChart hacks

  • Creating interactive reports and dashboards by incorporating form controls

  • Importing and cleaning data using Power Query

  • Predicting future values using forecast functions and forecast sheets

  • Recording and running macros to automate repetitive tasks

  • Understanding and making minor edits to VBA code

  • Combining functions to create practical formulas to complete specific tasks.


Excel for Business Analysts

  • How to merge data from different sources using VLOOKUP, HLOOKUP, INDEX MATCH, and XLOOKUP

  • How to use IF, IFS, IFERROR, SUMIF, and COUNTIF to apply logic to your analysis

  • How to split data using text functions SEARCH, LEFT, RIGHT, MID

  • How to standardize and clean data ready for analysis

  • About using the PivotTable function to perform data analysis

  • How to use slicers to draw out information

  • How to display your analysis using Pivot Charts

  • All about forecasting and using the Forecast Sheets

  • Conducting a Linear Forecast and Forecast Smoothing

  • How to use Conditional Formatting to highlight areas of your data

  • All about Histograms and Regression

  • How to use Goal Seek, Scenario Manager, and Solver to fill data gaps


Power Pivot, Power Query & DAX

  • How to get started with Power Query

  • How to connect Excel to multiple workbooks

  • How to get data from the web and other sources

  • How to merge and append queries using Power Query

  • How the Power Pivot window works

  • How to set up and manage relationships in a data model

  • How to create a PivotTable to display your data from the Power Pivot data model

  • How to add calculated columns using DAX

  • How to use functions such as CALCULATE, DIVIDE, DATESYTD in DAX

  • All about creating Pivot Charts and PivotTables and using your data model

  • How to use slicers to adjust the data you display


PivotTables for Beginners

  • How to clean and prepare your data

  • Creating a basic PivotTable

  • Using the PivotTable fields pane

  • Adding fields and pivoting the fields

  • Formatting numbers in PivotTable

  • Different ways to summarize data

  • Grouping PivotTable data

  • Using multiple fields and dimension

  • The methods of aggregation

  • How to choose and lock the report layout

  • Applying PivotTable styles

  • Sorting data and using filters

  • Create pivot charts based on PivotTable data

  • Selecting the right chart for your data

  • Apply conditional formatting

  • Add slicers and timelines to your dashboards

  • Adding new data to the original source dataset

  • Updating PivotTables and charts


Advanced PivotTables

  • How to do a PivotTable (a quick refresher)

  • How to combine data from multiple worksheets for a PivotTable

  • Grouping, ungrouping, and dealing with errors

  • How to format a PivotTable, including adjusting styles

  • How to use the Value Field Settings

  • Advanced Sorting and Filtering in PivotTables

  • How to use Slicers, Timelines on multiple tables

  • How to create a Calculated Field

  • All about GETPIVOTDATA

  • How to create a Pivot Chart and add sparklines and slicers

  • How to use 3D Maps from a PivotTable

  • How to update your data in a PivotTable and Pivot Chart

  • All about Conditional Formatting in a PivotTable

  • How to create amazing-looking dashboards


Interactive Excel Dashboards

  • About Dashboard architecture and inspiration

  • How to prepare data for analysis (cleaning data)

  • Useful formulas for creating dashboards in Excel

  • How to create and edit Pivot Tables in Excel

  • How to create Pivot Charts from Pivot Tables

  • Advanced chart techniques in Excel

  • How to add interactive elements (form controls) into your dashboards

  • How to create a Sales Dashboard from scratch

  • How to create an HR Dashboard from scratch


This bundle includes:

  1. 60+ hours of video tutorials

  2. 550+ individual video lectures

  3. Course and exercise files to follow along

  4. Certificate of completion

Bạn sẽ học được gì

Become familiar with what’s new in Excel 2021 and navigate the Excel 2021 interface

Create your first Excel spreadsheet and use basic and intermediate Excel formulas and functions

Utilize useful keyboard shortcuts to increase productivity

Linking to other worksheets & workbooks and protecting & sharing workbooks

How to use logical functions to make better business decisions

Creating an interactive dashboard to present high-level metrics

Using the NEW dynamic array functions to perform tasks

Recording and running macros to automate repetitive tasks

Predicting future values using forecast functions and forecast sheets

Using statistical functions to rank data and to calculate the MEDIAN and MODE

Understanding and making minor edits to VBA code

How to merge data from different sources using VLOOKUP, HLOOKUP, INDEX MATCH, and XLOOKUP

How to standardize and clean data ready for analysis in Excel

Conducting a Linear Forecast and Forecast Smoothing in Excel

All about Histograms and Regression in Excel

How to use Goal Seek, Scenario Manager, and Solver to fill data gaps in Excel

Learn to unlock advanced Excel tools Power Query and Power Pivot

Analyze huge buckets of data to make informed business decisions

How to create PivotTables

Grouping and ungrouping PivotTable data and dealing with errors

Creating PivotCharts and adding sparklines and slicers

Adding slicers and timelines and applying them to multiple tables

Combining data from multiple worksheets for a PivotTable

All about the GETPIVOTDATA function

How to use 3D maps from a PivotTable

Updating your data in a PivotTable and PivotChart

About Dashboard architecture and inspiration

How to prepare data for analysis (cleaning data)

Useful formulas for creating dashboards in Excel

How to create and edit Pivot Tables in Excel

How to create Pivot Charts from Pivot Tables

Advanced chart techniques in Excel

How to add interactive elements (form controls) into your dashboards

How to create a Sales Dashboard from scratch

How to create an HR Dashboard from scratch

Yêu cầu

  • Microsoft Excel 2021/365 desktop version for Windows for the Excel 2021 courses
  • You'll need a copy of Microsoft Excel that is compatible with the Power Pivot tool for the Power Pivot, Power Query & DAX course
  • The PivotTable courses were created using Excel 2019/365 for Windows. All of the code used in this course except for one property is compatible for Excel 2007, Excel 2010, Excel 2013, Excel 2016 and Excel 2019.

Nội dung khoá học

103 sections

Microsoft Excel 2021 for Beginners: Introduction

8 lectures
Course Introduction
02:19
WATCH ME: Essential Information for a Successful Training Experience
02:11
Downloadable Course Transcript
00:19
DOWNLOAD ME: Course Files
00:24
DOWNLOAD ME: Exercise Files
00:24
Free Keyboard Shortcut Guides
00:18
Excel 2021 vs Excel for Microsoft 365
05:39
Section Quiz
2 questions

Microsoft Excel 2021 for Beginners: Getting Started in Excel 2021

10 lectures
Launching Excel
03:38
The Start Screen
10:12
Exploring the Interface
11:39
Understanding Ribbons, Tabs and Menus
08:29
The Backstage Area
04:40
Customizing the Quick Access Toolbar
09:43
Useful Keyboard Shortcuts
09:41
Getting Help
06:36
Exercise 01
02:19
Section Quiz
2 questions

Microsoft Excel 2021 for Beginners: Creating You First Excel Spreadsheet

7 lectures
Working with Excel Templates
09:02
Working with Workbooks and Worksheets
07:34
Saving Workbooks and Worksheets
08:44
Entering and Editing Data
09:53
Navigating and Selecting Cells, Rows and Columns
07:21
Exercise 02
05:19
Section Quiz
2 questions

Microsoft Excel 2021 for Beginners: Introduction to Excel Formulas and Functions

11 lectures
Formulas and Functions Explained
11:42
Performing Calculations with the SUM Function
07:38
Counting Values and Blanks
07:26
Finding the Average with the AVERAGE Function
04:18
Working with the MIN and MAX Functions
02:24
Handling Errors in Formulas
08:41
Absolute vs Relative Referencing
06:56
Autosum and AutoFill
09:41
Flash Fill
05:02
Exercise 03
05:12
Section Quiz
2 questions

Microsoft Excel 2021 for Beginners: Using Named Ranges

6 lectures
What are Named Ranges?
04:40
Creating Named Ranges
04:25
Managing Named Ranges
03:49
Using Named Ranges in Calculations
05:19
Exercise 04
04:17
Section Quiz
2 questions

Microsoft Excel 2021 for Beginners: Formatting Numbers and Cells

6 lectures
Applying Number Formats
10:02
Applying Date and Time Formats
05:39
Formatting Cells, Rows and Columns
08:38
Using Format Painter
04:39
Exercise 05
04:06
Section Quiz
2 questions

Microsoft Excel 2021 for Beginners: Formatting Worksheets

6 lectures
Working with Rows and Columns
08:25
Deleting and Clearing Cells
06:25
Aligning Text and Numbers
11:13
Applying Themes and Styles
07:41
Exercise 06
05:22
Section Quiz
2 questions

Microsoft Excel 2021 for Beginners: Working with Excel Lists

9 lectures
How to Structure a List
04:37
Sorting a List (Single-Level Sort)
05:06
Sorting a List (Multi-Level Sort)
05:06
Sorting Using a Custom List (Custom Sort)
08:12
Using Autofilter to Filter a List
06:45
Format as a Table
10:18
Creating Subtotals in a List
07:34
Exercise 07
04:37
Section Quiz
2 questions

Microsoft Excel 2021 for Beginners: Moving and Linking to Data

8 lectures
Using Cut and Copy
04:56
Paste Options
07:45
Pasting from the Clipboard
04:31
Linking to Other Worksheets and Workbooks
06:26
3D Referencing
05:54
Inserting Hyperlinks to Worksheets
09:39
Exercise 08
04:41
Section Quiz
2 questions

Microsoft Excel 2021 for Beginners: An Introduction to Intermediate Formulas

9 lectures
Looking up Information with VLOOKUP
10:02
VLOOKUP Approximate Match
05:08
Error Handling Functions
07:10
Basic Logical Functions (IF, AND, OR)
12:24
Making Decisions with IF Statements
04:33
Cleaning Data Using Text Functions
12:09
Working with Time and Date Functions
11:17
Exercise 09
10:19
Section Quiz
2 questions

Microsoft Excel 2021 for Beginners: Analyzing Data with Charts

5 lectures
Choosing the Correct Chart Type
06:34
Presenting Data with Charts
10:01
Formatting Charts
12:51
Exercise 10
03:54
Section Quiz
2 questions

Microsoft Excel 2021 for Beginners: Conditional Formatting

6 lectures
Highlighting Cell Values
07:13
Data Bars
05:32
Color Scales
04:55
Icon Sets
07:49
Exercise 11
05:43
Section Quiz
2 questions

Microsoft Excel 2021 for Beginners: Inserting Items into a Spreadsheet

8 lectures
Inserting Pictures
10:53
Inserting Shapes and Text Boxes
09:04
Inserting Icons and 3D Models
06:00
Creating Diagrams Using SmartArt
10:41
Inserting Screenshots
04:27
Inserting Comments
05:13
Exercise 12
09:16
Section Quiz
2 questions

Microsoft Excel 2021 for Beginners: Working with Views and Zoom

6 lectures
Workbook Views
06:21
Using Zoom in a Worksheet
02:56
Arranging Workbooks and Worksheets
05:01
Freezing Panes
04:00
Exercise 13
03:26
Section Quiz
2 questions

Microsoft Excel 2021 for Beginners: Page Layout and Print Options

8 lectures
Setting Margins and Orientation
05:05
Setting and Clearing the Print Area
02:53
Inserting Page Breaks
04:32
Setting Print Titles and a Background
04:29
Inserting Headers and Footers
05:42
Printing a Workbook
06:00
Exercise 14
03:06
Section Quiz
2 questions

Microsoft Excel 2021 for Beginners: Finalizing the Spreadsheet

7 lectures
Protecting Workbooks and Worksheets
09:02
Spell Checking
03:45
Inspecting the Workbook
07:21
Saving the Workbook in Different Formats
04:21
Sharing a Workbook
05:35
Exercise 15
03:28
Section Quiz
2 questions

Microsoft Excel 2021 for Beginners: Course Close

1 lectures
Course Close
01:06

Microsoft Excel 2021 Intermediate: Introduction

6 lectures
Course Introduction
06:16
WATCH ME: Essential Information for a Successful Training Experience
02:11
Downloadable Course Transcript
00:19
DOWNLOAD ME: Course Exercise Files
00:24
DOWNLOAD ME: Course Instructor Files
00:24
Section Quiz
2 questions

Microsoft Excel 2021 Intermediate: Designing Better Spreadsheets

5 lectures
The Golden Rules of Spreadsheet Design
11:54
Improving Readability with Cell Styles
04:58
Controlling Data Input
08:19
Adding Navigation Buttons
08:42
Section Quiz
2 questions

Microsoft Excel 2021 Intermediate: Making Decisions with Logical Functions

9 lectures
Logical Functions (AND, OR, IF)
13:18
The IF Function
05:26
Nested IFs
08:01
The IFS Function
06:04
Conditional IFs (SUMIF, COUNTIF, AVERAGEIF)
06:45
Multiple Criteria (SUMIFS, COUNTIFS, AVERAGEIFS)
07:12
Error Handling with IFERROR and IFNA
06:01
Exercise 01
07:29
Section Quiz
2 questions

Microsoft Excel 2021 Intermediate: Looking Up Information

9 lectures
Looking Up Information using VLOOKUP (Exact Match)
10:41
Looking Up Information using VLOOKUP (Approx Match)
04:25
Looking Up Information Horizontally using HLOOKUP
05:38
Performing Flexible Lookups with INDEX and MATCH
10:28
Using XLOOKUP and XMATCH
10:09
The OFFSET Function
10:50
The INDIRECT Function
09:07
Exercise 02
05:03
Section Quiz
2 questions

Microsoft Excel 2021 Intermediate: Advanced Sorting and Filtering

8 lectures
Performing Sorts on Multiple Columns
07:03
Sorting Using a Custom List
03:35
The SORT and SORTBY Functions
10:00
Using the Advanced Filter
06:52
Extracting Unique Values - The UNIQUE Function
05:16
The FILTER Function
09:30
Exercise 03
05:41
Section Quiz
2 questions

Microsoft Excel 2021 Intermediate: Working with Date and Time

9 lectures
Understanding How Dates are Stored in Excel
04:11
Applying Custom Date Formats
07:09
Using Date and Time Functions
08:44
Using the WORKDAY and WORKDAY.INT Functions
03:49
Using the NETWORKDAYS and NETWORKDAYS.INT Function
02:57
Tabulate Date Differences with the DATEDIF Function
06:14
Calculate Dates with EDATE and EOMONTH
07:22
Exercise 04
04:51
Section Quiz
2 questions

Microsoft Excel 2021 Intermediate: Preparing Data for Analysis

10 lectures
Importing Data into Excel
09:56
Removing Blank Rows, Cells and Duplicates
05:20
Changing Case and Removing Spaces
09:03
Splitting Data using Text to Columns
07:03
Splitting Data using Text Functions
08:05
Splitting or Combining Cell Data Using Flashfill
05:00
Joining Data using CONCAT
07:30
Formatting Data as a Table
08:33
Exercise 05
05:41
Section Quiz
2 questions

Microsoft Excel 2021 Intermediate: PivotTables

12 lectures
PivotTables Explained
02:12
Creating a PivotTable from Scratch
04:49
Pivoting the PivotTable Fields
05:31
Applying Subtotals and Grand Totals
03:14
Applying Number Formatting to PivotTable Data
03:00
Show Values As and Summarize Values By
05:50
Grouping PivotTable Data
05:39
Formatting Error Values and Empty Cells
05:02
Choosing a Report Layout
04:35
Applying PivotTable Styles
04:49
Exercise 06
04:05
Section Quiz
2 questions

Microsoft Excel 2021 Intermediate: Pivot Charts

6 lectures
Creating a Pivot Chart
05:04
Formatting a Pivot Chart - Part 1
08:36
Formatting a Pivot Chart - Part 2
09:14
Using Map Charts
05:30
Exercise 07
04:18
Section Quiz
2 questions

Microsoft Excel 2021 Intermediate: Adding Interaction to PivotTables and Charts

6 lectures
Inserting and Formatting Slicers
07:30
Inserting Timeline Slicers
05:07
Connecting Slicers to Pivot Charts
05:01
Updating PivotTable Data
04:25
Exercise 08
06:48
Section Quiz
2 questions

Microsoft Excel 2021 Intermediate: Interactive Dashboards

6 lectures
What is a Dashboard?
05:27
Assembling a Dashboard - Part 1
11:25
Assembling a Dashboard - Part 2
10:47
Assembling a Dashboard - Part 3
08:49
Exercise 09
02:27
Section Quiz
2 questions

Microsoft Excel 2021 Intermediate: Formula Auditing

4 lectures
Troubleshooting Common Errors
08:11
Tracing Precedents and Formula Auditing
07:44
Exercise 10
07:30
Section Quiz
2 questions

Microsoft Excel 2021 Intermediate: Data Validation

5 lectures
Creating Dynamic Drop-down Lists
07:27
Other Types of Data Validation
07:05
Custom Data Validation
10:10
Exercise 11
06:53
Section Quiz
2 questions

Microsoft Excel 2021 Intermediate: WhatIf Analysis Tools

6 lectures
Goal Seek and the PMT Function
05:33
Using Scenario Manager
07:27
Data Tables: One Variable
04:29
Data Tables: Two Variables
04:12
Exercise 12
08:32
Section Quiz
2 questions

Microsoft Excel 2021 Intermediate: Course Close

1 lectures
Course Close
01:34

Microsoft Excel 2021 Advanced: Introduction

7 lectures
Course Introduction
02:46
WATCH ME: Essential Information for a Successful Training Experience
02:11
Downloadable Course Transcript
00:19
DOWNLOAD ME: Course Exercise Files
00:24
DOWNLOAD ME: Course Instructor Files
00:24
Exercise 01
01:47
Section Quiz
2 questions

Microsoft Excel 2021 Advanced: Dynamic Arrays

21 lectures
What are Dynamic Arrays?
02:14
Introduction to Spills and Arrays
10:49
Extract and Count Unique Entries
06:14
Unique vs Distinct
03:24
Extract Unique Values with Multiple Criteria
03:11
Extract Unique Values by Column
04:23
The SORT Function
08:53
The SORT Function - Horizontal SORT
06:06
The SORTBY Function
06:10
The SORTBY Function - Horizontal SORT
03:05
Simple SEQUENCE and Unstacking Records
10:10
The FILTER Function
06:51
FILTER with Logic: + Operator (OR)
04:48
FILTER with Logic: * Operator (AND)
05:39
FILTER with Logic: = Operator (Both or Neither)
04:11
FILTER with Logic: - Operator (One or the Other)
04:49
Using RANDARRAY and RANDBETWEEN to Randomize Data
09:44
Using XLOOKUP to Perform Complex Lookups
12:22
Using XMATCH
06:20
Exercise 02
13:09
Section Quiz
2 questions

Microsoft Excel 2021 Advanced: Advanced Lookup and Reference Functions

5 lectures
Performing 2-Way Lookups
08:25
Using the CHOOSE Function
10:02
Using the SWITCH Function
04:31
Exercise 03
07:05
Section Quiz
2 questions

Microsoft Excel 2021 Advanced: Statistical Functions

6 lectures
Using MEDIAN, MODE.SNGL and MODE.MULT
06:16
Using LARGE and SMALL
07:27
Ranking Data with Sorting using RANK.EQ and RANK.AVG
07:41
The COUNTBLANK Function
04:45
Exercise 04
07:05
Section Quiz
2 questions

Microsoft Excel 2021 Advanced: Math Functions

5 lectures
Rounding Values using ROUND, ROUNDUP and ROUNDDOWN
06:59
Specialized Rounding (MROUND, CEILING.MATH and FLOOR.MATH)
04:30
Using the AGGREGATE Function
04:32
Exercise 05
05:52
Section Quiz
2 questions

Microsoft Excel 2021 Advanced: New Functions - LET and LAMBDA

4 lectures
The LET Function
15:07
The LAMBDA Function
14:13
Exercise 06
11:49
Section Quiz
2 questions

Microsoft Excel 2021 Advanced: Advanced PivotTables and Pivot Charts

16 lectures
Creating a Custom PivotTable Style
09:47
Applying Custom Number Formatting
10:01
Sorting Using Custom Lists
04:38
Applying Multiple Filters to Data
05:06
Adjusting Slicer Settings
12:02
Locking Workbooks but not Slicers
03:18
Creating a Calculated Field
08:01
Creating a Calculated Item
06:30
Solve Order
08:11
GETPIVOTDATA
11:57
Using GETPIVOTDATA - Dependent Data Validation Lists
08:37
Creating a Dynamic Pivot Chart Title
10:41
Adding a Dynamic Series to a Pivot Chart
12:47
Adding Totals to a Stacked Column Chart
05:52
Exercise 07
10:10
Section Quiz
2 questions

Microsoft Excel 2021 Advanced: Form Controls

9 lectures
Introduction to Form Controls
04:14
Combo Box - Select from a List
07:21
Check Box - Check/Uncheck Option
06:48
Option Button - Choose an Option
06:30
Spin Button - Move Up and Down a List
05:54
List Box - Select from a List of Items
04:59
Scroll Bar - Scroll Through a List
05:01
Exercise 08
05:57
Section Quiz
2 questions

Microsoft Excel 2021 Advanced: Working with Power Query

8 lectures
Power Query Overview
01:35
Importing Data Using Get and Transform
07:09
The Power Query Editor
04:45
Combining Files
04:52
Transforming Files
09:30
Loading Files into Excel
04:02
Exercise 09
05:54
Section Quiz
2 questions

Microsoft Excel 2021 Advanced: Forecasting

7 lectures
Getting Forecast Data with FRED
05:34
Creating a Linear Sales Forecast
08:21
Creating a Sales Forecast with Seasonality
05:02
Adding Confidence Levels
06:58
Using Forecast Sheets
07:16
Exercise 10
02:21
Section Quiz
2 questions

Microsoft Excel 2021 Advanced: Macros and VBA

9 lectures
Using Macros to Automate Tasks
06:40
Recording, Saving and Running Macros
10:00
Recording a Macro with Relative Referencing
06:58
Multi-step Macros
07:09
The VBA Editor
07:55
Assigning Macros to Buttons
06:43
Creating a Custom Macro Ribbon
06:34
Exercise 11
05:29
Section Quiz
2 questions

Microsoft Excel 2021 Advanced: Practical Excel - Advanced Formulas

5 lectures
Finding the Last Occurrence of a Value
07:48
Finding the Closest Value
06:15
Extract Data from the Middle of a String
08:53
Exercise 12
05:45
Section Quiz
2 questions

Microsoft Excel 2021 Advanced: Course Close

1 lectures
Course Close
03:23

Excel for Business Analysts: Introduction

3 lectures
Introduction to Business Analysis
05:25
DOWNLOAD ME: Course Exercise Files
00:24
DOWNLOAD ME: Course Instructor Files
00:24

Excel for Business Analysts: The Basics

4 lectures
A Recap of Basic Formulas
12:42
Absolute vs Relative Referencing
08:15
Exercise 01
02:03
Section Quiz
2 questions

Excel for Business Analysts: Merging and Looking Up Data

10 lectures
Merging Data from Different Sources
02:48
Looking Up Information with VLOOKUP (Exact)
10:57
Looking Up information with VLOOKUP (Approx)
06:27
How to Use VLOOKUP with Data that Expands
10:00
Using HLOOKUP
12:16
Combining VLOOKUP and MATCH
12:25
Using INDEX, MATCH and XLOOKUP
17:25
Data Validation Lists with Lookups
08:30
Exercise 02
06:24
Section Quiz
2 questions

Excel for Business Analysts: Making Better Decisions with IF

9 lectures
How to Use the IF function
05:30
More Examples of the IF Function
07:08
Working with Nested Ifs
06:35
The IFS function
08:47
Error handling with IFERROR and IFNA
09:21
Using MAX and MIN instead of the IF function
11:25
Using SUMIFS and COUNTIFS
11:51
Exercise 03
01:32
Section Quiz
2 questions

Excel for Business Analysts: Preparing Data for Analysis

7 lectures
Splitting Data Using Text Functions
16:13
Using the Flash Fill Command
04:39
Concatenating Data
09:03
Standardizing Data
09:00
Formatting Data as a Table
09:45
Exercise 04
02:28
Section Quiz
3 questions

Excel for Business Analysts: PivotTables

7 lectures
An Introduction to PivotTables
03:15
Creating a PivotTable
12:40
Summarizing Data
13:52
Calculations in PivotTables
15:13
Using Slicers to filter information
09:55
Exercise 05
01:53
Section Quiz
3 questions

Excel for Business Analysts: Visualizing Data with Charts

6 lectures
Creating a Pivot Chart
10:38
Formatting a Pivot Chart
14:25
Using Sparklines
07:52
A Basic Interactive Dashboard
14:45
Exercise 06
02:51
Section Quiz
2 questions

Excel for Business Analysts: Forecasting

4 lectures
Forecast Sheets
07:18
The Forecast Function
07:24
Exercise 07
01:35
Section Quiz
3 questions

Excel for Business Analysts: Additional Useful Tools in Excel

7 lectures
Conditional Formatting
11:28
The INDIRECT Function
13:29
The OFFSET Function
10:32
Using Histograms
04:55
Regression
06:41
Exercise 08
02:12
Section Quiz
2 questions

Excel for Business Analysts: WhatIf Analysis

6 lectures
Goal Seek
07:43
Scenario Manager
08:01
Data Tables
07:13
Solver
06:50
Exercise 09
01:42
Section Quiz
2 questions

Excel for Business Analysts: Course Close

1 lectures
Course Close
00:44

PowerPivot, PowerQuery, DAX: Introduction

6 lectures
Welcome and Overview
03:02
DOWNLOAD ME: Course Exercise Files
00:23
DOWNLOAD ME: Course Instructor Files
00:24
What is Power Query?
05:24
What is Power Pivot?
03:43
Section Quiz
2 questions

PowerPivot, PowerQuery, DAX: Getting Started with Power Query

10 lectures
Exploring the Power Query Editor
06:29
Common Power Query Transformations
08:59
Editing an Existing Query
09:55
Import Multiple Files from a Folder
11:06
Connect to Data in Another Excel Workbook
09:37
Troubleshooting Data Errors When Using the Sample Files
02:11
IMPORTANT: Checking the Location of your Query's Source
03:34
Get Data From the Web
05:39
Practise Exercise
01:05
Section Quiz
2 questions

PowerPivot, PowerQuery, DAX: Useful Power Query Features

9 lectures
Unpivoting Columns
05:32
Combine Data from Multiple Tables with Merge Queries
06:11
Use Merge Queries to Compare Two Tables
05:03
Stack Data into One Table with Append Queries
06:02
Duplicating and Referencing Queries
09:10
Grouping and Aggregating Data
07:53
Conditional Columns in Power Query
07:14
Practise Exercise
01:14
Section Quiz
2 questions

PowerPivot, PowerQuery, DAX: Creating the Data Model

9 lectures
Enable the Power Pivot Add-In
01:54
Understanding the Power Pivot Window
04:42
Creating Relationships Between tables
05:03
Managing the Relationships of the Model
03:01
Creating a PivotTable from the Data Model
04:42
Hide Fields from Client Tools
03:19
Grouping Queries
04:33
Practise Exercise
00:49
Section Quiz
2 questions

PowerPivot, PowerQuery, DAX: Introduction to DAX

7 lectures
Why use DAX?
03:14
Creating Calculated Columns with DAX
05:09
Creating your First DAX Measure
06:17
The COUNTROWS Function
05:09
SUMX and RELATED Functions
04:45
Practise Exercise
00:49
Section Quiz
2 questions

PowerPivot, PowerQuery, DAX: More DAX Measures

7 lectures
Create a Date Table in Power Pivot
08:46
The CALCULATE Function
03:31
The DIVIDE Function
03:09
Using the DATESYTD Function
02:20
Calculate the Percentage of a Total
06:17
Practise Exercise
01:05
Section Quiz
2 questions

PowerPivot, PowerQuery, DAX: Using PivotTables and Slicers

5 lectures
Create PivotTables and PivotCharts
11:57
Using Slicers with your PivotTables
06:21
Create a Top 10 PivotTable
08:25
Practise Exercise
00:47
Section Quiz
2 questions

PowerPivot, PowerQuery, DAX: Closing

1 lectures
Wrap Up
01:26

Pivot Tables for Beginners: Introduction

6 lectures
Course Introduction
05:10
WATCH ME: Essential Information for a Successful Training Experience
02:03
DOWNLOAD ME: Course Exercise Files
00:23
DOWNLOAD ME: Course Instructor Files
00:23
What are Pivot Tables and Why are They Useful?
06:12
Section Quiz
2 questions

Pivot Tables for Beginners: Preparing Data for Analysis

13 lectures
The Importance of Cleaning Data
03:05
Removing Blank Rows
05:30
Removing Duplicate Rows
02:37
Clearing Formatting
04:26
Applying Number Formatting
08:38
Changing the Case
09:16
Removing Spaces and Non-printing Characters
10:06
Merging and Splitting Columns
13:00
Convert Numbers Stored as Text
02:28
Finding and Replacing Text
06:07
Spell Check
03:57
Exercise 01
04:01
Section Quiz
2 questions

Pivot Tables for Beginners: The Importance of Excel Tables

4 lectures
Excel Tables vs Pivot Tables
05:24
Format Data as a Table
08:47
Exercise 02
01:50
Section Quiz
2 questions

Pivot Tables for Beginners: Creating a Basic Pivot Table Report

8 lectures
Using Recommended Pivot Tables
05:29
Creating a Pivot Table from Scratch
05:45
Pivot Table Ribbons and Fields
06:39
Pivoting the Fields
05:32
Adding Multiple Dimensions
02:47
Deleting Fields and Locking the Report Layout
03:41
Exercise 03
01:37
Section Quiz
2 questions

Pivot Tables for Beginners: Aggregation and Grouping

5 lectures
Methods of Aggregation
04:09
Combining Methods of Aggregation
05:37
Grouping and Ungrouping Data
09:45
Exercise 04
03:22
Section Quiz
2 questions

Pivot Tables for Beginners: Formatting Values

4 lectures
Applying Number Formatting
04:45
Handling Cells with No Data
04:00
Exercise 05
02:18
Section Quiz
2 questions

Pivot Tables for Beginners: Layout Options

5 lectures
Subtotals and Grand Totals
04:27
Choosing a Report Layout
04:44
Inserting Blank Rows
02:14
Exercise 06
01:58
Section Quiz
2 questions

Pivot Tables for Beginners: Formatting Pivot Tables

5 lectures
Applying Pivot Table Styles
04:15
Modifying Pivot Table Styles
04:19
Creating a Custom Pivot Table Style
05:37
Exercise 07
03:30
Section Quiz
2 questions

Pivot Tables for Beginners: Sorting and Filtering

5 lectures
Sorting Pivot Table Data
08:31
Filtering Pivot Table Data
07:20
Top 10 Filter
03:31
Exercise 08
01:57
Section Quiz
2 questions

Pivot Tables for Beginners: Creating Pivot Charts

8 lectures
Selecting the Right Chart Type
08:40
Clustered Column and Bar Charts
13:40
Line Charts
09:55
Pie and Donut Charts
11:31
Map Charts
08:47
Applying Chart Layouts
03:06
Exercise 09
04:07
Section Quiz
2 questions

Pivot Tables for Beginners: Formatting Pivot Charts

6 lectures
Adding a Slicer
07:38
Formatting a Slicer
06:23
Adding a Timeline
05:22
Connecting Slicers and Timelines
05:30
Exercise 10
03:00
Section Quiz
2 questions

Pivot Tables for Beginners: Applying Conditional Formatting

6 lectures
Highlight Cell Rules
05:37
Data Bars
04:08
Color Scales
03:20
Icon Sets
04:26
Exercise 11
01:30
Section Quiz
2 questions

Pivot Tables for Beginners: Updating Pivot Tables and Pivot Charts

4 lectures
Adding Data to the Dataset
02:37
Updating Pivot Tables and Pivot Charts
01:41
Exercise 12
01:39
Section Quiz
2 questions

Pivot Tables for Beginners: Course Close and Next Steps

1 lectures
Course Close and Next Steps
01:53

Advanced PivotTables in Excel: Introduction

6 lectures
Introduction to Advanced PivotTables
03:49
WATCH ME: Essential Information for a Successful Training Experience
02:03
DOWNLOAD ME: Course Exercise Files
00:24
DOWNLOAD ME: Course Instructor Files
00:23
PivotTables Recap
12:42
Section Quiz
1 question

Advanced PivotTables in Excel: Importing Data

4 lectures
Importing Data From a Text File
09:57
Importing Data From Access
08:20
Exercise 01
04:46
Section Quiz
2 questions

Advanced PivotTables in Excel: Preparing Data for Analysis

4 lectures
Cleaning Data
17:40
Tabular Data
16:05
Exercise 02
03:18
Section Quiz
3 questions

Advanced PivotTables in Excel: Creating and Manipulating PivotTables

7 lectures
Creating and Manipulating a PivotTable
12:27
Combining Data from Multiple Worksheets
12:02
Grouping and Ungrouping
11:01
Report Layouts
10:53
Formatting Error Values and Empty Cells
08:26
Exercise 03
01:35
Section Quiz
2 questions

Advanced PivotTables in Excel: Formatting PivotTables

4 lectures
PivotTable Styles
11:39
Custom Number Formatting
16:25
Exercise 04
01:44
Section Quiz
2 questions

Advanced PivotTables in Excel: Value Field Settings

4 lectures
Summarizing Values
11:25
Show Values As
09:12
Exercise 05
01:46
Section Quiz
2 questions

Advanced PivotTables in Excel: Sorting and Filtering

4 lectures
Advanced Sorting
08:40
Advanced Filtering
14:04
Exercise 06
02:16
Section Quiz
2 questions

Advanced PivotTables in Excel: Interacting with PivotTables

6 lectures
Inserting and Formatting Slicers
13:51
Inserting and Formatting Timelines
07:06
Connecting Slicers to Multiple PivotTables
08:10
Using Slicers in Protected Workbooks
05:36
Exercise 07
02:20
Section Quiz
2 questions

Advanced PivotTables in Excel: Calculations

6 lectures
Creating a Calculated Field
08:25
Creating a Calculated Item
08:09
Solve Order and List Formulas
10:38
GETPIVOTDATA
09:25
Exercise 08
06:41
Section Quiz
3 questions

Advanced PivotTables in Excel: Pivot Charts

8 lectures
Creating a Pivot Chart
11:30
Formatting a Pivot Chart - Part 1
15:43
Formatting a Pivot Chart - Part 2
15:28
Creating a Map Chart using Pivot Data
12:01
Dynamic Chart Titles
13:50
Include a Sparkline with your PivotTable
10:40
Exercise 09
07:45
Section Quiz
3 questions

Advanced PivotTables in Excel: Conditional Formatting

5 lectures
Highlighting Cell Rules
09:32
Graphical Conditional Formats
10:06
Conditional Formatting and Slicers
06:28
Exercise 10
02:26
Section Quiz
2 questions

Advanced PivotTables in Excel: Dashboards

5 lectures
Creating an Interactive Dashboard - Part 1
23:12
Creating an Interactive Dashboard - Part 2
13:55
Updating Pivot Charts and PivotTables
04:24
Exercise 11
03:26
Section Quiz
2 questions

Advanced PivotTables in Excel: Course Close

1 lectures
Course Close
00:37

Interactive Dashboard in Excel: Introduction

6 lectures
Introduction to Excel Dashboards
02:22
WATCH ME: Essential Information for a Successful Training Experience
02:11
Course Exercise Files
01:29
DOWNLOAD ME: Course Exercise Files
00:23
DOWNLOAD ME: Course Demo Files
00:23
Section Quiz
2 questions

Interactive Dashboard in Excel: Dashboard Setup

2 lectures
Spreadsheet Architecture
03:28
Section Quiz
2 questions

Interactive Dashboard in Excel: Design Inspiration

2 lectures
Dashboard Design Inspiration and Resources
05:34
Section Quiz
2 questions

Interactive Dashboard in Excel: Preparing Data for Analysis

9 lectures
Why Clean Data?
05:42
Remove Blanks and Duplicates
05:51
Use Text Functions to Clean Data
07:50
Find and Replace
05:06
Convert Numbers Stored as Text to Numbers
04:54
Spell Check
04:42
Format Data
09:58
Exercise 01
05:32
Section Quiz
2 questions

Interactive Dashboard in Excel: Useful Excel Formulas

11 lectures
Basic INDEX and MATCH
12:32
XLOOKUP (Microsoft 365 Users)
09:55
Dependent, Dynamic Drop-down Lists
14:46
SUMIFS and COUNTIFS
14:06
LARGE and SMALL
04:49
CHOOSE function
12:01
Use CHOOSE with Form Controls and Charts
05:53
The INDIRECT function
11:51
Extracting Unique Values: UNIQUE and the Advanced Filter
07:28
Exercise 02
07:34
Section Quiz
2 questions

Interactive Dashboard in Excel: PivotTables and Pivot Charts

12 lectures
Create a PivotTable
07:42
Manipulating PivotTable Data
08:32
Number Formatting
04:33
Value Field Settings
05:52
Show Values As
08:33
Create a Pivot Chart
09:45
Formatting Pivot Charts - Part 1
12:41
Formatting Pivot Charts - Part 2
11:14
Slicers and Timelines
11:41
GETPIVOTDATA()
13:30
Exercise 03
07:08
Section Quiz
2 questions

Interactive Dashboard in Excel: Advanced Chart Techniques

5 lectures
Add Total Values to Stacked Column Charts
09:18
Dynamic Chart Titles and Slicer Macros
14:07
Dynamic Map Charts
20:16
Exercise 04
10:13
Section Quiz
2 questions

Interactive Dashboard in Excel: Interactive Elements - Form Controls

9 lectures
Introduction to Form Controls
03:23
Combo Box
09:11
Check Box
11:02
Option Button
08:26
Spin Button
03:54
List Box
04:53
Scroll Bar
08:25
Exercise 05
07:34
Section Quiz
2 questions

Interactive Dashboard in Excel: Sales Analysis Dashboard

16 lectures
Dashboard Overview
04:53
Data Setup
03:24
Wireframe Design
03:41
Form Controls: Combo Box Setup
04:51
Headline Stats - SUMIFS, MAX, LARGE and INDEX and MATCH
12:50
Sales Tables Calculations - IF, SUMIFS and COUNTIFS
12:20
Map Chart - Dynamic Filled Map
08:18
Discount Charts - Setup
09:01
Stacked Column Chart - Dynamic with Totals
09:53
Donut Chart - Dynamic with Icon
04:44
Sparklines
07:44
Conditional Formatting
10:55
Dynamic Titles
03:16
Assemble Dashboard - Part 1
11:12
Assemble Dashboard - Part 2
06:31
Section Quiz
2 questions

Interactive Dashboard in Excel: HR Dashboard

17 lectures
Dashboard Overview
04:22
Data Setup
03:38
Headline Stats with Custom Number Formatting
05:30
Gender Breakdown Infographic
13:54
Age Distribution - Funnel Chart with Custom Slicer
07:20
Diversity Tracker
03:55
Active Employees - Grouping PivotTable Data
05:23
Full Time vs Part Time - PivotTable and Pivot Chart
02:32
Form Controls - Option Button Setup
04:37
Employees by Job Level - Dynamic Column Chart with Title
06:27
Doughnut Chart - Dynamic with Icon
05:03
Top 3 Employees - XLOOKUP and LARGE
04:20
New Hires - Line Chart with Timeline Slicer
06:29
Assemble Dashboard
13:46
Updating the Dashboard
02:13
Exercise 06
01:41
Section Quiz
2 questions

Interactive Dashboard in Excel: Course Close

1 lectures
Course Close
00:46

Additional Training

4 lectures
READ ME: This Additional Training Is Optional
00:11
Ten Excel Tips and Tricks - Part 1
43:23
Ten Excel Tips and Tricks - Part 2
40:36
Ten Excel Tips and Tricks - Part 3
37:09

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

Khoá học liên quan

Microsoft Excel - Excel from Beginner to Advanced

Microsoft Excel - Excel from Beginner to Advanced

100 VND
50.000 VND
VBA Excel toàn tập từ cơ bản đến nâng cao

VBA Excel toàn tập từ cơ bản đến nâng cao

599.000 VND
99.000 VND
Tạo ứng dụng quản lý kho cơ bản với Appsheet

Tạo ứng dụng quản lý kho cơ bản với Appsheet

1.900.000 VND
50.000 VND
Trở thành chuyên gia kế toán tổng hợp trên Excel

Trở thành chuyên gia kế toán tổng hợp trên Excel

299.000 VND
99.000 VND
Microsoft Project for Project Manager & Civil Engineers -MSP

Microsoft Project for Project Manager & Civil Engineers -MSP

55 VND
50.000 VND
Quantity Surveying Building Estimation,Cad Excel & Planswift

Quantity Surveying Building Estimation,Cad Excel & Planswift

1.399.000 VND
50.000 VND
Microsoft Power BI for Construction Management

Microsoft Power BI for Construction Management

55 VND
50.000 VND
SAP ABAP Programming For Beginners - Online Training

SAP ABAP Programming For Beginners - Online Training

90 VND
50.000 VND
SharePoint 2013 Complete Training

SharePoint 2013 Complete Training

1.049.000 VND
50.000 VND
The Complete Google Drive Course - Mastering Google Drive

The Complete Google Drive Course - Mastering Google Drive

1.399.000 VND
50.000 VND
SAP ABAP : Enhancement & Modification to SAP Standard

SAP ABAP : Enhancement & Modification to SAP Standard

25 VND
50.000 VND
EXG02 - Thủ thuật Excel cập nhật hàng tuần cho dân văn phòng

EXG02 - Thủ thuật Excel cập nhật hàng tuần cho dân văn phòng

199.000 VND
50.000 VND
SharePoint - Complete Guide to Microsoft SharePoint Online

SharePoint - Complete Guide to Microsoft SharePoint Online

95 VND
50.000 VND
Administration and Automation with Windows PowerShell

Administration and Automation with Windows PowerShell

1.499.000 VND
50.000 VND
Microsoft Project ALL: BEGINNER to EXPERT 10 Projects 9 PDU

Microsoft Project ALL: BEGINNER to EXPERT 10 Projects 9 PDU

99 VND
50.000 VND
SharePoint Content Management and Content Organizer

SharePoint Content Management and Content Organizer

399.000 VND
50.000 VND
image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.

Get khoá học cho tôi