No Events
Introduction
Effective business reporting is an essential tool for today’s business:
- Scheduling – employee or resource schedule
- Basic Accounting – Invoice, PO & Sales Report
- Product Tracking – Analyst Product Performance
- Return of Investment – Business Performance Report
- Customer Database – Update Customer Information
All the above are useful information for business success. In this Microsoft Excel training program, we explore the potential on how Pivot Table, Functions, and Formulas can help us to achieve the above mentioned in a fast and accurate maner.
Prerequisites
This program is suitable only for those who have attended Microsoft Excel Intermediate and Advance.
Course Objectives
After completing this course, students should be able to:
- Understand the benefits of PivotTable Reports
- Convert raw data in an Excel worksheet into meaningful PivotTables and PivotCharts
- Manipulate the PivotTable layout
- Use grouping
- Create custom calculations
- Use formulas and create formulas outside of a report
- Create a PivotChart and publish it to a Web site