Basic & Advanced Excel Training

Module 1- Introduction, Save and Protect Workbook

1. Introduction
2. Interface
3. Tabs and Ribbons
4. Document Windows
5. Navigation Tips
6. Office Button and Save
7. Workbook Passwords
8. Protecting Workbooks
9. Unlocking Cells
10. Save As Previous Version
11. Auto Recover Save Options
12. Templates
13. Save As PDF
14. Save As Web Page
15. Macro-Enabled Workbook

Module 2 - Entering, Editing and Formatting Data

1. Introduction
2. Entering Data
3. Fonts, Fills, and Alignment
4. Cut, Copy, and Paste
5. Paste Special
6. Undo and Redo
7. Moving, Finding, and Replacing a Value
8. Cell Styles
9. Comments

Module 3 - Formatting Numbers

1. Introduction
2. Currency Format
3. Format Painter
4. Formatting Dates
5. Custom and Special Formats

Module 4 - Managing Worksheets, Rows and Columns & AutoFill and Custom List

1. Introduction
2. Naming and Moving Worksheets
3. Copying Worksheets
4. Adding, Deleting and Hiding Worksheets
5. Grouping Worksheets
6. Moving, Copying, Deleting and Hiding Grouped Worksheets
7. Inserting and Deleting Columns and Rows
8. Inserting & Deleting Cells
9. Inserting Multiple Columns & Rows
10. Modifying Cell Width and Height
11. Hiding and Unhiding Rows and Columns
12. AutoFill a Series
13. Creating Custom Lists
14. Series Formatting

Module 5 - Conditional Formatting

1. Introduction
2. Highlight Cells Rules
3. Top/Bottom Rules
4. Data Bars
5. Color Scales
6. Custom Formatting Rule

Module 6 - Tables

1. Introduction
2. Insert a Table and Style Options
3. Add Rows and Columns
4. Perform a Function in a Table
5. Summarise With Pivot Table

Module 7 - Changing Views

1. Introduction
2. Workbook Views & Show/Hide
3. Zoom Features & Freeze Panes
4. Split Windows
5. Viewing Multiple Windows
6. Minimize The Ribbon
7. Worksheet Backgrounds & Watermarks

Module 8 - Data Tools

1. Introduction
2. Data Validation
3. Drop-Down Lists
4. Removing Duplicates
5. Text To Columns
6. Goal Seek
7. Scenario Manager

Module 9 - Understanding Formulas

1. Introduction
2. Using Operations
3. Creating Formulas
4. AutoSum
5. Common Formulas
6. Searching for Formulas
7. Copying Formulas

Module 10 - Ranges and Dates

1. Introduction
2. Cell Names
3. Named Ranges
4. Formulas with Cell Names
5. Date Formulas

Module 11 - Lookups

1. Introduction
2. VLOOKUP
3. VLOOKUP Exact Match
4. HLOOKUP
5. HLOOKUP Exact Match

Module 12 - Conditional Logic

1. Introduction
2. IF Statement
3. Nested IF
4. AND
5. OR
6. NOT
7. IFERROR
8. SUMIF
9. AVERAGEIF
10. COUNTIF & COUNTIFS
11. SUMIFS
12. AVERAGEIFS

Module 13 - Text Formulas

1. Introduction
2. Case Formulas
3. Fix Number Fields
4. Trim Spaces
5. Substitute Text

Module 14 - Referencing Formulas

1. Introduction
2. Multiple Sheet References
3. Consolidating Data – With or Without Links
4. Trace the Precedents and Dependents
5. Using the Watch Window

Module 15 - Introduction to Charts

1. Introduction
2. Chart Types
3. Instant Chart
4. Update Chart
5. Column Chart
6. Picture Fill
7. Adjust Chart Size
8. Line Chart
9. Scatter Chart

Module 16 - Formatting Charts

1. Introduction
2. Chart Styles
3. Chart Layouts
4. Add Labels
5. Axis Options
6. Chart Title
7. Legends
8. Data Labels

Module 17 - Adding Graphics to Spreadsheets

1. Introduction
2. Insert Pictures
3. Modifying Pictures
4. Insert Shapes
5. Insert Smart Art
6. Apply Themes and Arrange

Module 18 - Outline, Sort, Filter, and Subtotal

1. Introduction
2.Group and Ungroup
3. Sort Data
4. Sort Multiple Levels
5. Filter Data
6. Advanced Filter
7. Conditional Sorting and Filtering
8. Sorting with Custom Lists
9. Subtotal

Module 19- Pivot Tables

1. Introduction
2. Creating PivotTables
3. Choosing Fields
4. PivotTable Layout
5. Filtering PivotTables
6. Modifying PivotTable Data
7. PivotCharts

Module 20- Collaboration

1. Introduction
2. Document Properties
3. Inserting Hyperlinks
4. Sharing a Workbook
5. Track Changes
6. Accept/Reject Changes
7. Mark as Final

Module 21- Printing

1. Introduction
2. Page Orientation
3. Page Breaks
4. Print Area
5. Margins
6. Print Titles
7. Headers and Footers
8. Scaling
9. Sheet Options

Module 22- Macros

1. Introduction and Macro Security
2. Recording a Macro
3. Assign a Macro to a Button or Shape
4. Run a Macro upon Opening a Workbook
5. How to Inspect and Modify a Macro

Module 23- Dashboard

1. To Define KPIs (Key performance Indicator)
2. Customer Service Dashboards or Project Management Dashboard (Gantt Chart)
3. Dashboard Reports Based on Tables
4. Number or Charts/Graphs or Both