Microsoft Excel: Pivot Tables, Power Query, Power Pivot/DAX

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

Course Description

This course covers the visualizations and analysing content required for Microsoft's 70-779 certification exam. (Note: this exam is no longer available, but the topics are well worth learning!)

Reviews

Nora: "I liked that it went through really fast through the process, as expected if you consider yourself an advanced Excel user. Really enjoyable"

Dilbag: "Phillip's presentation of content is amazing. He has in-depth knowledge of the subject. I would highly recommend this course."

Amy: "I want to add how this course is by far the best one I have found on the subject. It really delves deeply into each piece of material. While many courses focus on getting you ready for the exam, this one makes sure you know how to use it in the real world as well. I would suggest this course to anyone who not only wants to pass the 70-779 test, but utilize it in their job."

Khalid: "Great great teacher. knowledgable in the tech and its usages, Speed, info delivery, and his voice is friendly. I'm lucky to choose this course over another one ;). Thank you all"

----------------

Do you already use the PC version of Excel to create data analysis, but find that you need to create more advanced analyses? Do you want to combine various sets of data, and or manipulate existing data sets? Do you want to save time, and have your analysis be automatically refreshed with new data?

In this course, learn the skills that Microsoft want you to know, and add another tool to your CV, and even go for the Microsoft certification.

Excel is one of the most requested analysis tools that are requested in the job market, and the ability to being able to use it at an advanced level could be very useful for your current work, and your next job hunt.

This course comes in three parts:

Part 1 - Creating Pivot Tables and Pivot Charts

This part of the course covers one of the most useful, but scariest-sounding, functions in Microsoft Excel; PIVOT TABLES.

It sounds difficult, but in fact can be done in just a few clicks. We'll do our first one in a couple of minutes - that's all it takes. We'll also add a chart as well in that time.

After only these first few minutes, you will be streets ahead of anyone who doesn't know anything about Pivot Tables - it is really that important.

After this introduction, we'll go into some detail into how to set up your Pivot Table - the initial data, and the various options that are available to you. We will go into advanced options that most people don't even know about, but which are very useful.

By the end, you will be an Expert user of Pivot Tables, able to create reliable analyses which are able to be drilled-down quickly, and you'll be able to help others with their data analysis.

Part 2 - Get and Transform Data (also known as Prepare the Data)

We see how data can be transformed, saving you time in analysing the data. We'll look at sorting and filtering, split columns, and other transform activities. We'll merge, append and combine queries together. We'll Pivot and Unpivot, and transform text, numbers, dates and times, and create custom columns using the M language.

Part 3 - Refining the model (also known as Model the Data)

We'll see how relationships can be made through multiple tables, and refine the data with custom columns and measures using the DAX language.

The course will take around 16 hours to complete, but completing this will enable you to create vizzes, dashboards and stories of your own, and know how to overcome common problems.

The course increases in difficulty slowly, so you'll create for instance a table or basic bar chart, then turn it into a stacked bar chart, and investigate more of their properties, step by step.

The course is fairly relaxed - there will be a few "wrong turns", so you can see what problems might arise, but every lesson works towards an end goal at a relatively slow pace, so you can follow on your own computer easily. I assume that you know how to use a computer, including installing programs, but the actual analysis will be at a basic level, and I'll introduce every component as we go on.

At the end of the course, you can download a certificate of completion, so you can show everyone your new-found skills, and be able to start creating analyses for yourselves.

Please note: Microsoft will retire the 70-779 exam on 31 January 2021. No replacement has yet been given by Microsoft.

Who this course is for:

  • This reporting course is meant for anyone who has no prior, or only a little experience of Pivot Tables, Get and Transform, and Power Pivot.
  • No prior experience in reporting tools is required.
  • This course is probably not for you if you always know how to how to do the advanced functionality of Get and Transform and Power Pivots, although we will be looking at some more advanced topics, including the M and DAX languages.

Expected Outcomes

  1. Be able to create PivotTables and PivotCharts, both basic and advanced You will be able to format numbers and dates, and create advanced calculations. You will be able to Get and Transform multiple sources of data, including merging multiple files from a folder, pivoting and unpivotting. Building and refine models, including adding calculated columns and measures. You will learn the important M and DAX functions, to enable you to build your own formulas. Curated for the Udemy Business collection Requirements Before you begin this course, you should have a PC with Microsoft Excel 2016 or later. The first part of this course will work with Macs, but the second and third parts are not compatible with the Mac version of Excel. (It will work if you are using the PC version of Excel, including using Parallel Desktop.) You should also know how to open an Excel workbook, and have an interest in analysis. It would also be good if you had prior experience in using Excel formulas, but that is not essential. That's it! The more experience in using Excel, the better, but it is not essential. Description This course covers the visualizations and analysing content required for Microsoft's 70-779 certification exam. (Note: this exam is no longer available, but the topics are well worth learning!) Reviews Nora: "I liked that it went through really fast through the process, as expected if you consider yourself an advanced Excel user. Really enjoyable" Dilbag: "Phillip's presentation of content is amazing. He has in-depth knowledge of the subject. I would highly recommend this course." Amy: "I want to add how this course is by far the best one I have found on the subject. It really delves deeply into each piece of material. While many courses focus on getting you ready for the exam, this one makes sure you know how to use it in the real world as well. I would suggest this course to anyone who not only wants to pass the 70-779 test, but utilize it in their job." Khalid: "Great great teacher. knowledgable in the tech and its usages, Speed, info delivery, and his voice is friendly. I'm lucky to choose this course over another one ;). Thank you all" ---------------- Do you already use the PC version of Excel to create data analysis, but find that you need to create more advanced analyses? Do you want to combine various sets of data, and or manipulate existing data sets? Do you want to save time, and have your analysis be automatically refreshed with new data? In this course, learn the skills that Microsoft want you to know, and add another tool to your CV, and even go for the Microsoft certification. Excel is one of the most requested analysis tools that are requested in the job market, and the ability to being able to use it at an advanced level could be very useful for your current work, and your next job hunt. This course comes in three parts: Part 1 - Creating Pivot Tables and Pivot Charts This part of the course covers one of the most useful, but scariest-sounding, functions in Microsoft Excel; PIVOT TABLES. It sounds difficult, but in fact can be done in just a few clicks. We'll do our first one in a couple of minutes - that's all it takes. We'll also add a chart as well in that time. After only these first few minutes, you will be streets ahead of anyone who doesn't know anything about Pivot Tables - it is really that important. After this introduction, we'll go into some detail into how to set up your Pivot Table - the initial data, and the various options that are available to you. We will go into advanced options that most people don't even know about, but which are very useful. By the end, you will be an Expert user of Pivot Tables, able to create reliable analyses which are able to be drilled-down quickly, and you'll be able to help others with their data analysis. Part 2 - Get and Transform Data (also known as Prepare the Data) We see how data can be transformed, saving you time in analysing the data. We'll look at sorting and filtering, split columns, and other transform activities. We'll merge, append and combine queries together. We'll Pivot and Unpivot, and transform text, numbers, dates and times, and create custom columns using the M language. Part 3 - Refining the model (also known as Model the Data) We'll see how relationships can be made through multiple tables, and refine the data with custom columns and measures using the DAX language. The course will take around 16 hours to complete, but completing this will enable you to create vizzes, dashboards and stories of your own, and know how to overcome common problems. The course increases in difficulty slowly, so you'll create for instance a table or basic bar chart, then turn it into a stacked bar chart, and investigate more of their properties, step by step. The course is fairly relaxed - there will be a few "wrong turns", so you can see what problems might arise, but every lesson works towards an end goal at a relatively slow pace, so you can follow on your own computer easily. I assume that you know how to use a computer, including installing programs, but the actual analysis will be at a basic level, and I'll introduce every component as we go on. At the end of the course, you can download a certificate of completion, so you can show everyone your new-found skills, and be able to start creating analyses for yourselves. Please note: Microsoft will retire the 70-779 exam on 31 January 2021. No replacement has yet been given by Microsoft. Who this course is for: This reporting course is meant for anyone who has no prior, or only a little experience of Pivot Tables, Get and Transform, and Power Pivot. No prior experience in reporting tools is required. This course is probably not for you if you always know how to how to do the advanced functionality of Get and Transform and Power Pivots, although we will be looking at some more advanced topics, including the M and DAX languages. Show more Show less Course content 31 sections • 208 lectures • 16h 51m total length Expand all sections Introduction 5 lectures • 12min Introduction Preview 01:33 Welcome to Udemy 00:35 The Udemy Interface 02:00 Curriculum Preview 07:31 Resources 00:23 Creating our first PivotTable and PivotChart 6 lectures • 21min Our first PivotTable Preview 08:15 PivotTable Menus 02:15 Our first PivotChart 03:43 PivotChart Menus and An Introduction to Practice Activity 1 03:25 Practice Activity Number 1 00:08 Answer to Practice Activity 1 03:40 Expanding our PivotTable 9 lectures • 32min Source data requirements 04:53 Adding additional values 04:44 Recommended PivotTables 02:51 Moving PivotTable 03:16 Refresh PivotTable - why it doesn't auto-update 05:17 Extracting data 05:28 Sorting 02:35 Practice Activity Number 2 00:24 Answer to Practice Activity 2 02:10 Going deeper in our PivotTable 14 lectures • 56min Adding additional row fields 03:51 Different layouts – Compact, Outline and Tabular 05:00 Blank Rows 04:17 Group Records 04:55 Showing or hiding additional detail - the +/- buttons 03:33 Adding columns 04:34 Adding page fields 03:48 Adding filters 08:22 Changing source 03:26 Using a table source 04:02 Other PivotTable - Analyze options 04:01 Introduction to Practice Activity 3 01:48 Practice Activity Number 3 00:31 Answers to Practice Activity 3 03:32 Modify field selections 9 lectures • 45min Change aggregate (COUNT, MIN, MAX) 07:20 Repeat All 04:28 Using Conditional Formatting to hide Repeat All 04:25 Grand Totals 06:39 Adding subtotals 08:06 Show items with no data 05:31 Other field settings 06:33 Practice Activity Number 4 00:14 Answers to Practice Activity 4 02:11 PivotTable Options 7 lectures • 33min Layout 09:52 Totals & Filters, and Alt Text 04:54 Display 03:02 Print 04:29 Data 08:29 Practice Activity Number 5 00:14 Answers to Practice Activity 5 01:54 Slicers 6 lectures • 20min Create slicers 02:20 Identifying impossible options, and selecting more than one option at once. 03:29 Join to multiple PivotTables 04:12 Options 04:38 Practice Activity Number 6 00:35 Answer to Practice Activity 6 04:49 Dates and Timeline 5 lectures • 20min Aggregates 03:59 Group by time period 06:33 Timelines 05:43 Practice Activity Number 7 00:19 Answer to Practice Activity 7 02:57 Formatting 10 lectures • 59min Formatting number values 04:37 Custom Formatting - number formatting 08:25 Custom Formatting - dates and text 09:32 Custom Formatting - sections and colors 08:17 Conditional Formatting - Highlighting cells 07:28 Conditional Formatting - Data Bars and Color Sets 07:13 Formatting printing 05:19 Styles 04:20 Practice Activity Number 8 00:16 Answer to Practice Activity 8 03:47 Advanced calculations 7 lectures • 36min Percentage of total 07:47 Percentage of total - Advanced 06:41 Cumulative totals 03:59 Rank and Index 04:35 Difference from 03:42 Calculated fields 04:05 Calculated Items 05:02 21 more sections Instructor Phillip Burton Best Selling Instructor - over 340,000 students so far 4.5 Instructor Rating 53,317 Reviews 346,028 Students 48 Courses Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist. He enjoys investigating data, which allows him to maintain up to date and pro-active systems to help control and monitor day-to-day activities. He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation. He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015. His interests are working with data, including Microsoft Excel, Access and SQL Server. 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:'678136499b9bf3eb',m:'5fffd66cfcfdaccc91a33362f6c94122236abd20-1627843407-1800-AcO4M4iqLWcrHCP0Sqd1OuwQ1/ylnjFZ5T9CWQhzR3IAtCvjAR+26dERsNWwLFOABqVfMTgenHhUDHsBu/Ko1QMMdgAZBIPCRMgPfH8JZ7YP57Tgc7ntWn7pDFGj8BwZlr8Ogn+lUNdi1DAcLH66bN1vk2Bd/TXcoEp1sNWKweVXxagDVsBrBLCmOYLAJiTxjdR49MSUKPp/R5q9R+wzicI=',s:[0xbfe70788b7,0x32ddc23cff],}})();
  2. You will be able to format numbers and dates, and create advanced calculations. You will be able to Get and Transform multiple sources of data, including merging multiple files from a folder, pivoting and unpivotting. Building and refine models, including adding calculated columns and measures. You will learn the important M and DAX functions, to enable you to build your own formulas. Curated for the Udemy Business collection Requirements Before you begin this course, you should have a PC with Microsoft Excel 2016 or later. The first part of this course will work with Macs, but the second and third parts are not compatible with the Mac version of Excel. (It will work if you are using the PC version of Excel, including using Parallel Desktop.) You should also know how to open an Excel workbook, and have an interest in analysis. It would also be good if you had prior experience in using Excel formulas, but that is not essential. That's it! The more experience in using Excel, the better, but it is not essential. Description This course covers the visualizations and analysing content required for Microsoft's 70-779 certification exam. (Note: this exam is no longer available, but the topics are well worth learning!) Reviews Nora: "I liked that it went through really fast through the process, as expected if you consider yourself an advanced Excel user. Really enjoyable" Dilbag: "Phillip's presentation of content is amazing. He has in-depth knowledge of the subject. I would highly recommend this course." Amy: "I want to add how this course is by far the best one I have found on the subject. It really delves deeply into each piece of material. While many courses focus on getting you ready for the exam, this one makes sure you know how to use it in the real world as well. I would suggest this course to anyone who not only wants to pass the 70-779 test, but utilize it in their job." Khalid: "Great great teacher. knowledgable in the tech and its usages, Speed, info delivery, and his voice is friendly. I'm lucky to choose this course over another one ;). Thank you all" ---------------- Do you already use the PC version of Excel to create data analysis, but find that you need to create more advanced analyses? Do you want to combine various sets of data, and or manipulate existing data sets? Do you want to save time, and have your analysis be automatically refreshed with new data? In this course, learn the skills that Microsoft want you to know, and add another tool to your CV, and even go for the Microsoft certification. Excel is one of the most requested analysis tools that are requested in the job market, and the ability to being able to use it at an advanced level could be very useful for your current work, and your next job hunt. This course comes in three parts: Part 1 - Creating Pivot Tables and Pivot Charts This part of the course covers one of the most useful, but scariest-sounding, functions in Microsoft Excel; PIVOT TABLES. It sounds difficult, but in fact can be done in just a few clicks. We'll do our first one in a couple of minutes - that's all it takes. We'll also add a chart as well in that time. After only these first few minutes, you will be streets ahead of anyone who doesn't know anything about Pivot Tables - it is really that important. After this introduction, we'll go into some detail into how to set up your Pivot Table - the initial data, and the various options that are available to you. We will go into advanced options that most people don't even know about, but which are very useful. By the end, you will be an Expert user of Pivot Tables, able to create reliable analyses which are able to be drilled-down quickly, and you'll be able to help others with their data analysis. Part 2 - Get and Transform Data (also known as Prepare the Data) We see how data can be transformed, saving you time in analysing the data. We'll look at sorting and filtering, split columns, and other transform activities. We'll merge, append and combine queries together. We'll Pivot and Unpivot, and transform text, numbers, dates and times, and create custom columns using the M language. Part 3 - Refining the model (also known as Model the Data) We'll see how relationships can be made through multiple tables, and refine the data with custom columns and measures using the DAX language. The course will take around 16 hours to complete, but completing this will enable you to create vizzes, dashboards and stories of your own, and know how to overcome common problems. The course increases in difficulty slowly, so you'll create for instance a table or basic bar chart, then turn it into a stacked bar chart, and investigate more of their properties, step by step. The course is fairly relaxed - there will be a few "wrong turns", so you can see what problems might arise, but every lesson works towards an end goal at a relatively slow pace, so you can follow on your own computer easily. I assume that you know how to use a computer, including installing programs, but the actual analysis will be at a basic level, and I'll introduce every component as we go on. At the end of the course, you can download a certificate of completion, so you can show everyone your new-found skills, and be able to start creating analyses for yourselves. Please note: Microsoft will retire the 70-779 exam on 31 January 2021. No replacement has yet been given by Microsoft. Who this course is for: This reporting course is meant for anyone who has no prior, or only a little experience of Pivot Tables, Get and Transform, and Power Pivot. No prior experience in reporting tools is required. This course is probably not for you if you always know how to how to do the advanced functionality of Get and Transform and Power Pivots, although we will be looking at some more advanced topics, including the M and DAX languages. Show more Show less Course content 31 sections • 208 lectures • 16h 51m total length Expand all sections Introduction 5 lectures • 12min Introduction Preview 01:33 Welcome to Udemy 00:35 The Udemy Interface 02:00 Curriculum Preview 07:31 Resources 00:23 Creating our first PivotTable and PivotChart 6 lectures • 21min Our first PivotTable Preview 08:15 PivotTable Menus 02:15 Our first PivotChart 03:43 PivotChart Menus and An Introduction to Practice Activity 1 03:25 Practice Activity Number 1 00:08 Answer to Practice Activity 1 03:40 Expanding our PivotTable 9 lectures • 32min Source data requirements 04:53 Adding additional values 04:44 Recommended PivotTables 02:51 Moving PivotTable 03:16 Refresh PivotTable - why it doesn't auto-update 05:17 Extracting data 05:28 Sorting 02:35 Practice Activity Number 2 00:24 Answer to Practice Activity 2 02:10 Going deeper in our PivotTable 14 lectures • 56min Adding additional row fields 03:51 Different layouts – Compact, Outline and Tabular 05:00 Blank Rows 04:17 Group Records 04:55 Showing or hiding additional detail - the +/- buttons 03:33 Adding columns 04:34 Adding page fields 03:48 Adding filters 08:22 Changing source 03:26 Using a table source 04:02 Other PivotTable - Analyze options 04:01 Introduction to Practice Activity 3 01:48 Practice Activity Number 3 00:31 Answers to Practice Activity 3 03:32 Modify field selections 9 lectures • 45min Change aggregate (COUNT, MIN, MAX) 07:20 Repeat All 04:28 Using Conditional Formatting to hide Repeat All 04:25 Grand Totals 06:39 Adding subtotals 08:06 Show items with no data 05:31 Other field settings 06:33 Practice Activity Number 4 00:14 Answers to Practice Activity 4 02:11 PivotTable Options 7 lectures • 33min Layout 09:52 Totals & Filters, and Alt Text 04:54 Display 03:02 Print 04:29 Data 08:29 Practice Activity Number 5 00:14 Answers to Practice Activity 5 01:54 Slicers 6 lectures • 20min Create slicers 02:20 Identifying impossible options, and selecting more than one option at once. 03:29 Join to multiple PivotTables 04:12 Options 04:38 Practice Activity Number 6 00:35 Answer to Practice Activity 6 04:49 Dates and Timeline 5 lectures • 20min Aggregates 03:59 Group by time period 06:33 Timelines 05:43 Practice Activity Number 7 00:19 Answer to Practice Activity 7 02:57 Formatting 10 lectures • 59min Formatting number values 04:37 Custom Formatting - number formatting 08:25 Custom Formatting - dates and text 09:32 Custom Formatting - sections and colors 08:17 Conditional Formatting - Highlighting cells 07:28 Conditional Formatting - Data Bars and Color Sets 07:13 Formatting printing 05:19 Styles 04:20 Practice Activity Number 8 00:16 Answer to Practice Activity 8 03:47 Advanced calculations 7 lectures • 36min Percentage of total 07:47 Percentage of total - Advanced 06:41 Cumulative totals 03:59 Rank and Index 04:35 Difference from 03:42 Calculated fields 04:05 Calculated Items 05:02 21 more sections Instructor Phillip Burton Best Selling Instructor - over 340,000 students so far 4.5 Instructor Rating 53,317 Reviews 346,028 Students 48 Courses Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist. He enjoys investigating data, which allows him to maintain up to date and pro-active systems to help control and monitor day-to-day activities. He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation. He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015. His interests are working with data, including Microsoft Excel, Access and SQL Server. 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:'678136499b9bf3eb',m:'5fffd66cfcfdaccc91a33362f6c94122236abd20-1627843407-1800-AcO4M4iqLWcrHCP0Sqd1OuwQ1/ylnjFZ5T9CWQhzR3IAtCvjAR+26dERsNWwLFOABqVfMTgenHhUDHsBu/Ko1QMMdgAZBIPCRMgPfH8JZ7YP57Tgc7ntWn7pDFGj8BwZlr8Ogn+lUNdi1DAcLH66bN1vk2Bd/TXcoEp1sNWKweVXxagDVsBrBLCmOYLAJiTxjdR49MSUKPp/R5q9R+wzicI=',s:[0xbfe70788b7,0x32ddc23cff],}})();
  3. You will be able to Get and Transform multiple sources of data, including merging multiple files from a folder, pivoting and unpivotting. Building and refine models, including adding calculated columns and measures. You will learn the important M and DAX functions, to enable you to build your own formulas. Curated for the Udemy Business collection Requirements Before you begin this course, you should have a PC with Microsoft Excel 2016 or later. The first part of this course will work with Macs, but the second and third parts are not compatible with the Mac version of Excel. (It will work if you are using the PC version of Excel, including using Parallel Desktop.) You should also know how to open an Excel workbook, and have an interest in analysis. It would also be good if you had prior experience in using Excel formulas, but that is not essential. That's it! The more experience in using Excel, the better, but it is not essential. Description This course covers the visualizations and analysing content required for Microsoft's 70-779 certification exam. (Note: this exam is no longer available, but the topics are well worth learning!) Reviews Nora: "I liked that it went through really fast through the process, as expected if you consider yourself an advanced Excel user. Really enjoyable" Dilbag: "Phillip's presentation of content is amazing. He has in-depth knowledge of the subject. I would highly recommend this course." Amy: "I want to add how this course is by far the best one I have found on the subject. It really delves deeply into each piece of material. While many courses focus on getting you ready for the exam, this one makes sure you know how to use it in the real world as well. I would suggest this course to anyone who not only wants to pass the 70-779 test, but utilize it in their job." Khalid: "Great great teacher. knowledgable in the tech and its usages, Speed, info delivery, and his voice is friendly. I'm lucky to choose this course over another one ;). Thank you all" ---------------- Do you already use the PC version of Excel to create data analysis, but find that you need to create more advanced analyses? Do you want to combine various sets of data, and or manipulate existing data sets? Do you want to save time, and have your analysis be automatically refreshed with new data? In this course, learn the skills that Microsoft want you to know, and add another tool to your CV, and even go for the Microsoft certification. Excel is one of the most requested analysis tools that are requested in the job market, and the ability to being able to use it at an advanced level could be very useful for your current work, and your next job hunt. This course comes in three parts: Part 1 - Creating Pivot Tables and Pivot Charts This part of the course covers one of the most useful, but scariest-sounding, functions in Microsoft Excel; PIVOT TABLES. It sounds difficult, but in fact can be done in just a few clicks. We'll do our first one in a couple of minutes - that's all it takes. We'll also add a chart as well in that time. After only these first few minutes, you will be streets ahead of anyone who doesn't know anything about Pivot Tables - it is really that important. After this introduction, we'll go into some detail into how to set up your Pivot Table - the initial data, and the various options that are available to you. We will go into advanced options that most people don't even know about, but which are very useful. By the end, you will be an Expert user of Pivot Tables, able to create reliable analyses which are able to be drilled-down quickly, and you'll be able to help others with their data analysis. Part 2 - Get and Transform Data (also known as Prepare the Data) We see how data can be transformed, saving you time in analysing the data. We'll look at sorting and filtering, split columns, and other transform activities. We'll merge, append and combine queries together. We'll Pivot and Unpivot, and transform text, numbers, dates and times, and create custom columns using the M language. Part 3 - Refining the model (also known as Model the Data) We'll see how relationships can be made through multiple tables, and refine the data with custom columns and measures using the DAX language. The course will take around 16 hours to complete, but completing this will enable you to create vizzes, dashboards and stories of your own, and know how to overcome common problems. The course increases in difficulty slowly, so you'll create for instance a table or basic bar chart, then turn it into a stacked bar chart, and investigate more of their properties, step by step. The course is fairly relaxed - there will be a few "wrong turns", so you can see what problems might arise, but every lesson works towards an end goal at a relatively slow pace, so you can follow on your own computer easily. I assume that you know how to use a computer, including installing programs, but the actual analysis will be at a basic level, and I'll introduce every component as we go on. At the end of the course, you can download a certificate of completion, so you can show everyone your new-found skills, and be able to start creating analyses for yourselves. Please note: Microsoft will retire the 70-779 exam on 31 January 2021. No replacement has yet been given by Microsoft. Who this course is for: This reporting course is meant for anyone who has no prior, or only a little experience of Pivot Tables, Get and Transform, and Power Pivot. No prior experience in reporting tools is required. This course is probably not for you if you always know how to how to do the advanced functionality of Get and Transform and Power Pivots, although we will be looking at some more advanced topics, including the M and DAX languages. Show more Show less Course content 31 sections • 208 lectures • 16h 51m total length Expand all sections Introduction 5 lectures • 12min Introduction Preview 01:33 Welcome to Udemy 00:35 The Udemy Interface 02:00 Curriculum Preview 07:31 Resources 00:23 Creating our first PivotTable and PivotChart 6 lectures • 21min Our first PivotTable Preview 08:15 PivotTable Menus 02:15 Our first PivotChart 03:43 PivotChart Menus and An Introduction to Practice Activity 1 03:25 Practice Activity Number 1 00:08 Answer to Practice Activity 1 03:40 Expanding our PivotTable 9 lectures • 32min Source data requirements 04:53 Adding additional values 04:44 Recommended PivotTables 02:51 Moving PivotTable 03:16 Refresh PivotTable - why it doesn't auto-update 05:17 Extracting data 05:28 Sorting 02:35 Practice Activity Number 2 00:24 Answer to Practice Activity 2 02:10 Going deeper in our PivotTable 14 lectures • 56min Adding additional row fields 03:51 Different layouts – Compact, Outline and Tabular 05:00 Blank Rows 04:17 Group Records 04:55 Showing or hiding additional detail - the +/- buttons 03:33 Adding columns 04:34 Adding page fields 03:48 Adding filters 08:22 Changing source 03:26 Using a table source 04:02 Other PivotTable - Analyze options 04:01 Introduction to Practice Activity 3 01:48 Practice Activity Number 3 00:31 Answers to Practice Activity 3 03:32 Modify field selections 9 lectures • 45min Change aggregate (COUNT, MIN, MAX) 07:20 Repeat All 04:28 Using Conditional Formatting to hide Repeat All 04:25 Grand Totals 06:39 Adding subtotals 08:06 Show items with no data 05:31 Other field settings 06:33 Practice Activity Number 4 00:14 Answers to Practice Activity 4 02:11 PivotTable Options 7 lectures • 33min Layout 09:52 Totals & Filters, and Alt Text 04:54 Display 03:02 Print 04:29 Data 08:29 Practice Activity Number 5 00:14 Answers to Practice Activity 5 01:54 Slicers 6 lectures • 20min Create slicers 02:20 Identifying impossible options, and selecting more than one option at once. 03:29 Join to multiple PivotTables 04:12 Options 04:38 Practice Activity Number 6 00:35 Answer to Practice Activity 6 04:49 Dates and Timeline 5 lectures • 20min Aggregates 03:59 Group by time period 06:33 Timelines 05:43 Practice Activity Number 7 00:19 Answer to Practice Activity 7 02:57 Formatting 10 lectures • 59min Formatting number values 04:37 Custom Formatting - number formatting 08:25 Custom Formatting - dates and text 09:32 Custom Formatting - sections and colors 08:17 Conditional Formatting - Highlighting cells 07:28 Conditional Formatting - Data Bars and Color Sets 07:13 Formatting printing 05:19 Styles 04:20 Practice Activity Number 8 00:16 Answer to Practice Activity 8 03:47 Advanced calculations 7 lectures • 36min Percentage of total 07:47 Percentage of total - Advanced 06:41 Cumulative totals 03:59 Rank and Index 04:35 Difference from 03:42 Calculated fields 04:05 Calculated Items 05:02 21 more sections Instructor Phillip Burton Best Selling Instructor - over 340,000 students so far 4.5 Instructor Rating 53,317 Reviews 346,028 Students 48 Courses Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist. He enjoys investigating data, which allows him to maintain up to date and pro-active systems to help control and monitor day-to-day activities. He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation. He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015. His interests are working with data, including Microsoft Excel, Access and SQL Server. 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:'678136499b9bf3eb',m:'5fffd66cfcfdaccc91a33362f6c94122236abd20-1627843407-1800-AcO4M4iqLWcrHCP0Sqd1OuwQ1/ylnjFZ5T9CWQhzR3IAtCvjAR+26dERsNWwLFOABqVfMTgenHhUDHsBu/Ko1QMMdgAZBIPCRMgPfH8JZ7YP57Tgc7ntWn7pDFGj8BwZlr8Ogn+lUNdi1DAcLH66bN1vk2Bd/TXcoEp1sNWKweVXxagDVsBrBLCmOYLAJiTxjdR49MSUKPp/R5q9R+wzicI=',s:[0xbfe70788b7,0x32ddc23cff],}})();
  4. Building and refine models, including adding calculated columns and measures. You will learn the important M and DAX functions, to enable you to build your own formulas. Curated for the Udemy Business collection Requirements Before you begin this course, you should have a PC with Microsoft Excel 2016 or later. The first part of this course will work with Macs, but the second and third parts are not compatible with the Mac version of Excel. (It will work if you are using the PC version of Excel, including using Parallel Desktop.) You should also know how to open an Excel workbook, and have an interest in analysis. It would also be good if you had prior experience in using Excel formulas, but that is not essential. That's it! The more experience in using Excel, the better, but it is not essential. Description This course covers the visualizations and analysing content required for Microsoft's 70-779 certification exam. (Note: this exam is no longer available, but the topics are well worth learning!) Reviews Nora: "I liked that it went through really fast through the process, as expected if you consider yourself an advanced Excel user. Really enjoyable" Dilbag: "Phillip's presentation of content is amazing. He has in-depth knowledge of the subject. I would highly recommend this course." Amy: "I want to add how this course is by far the best one I have found on the subject. It really delves deeply into each piece of material. While many courses focus on getting you ready for the exam, this one makes sure you know how to use it in the real world as well. I would suggest this course to anyone who not only wants to pass the 70-779 test, but utilize it in their job." Khalid: "Great great teacher. knowledgable in the tech and its usages, Speed, info delivery, and his voice is friendly. I'm lucky to choose this course over another one ;). Thank you all" ---------------- Do you already use the PC version of Excel to create data analysis, but find that you need to create more advanced analyses? Do you want to combine various sets of data, and or manipulate existing data sets? Do you want to save time, and have your analysis be automatically refreshed with new data? In this course, learn the skills that Microsoft want you to know, and add another tool to your CV, and even go for the Microsoft certification. Excel is one of the most requested analysis tools that are requested in the job market, and the ability to being able to use it at an advanced level could be very useful for your current work, and your next job hunt. This course comes in three parts: Part 1 - Creating Pivot Tables and Pivot Charts This part of the course covers one of the most useful, but scariest-sounding, functions in Microsoft Excel; PIVOT TABLES. It sounds difficult, but in fact can be done in just a few clicks. We'll do our first one in a couple of minutes - that's all it takes. We'll also add a chart as well in that time. After only these first few minutes, you will be streets ahead of anyone who doesn't know anything about Pivot Tables - it is really that important. After this introduction, we'll go into some detail into how to set up your Pivot Table - the initial data, and the various options that are available to you. We will go into advanced options that most people don't even know about, but which are very useful. By the end, you will be an Expert user of Pivot Tables, able to create reliable analyses which are able to be drilled-down quickly, and you'll be able to help others with their data analysis. Part 2 - Get and Transform Data (also known as Prepare the Data) We see how data can be transformed, saving you time in analysing the data. We'll look at sorting and filtering, split columns, and other transform activities. We'll merge, append and combine queries together. We'll Pivot and Unpivot, and transform text, numbers, dates and times, and create custom columns using the M language. Part 3 - Refining the model (also known as Model the Data) We'll see how relationships can be made through multiple tables, and refine the data with custom columns and measures using the DAX language. The course will take around 16 hours to complete, but completing this will enable you to create vizzes, dashboards and stories of your own, and know how to overcome common problems. The course increases in difficulty slowly, so you'll create for instance a table or basic bar chart, then turn it into a stacked bar chart, and investigate more of their properties, step by step. The course is fairly relaxed - there will be a few "wrong turns", so you can see what problems might arise, but every lesson works towards an end goal at a relatively slow pace, so you can follow on your own computer easily. I assume that you know how to use a computer, including installing programs, but the actual analysis will be at a basic level, and I'll introduce every component as we go on. At the end of the course, you can download a certificate of completion, so you can show everyone your new-found skills, and be able to start creating analyses for yourselves. Please note: Microsoft will retire the 70-779 exam on 31 January 2021. No replacement has yet been given by Microsoft. Who this course is for: This reporting course is meant for anyone who has no prior, or only a little experience of Pivot Tables, Get and Transform, and Power Pivot. No prior experience in reporting tools is required. This course is probably not for you if you always know how to how to do the advanced functionality of Get and Transform and Power Pivots, although we will be looking at some more advanced topics, including the M and DAX languages. Show more Show less Course content 31 sections • 208 lectures • 16h 51m total length Expand all sections Introduction 5 lectures • 12min Introduction Preview 01:33 Welcome to Udemy 00:35 The Udemy Interface 02:00 Curriculum Preview 07:31 Resources 00:23 Creating our first PivotTable and PivotChart 6 lectures • 21min Our first PivotTable Preview 08:15 PivotTable Menus 02:15 Our first PivotChart 03:43 PivotChart Menus and An Introduction to Practice Activity 1 03:25 Practice Activity Number 1 00:08 Answer to Practice Activity 1 03:40 Expanding our PivotTable 9 lectures • 32min Source data requirements 04:53 Adding additional values 04:44 Recommended PivotTables 02:51 Moving PivotTable 03:16 Refresh PivotTable - why it doesn't auto-update 05:17 Extracting data 05:28 Sorting 02:35 Practice Activity Number 2 00:24 Answer to Practice Activity 2 02:10 Going deeper in our PivotTable 14 lectures • 56min Adding additional row fields 03:51 Different layouts – Compact, Outline and Tabular 05:00 Blank Rows 04:17 Group Records 04:55 Showing or hiding additional detail - the +/- buttons 03:33 Adding columns 04:34 Adding page fields 03:48 Adding filters 08:22 Changing source 03:26 Using a table source 04:02 Other PivotTable - Analyze options 04:01 Introduction to Practice Activity 3 01:48 Practice Activity Number 3 00:31 Answers to Practice Activity 3 03:32 Modify field selections 9 lectures • 45min Change aggregate (COUNT, MIN, MAX) 07:20 Repeat All 04:28 Using Conditional Formatting to hide Repeat All 04:25 Grand Totals 06:39 Adding subtotals 08:06 Show items with no data 05:31 Other field settings 06:33 Practice Activity Number 4 00:14 Answers to Practice Activity 4 02:11 PivotTable Options 7 lectures • 33min Layout 09:52 Totals & Filters, and Alt Text 04:54 Display 03:02 Print 04:29 Data 08:29 Practice Activity Number 5 00:14 Answers to Practice Activity 5 01:54 Slicers 6 lectures • 20min Create slicers 02:20 Identifying impossible options, and selecting more than one option at once. 03:29 Join to multiple PivotTables 04:12 Options 04:38 Practice Activity Number 6 00:35 Answer to Practice Activity 6 04:49 Dates and Timeline 5 lectures • 20min Aggregates 03:59 Group by time period 06:33 Timelines 05:43 Practice Activity Number 7 00:19 Answer to Practice Activity 7 02:57 Formatting 10 lectures • 59min Formatting number values 04:37 Custom Formatting - number formatting 08:25 Custom Formatting - dates and text 09:32 Custom Formatting - sections and colors 08:17 Conditional Formatting - Highlighting cells 07:28 Conditional Formatting - Data Bars and Color Sets 07:13 Formatting printing 05:19 Styles 04:20 Practice Activity Number 8 00:16 Answer to Practice Activity 8 03:47 Advanced calculations 7 lectures • 36min Percentage of total 07:47 Percentage of total - Advanced 06:41 Cumulative totals 03:59 Rank and Index 04:35 Difference from 03:42 Calculated fields 04:05 Calculated Items 05:02 21 more sections Instructor Phillip Burton Best Selling Instructor - over 340,000 students so far 4.5 Instructor Rating 53,317 Reviews 346,028 Students 48 Courses Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist. He enjoys investigating data, which allows him to maintain up to date and pro-active systems to help control and monitor day-to-day activities. He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation. He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015. His interests are working with data, including Microsoft Excel, Access and SQL Server. 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:'678136499b9bf3eb',m:'5fffd66cfcfdaccc91a33362f6c94122236abd20-1627843407-1800-AcO4M4iqLWcrHCP0Sqd1OuwQ1/ylnjFZ5T9CWQhzR3IAtCvjAR+26dERsNWwLFOABqVfMTgenHhUDHsBu/Ko1QMMdgAZBIPCRMgPfH8JZ7YP57Tgc7ntWn7pDFGj8BwZlr8Ogn+lUNdi1DAcLH66bN1vk2Bd/TXcoEp1sNWKweVXxagDVsBrBLCmOYLAJiTxjdR49MSUKPp/R5q9R+wzicI=',s:[0xbfe70788b7,0x32ddc23cff],}})();
  5. You will learn the important M and DAX functions, to enable you to build your own formulas. Curated for the Udemy Business collection Requirements Before you begin this course, you should have a PC with Microsoft Excel 2016 or later. The first part of this course will work with Macs, but the second and third parts are not compatible with the Mac version of Excel. (It will work if you are using the PC version of Excel, including using Parallel Desktop.) You should also know how to open an Excel workbook, and have an interest in analysis. It would also be good if you had prior experience in using Excel formulas, but that is not essential. That's it! The more experience in using Excel, the better, but it is not essential. Description This course covers the visualizations and analysing content required for Microsoft's 70-779 certification exam. (Note: this exam is no longer available, but the topics are well worth learning!) Reviews Nora: "I liked that it went through really fast through the process, as expected if you consider yourself an advanced Excel user. Really enjoyable" Dilbag: "Phillip's presentation of content is amazing. He has in-depth knowledge of the subject. I would highly recommend this course." Amy: "I want to add how this course is by far the best one I have found on the subject. It really delves deeply into each piece of material. While many courses focus on getting you ready for the exam, this one makes sure you know how to use it in the real world as well. I would suggest this course to anyone who not only wants to pass the 70-779 test, but utilize it in their job." Khalid: "Great great teacher. knowledgable in the tech and its usages, Speed, info delivery, and his voice is friendly. I'm lucky to choose this course over another one ;). Thank you all" ---------------- Do you already use the PC version of Excel to create data analysis, but find that you need to create more advanced analyses? Do you want to combine various sets of data, and or manipulate existing data sets? Do you want to save time, and have your analysis be automatically refreshed with new data? In this course, learn the skills that Microsoft want you to know, and add another tool to your CV, and even go for the Microsoft certification. Excel is one of the most requested analysis tools that are requested in the job market, and the ability to being able to use it at an advanced level could be very useful for your current work, and your next job hunt. This course comes in three parts: Part 1 - Creating Pivot Tables and Pivot Charts This part of the course covers one of the most useful, but scariest-sounding, functions in Microsoft Excel; PIVOT TABLES. It sounds difficult, but in fact can be done in just a few clicks. We'll do our first one in a couple of minutes - that's all it takes. We'll also add a chart as well in that time. After only these first few minutes, you will be streets ahead of anyone who doesn't know anything about Pivot Tables - it is really that important. After this introduction, we'll go into some detail into how to set up your Pivot Table - the initial data, and the various options that are available to you. We will go into advanced options that most people don't even know about, but which are very useful. By the end, you will be an Expert user of Pivot Tables, able to create reliable analyses which are able to be drilled-down quickly, and you'll be able to help others with their data analysis. Part 2 - Get and Transform Data (also known as Prepare the Data) We see how data can be transformed, saving you time in analysing the data. We'll look at sorting and filtering, split columns, and other transform activities. We'll merge, append and combine queries together. We'll Pivot and Unpivot, and transform text, numbers, dates and times, and create custom columns using the M language. Part 3 - Refining the model (also known as Model the Data) We'll see how relationships can be made through multiple tables, and refine the data with custom columns and measures using the DAX language. The course will take around 16 hours to complete, but completing this will enable you to create vizzes, dashboards and stories of your own, and know how to overcome common problems. The course increases in difficulty slowly, so you'll create for instance a table or basic bar chart, then turn it into a stacked bar chart, and investigate more of their properties, step by step. The course is fairly relaxed - there will be a few "wrong turns", so you can see what problems might arise, but every lesson works towards an end goal at a relatively slow pace, so you can follow on your own computer easily. I assume that you know how to use a computer, including installing programs, but the actual analysis will be at a basic level, and I'll introduce every component as we go on. At the end of the course, you can download a certificate of completion, so you can show everyone your new-found skills, and be able to start creating analyses for yourselves. Please note: Microsoft will retire the 70-779 exam on 31 January 2021. No replacement has yet been given by Microsoft. Who this course is for: This reporting course is meant for anyone who has no prior, or only a little experience of Pivot Tables, Get and Transform, and Power Pivot. No prior experience in reporting tools is required. This course is probably not for you if you always know how to how to do the advanced functionality of Get and Transform and Power Pivots, although we will be looking at some more advanced topics, including the M and DAX languages. Show more Show less Course content 31 sections • 208 lectures • 16h 51m total length Expand all sections Introduction 5 lectures • 12min Introduction Preview 01:33 Welcome to Udemy 00:35 The Udemy Interface 02:00 Curriculum Preview 07:31 Resources 00:23 Creating our first PivotTable and PivotChart 6 lectures • 21min Our first PivotTable Preview 08:15 PivotTable Menus 02:15 Our first PivotChart 03:43 PivotChart Menus and An Introduction to Practice Activity 1 03:25 Practice Activity Number 1 00:08 Answer to Practice Activity 1 03:40 Expanding our PivotTable 9 lectures • 32min Source data requirements 04:53 Adding additional values 04:44 Recommended PivotTables 02:51 Moving PivotTable 03:16 Refresh PivotTable - why it doesn't auto-update 05:17 Extracting data 05:28 Sorting 02:35 Practice Activity Number 2 00:24 Answer to Practice Activity 2 02:10 Going deeper in our PivotTable 14 lectures • 56min Adding additional row fields 03:51 Different layouts – Compact, Outline and Tabular 05:00 Blank Rows 04:17 Group Records 04:55 Showing or hiding additional detail - the +/- buttons 03:33 Adding columns 04:34 Adding page fields 03:48 Adding filters 08:22 Changing source 03:26 Using a table source 04:02 Other PivotTable - Analyze options 04:01 Introduction to Practice Activity 3 01:48 Practice Activity Number 3 00:31 Answers to Practice Activity 3 03:32 Modify field selections 9 lectures • 45min Change aggregate (COUNT, MIN, MAX) 07:20 Repeat All 04:28 Using Conditional Formatting to hide Repeat All 04:25 Grand Totals 06:39 Adding subtotals 08:06 Show items with no data 05:31 Other field settings 06:33 Practice Activity Number 4 00:14 Answers to Practice Activity 4 02:11 PivotTable Options 7 lectures • 33min Layout 09:52 Totals & Filters, and Alt Text 04:54 Display 03:02 Print 04:29 Data 08:29 Practice Activity Number 5 00:14 Answers to Practice Activity 5 01:54 Slicers 6 lectures • 20min Create slicers 02:20 Identifying impossible options, and selecting more than one option at once. 03:29 Join to multiple PivotTables 04:12 Options 04:38 Practice Activity Number 6 00:35 Answer to Practice Activity 6 04:49 Dates and Timeline 5 lectures • 20min Aggregates 03:59 Group by time period 06:33 Timelines 05:43 Practice Activity Number 7 00:19 Answer to Practice Activity 7 02:57 Formatting 10 lectures • 59min Formatting number values 04:37 Custom Formatting - number formatting 08:25 Custom Formatting - dates and text 09:32 Custom Formatting - sections and colors 08:17 Conditional Formatting - Highlighting cells 07:28 Conditional Formatting - Data Bars and Color Sets 07:13 Formatting printing 05:19 Styles 04:20 Practice Activity Number 8 00:16 Answer to Practice Activity 8 03:47 Advanced calculations 7 lectures • 36min Percentage of total 07:47 Percentage of total - Advanced 06:41 Cumulative totals 03:59 Rank and Index 04:35 Difference from 03:42 Calculated fields 04:05 Calculated Items 05:02 21 more sections Instructor Phillip Burton Best Selling Instructor - over 340,000 students so far 4.5 Instructor Rating 53,317 Reviews 346,028 Students 48 Courses Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist. He enjoys investigating data, which allows him to maintain up to date and pro-active systems to help control and monitor day-to-day activities. He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation. He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015. His interests are working with data, including Microsoft Excel, Access and SQL Server. 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:'678136499b9bf3eb',m:'5fffd66cfcfdaccc91a33362f6c94122236abd20-1627843407-1800-AcO4M4iqLWcrHCP0Sqd1OuwQ1/ylnjFZ5T9CWQhzR3IAtCvjAR+26dERsNWwLFOABqVfMTgenHhUDHsBu/Ko1QMMdgAZBIPCRMgPfH8JZ7YP57Tgc7ntWn7pDFGj8BwZlr8Ogn+lUNdi1DAcLH66bN1vk2Bd/TXcoEp1sNWKweVXxagDVsBrBLCmOYLAJiTxjdR49MSUKPp/R5q9R+wzicI=',s:[0xbfe70788b7,0x32ddc23cff],}})();