Business Reporting with PivotTables
Course Description PivotTables are widely used feature of Microsoft Excel that ensures a compact solution of Business Reporting and Presentation. This course demonstrates the use of PivotTables to summarize, sort, count, chart and make a dynamic presentation of your data in Microsoft Excel using some practical business case. Author Rupom shows you how to navigate the complexity of PivotTables while taking advantage of their power. This course shows how to build PivotTables from single or multiple data sources, add calculated fields, filter your results, and format your layout to make it more readable and business-oriented. Plus, learn how to create …
Curriculum
Overview
Course Description
PivotTables are widely used feature of Microsoft Excel that ensures a compact solution of Business Reporting and Presentation. This course demonstrates the use of PivotTables to summarize, sort, count, chart and make a dynamic presentation of your data in Microsoft Excel using some practical business case. Author Rupom shows you how to navigate the complexity of PivotTables while taking advantage of their power. This course shows how to build PivotTables from single or multiple data sources, add calculated fields, filter your results, and format your layout to make it more readable and business-oriented. Plus, learn how to create PivotCharts to visualize your data, enhance PivotTables with macros, and use the Data Model feature to build PivotTables from related tables.
Audience
The course is useful for a Student to Corporate Professionals to entrepreneurs. Practical demonstration of PivotTable will help a University student to prepare the report and present their course assignments, for an Entrepreneur to track the business update and make crucial business decisions by preparing dashboard reports and for a Corporate professional to analyze business data, prepare report and presentation.
Pre-requisite
The learner should be familiar with the Microsoft Excel platform and able to perform the simple calculations with Excel.
Learning Outcomes
- Identify how to format data for use in a PivotTable.
- Discover how to create a new PivotTable.
- Define how to connect to data sources.
- Evaluate and consolidate data from multiple data sources.
- Identify how to create calculated fields.
- Summarize field data.
- Review PivotTable sorting.
- Review PivotTable filters.
- Discover how to work with Excel slicers.
- Recall how to format PivotTables with styles and formats.
- Assess how to build PivotCharts.
- Assess how to run macros.
- Evaluate how to create a PivotTable using the data model.
- Prepare business dashboards and reporting.
Why This Course?
The course illustrates very detail step-by-step preparation and reporting techniques using PivotTables. In addition to that, the exercise files are designed in a manner so that it can be related to a Business Case scenario. A beginner user of PivotTables can transform her/him to an intermediate or even advanced level user after completion of the course. Thus, the language, exercise files, and video techniques are comprehensible for any level of user in Excel and regardless of their profession.
Notes:
- Download the exercise file from Lecture 1.3
- After completing each lesson, you have to click on the “COMPLETE” button to go to the next lesson.
- Must fill up your first name, last name then display name for your certificate.
- Complete every lesson of this course serially.
- Don’t click on “FINISH COURSE” button.
- If you click on the “FINISH COURSE” button then the course will be finished, you will unable to complete the next lessons or parts of this course and a Certificate will be generated.
Course Instructor
Md. Mehanazuddin Rupom