Pivot Tables and Pivot Charts
Working With Pivot Tables
Examine Pivot Tables
Pivot Table from Another Worksheet
Adding Calculated Fields
Using fields to filter Data
changing Source
Inserting Slicers
Using Slicers to filter Data
Modify Slicers
Rearranging Pivot Table
Refreshing Pivot Table Data
Using Pivot Chart
Creating Pivot Chart
Changing the view of Pivot Chart
Using with Different Pivot Charts
Conditional Formatting and Data Tools
Formatting Data on Conditions
Highlight Duplicate and Unique Value
Finding Top 5/10 items in the Data
Formatting Data using Data Bars and Icons
Customize conditional Formatting
Clearing and Managing Rules
Summarizing data (consolidate)
Creating Sub Totals
Sorting and Filtering
Advance Filtering on more than 1 Criteria
Extracting Unique Value from Filtering
Advance filter with copy another location
Text to Columns
Cells and Range Names
Creating and Using Names
Defining names for Cells or Range
Using Named Range as a reference in Formula
Apply Shortcuts to define name
Managing Names
Using Name manager to change and Deleting Names
Lookups
Lookup
Vlookup
Hlookup
Use VLOOKUP to find exact matches
Use VLOOKUP to find Approximate matches
Use HLOOKUP to find exact matches
Use HLOOKUP to find Approximate matches
Using MATCH AND INDEX
The MATCH Function
The INDEX Function
Logical and Statistical Functions
The IF Function
Nested IF Function
Rank and IFAND Function
Count, Countif, Countifs ,Counta and Countblank
Sum, Sumif and Sumifs
Average and Averageif
Round Function
Financial and Date Function
Financial Function
PMT FUNCTION
Creating Variable Data Tables
DATE And Time Function
Today
Now
Date
Managing Large Work Book
Viewing Large Work Sheet
Locking Row and Columns
Opening and Arranging Windows
Splitting a work Sheets
Hiding rows and columns
Hiding and Unhiding Worksheets
Print Title
Page Breaks
Adding Headers and Footers
Rename Work Sheet
Formatting Worksheet Table
Inserting Worksheets
Moving and Copying Work Sheets
Page orientation and size
Printing.
Advanced Data Management
Validating Cell Entries
Validating Data
Setting Data Validation Rules
Using Date in Validation Rule
Create Dropdown List in a Cell
Data Validation Error Message
Documenting and Auditing
Auditing Features
Tracing Cell Values
Tracing Errors in worksheet
Comments in Cells
Viewing Comments
Adding and Managing All Comments
Comments Display Option
Protection
Applying password to protect a worksheet
Protecting parts of a worksheet
Protecting Cells and Columns
Allowing Permission for Editing
Sharing Workbook
Insert background
Change Themes
Advanced Formatting
Using Special Number Formats
Custom Number Formats
Zero Values
Upper, Lower and Proper Function
Apply Currency Format
Date and Time Formats
Merging Cells
Wrap Text
Using Paste Special
Adding Background
Cell Orientation
Charts
Charts Basics
Creating and Moving Charts
Chart Data
Moving charts with in the text box
Chart Elements
Types of Charts
Charts Style and Layout
Adding and Formatting Chart Elements
Axis Title
Legends
Advanced Charting
Chart formatting option
Changing chart type
Formatting Data Points
Pie Charts
Combination Charts
Adding Axis
Adding Trend Line
Adding Spark Line
Adding Pictures
Modifying Pictures
Your Content Goes Here