Advance Microsoft Excel Course


 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

 



No comments:

Post a Comment