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.


No comments:

Post a Comment

Thankyou Dear, for the feedback on your Experience with our Support Team.