What is going to be covered in this best Advanced Excel Access Training in Mohali
Using advanced graphs and presentation techniques to maximize impact.
How macros and VBA automate your spreadsheets and increase interactivity.
How superpower functions can solve complex problems.
Using PivotTables and PowerPivots to turn raw data into clear information that supports key decisions.
Session 1: Introduction
Introduction
Interface
Tabs and Ribbons
Document Windows
Navigation Tips
Office Button and Save
Session 2:
Entering, Editing and Formatting Data
Introduction
Entering Data
Fonts, Fills, and Alignment
Cut, Copy, and Paste
Paste Special
Undo and Redo
Moving, Finding, and Replacing a Value
Cell Styles
Comments
Session 3: Formatting Numbers
Introduction
Currency Format
Format Painter
Formatting Dates
Custom and Special Formats
Session 4: Managing Worksheets
Introduction
Naming and Moving Worksheets
Copying Worksheets
Adding, Deleting and Hiding Worksheets
Grouping Worksheets
Moving, Copying, Deleting and Hiding Grouped Worksheets
Session 5: Modifying Rows and Columns
Introduction
Inserting and Deleting Columns and Rows
Inserting & Deleting Cells
Inserting Multiple Columns & Rows
Modifying Cell Width and Height
Hiding and Unhiding Rows and Columns
Session 6: Understanding Formulas
Introduction
Using Operations
Creating Formulas
AutoSum
Common Formulas
Searching for Formulas
Copying Formulas
Using Relative and Absolute References
Session 7: Changing Views
Introduction
Workbook Views
Show/Hide
Zoom Features
Freeze Panes
Split Windows
Viewing Multiple Windows
Minimize the Ribbon
Worksheet Backgrounds
Watermarks
Session 8: AutoFill and Custom Lists
Introduction
AutoFill a Series
AutoFill Non-Adjacent Cells
AutoFill on Multiple Sheets
Creating Custom Lists
Series Formatting
Session 9: Conditional Formatting
Introduction
Highlight Cells Rules
Top/Bottom Rules
Data Bars
Color Scales
Custom Formatting Rule
Session 10: Tables
Introduction
Insert a Table and Style Options
Add Rows and Columns
Perform a Function in a Table
Summarise With Pivot Table
Session 11: Data Tools
Introduction
Data Validation
Drop-Down Lists
Removing Duplicates
Text to Columns
Goal Seek
Scenario Manager
Session 12: Referencing Formulas
Introduction
Multiple Sheet References
Consolidating Data - With or Without Links
Trace the Precedents and Dependents
Using the Watch Window
Session 13: Ranges and Dates
Introduction
Cell Names
Named Ranges
Formulas with Cell Names
Date Formulas
Session 14: Lookups
Introduction
VLOOKUP
VLOOKUP Exact Match
HLOOKUP
HLOOKUP Exact Match
Session 15: Conditional Logic
Introduction
IF Statement
Nested IF
AND
OR
NOT
IFERROR
SUM IF
AVERAGE IF
COUNT IF & COUNT IFS
SUMIFS
AVERAGE IFS
Session 16: Text Formulas
Introduction
Case Formulas
Fix Number Fields
Trim Spaces
Substitute Text
Session 17: Introduction to Charts
Introduction
Chart Types
Instant Chart
Update Chart
Column Chart
Picture Fill
Adjust Chart Size
Line Chart
Scatter Chart
Session 18: Formatting Charts
Introduction
Chart Styles
Chart Layouts
Add Labels
Axis Options
Chart Title
Legends
Data Labels
Session 19: Adding Graphics to Spreadsheets
Introduction
Insert Pictures
Modifying Pictures
Insert Shapes
Insert SmartArt
Apply Themes
Arrange
Session 20: Outline, Sort, Filter, and Subtotal
Introduction
Group and Ungroup
Sort Data
Sort Multiple Levels
Filter Data
Advanced Filter
Conditional Sorting and Filtering
Sorting with Custom Lists
Subtotal
Session 21: PivotTables
Introduction
Creating PivotTables
Choosing Fields
PivotTable Layout
Filtering PivotTables
Modifying PivotTable Data
Pivot Charts
Session 22:
Protecting Data
Introduction
Workbook Passwords
Protecting Workbooks
Unlocking Cells
Session 23: Collaboration
Introduction
Document Properties
Inserting Hyperlinks
Sharing a Workbook
Track Changes
Accept/Reject Changes
Mark as Final
Session 24: Printing
Introduction
Page Orientation
Page Breaks
Print Area
Margins
Print Titles
Headers and Footers
Scaling
Sheet Options
Session 25: Saving a Workbook
Introduction
Save As Previous Version
AutoRecover Save Options
Templates
Save As PDF
Save As Web Page
Macro-Enabled Workbook
Session 26: Macros
Introduction and Macro Security
Recording a Macro
Assign a Macro to a Button or Shape
Run a Macro upon Opening a Workbook
How to Inspect and Modify a Macro