Microsoft Advanced Excel Training – Analyzing Data With Pivot Tables & Pivot Charts Report
Date Listed 14/08/2019
MICROSOFT ADVANCED EXCEL – PIVOT TABLES & CHARTS REPORT TRAINING (1 Day) Introduction: Pivot table is one of the most powerful features of Excel. Pivot Table reports are especially well-suited for taking large amounts of data and summarizing it into useful reports. This course will begin with basic pivot tables and progresses to advanced pivot table topics covering insights into the inner workings of Pivot Tables, enabling analysis and preparation of reports to solve pressing business needs. Learning Outcomes Upon completion of this workshop, participants will be able to: •Create basic and advanced Excel pivot tables •Customized fields in a pivot table •Perform calculations within pivot tables •Structure and format your tables of raw data to easily allow for data analysis using pivot tables and pivot charts Target Audience: This course would benefit to Managers & Executives who needs to use Pivot Table Analysis Techniques to handle more complex data sets in order to prepare reports. Participants should have a strong grounding in Excel basic to intermediate knowledge. Course Outlines: Building a Pivot Table Create Pivot Table Create Multi Level Pivot Table Categorize Pivot Table Data Customize a Pivot Table Formatting Pivot Table Table Layout Formatting Value Field Setting Option Sorting & Filtering Using Field Header Changing Numeric Format Restructure a Pivot Table Create Custom Calculations in Pivot Table Changing Calculation Value Field Value Field Setting Summarize Values By Inserting Calculated Fields Inserting Calculated Items Refresh Pivot Table Update Pivot Table Change Pivot Source Inserting & Using Slicers In Pivot Tables To Filter Pivot Chart Formatting/ Modifying Slicers Slicer Setting Generating Pivot Chart Reports Create & Formatting Pivot Chart Change Pivot Chart Layout Switch Row / Column Adding & Modifying Chart Analysis Tools Terms Of Payment: 1. Enrollment fee is a one-time payment. Full Course fee must be made before course commencement. Payment Mode: Cash Only 2. Registration Fee Per Person - RM50 3. Booking/ Reservation has to be made a week earlier before course commencement. 4. After booking date of the course has been made, if the participant fails to attend / cancel / postpone the date and time, both registration & full course fees will not be returned.
Training Venue: Infomedia Computer Training Academy
Nusajaya , Johor Bahru
For course booking, appointment & registration , please contact us via phone at : +6012-7461582