Advance Microsoft Excel Course Mohan Nagar, Delhi - 9250044755

 Contents                      

           ·Module 1:    Introduction

·Module 2 :   Entering, Editing and Formatting Data

·Module 3:    Formatting Numbers

·Module 4:    Managing Worksheets

· Module 5:    Modifying Rows and Columns

· Module 6:    Understanding Formulas

· Module 7:    Changing Views

·Module 8:    AutoFill and Custom Lists

·Module 9 :    Conditional Formatting

·Module 10:    Tables

·Module 11:    Data Tools

·Module 12:    Referencing Formulas

· Module 13:    Ranges and Dates

· Module 14:    Lookups

·Module 15:    Conditional Logic

·Module 16 :    Text Formulas

·Module 17:    Introduction to Charts

·Module 18:    Formatting Charts

·Module 19:    Adding Graphics to Spreadsheets

·Module 20:    Outline, Sort, Filter, and Subtotal

·Module 21:    PivotTables

·Module 22 :    Protecting Data

·Module 23:    Collaboration

·Module 24:    Printing

·Module 25:    Saving a Workbook

·Module 26:    Macros

Introduction

• Introduction
• Interface
• Tabs and Ribbons
• Document Windows
• Navigation Tips
• Office Button and Save

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

Formatting Numbers

• Introduction
• Currency Format
• Format Painter
• Formatting Dates
• Custom and Special Formats

Managing Worksheets

• Introduction
• Naming and Moving Worksheets
• Copying Worksheets
• Adding, Deleting and Hiding Worksheets
• Grouping Worksheets
• Moving, Copying, Deleting and Hiding Grouped Worksheets

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

Understanding Formulas

• Introduction
• Using Operations
• Creating Formulas
• AutoSum
• Common Formulas
• Searching for Formulas
• Copying Formulas
• Using Relative and Absolute References

Changing Views

• Introduction
• Workbook Views
• Show/Hide
• Zoom Features
• Freeze Panes
• Split Windows
• Viewing Multiple Windows
• Minimize The Ribbon
• Worksheet Backgrounds
• Watermarks

AutoFill and Custom Lists

•  Introduction
•  AutoFill a Series
•  AutoFill Non-Adjacent Cells
•  AutoFill on Multiple Sheets
•  Creating Custom Lists
•  Series Formatting

Conditional Formatting

• Introduction
• Highlight Cells Rules
• Top/Bottom Rules
• Data Bars
• Color Scales
• Custom Formatting Rule

Tables

•  Introduction
•  Insert a Table and Style Options
•  Add Rows and Columns
•  Perform a Function in a Table
•  Summarise With Pivot Table

Data Tools Data Tools

•  Introduction
•  Data Validation
•  Drop-Down Lists
•  Removing Duplicates
•  Text To Columns
•  Goal Seek
•  Scenario Manager

Referencing Formulas

•  Introduction
•  Multiple Sheet References
•  Consolidating Data - With or Without Links
•  Trace the Precedents and Dependents
•  Using the Watch Window

Ranges and Dates

• Introduction
• Cell Names
• Named Ranges
• Formulas with Cell Names
• Date Formulas

Lookups

•  Introduction
•  VLOOKUP
•  VLOOKUP Exact Match
•  HLOOKUP
•  HLOOKUP Exact Match

Conditional Logic

•  Introduction
•  IF Statement
•  Nested IF
•  AND
•  OR
•  NOT
•  IFERROR
•  SUMIF
•  AVERAGEIF
•  COUNTIF & COUNTIFS
•  SUMIFS
•  AVERAGEIF

Text Formulas

•  Introduction
•  Case Formulas
•  Fix Number Fields
•  Trim Spaces
•  Substitute Text

Introduction to Charts

•  Introduction
•  Chart Types
•  Instant Chart
•  Update Chart
•  Column Chart
•  Picture Fill
•  Adjust Chart Size
•  Line Chart
•  Scatter Chart

Formatting Charts

•  Introduction
•  Chart Styles
•  Chart Layouts
•  Add Labels
•  Axis Options
•  Chart Title
•  Legends
•  Data Labels

Adding Graphics to Spreadsheets

•  Introduction
•  Insert Pictures
•  Modifying Pictures
•  Insert Shapes
•  Insert SmartArt
•  Apply Themes
•  Arrange

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

PivotTables

•  Introduction
•  Creating PivotTables
•  Choosing Fields
•  PivotTable Layout
•  Filtering PivotTables
•  Modifying PivotTable Data
•  PivotCharts

Protecting Data

•  Introduction
•  Workbook Passwords
•  Protecting Workbooks
•  Unlocking Cells

Collaboration

•  Introduction
•  Document Properties
•  Inserting Hyperlinks
•  Sharing a Workbook
•  Track Changes
•  Accept/Reject Changes
•  Mark as Final

Printing

•  Introduction
•  Page Orientation
•  Page Breaks
•  Print Area
•  Margins
•  Print Titles
•  Headers and Footers
•  Scaling
•  Sheet Options

Saving a Workbook

•  Introduction
•  Save As Previous Version
•  AutoRecover Save Options
•  Templates
•  Save As PDF
•  Save As Web Page
•  Macro-Enabled Workbook

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

Our Location:-

Our Institute Provides Students are taught Professionally Advance Microsoft Excel Course Education in Every Cities of Delhi .Contact for More Details.- Sagarpur West | Sagarpur East | Desu Colony | Raghu Nagar | Madanpuri  | Mohan Nagar | Vashist Park | Durga Park | Jagdamba Vihar | Dabri  | Nangal Raya | Sitapuri  | Indra Park | Vijay Enclave | Mahavir Enclave | Nasirpur  | Madhu Vihar  | Dwarka More |  Dwarka Sector 3 |  Dwarka Sector 4 |  Dwarka Sector 12 |  Dwarka Sector 13 | Lajwanti Garden | Pankha Road | Manglapuri | Hari Nagar | Palam  | Raj Nagar  |  Sadh Nagar | Kailash Puri | Bindapur | Dashrath Puri | Delhi Cantt |  Mayapuri  | Jeewan Park  |  Janakpuri A Block | Janakpuri D Block | Janakpuri District Center  | Tilak Nagar  | Janakpuri C1 Block  |  Chanakya Place  | Uttam Nagar  | Mohan Garden  |  Nawada   |  Om Vihar  | Mansa Ram Park  |  Rama Park |  Dwarka etc.