MODULE NO.1 Introduction

• Introduction
• Interface
• Tabs and Ribbons
• Document Windows
• Navigation Tips
• Office Button and Save
• Entering, Editing and Formatting Data

• Entering Data
• Fonts, Fills, and Alignment
• Cut, Copy, and Paste
• Paste Special
• Undo and Redo
• Moving, Finding, and Replacing a Value
• Cell Styles
• Comments

MODULE NO.3 Formatting Numbers

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

MODULE NO.4 Managing Worksheets

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

MODULE NO.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

MODULE NO.6 Understanding Formulas

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

MODULE NO.7 Changing Views

• Introduction
• Workbook Views
• Show/Hide
• Zoom Features
• Freeze Panes

• Split Windows
• Viewing Multiple Windows
• Minimize the Ribbon
• Worksheet Backgrounds
• Watermarks

MODULE NO.8 AutoFill and Custom Lists

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

MODULE NO.9 Conditional Formatting

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

MODULE NO.10 Tables

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

MODULE NO.11 Data Tools

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

MODULE NO.12 Referencing Formulas

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

MODULE NO.13 Ranges and Dates

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

MODULE NO.14 Lookups

• Introduction
• VLOOKUP
• VLOOKUP Exact Match

• HLOOKUP
• HLOOKUP Exact Match

Module.15 Conditional Logic

• Introduction
• IF Statement
• Nested IF
• AND
• OR
• NOT
• IFERROR
• SUM IF
• AVERAGE IF
• COUNT IF & COUNT IFS
• SUMIFS
• AVERAGE IFS

MODULE NO.16 Text Formulas

• 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

MODULE NO.17 Formatting Charts

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

MODULE NO.18 Adding Graphics to Spreadsheets

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

MODULE NO.19 Outline, Sort, Filter, and Subtotal

• Group and Ungroup
• Sort Data
• Sort Multiple Levels
• Filter Data
• Advanced Filter
• Conditional Sorting and Filtering
• Sorting with Custom Lists
• Subtotal

MODULE NO.20 PivotTables

• Introduction
• Creating PivotTables
• Choosing Fields
• PivotTable Layout
• Filtering PivotTables
• Modifying PivotTable Data
• Pivot Charts

MODULE NO.21 PivotTables

• introduction
• Protecting Data
• Introduction
• Workbook Passwords
• Protecting Workbooks
• Unlocking Cells

MODULE NO.22 Collaboration

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

MODULE NO.23 Printing

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

MODULE NO.24 Saving a Workbook

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

MODULE NO.25 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