By Stream Skill | in Online Courses
Pivot Tables is an essential Excel skill for jobs that involve analyzing and visualizing large amounts of data. Pivot Tables are an interactive way of quickly summarizing large amounts of data by grouping and aggregating sets of data and letting you analyze data in a clear and effective way. This course will discuss the importance of cleaning your data before you can create your first Pivot Table. You will also learn how to create Pivot Charts and how to format your Pivot Tables and Charts.
Important Details
Requirements
By Stream Skill | in Online Courses
In this Advanced PivotTables in Excel course, you'll learn how to make the most of this powerful data analysis function. PivotTables are ideal if you are looking to perform data analysis tasks quickly and efficiently in Excel. You'll get a PivotTable refresher and move on to some of the advanced features of this tool including Advanced Sorting, Slicers, Timelines, Calculated Fields, Pivot Charts, and Conditional Formatting. This course is aimed at intermediate users of Excel who are comfortable using the PivotTable function.
Important Details
Requirements
By Stream Skill | in Online Courses
A dashboard is a great way to visualize your data. An interactive dashboard allows you to change what results you see at the click of a button. This in-depth course will prepare your data for analysis, some essential formulas you’ll need to help you create dashboards in Excel, Pivot Tables, Pivot Charts, Form Controls and so much more. It takes you through how to combine all those skills to create a Sales Dashboard and an HR Dashboard in two, end of course projects. If you need to analyze and present data in Excel, then this course will show you step-by-step how to create jaw-dropping Excel dashboards that leave people wondering how you became that good in Excel!
Important Details
Requirements