About Workshop
Introduction
Microsoft Excel is most widely used productivity tool in today’s corporate world and education sector. Day to day corporate analysis, reporting, tools and applications are prepared with Excel. It will be an advantage for course attendees to learn practical and advanced usages of Excel for office and academic activities. Excel allows us to accomplish a task in multiple ways which will be shown to attendees with Pros and Cons of the methods.
How participants will benefit after the course
HANDS ON EXPERIENCES. Most widely practiced Excel topics are covered in the course syllabus with practical exercises. Participants will do the live exercises along with the trainer to learn faster and effectively. Learning the required Excel functionalities in course will ensure participants high performance in their career and academics.
Workshop topics to be covered:
Charts and Trend lines
Working with Chart Components (Axis, Categories, Series, Legend)
Resizing, Moving and Copying Charts
Formatting and Styling Charts with 2D, 3D and Round effect
Using multiple combination chart types in a single chart
Solving Yearly Chart Problem
Selecting the appropriate Chart Type and Format
Creating Column, Line, Pie, Bar, Area and Scatter Charts
Copying a Chart Format to other charts
Dual Axis chart (Primary & Secondary Axis)
Creating a Chart ONLY Sheet
Chart Trend lines (Linear, Exponential, Polynomial and Moving Avg)
PivotTable and PivotChart
Arranging Pivot Fields in Report Layouts (Row Label, Column Label, Values)
Grouping and comparing Dates by Month, Year, Quarter and Days
Working with Report Filter options
Subtotalling and Counting data using pivot table
Analyzing Difference, Growth and % of Total with pivot
Working with Subtotal, Row Total and Grand Total options
Pivot Date filtering with Days, Weeks, Months, Quarters and Years
Filtering of Top 10 or Bottom 10 items
Inserting Formulas in pivot using calculated fields
Add new data to pivot data source and auto update pivot accordingly
Custom Grouping of pivot Text data
Removing a pivot tables from a worksheet
Creating more copies of pivots from an existing pivot
Moving a pivot table to existing or new sheet
Sorting pivot data by simply typing
Solving the Report Filter values sorting problem
Generate multiple sub-report pages from master report
Handling Empty Cells and Error values
Removing the blank word from pivot
Changing pivot's existing data source
Working with dynamic Pivot Charts
Data Drilling or Mining in pivot
Formatting Number, Date and Text
Solving pivot Date displaying problem
Time saving tips for pivots with large data source
Working with PivotTable Options
Functions(Lookup)
Lookup vertically using VLOOKUP
Powerful VLOOKUP instead of Nested IF
Lookup horizontally using HLOOKUP
Single Criteria based LOOKUP
Multiple Criteria based LOOKUP
Advanced Lookup using INDEX- MATCH function
Technique for Two-way lookup (vertical-horizontal) at once
![](Templates/"../images/bodyedge_tr.gif"width="2"){kind=small}
![](Templates/"../images/bodyedge_tl.gif"width="2"){kind=small}
