Excel Interactive Dashboards and Data Analysis

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

If you are new to Excel dashboards or data analysis or want to fill in some gaps in your knowledge, THIS is the course for you. We've focused on providing you with the fundamentals you need to work with Excel effectively!

Don't sit through days of boring training to understand how to create powerful interactive dashboards that work! This course will get you up to speed and working in half the time, giving you the crucial foundation to start you on the journey to becoming an Excel dashboard and data analysis expert!

This course has been updated for 2021 in full HD video quality, so you will learn on the latest Excel interface. Students who have taken this course have this to say:

"I thought i know Pivot tables, report and dashboards, but i was shocked to see one can do so much in reports, pivot tables and dashboards...Thanks Ian For this amazing course. I am glad i found it...Thanks once again. "

"Im really excited to use this tools, all the information was very clear and easy to understand, thank you!!"

"Nice pace. Instructor knew the material and delivered it in a clear and understandable way"

"A very well structured course , taking the student from A to Z of Pivot tables , theory and practical aspects of Interactive Dashboards . A must for a foundation for other data analysis courses"

**** Lifetime access to course materials and practice activities. ****

This course is lead by Ian Littlejohn - an international trainer, consultant and data analyst with over 125 000 enrollments & 100 000 students on Udemy. Ian specializes in teaching data analysis techniques, Excel Pivot Tables, Power Pivot, Microsoft Power BI, Google Data Studio & Amazon Quicksight & his courses average over 4.5 stars out of 5.

Excel is the most commonly used data analysis tools available on the market today. In this course we show you how to create POWERFUL INTERACTIVE dashboards in minutes using standard Excel tools and techniques. (No coding or complicated methods required!)

We also discuss how to create and use BEST PRACTICE for your dashboards.

  • How to configure a dashboard

  • What graphs you should use to display what types of data

  • What questions you should ask of the data

  • What methods of analysis you can use in the data

In this course we answer these questions and more! We GUARANTEE that you will be able to EASILY create interactive dashboards and understand the most powerful methods of data analysis.

In the course you will learn the following key outcomes:

  • How to STRUCTURE your data for dashboards and data analysis

  • Create PIVOT TABLES to easily summarize and aggregate your data

  • Use Excel SLICERS to create filter tables and graphs

  • Create INTERACTIVE dashboards combining Key Metrics, Trend Graphs, Top 10 reports, Comparisons, Pie graphs and more

  • Understand how to EASILY create time / trend analysis using a few clicks of the mouse

  • Filter data and create Top 10 analysis

  • Learn how to do comparison, trend, ranking, contribution, variance, frequency and pareto analysis

  • Create a Sales, Human Resource and Finance dashboard

  • Use Conditional Formatting to highlight key data and trends

This course will teach you the best practices and principles for dashboard design and creating graphs. In addition you will learn the following forms of data analysis:

  • Comparison Analysis

  • Trend Analysis

  • Ranking Analysis

  • Contribution Analysis

  • Variance Analysis

  • Pareto Analysis

Who this course is for:

  • Excel users who want to learn reporting, data analysis and dashboards
  • Excel users who want to learn the power of Pivot Tables and Pivot Charts
  • Discover the most POWERFUL tool in Excel to transform your Data into Insight and intelligence LIFETIME access to course materials and practice activities Learn POWERFUL data analysis techniques using comparison, trend, contribution, ranking, frequency, variance and pareto analysis In this course you will learn how to create Sales, Human Resource and Finance interactive dashboards Learn BEST PRACTICES for dashboard development, table and graph design Learn powerful methods to easily GROUP and FILTER your data with a few clicks of the mouse Curated for the Udemy Business collection Requirements You should know how to work with spreadsheets with Excel 2013 or 2016 You will require Excel 2013 or 2016 Description If you are new to Excel dashboards or data analysis or want to fill in some gaps in your knowledge, THIS is the course for you. We've focused on providing you with the fundamentals you need to work with Excel effectively! Don't sit through days of boring training to understand how to create powerful interactive dashboards that work! This course will get you up to speed and working in half the time, giving you the crucial foundation to start you on the journey to becoming an Excel dashboard and data analysis expert! This course has been updated for 2021 in full HD video quality, so you will learn on the latest Excel interface. Students who have taken this course have this to say: "I thought i know Pivot tables, report and dashboards, but i was shocked to see one can do so much in reports, pivot tables and dashboards...Thanks Ian For this amazing course. I am glad i found it...Thanks once again. " "Im really excited to use this tools, all the information was very clear and easy to understand, thank you!!" "Nice pace. Instructor knew the material and delivered it in a clear and understandable way" "A very well structured course , taking the student from A to Z of Pivot tables , theory and practical aspects of Interactive Dashboards . A must for a foundation for other data analysis courses" **** Lifetime access to course materials and practice activities. **** This course is lead by Ian Littlejohn - an international trainer, consultant and data analyst with over 125 000 enrollments & 100 000 students on Udemy. Ian specializes in teaching data analysis techniques, Excel Pivot Tables, Power Pivot, Microsoft Power BI, Google Data Studio & Amazon Quicksight & his courses average over 4.5 stars out of 5. Excel is the most commonly used data analysis tools available on the market today. In this course we show you how to create POWERFUL INTERACTIVE dashboards in minutes using standard Excel tools and techniques. (No coding or complicated methods required!) We also discuss how to create and use BEST PRACTICE for your dashboards. How to configure a dashboard What graphs you should use to display what types of data What questions you should ask of the data What methods of analysis you can use in the data In this course we answer these questions and more! We GUARANTEE that you will be able to EASILY create interactive dashboards and understand the most powerful methods of data analysis. In the course you will learn the following key outcomes: How to STRUCTURE your data for dashboards and data analysis Create PIVOT TABLES to easily summarize and aggregate your data Use Excel SLICERS to create filter tables and graphs Create INTERACTIVE dashboards combining Key Metrics, Trend Graphs, Top 10 reports, Comparisons, Pie graphs and more Understand how to EASILY create time / trend analysis using a few clicks of the mouse Filter data and create Top 10 analysis Learn how to do comparison, trend, ranking, contribution, variance, frequency and pareto analysis Create a Sales, Human Resource and Finance dashboard Use Conditional Formatting to highlight key data and trends This course will teach you the best practices and principles for dashboard design and creating graphs. In addition you will learn the following forms of data analysis: Comparison Analysis Trend Analysis Ranking Analysis Contribution Analysis Variance Analysis Pareto Analysis Who this course is for: Excel users who want to learn reporting, data analysis and dashboards Excel users who want to learn the power of Pivot Tables and Pivot Charts Show more Show less Course content 15 sections • 82 lectures • 4h 50m total length Expand all sections Introduction 3 lectures • 4min Introduction to the Course Preview 01:45 About the Course Preview 01:55 Please download the Training Data Sets 00:04 Starting with Pivot Tables 8 lectures • 33min Introduction to Starting with Pivot Tables Preview 00:46 Structuring Data Correctly Preview 04:47 Creating Pivot Tables Preview 09:02 Working with Multiple Dimensions 04:08 Working with Multiple Measures 03:28 Sorting Fields in the Pivot Table 02:02 Practical Activity - Introduction to Pivot Tables 00:28 Completed Practical Activity - Pivot Tables 08:04 Filtering and Grouping Data with Pivot Tables 10 lectures • 37min Introduction to Filtering and Grouping Data with Pivot Tables 00:57 Filtering Data with Excel Slicers Preview 05:17 Practical Activity - Using Slicers to Filter Data 00:27 Completed Practical Activity - Using Slicers 04:45 Filtering Data with Slicers from more than One Table 05:15 Different Methods of Aggregation 06:58 Practical Activity - Method of Aggregation 00:16 Completed Practical Activity - Methods of Aggregation 03:23 Grouping Data in Pivot Tables 03:52 Review of the Pivot Table Design 05:37 Creating the Interactive Dashboard 3 lectures • 11min Introduction to Creating the Interactive Dashboard 00:47 Practical Activity - Create the Interactive Dashboard 00:16 Creating the Interactive Dashboard 10:23 Trend and Time Analysis 7 lectures • 28min Introduction to Trend and Time Analysis 01:02 Trend and Time Analysis using Date Groups Preview 05:45 Practical Activity - Trend Analysis 00:21 Completed Practical Activity - Trend Analysis 04:04 Trend Time Analysis with Fields 09:06 Trend and Time Analysis with Graphs 03:27 Adding the Trend Graph into the Dashboard 04:07 Comparison Analysis 3 lectures • 10min Introduction to Comparison Analysis 00:51 Comparison Analysis Graphs 05:45 Stacked Comparison Analysis Graphs 03:09 Additional Graph Types 4 lectures • 11min Introduction to Additional Graph Types 00:37 Stacked Line Graph 02:56 The Stacked Area Graph 03:16 Display the Dashboard 04:17 Asking Questions of your Data 7 lectures • 21min Introduction to Asking Questions of your Data 01:17 Filtering Text Data Preview 03:47 Filtering Values 02:43 Top 10 Analysis 04:52 Practical Activity - Ask questions of your data 00:29 Completed Practical Activity - Asking questions 03:37 Filtering Date Data 03:55 Creating a Sales Dashboard 4 lectures • 15min Introduction to Creating a Sales Dashboard 00:53 Practical Activity - Create a Sales Dashboard 00:22 The Completed Sales Dashboard - Part 1 09:15 The Completed Sales Dashboard - Part 2 04:14 Contribution Analysis 3 lectures • 13min Introduction to Contribution Analysis 00:53 Contribution Analysis 05:42 Pie Graphs 06:16 5 more sections Instructor Ian Littlejohn Excel Power Tools, Power BI and Google Data Studio Trainer 4.6 Instructor Rating 39,520 Reviews 124,743 Students 17 Courses Ian is a trainer that specializes in Microsoft Excel Business Intelligence tools, Power BI and Google Data Studio. Ian is an experienced trainer that teaches techniques and tools making it easy for learners to harness the power of Excel PivotTables, PowerPivot, Power Query, Power BI and Google Data Studio. Ian has been training learners on these powerful technologies for over 10 years making it easy for business users to easily create management reports, develop interactive dashboards and generate new insight and intelligence from business data. Ian has over 10 years of Management Consulting experience and he brings this knowledge and skills to his training course showing Excel and Google Data Studio users how to easily create sophisticated management reports, perform data analysis and create amazing interactive dashboards without using any complex programming or specialized tools. Ian has consulted and worked with major organizations in the Banking, Insurance, Manufacturing, Telecommunications and Logistics industries across a number of countries and continents. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'67810446f947408a',m:'2107f586306c3b8997fec7a96c74d0eec53e4e53-1627841359-1800-ASrgXOFYGd9WJF5HFB1jYU1fseNR1ksTBxP6x488oQRfXpNP4erY5LzLfqn6LQntHyZxjXz391To5Hvbs0FloIrZ84zPw1CwdOi/vqL3QrP5JGocjavL6XgulTxf/zXOhGGHdLG3/XsvvsRmHcLSUhAcxXAT6HgwudiiC6ajVzrwCNK9x7FA/Par0a4ujaTdFg==',s:[0x82bce0e934,0x931b4325f5],}})();
  • LIFETIME access to course materials and practice activities Learn POWERFUL data analysis techniques using comparison, trend, contribution, ranking, frequency, variance and pareto analysis In this course you will learn how to create Sales, Human Resource and Finance interactive dashboards Learn BEST PRACTICES for dashboard development, table and graph design Learn powerful methods to easily GROUP and FILTER your data with a few clicks of the mouse Curated for the Udemy Business collection Requirements You should know how to work with spreadsheets with Excel 2013 or 2016 You will require Excel 2013 or 2016 Description If you are new to Excel dashboards or data analysis or want to fill in some gaps in your knowledge, THIS is the course for you. We've focused on providing you with the fundamentals you need to work with Excel effectively! Don't sit through days of boring training to understand how to create powerful interactive dashboards that work! This course will get you up to speed and working in half the time, giving you the crucial foundation to start you on the journey to becoming an Excel dashboard and data analysis expert! This course has been updated for 2021 in full HD video quality, so you will learn on the latest Excel interface. Students who have taken this course have this to say: "I thought i know Pivot tables, report and dashboards, but i was shocked to see one can do so much in reports, pivot tables and dashboards...Thanks Ian For this amazing course. I am glad i found it...Thanks once again. " "Im really excited to use this tools, all the information was very clear and easy to understand, thank you!!" "Nice pace. Instructor knew the material and delivered it in a clear and understandable way" "A very well structured course , taking the student from A to Z of Pivot tables , theory and practical aspects of Interactive Dashboards . A must for a foundation for other data analysis courses" **** Lifetime access to course materials and practice activities. **** This course is lead by Ian Littlejohn - an international trainer, consultant and data analyst with over 125 000 enrollments & 100 000 students on Udemy. Ian specializes in teaching data analysis techniques, Excel Pivot Tables, Power Pivot, Microsoft Power BI, Google Data Studio & Amazon Quicksight & his courses average over 4.5 stars out of 5. Excel is the most commonly used data analysis tools available on the market today. In this course we show you how to create POWERFUL INTERACTIVE dashboards in minutes using standard Excel tools and techniques. (No coding or complicated methods required!) We also discuss how to create and use BEST PRACTICE for your dashboards. How to configure a dashboard What graphs you should use to display what types of data What questions you should ask of the data What methods of analysis you can use in the data In this course we answer these questions and more! We GUARANTEE that you will be able to EASILY create interactive dashboards and understand the most powerful methods of data analysis. In the course you will learn the following key outcomes: How to STRUCTURE your data for dashboards and data analysis Create PIVOT TABLES to easily summarize and aggregate your data Use Excel SLICERS to create filter tables and graphs Create INTERACTIVE dashboards combining Key Metrics, Trend Graphs, Top 10 reports, Comparisons, Pie graphs and more Understand how to EASILY create time / trend analysis using a few clicks of the mouse Filter data and create Top 10 analysis Learn how to do comparison, trend, ranking, contribution, variance, frequency and pareto analysis Create a Sales, Human Resource and Finance dashboard Use Conditional Formatting to highlight key data and trends This course will teach you the best practices and principles for dashboard design and creating graphs. In addition you will learn the following forms of data analysis: Comparison Analysis Trend Analysis Ranking Analysis Contribution Analysis Variance Analysis Pareto Analysis Who this course is for: Excel users who want to learn reporting, data analysis and dashboards Excel users who want to learn the power of Pivot Tables and Pivot Charts Show more Show less Course content 15 sections • 82 lectures • 4h 50m total length Expand all sections Introduction 3 lectures • 4min Introduction to the Course Preview 01:45 About the Course Preview 01:55 Please download the Training Data Sets 00:04 Starting with Pivot Tables 8 lectures • 33min Introduction to Starting with Pivot Tables Preview 00:46 Structuring Data Correctly Preview 04:47 Creating Pivot Tables Preview 09:02 Working with Multiple Dimensions 04:08 Working with Multiple Measures 03:28 Sorting Fields in the Pivot Table 02:02 Practical Activity - Introduction to Pivot Tables 00:28 Completed Practical Activity - Pivot Tables 08:04 Filtering and Grouping Data with Pivot Tables 10 lectures • 37min Introduction to Filtering and Grouping Data with Pivot Tables 00:57 Filtering Data with Excel Slicers Preview 05:17 Practical Activity - Using Slicers to Filter Data 00:27 Completed Practical Activity - Using Slicers 04:45 Filtering Data with Slicers from more than One Table 05:15 Different Methods of Aggregation 06:58 Practical Activity - Method of Aggregation 00:16 Completed Practical Activity - Methods of Aggregation 03:23 Grouping Data in Pivot Tables 03:52 Review of the Pivot Table Design 05:37 Creating the Interactive Dashboard 3 lectures • 11min Introduction to Creating the Interactive Dashboard 00:47 Practical Activity - Create the Interactive Dashboard 00:16 Creating the Interactive Dashboard 10:23 Trend and Time Analysis 7 lectures • 28min Introduction to Trend and Time Analysis 01:02 Trend and Time Analysis using Date Groups Preview 05:45 Practical Activity - Trend Analysis 00:21 Completed Practical Activity - Trend Analysis 04:04 Trend Time Analysis with Fields 09:06 Trend and Time Analysis with Graphs 03:27 Adding the Trend Graph into the Dashboard 04:07 Comparison Analysis 3 lectures • 10min Introduction to Comparison Analysis 00:51 Comparison Analysis Graphs 05:45 Stacked Comparison Analysis Graphs 03:09 Additional Graph Types 4 lectures • 11min Introduction to Additional Graph Types 00:37 Stacked Line Graph 02:56 The Stacked Area Graph 03:16 Display the Dashboard 04:17 Asking Questions of your Data 7 lectures • 21min Introduction to Asking Questions of your Data 01:17 Filtering Text Data Preview 03:47 Filtering Values 02:43 Top 10 Analysis 04:52 Practical Activity - Ask questions of your data 00:29 Completed Practical Activity - Asking questions 03:37 Filtering Date Data 03:55 Creating a Sales Dashboard 4 lectures • 15min Introduction to Creating a Sales Dashboard 00:53 Practical Activity - Create a Sales Dashboard 00:22 The Completed Sales Dashboard - Part 1 09:15 The Completed Sales Dashboard - Part 2 04:14 Contribution Analysis 3 lectures • 13min Introduction to Contribution Analysis 00:53 Contribution Analysis 05:42 Pie Graphs 06:16 5 more sections Instructor Ian Littlejohn Excel Power Tools, Power BI and Google Data Studio Trainer 4.6 Instructor Rating 39,520 Reviews 124,743 Students 17 Courses Ian is a trainer that specializes in Microsoft Excel Business Intelligence tools, Power BI and Google Data Studio. Ian is an experienced trainer that teaches techniques and tools making it easy for learners to harness the power of Excel PivotTables, PowerPivot, Power Query, Power BI and Google Data Studio. Ian has been training learners on these powerful technologies for over 10 years making it easy for business users to easily create management reports, develop interactive dashboards and generate new insight and intelligence from business data. Ian has over 10 years of Management Consulting experience and he brings this knowledge and skills to his training course showing Excel and Google Data Studio users how to easily create sophisticated management reports, perform data analysis and create amazing interactive dashboards without using any complex programming or specialized tools. Ian has consulted and worked with major organizations in the Banking, Insurance, Manufacturing, Telecommunications and Logistics industries across a number of countries and continents. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'67810446f947408a',m:'2107f586306c3b8997fec7a96c74d0eec53e4e53-1627841359-1800-ASrgXOFYGd9WJF5HFB1jYU1fseNR1ksTBxP6x488oQRfXpNP4erY5LzLfqn6LQntHyZxjXz391To5Hvbs0FloIrZ84zPw1CwdOi/vqL3QrP5JGocjavL6XgulTxf/zXOhGGHdLG3/XsvvsRmHcLSUhAcxXAT6HgwudiiC6ajVzrwCNK9x7FA/Par0a4ujaTdFg==',s:[0x82bce0e934,0x931b4325f5],}})();
  • Learn POWERFUL data analysis techniques using comparison, trend, contribution, ranking, frequency, variance and pareto analysis In this course you will learn how to create Sales, Human Resource and Finance interactive dashboards Learn BEST PRACTICES for dashboard development, table and graph design Learn powerful methods to easily GROUP and FILTER your data with a few clicks of the mouse Curated for the Udemy Business collection Requirements You should know how to work with spreadsheets with Excel 2013 or 2016 You will require Excel 2013 or 2016 Description If you are new to Excel dashboards or data analysis or want to fill in some gaps in your knowledge, THIS is the course for you. We've focused on providing you with the fundamentals you need to work with Excel effectively! Don't sit through days of boring training to understand how to create powerful interactive dashboards that work! This course will get you up to speed and working in half the time, giving you the crucial foundation to start you on the journey to becoming an Excel dashboard and data analysis expert! This course has been updated for 2021 in full HD video quality, so you will learn on the latest Excel interface. Students who have taken this course have this to say: "I thought i know Pivot tables, report and dashboards, but i was shocked to see one can do so much in reports, pivot tables and dashboards...Thanks Ian For this amazing course. I am glad i found it...Thanks once again. " "Im really excited to use this tools, all the information was very clear and easy to understand, thank you!!" "Nice pace. Instructor knew the material and delivered it in a clear and understandable way" "A very well structured course , taking the student from A to Z of Pivot tables , theory and practical aspects of Interactive Dashboards . A must for a foundation for other data analysis courses" **** Lifetime access to course materials and practice activities. **** This course is lead by Ian Littlejohn - an international trainer, consultant and data analyst with over 125 000 enrollments & 100 000 students on Udemy. Ian specializes in teaching data analysis techniques, Excel Pivot Tables, Power Pivot, Microsoft Power BI, Google Data Studio & Amazon Quicksight & his courses average over 4.5 stars out of 5. Excel is the most commonly used data analysis tools available on the market today. In this course we show you how to create POWERFUL INTERACTIVE dashboards in minutes using standard Excel tools and techniques. (No coding or complicated methods required!) We also discuss how to create and use BEST PRACTICE for your dashboards. How to configure a dashboard What graphs you should use to display what types of data What questions you should ask of the data What methods of analysis you can use in the data In this course we answer these questions and more! We GUARANTEE that you will be able to EASILY create interactive dashboards and understand the most powerful methods of data analysis. In the course you will learn the following key outcomes: How to STRUCTURE your data for dashboards and data analysis Create PIVOT TABLES to easily summarize and aggregate your data Use Excel SLICERS to create filter tables and graphs Create INTERACTIVE dashboards combining Key Metrics, Trend Graphs, Top 10 reports, Comparisons, Pie graphs and more Understand how to EASILY create time / trend analysis using a few clicks of the mouse Filter data and create Top 10 analysis Learn how to do comparison, trend, ranking, contribution, variance, frequency and pareto analysis Create a Sales, Human Resource and Finance dashboard Use Conditional Formatting to highlight key data and trends This course will teach you the best practices and principles for dashboard design and creating graphs. In addition you will learn the following forms of data analysis: Comparison Analysis Trend Analysis Ranking Analysis Contribution Analysis Variance Analysis Pareto Analysis Who this course is for: Excel users who want to learn reporting, data analysis and dashboards Excel users who want to learn the power of Pivot Tables and Pivot Charts Show more Show less Course content 15 sections • 82 lectures • 4h 50m total length Expand all sections Introduction 3 lectures • 4min Introduction to the Course Preview 01:45 About the Course Preview 01:55 Please download the Training Data Sets 00:04 Starting with Pivot Tables 8 lectures • 33min Introduction to Starting with Pivot Tables Preview 00:46 Structuring Data Correctly Preview 04:47 Creating Pivot Tables Preview 09:02 Working with Multiple Dimensions 04:08 Working with Multiple Measures 03:28 Sorting Fields in the Pivot Table 02:02 Practical Activity - Introduction to Pivot Tables 00:28 Completed Practical Activity - Pivot Tables 08:04 Filtering and Grouping Data with Pivot Tables 10 lectures • 37min Introduction to Filtering and Grouping Data with Pivot Tables 00:57 Filtering Data with Excel Slicers Preview 05:17 Practical Activity - Using Slicers to Filter Data 00:27 Completed Practical Activity - Using Slicers 04:45 Filtering Data with Slicers from more than One Table 05:15 Different Methods of Aggregation 06:58 Practical Activity - Method of Aggregation 00:16 Completed Practical Activity - Methods of Aggregation 03:23 Grouping Data in Pivot Tables 03:52 Review of the Pivot Table Design 05:37 Creating the Interactive Dashboard 3 lectures • 11min Introduction to Creating the Interactive Dashboard 00:47 Practical Activity - Create the Interactive Dashboard 00:16 Creating the Interactive Dashboard 10:23 Trend and Time Analysis 7 lectures • 28min Introduction to Trend and Time Analysis 01:02 Trend and Time Analysis using Date Groups Preview 05:45 Practical Activity - Trend Analysis 00:21 Completed Practical Activity - Trend Analysis 04:04 Trend Time Analysis with Fields 09:06 Trend and Time Analysis with Graphs 03:27 Adding the Trend Graph into the Dashboard 04:07 Comparison Analysis 3 lectures • 10min Introduction to Comparison Analysis 00:51 Comparison Analysis Graphs 05:45 Stacked Comparison Analysis Graphs 03:09 Additional Graph Types 4 lectures • 11min Introduction to Additional Graph Types 00:37 Stacked Line Graph 02:56 The Stacked Area Graph 03:16 Display the Dashboard 04:17 Asking Questions of your Data 7 lectures • 21min Introduction to Asking Questions of your Data 01:17 Filtering Text Data Preview 03:47 Filtering Values 02:43 Top 10 Analysis 04:52 Practical Activity - Ask questions of your data 00:29 Completed Practical Activity - Asking questions 03:37 Filtering Date Data 03:55 Creating a Sales Dashboard 4 lectures • 15min Introduction to Creating a Sales Dashboard 00:53 Practical Activity - Create a Sales Dashboard 00:22 The Completed Sales Dashboard - Part 1 09:15 The Completed Sales Dashboard - Part 2 04:14 Contribution Analysis 3 lectures • 13min Introduction to Contribution Analysis 00:53 Contribution Analysis 05:42 Pie Graphs 06:16 5 more sections Instructor Ian Littlejohn Excel Power Tools, Power BI and Google Data Studio Trainer 4.6 Instructor Rating 39,520 Reviews 124,743 Students 17 Courses Ian is a trainer that specializes in Microsoft Excel Business Intelligence tools, Power BI and Google Data Studio. Ian is an experienced trainer that teaches techniques and tools making it easy for learners to harness the power of Excel PivotTables, PowerPivot, Power Query, Power BI and Google Data Studio. Ian has been training learners on these powerful technologies for over 10 years making it easy for business users to easily create management reports, develop interactive dashboards and generate new insight and intelligence from business data. Ian has over 10 years of Management Consulting experience and he brings this knowledge and skills to his training course showing Excel and Google Data Studio users how to easily create sophisticated management reports, perform data analysis and create amazing interactive dashboards without using any complex programming or specialized tools. Ian has consulted and worked with major organizations in the Banking, Insurance, Manufacturing, Telecommunications and Logistics industries across a number of countries and continents. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'67810446f947408a',m:'2107f586306c3b8997fec7a96c74d0eec53e4e53-1627841359-1800-ASrgXOFYGd9WJF5HFB1jYU1fseNR1ksTBxP6x488oQRfXpNP4erY5LzLfqn6LQntHyZxjXz391To5Hvbs0FloIrZ84zPw1CwdOi/vqL3QrP5JGocjavL6XgulTxf/zXOhGGHdLG3/XsvvsRmHcLSUhAcxXAT6HgwudiiC6ajVzrwCNK9x7FA/Par0a4ujaTdFg==',s:[0x82bce0e934,0x931b4325f5],}})();
  • In this course you will learn how to create Sales, Human Resource and Finance interactive dashboards Learn BEST PRACTICES for dashboard development, table and graph design Learn powerful methods to easily GROUP and FILTER your data with a few clicks of the mouse Curated for the Udemy Business collection Requirements You should know how to work with spreadsheets with Excel 2013 or 2016 You will require Excel 2013 or 2016 Description If you are new to Excel dashboards or data analysis or want to fill in some gaps in your knowledge, THIS is the course for you. We've focused on providing you with the fundamentals you need to work with Excel effectively! Don't sit through days of boring training to understand how to create powerful interactive dashboards that work! This course will get you up to speed and working in half the time, giving you the crucial foundation to start you on the journey to becoming an Excel dashboard and data analysis expert! This course has been updated for 2021 in full HD video quality, so you will learn on the latest Excel interface. Students who have taken this course have this to say: "I thought i know Pivot tables, report and dashboards, but i was shocked to see one can do so much in reports, pivot tables and dashboards...Thanks Ian For this amazing course. I am glad i found it...Thanks once again. " "Im really excited to use this tools, all the information was very clear and easy to understand, thank you!!" "Nice pace. Instructor knew the material and delivered it in a clear and understandable way" "A very well structured course , taking the student from A to Z of Pivot tables , theory and practical aspects of Interactive Dashboards . A must for a foundation for other data analysis courses" **** Lifetime access to course materials and practice activities. **** This course is lead by Ian Littlejohn - an international trainer, consultant and data analyst with over 125 000 enrollments & 100 000 students on Udemy. Ian specializes in teaching data analysis techniques, Excel Pivot Tables, Power Pivot, Microsoft Power BI, Google Data Studio & Amazon Quicksight & his courses average over 4.5 stars out of 5. Excel is the most commonly used data analysis tools available on the market today. In this course we show you how to create POWERFUL INTERACTIVE dashboards in minutes using standard Excel tools and techniques. (No coding or complicated methods required!) We also discuss how to create and use BEST PRACTICE for your dashboards. How to configure a dashboard What graphs you should use to display what types of data What questions you should ask of the data What methods of analysis you can use in the data In this course we answer these questions and more! We GUARANTEE that you will be able to EASILY create interactive dashboards and understand the most powerful methods of data analysis. In the course you will learn the following key outcomes: How to STRUCTURE your data for dashboards and data analysis Create PIVOT TABLES to easily summarize and aggregate your data Use Excel SLICERS to create filter tables and graphs Create INTERACTIVE dashboards combining Key Metrics, Trend Graphs, Top 10 reports, Comparisons, Pie graphs and more Understand how to EASILY create time / trend analysis using a few clicks of the mouse Filter data and create Top 10 analysis Learn how to do comparison, trend, ranking, contribution, variance, frequency and pareto analysis Create a Sales, Human Resource and Finance dashboard Use Conditional Formatting to highlight key data and trends This course will teach you the best practices and principles for dashboard design and creating graphs. In addition you will learn the following forms of data analysis: Comparison Analysis Trend Analysis Ranking Analysis Contribution Analysis Variance Analysis Pareto Analysis Who this course is for: Excel users who want to learn reporting, data analysis and dashboards Excel users who want to learn the power of Pivot Tables and Pivot Charts Show more Show less Course content 15 sections • 82 lectures • 4h 50m total length Expand all sections Introduction 3 lectures • 4min Introduction to the Course Preview 01:45 About the Course Preview 01:55 Please download the Training Data Sets 00:04 Starting with Pivot Tables 8 lectures • 33min Introduction to Starting with Pivot Tables Preview 00:46 Structuring Data Correctly Preview 04:47 Creating Pivot Tables Preview 09:02 Working with Multiple Dimensions 04:08 Working with Multiple Measures 03:28 Sorting Fields in the Pivot Table 02:02 Practical Activity - Introduction to Pivot Tables 00:28 Completed Practical Activity - Pivot Tables 08:04 Filtering and Grouping Data with Pivot Tables 10 lectures • 37min Introduction to Filtering and Grouping Data with Pivot Tables 00:57 Filtering Data with Excel Slicers Preview 05:17 Practical Activity - Using Slicers to Filter Data 00:27 Completed Practical Activity - Using Slicers 04:45 Filtering Data with Slicers from more than One Table 05:15 Different Methods of Aggregation 06:58 Practical Activity - Method of Aggregation 00:16 Completed Practical Activity - Methods of Aggregation 03:23 Grouping Data in Pivot Tables 03:52 Review of the Pivot Table Design 05:37 Creating the Interactive Dashboard 3 lectures • 11min Introduction to Creating the Interactive Dashboard 00:47 Practical Activity - Create the Interactive Dashboard 00:16 Creating the Interactive Dashboard 10:23 Trend and Time Analysis 7 lectures • 28min Introduction to Trend and Time Analysis 01:02 Trend and Time Analysis using Date Groups Preview 05:45 Practical Activity - Trend Analysis 00:21 Completed Practical Activity - Trend Analysis 04:04 Trend Time Analysis with Fields 09:06 Trend and Time Analysis with Graphs 03:27 Adding the Trend Graph into the Dashboard 04:07 Comparison Analysis 3 lectures • 10min Introduction to Comparison Analysis 00:51 Comparison Analysis Graphs 05:45 Stacked Comparison Analysis Graphs 03:09 Additional Graph Types 4 lectures • 11min Introduction to Additional Graph Types 00:37 Stacked Line Graph 02:56 The Stacked Area Graph 03:16 Display the Dashboard 04:17 Asking Questions of your Data 7 lectures • 21min Introduction to Asking Questions of your Data 01:17 Filtering Text Data Preview 03:47 Filtering Values 02:43 Top 10 Analysis 04:52 Practical Activity - Ask questions of your data 00:29 Completed Practical Activity - Asking questions 03:37 Filtering Date Data 03:55 Creating a Sales Dashboard 4 lectures • 15min Introduction to Creating a Sales Dashboard 00:53 Practical Activity - Create a Sales Dashboard 00:22 The Completed Sales Dashboard - Part 1 09:15 The Completed Sales Dashboard - Part 2 04:14 Contribution Analysis 3 lectures • 13min Introduction to Contribution Analysis 00:53 Contribution Analysis 05:42 Pie Graphs 06:16 5 more sections Instructor Ian Littlejohn Excel Power Tools, Power BI and Google Data Studio Trainer 4.6 Instructor Rating 39,520 Reviews 124,743 Students 17 Courses Ian is a trainer that specializes in Microsoft Excel Business Intelligence tools, Power BI and Google Data Studio. Ian is an experienced trainer that teaches techniques and tools making it easy for learners to harness the power of Excel PivotTables, PowerPivot, Power Query, Power BI and Google Data Studio. Ian has been training learners on these powerful technologies for over 10 years making it easy for business users to easily create management reports, develop interactive dashboards and generate new insight and intelligence from business data. Ian has over 10 years of Management Consulting experience and he brings this knowledge and skills to his training course showing Excel and Google Data Studio users how to easily create sophisticated management reports, perform data analysis and create amazing interactive dashboards without using any complex programming or specialized tools. Ian has consulted and worked with major organizations in the Banking, Insurance, Manufacturing, Telecommunications and Logistics industries across a number of countries and continents. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'67810446f947408a',m:'2107f586306c3b8997fec7a96c74d0eec53e4e53-1627841359-1800-ASrgXOFYGd9WJF5HFB1jYU1fseNR1ksTBxP6x488oQRfXpNP4erY5LzLfqn6LQntHyZxjXz391To5Hvbs0FloIrZ84zPw1CwdOi/vqL3QrP5JGocjavL6XgulTxf/zXOhGGHdLG3/XsvvsRmHcLSUhAcxXAT6HgwudiiC6ajVzrwCNK9x7FA/Par0a4ujaTdFg==',s:[0x82bce0e934,0x931b4325f5],}})();
  • Learn BEST PRACTICES for dashboard development, table and graph design Learn powerful methods to easily GROUP and FILTER your data with a few clicks of the mouse Curated for the Udemy Business collection Requirements You should know how to work with spreadsheets with Excel 2013 or 2016 You will require Excel 2013 or 2016 Description If you are new to Excel dashboards or data analysis or want to fill in some gaps in your knowledge, THIS is the course for you. We've focused on providing you with the fundamentals you need to work with Excel effectively! Don't sit through days of boring training to understand how to create powerful interactive dashboards that work! This course will get you up to speed and working in half the time, giving you the crucial foundation to start you on the journey to becoming an Excel dashboard and data analysis expert! This course has been updated for 2021 in full HD video quality, so you will learn on the latest Excel interface. Students who have taken this course have this to say: "I thought i know Pivot tables, report and dashboards, but i was shocked to see one can do so much in reports, pivot tables and dashboards...Thanks Ian For this amazing course. I am glad i found it...Thanks once again. " "Im really excited to use this tools, all the information was very clear and easy to understand, thank you!!" "Nice pace. Instructor knew the material and delivered it in a clear and understandable way" "A very well structured course , taking the student from A to Z of Pivot tables , theory and practical aspects of Interactive Dashboards . A must for a foundation for other data analysis courses" **** Lifetime access to course materials and practice activities. **** This course is lead by Ian Littlejohn - an international trainer, consultant and data analyst with over 125 000 enrollments & 100 000 students on Udemy. Ian specializes in teaching data analysis techniques, Excel Pivot Tables, Power Pivot, Microsoft Power BI, Google Data Studio & Amazon Quicksight & his courses average over 4.5 stars out of 5. Excel is the most commonly used data analysis tools available on the market today. In this course we show you how to create POWERFUL INTERACTIVE dashboards in minutes using standard Excel tools and techniques. (No coding or complicated methods required!) We also discuss how to create and use BEST PRACTICE for your dashboards. How to configure a dashboard What graphs you should use to display what types of data What questions you should ask of the data What methods of analysis you can use in the data In this course we answer these questions and more! We GUARANTEE that you will be able to EASILY create interactive dashboards and understand the most powerful methods of data analysis. In the course you will learn the following key outcomes: How to STRUCTURE your data for dashboards and data analysis Create PIVOT TABLES to easily summarize and aggregate your data Use Excel SLICERS to create filter tables and graphs Create INTERACTIVE dashboards combining Key Metrics, Trend Graphs, Top 10 reports, Comparisons, Pie graphs and more Understand how to EASILY create time / trend analysis using a few clicks of the mouse Filter data and create Top 10 analysis Learn how to do comparison, trend, ranking, contribution, variance, frequency and pareto analysis Create a Sales, Human Resource and Finance dashboard Use Conditional Formatting to highlight key data and trends This course will teach you the best practices and principles for dashboard design and creating graphs. In addition you will learn the following forms of data analysis: Comparison Analysis Trend Analysis Ranking Analysis Contribution Analysis Variance Analysis Pareto Analysis Who this course is for: Excel users who want to learn reporting, data analysis and dashboards Excel users who want to learn the power of Pivot Tables and Pivot Charts Show more Show less Course content 15 sections • 82 lectures • 4h 50m total length Expand all sections Introduction 3 lectures • 4min Introduction to the Course Preview 01:45 About the Course Preview 01:55 Please download the Training Data Sets 00:04 Starting with Pivot Tables 8 lectures • 33min Introduction to Starting with Pivot Tables Preview 00:46 Structuring Data Correctly Preview 04:47 Creating Pivot Tables Preview 09:02 Working with Multiple Dimensions 04:08 Working with Multiple Measures 03:28 Sorting Fields in the Pivot Table 02:02 Practical Activity - Introduction to Pivot Tables 00:28 Completed Practical Activity - Pivot Tables 08:04 Filtering and Grouping Data with Pivot Tables 10 lectures • 37min Introduction to Filtering and Grouping Data with Pivot Tables 00:57 Filtering Data with Excel Slicers Preview 05:17 Practical Activity - Using Slicers to Filter Data 00:27 Completed Practical Activity - Using Slicers 04:45 Filtering Data with Slicers from more than One Table 05:15 Different Methods of Aggregation 06:58 Practical Activity - Method of Aggregation 00:16 Completed Practical Activity - Methods of Aggregation 03:23 Grouping Data in Pivot Tables 03:52 Review of the Pivot Table Design 05:37 Creating the Interactive Dashboard 3 lectures • 11min Introduction to Creating the Interactive Dashboard 00:47 Practical Activity - Create the Interactive Dashboard 00:16 Creating the Interactive Dashboard 10:23 Trend and Time Analysis 7 lectures • 28min Introduction to Trend and Time Analysis 01:02 Trend and Time Analysis using Date Groups Preview 05:45 Practical Activity - Trend Analysis 00:21 Completed Practical Activity - Trend Analysis 04:04 Trend Time Analysis with Fields 09:06 Trend and Time Analysis with Graphs 03:27 Adding the Trend Graph into the Dashboard 04:07 Comparison Analysis 3 lectures • 10min Introduction to Comparison Analysis 00:51 Comparison Analysis Graphs 05:45 Stacked Comparison Analysis Graphs 03:09 Additional Graph Types 4 lectures • 11min Introduction to Additional Graph Types 00:37 Stacked Line Graph 02:56 The Stacked Area Graph 03:16 Display the Dashboard 04:17 Asking Questions of your Data 7 lectures • 21min Introduction to Asking Questions of your Data 01:17 Filtering Text Data Preview 03:47 Filtering Values 02:43 Top 10 Analysis 04:52 Practical Activity - Ask questions of your data 00:29 Completed Practical Activity - Asking questions 03:37 Filtering Date Data 03:55 Creating a Sales Dashboard 4 lectures • 15min Introduction to Creating a Sales Dashboard 00:53 Practical Activity - Create a Sales Dashboard 00:22 The Completed Sales Dashboard - Part 1 09:15 The Completed Sales Dashboard - Part 2 04:14 Contribution Analysis 3 lectures • 13min Introduction to Contribution Analysis 00:53 Contribution Analysis 05:42 Pie Graphs 06:16 5 more sections Instructor Ian Littlejohn Excel Power Tools, Power BI and Google Data Studio Trainer 4.6 Instructor Rating 39,520 Reviews 124,743 Students 17 Courses Ian is a trainer that specializes in Microsoft Excel Business Intelligence tools, Power BI and Google Data Studio. Ian is an experienced trainer that teaches techniques and tools making it easy for learners to harness the power of Excel PivotTables, PowerPivot, Power Query, Power BI and Google Data Studio. Ian has been training learners on these powerful technologies for over 10 years making it easy for business users to easily create management reports, develop interactive dashboards and generate new insight and intelligence from business data. Ian has over 10 years of Management Consulting experience and he brings this knowledge and skills to his training course showing Excel and Google Data Studio users how to easily create sophisticated management reports, perform data analysis and create amazing interactive dashboards without using any complex programming or specialized tools. Ian has consulted and worked with major organizations in the Banking, Insurance, Manufacturing, Telecommunications and Logistics industries across a number of countries and continents. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'67810446f947408a',m:'2107f586306c3b8997fec7a96c74d0eec53e4e53-1627841359-1800-ASrgXOFYGd9WJF5HFB1jYU1fseNR1ksTBxP6x488oQRfXpNP4erY5LzLfqn6LQntHyZxjXz391To5Hvbs0FloIrZ84zPw1CwdOi/vqL3QrP5JGocjavL6XgulTxf/zXOhGGHdLG3/XsvvsRmHcLSUhAcxXAT6HgwudiiC6ajVzrwCNK9x7FA/Par0a4ujaTdFg==',s:[0x82bce0e934,0x931b4325f5],}})();
  • Learn powerful methods to easily GROUP and FILTER your data with a few clicks of the mouse Curated for the Udemy Business collection Requirements You should know how to work with spreadsheets with Excel 2013 or 2016 You will require Excel 2013 or 2016 Description If you are new to Excel dashboards or data analysis or want to fill in some gaps in your knowledge, THIS is the course for you. We've focused on providing you with the fundamentals you need to work with Excel effectively! Don't sit through days of boring training to understand how to create powerful interactive dashboards that work! This course will get you up to speed and working in half the time, giving you the crucial foundation to start you on the journey to becoming an Excel dashboard and data analysis expert! This course has been updated for 2021 in full HD video quality, so you will learn on the latest Excel interface. Students who have taken this course have this to say: "I thought i know Pivot tables, report and dashboards, but i was shocked to see one can do so much in reports, pivot tables and dashboards...Thanks Ian For this amazing course. I am glad i found it...Thanks once again. " "Im really excited to use this tools, all the information was very clear and easy to understand, thank you!!" "Nice pace. Instructor knew the material and delivered it in a clear and understandable way" "A very well structured course , taking the student from A to Z of Pivot tables , theory and practical aspects of Interactive Dashboards . A must for a foundation for other data analysis courses" **** Lifetime access to course materials and practice activities. **** This course is lead by Ian Littlejohn - an international trainer, consultant and data analyst with over 125 000 enrollments & 100 000 students on Udemy. Ian specializes in teaching data analysis techniques, Excel Pivot Tables, Power Pivot, Microsoft Power BI, Google Data Studio & Amazon Quicksight & his courses average over 4.5 stars out of 5. Excel is the most commonly used data analysis tools available on the market today. In this course we show you how to create POWERFUL INTERACTIVE dashboards in minutes using standard Excel tools and techniques. (No coding or complicated methods required!) We also discuss how to create and use BEST PRACTICE for your dashboards. How to configure a dashboard What graphs you should use to display what types of data What questions you should ask of the data What methods of analysis you can use in the data In this course we answer these questions and more! We GUARANTEE that you will be able to EASILY create interactive dashboards and understand the most powerful methods of data analysis. In the course you will learn the following key outcomes: How to STRUCTURE your data for dashboards and data analysis Create PIVOT TABLES to easily summarize and aggregate your data Use Excel SLICERS to create filter tables and graphs Create INTERACTIVE dashboards combining Key Metrics, Trend Graphs, Top 10 reports, Comparisons, Pie graphs and more Understand how to EASILY create time / trend analysis using a few clicks of the mouse Filter data and create Top 10 analysis Learn how to do comparison, trend, ranking, contribution, variance, frequency and pareto analysis Create a Sales, Human Resource and Finance dashboard Use Conditional Formatting to highlight key data and trends This course will teach you the best practices and principles for dashboard design and creating graphs. In addition you will learn the following forms of data analysis: Comparison Analysis Trend Analysis Ranking Analysis Contribution Analysis Variance Analysis Pareto Analysis Who this course is for: Excel users who want to learn reporting, data analysis and dashboards Excel users who want to learn the power of Pivot Tables and Pivot Charts Show more Show less Course content 15 sections • 82 lectures • 4h 50m total length Expand all sections Introduction 3 lectures • 4min Introduction to the Course Preview 01:45 About the Course Preview 01:55 Please download the Training Data Sets 00:04 Starting with Pivot Tables 8 lectures • 33min Introduction to Starting with Pivot Tables Preview 00:46 Structuring Data Correctly Preview 04:47 Creating Pivot Tables Preview 09:02 Working with Multiple Dimensions 04:08 Working with Multiple Measures 03:28 Sorting Fields in the Pivot Table 02:02 Practical Activity - Introduction to Pivot Tables 00:28 Completed Practical Activity - Pivot Tables 08:04 Filtering and Grouping Data with Pivot Tables 10 lectures • 37min Introduction to Filtering and Grouping Data with Pivot Tables 00:57 Filtering Data with Excel Slicers Preview 05:17 Practical Activity - Using Slicers to Filter Data 00:27 Completed Practical Activity - Using Slicers 04:45 Filtering Data with Slicers from more than One Table 05:15 Different Methods of Aggregation 06:58 Practical Activity - Method of Aggregation 00:16 Completed Practical Activity - Methods of Aggregation 03:23 Grouping Data in Pivot Tables 03:52 Review of the Pivot Table Design 05:37 Creating the Interactive Dashboard 3 lectures • 11min Introduction to Creating the Interactive Dashboard 00:47 Practical Activity - Create the Interactive Dashboard 00:16 Creating the Interactive Dashboard 10:23 Trend and Time Analysis 7 lectures • 28min Introduction to Trend and Time Analysis 01:02 Trend and Time Analysis using Date Groups Preview 05:45 Practical Activity - Trend Analysis 00:21 Completed Practical Activity - Trend Analysis 04:04 Trend Time Analysis with Fields 09:06 Trend and Time Analysis with Graphs 03:27 Adding the Trend Graph into the Dashboard 04:07 Comparison Analysis 3 lectures • 10min Introduction to Comparison Analysis 00:51 Comparison Analysis Graphs 05:45 Stacked Comparison Analysis Graphs 03:09 Additional Graph Types 4 lectures • 11min Introduction to Additional Graph Types 00:37 Stacked Line Graph 02:56 The Stacked Area Graph 03:16 Display the Dashboard 04:17 Asking Questions of your Data 7 lectures • 21min Introduction to Asking Questions of your Data 01:17 Filtering Text Data Preview 03:47 Filtering Values 02:43 Top 10 Analysis 04:52 Practical Activity - Ask questions of your data 00:29 Completed Practical Activity - Asking questions 03:37 Filtering Date Data 03:55 Creating a Sales Dashboard 4 lectures • 15min Introduction to Creating a Sales Dashboard 00:53 Practical Activity - Create a Sales Dashboard 00:22 The Completed Sales Dashboard - Part 1 09:15 The Completed Sales Dashboard - Part 2 04:14 Contribution Analysis 3 lectures • 13min Introduction to Contribution Analysis 00:53 Contribution Analysis 05:42 Pie Graphs 06:16 5 more sections Instructor Ian Littlejohn Excel Power Tools, Power BI and Google Data Studio Trainer 4.6 Instructor Rating 39,520 Reviews 124,743 Students 17 Courses Ian is a trainer that specializes in Microsoft Excel Business Intelligence tools, Power BI and Google