Advanced Excel2018-08-25T12:45:47+00:00

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