×
Create CV Books Summaries Online Courses Blog Communities

Login

Sign up
MindLuster Logo
Categories
Recent

Advanced Pivot table tricks for Reporting and Analysis

Share your inquiries now with community members Click Here
Next Lesson
Sign Up and Get Free Certificate
Sign up Now
Lesson extensions

Lessons List | 50 Lesson
Advanced Pivot table tricks for Reporting and Analysis
00:21:34

Advanced Pivot table tricks for Reporting and Analysis
Pivot Table Automation with Calculated Field and Calculated Item When and How to Use Each
00:15:17

Pivot Table Automation with Calculated Field and Calculated Item When and How to Use Each
Sort Pivot Table Values Largest to Smallest text dates and More All about Sorting
00:10:39

Sort Pivot Table Values Largest to Smallest text dates and More All about Sorting
Using Pivot Tables to transform Large data into Beautiful Summaries Beginner Pivot table Tutorial
00:11:10

Using Pivot Tables to transform Large data into Beautiful Summaries Beginner Pivot table Tutorial
XLookup for Accountants Wow
00:19:13

XLookup for Accountants Wow
Create Waterfall Chart Auto update Bar Colour and Data labels Advanced Tutorial
00:21:35

Create Waterfall Chart Auto update Bar Colour and Data labels Advanced Tutorial
How to Create a Dynamic Chart with Excel Drop Down list Excel dynamic Chart
00:10:46

How to Create a Dynamic Chart with Excel Drop Down list Excel dynamic Chart
Dynamic Dependent drop down list in Excel Part 2 Data Linked Drop down list
00:04:08

Dynamic Dependent drop down list in Excel Part 2 Data Linked Drop down list

Excel How to create a drop down list Part 1
00:05:27

Excel How to create a drop down list Part 1
Excel Daily Sales Report Automating monthly Days billed and Billings days
00:16:00

Excel Daily Sales Report Automating monthly Days billed and Billings days
How to Convert Numbers stored as text to Numbers blink of an eye
00:03:03

How to Convert Numbers stored as text to Numbers blink of an eye
Vlookup Automation Do not worry about column number
00:10:22

Vlookup Automation Do not worry about column number
How to Lookup Names with Spelling Errors All types of Spelling mistakes Excel Vlookup and Xlookup
00:11:23

How to Lookup Names with Spelling Errors All types of Spelling mistakes Excel Vlookup and Xlookup
How to use Vlookup in Excel 2013 Excel Vlookup Vlookup Excel 2013
00:05:53

How to use Vlookup in Excel 2013 Excel Vlookup Vlookup Excel 2013
How to find selling price with cost and profit margin only
00:06:07

How to find selling price with cost and profit margin only
How to calculate selling price with cost and margin Discount and Rebate included
00:07:47

How to calculate selling price with cost and margin Discount and Rebate included
Etsy fees explained how to calculate selling price and make profit
00:17:32

Etsy fees explained how to calculate selling price and make profit
Top 13 Excel Hacks for Accounting Finance from a fellow Finance Professional
00:31:40

Top 13 Excel Hacks for Accounting Finance from a fellow Finance Professional
How to Calculate Units to sell at different Selling prices
00:02:34

How to Calculate Units to sell at different Selling prices
How Change in Selling prices impacts required Units Sold
00:05:04

How Change in Selling prices impacts required Units Sold
How to Copy a sheet in Excel to a New file or Existing file
00:00:31

How to Copy a sheet in Excel to a New file or Existing file
How to Turn off Automatic calculations and Formulas in Excel
00:00:23

How to Turn off Automatic calculations and Formulas in Excel
Why my Pivot Table does not work
00:00:46

Why my Pivot Table does not work
Automate daily reporting in Excel using Pivot Tables
00:17:11

Automate daily reporting in Excel using Pivot Tables
Quickly Split Data in Excel into columns with Flash fill
00:00:56

Quickly Split Data in Excel into columns with Flash fill
Auto Refresh Pivot Table Data Great for Reporting
00:00:59

Auto Refresh Pivot Table Data Great for Reporting
Automate Graphs in Excel with GetPivotData for Dashboards
00:00:53

Automate Graphs in Excel with GetPivotData for Dashboards
Dynamically update Pivot Table when source data changes
00:01:00

Dynamically update Pivot Table when source data changes
Convert image in email to data in Excel
00:01:00

Convert image in email to data in Excel
Using Vlookup Here is what you are missing
00:00:54

Using Vlookup Here is what you are missing
How to Unhide the Sheets bar in Excel
00:00:39

How to Unhide the Sheets bar in Excel
Repeat top rows Titles when printing Repeat rows at top grayed out
00:00:59

Repeat top rows Titles when printing Repeat rows at top grayed out
Pivot Table Hack Quickly create Data Ranges
00:01:00

Pivot Table Hack Quickly create Data Ranges
Purchasing decisions Which vendor rebate is better
00:12:50

Purchasing decisions Which vendor rebate is better
Top Excel Shortcuts for working with Data
00:00:48

Top Excel Shortcuts for working with Data
Excel s single most valuable shortcut You are welcome
00:00:33

Excel s single most valuable shortcut You are welcome
How to sum filtered data in Excel
00:00:32

How to sum filtered data in Excel
How to sum data excluding subtotals in Excel
00:00:45

How to sum data excluding subtotals in Excel
How to sum in Excel ignoring error values
00:00:41

How to sum in Excel ignoring error values
How to find and fix Circular reference errors in Excel
00:00:43

How to find and fix Circular reference errors in Excel
Show More Lessons

Comments

Our New Certified Courses Will Reach You in Our Telegram Channel
Join Our Telegram Channels to Get Best Free Courses

Join Now

We Appreciate Your Feedback

Excellent
6 Reviews
Good
0 Reviews
medium
0 Reviews
Acceptable
0 Reviews
Not Good
0 Reviews
4.6
16 Reviews
Priyanshu Kumar Bhargav 

The course is good but try to provide in different languages also.
2025-09-14

Laili Husnul Hidayah 

Good, but the eds so annoyed
2025-08-22

Harshada Sarde 

I completed an Excel course, and it was incredibly helpful! I’ve gained a much deeper understanding of formulas, shortcuts, and data analysis tools. I’m now more confident using Excel for everyday tasks and excited to apply these skills in real-world projects.
2025-06-24

Usman Khan 

Excellent
2025-04-26

nathan bui 

Loved it very beneifical
2025-04-22

Mehboob Maqbool 

Great knowledge access
2025-04-14

kaveh rezazadeh 

it is good
2025-04-13

Mujahid Hussain 

Great opportunities for students
2025-03-28

Raghunandan M Hegde 

nice
2025-03-16

Rupali Samanta 

Good
2025-02-21

محمد شاجع الشميري 

Very Good
2025-02-19

Muhammad Shafique 

Very Nice
2025-02-10

Show More Reviews


Related Courses in Accounting
Accounting
18 Lessons

Accounting

Basic Accounting
10 Lessons

Basic Accounting

CMA Final Cost and Management Audit Paper 19
38 Lessons

CMA Final Cost and Management Audit Paper 19

Financial Accounting basics
19 Lessons

Financial Accounting basics

Accounting Fundamentals
37 Lessons

Accounting Fundamentals

Accounting Introduction
5 Lessons

Accounting Introduction

Financial Auditing for beginners
18 Lessons

Financial Auditing for beginners

Cost Accounting Fundamentals
3 Lessons

Cost Accounting Fundamentals

CMA Foundation Law
12 Lessons

CMA Foundation Law

CMA Foundation Economics
13 Lessons

CMA Foundation Economics

Auditing Principles and Practices
5 Lessons

Auditing Principles and Practices

CMA Strategic Management
7 Lessons

CMA Strategic Management

CMA Accounting basics
15 Lessons

CMA Accounting basics

CMA Company Accounts for beginner
3 Lessons

CMA Company Accounts for beginner

CMA Financial Accounting
3 Lessons

CMA Financial Accounting

Financial Accounting Fundamentals
4 Lessons

Financial Accounting Fundamentals

Course Description

we will learn about Microsoft Excel course, covering spreadsheet creation, formula use, data analysis with pivot tables, and automation through macros. Learn Accounting Finance
Trends
Recent
Next Lesson