This free online course on Advanced Microsoft Excel PivotTables explains key functions and analysis in PivotTables. In this free online Advanced Microsoft Excel PivotTables course, you will be taken through how to make the most of powerful data analysis functions. You will be introduced to several techniques used for manipulating data in order to ensure the data is clean and consistent in PivotTables. By the end of this course, you will become better informed about the use of PivotTables in Excel.
| College | Alison |
| Course ID | 195451 |
| Course Type | Online Learning |
| Course Qualification | CPD Certificate |
| Course Duration | 1.5-3 hours |
| Course Fee | Free |
| Entry Requirements | Like all courses on the Alison Free Learning platform this is a free, CPD-accredited course. A Graduate can choose to buy a certificate or diploma upon successful completion of a course, but this is not required or necessary. At Alison we believe that free education, more than anything, has the power to break through boundaries and transform lives. Alison is the world’s largest free online empowerment platform for education and skills training, offering over 5000 CPD accredited courses and a range of impactful career development tools. It is a for-profit social enterprise dedicated to making it possible for anyone, to study anything, anywhere, at any time, for free online, at any subject level. Through our mission, we are a catalyst for positive social change, creating opportunity, prosperity, and equality for everyone. |
| Career Path | What You Will Learn In This Free Course • Describe how to put a Pivot together in Excel • Explain how to Import data from a text file • Discuss the process of Importing data from Access • Describe the cleaning of Data to use in a PivotTable • Discuss Tabular Data and setting up a Table • Explain the process of creating and Manipulating a PivotTable • Discuss the combination of Data from Multiple Worksheets • Explain Grouping and Ungrouping in a Pivot Table • Describe how to Report Layouts • Explains how to Format Error Values and Empty Cells • Differentiate PivotTable Styles and how to use them • Describe Custom Number Formatting in a Pivot Table |
| Course Code | 2504 |
This free online course on Advanced Microsoft Excel PivotTables explains key functions and analysis in PivotTables.
This course explores financial strategy for public managers, covering budgeting, financial statements, and cost analysis Join this course to dive into essential financial strategies for public managers.
Gain professional event planning and management skills and enhance your career prospects with this free online course.
This free online course uncovers how to raise ethical standards and perspectives in the real estate industry.
