As the course is targeting beginners, it has been developed to be very easy to follow. The course covers the topics that you would need to know to become a functional user. After this course, you will have mastered the most popular Excel tools and come out with the confidence to complete any Excel tasks with efficiency and grace.

Course Overview

Session 1: Introduction:

• 1.01 Introduction to Excel
• 1.02 Interface
• 1.03 Tabs and Ribbons
• 1.04 Document Windows
• 1.05 Navigation Tips
• 1.06 Office Button and Save

Session 2: Entering, Editing and Formatting Data

• 2.01 Introduction
• 2.02 Entering Data
• 2.03 Fonts, Fills, and Alignment
• 2.04 Cut, Copy, and Paste
• 2.05 Paste Special
• 2.06 Undo and Redo
• 2.07 Moving, Finding, and Replacing a Value
• 2.08 Cell Styles
• 2.09 Comments

Session 3: Formatting Number

• 3.01 Introduction
• 3.02 Currency Format
• 3.03 Format Painter
• 3.04 Formatting Dates
• 3.05 Custom and Special Formats

Session 4: Managing Worksheets

• 4.01 Introduction
• 4.02 Naming and Moving Worksheets
• 4.03 Copying Worksheets
• 4.04 Adding, Deleting and Hiding Worksheets
• 4.05 Grouping Worksheets
• 4.06 Moving, Copying, Deleting and Hiding Grouped Worksheets

Session 5: Modifying Rows and Columns

• 5.01 Introduction
• 5.02 Inserting and Deleting Columns and Rows
• 5.03 Inserting & Deleting Cells
• 5.04 Inserting Multiple Columns & Rows
• 5.05 Modifying Cell Width and Height
• 5.06 Hiding and Unhiding Rows and Columns

Session 6: Understanding Formulas

• 6.01 Introduction
• 6.02 Using Operations
• 6.03 Creating Formulas
• 6.04 AutoSum
• 6.05 Common Formulas
• 6.06 Copying Formula

Session 7: Changing Views

• 7.01 Introduction
• 7.02 Workbook Views
• 7.03 Show/Hide
• 7.04 Zoom Features
• 7.05 Freeze Panes
• 7.06 Split Windows

• 7.07 Viewing Multiple Windows
• 7.08 Minimize The Ribbon
• 7.09 Worksheet Backgrounds
• 7.10 Watermarks

Session 8: AutoFill and Custom Lists

• 8.01 Introduction
• 8.02 AutoFill a Series
• 8.03 AutoFill Non-Adjacent Cells
• 8.04 AutoFill on Multiple Sheets
• 8.05 Creating Custom Lists
• 8.06 Series Formatting

Session 9: Tables

• 9.01 Introduction
• 9.02 Insert a Table and Style Options
• 9.03 Add Rows and Columns
• 9.04 Perform a Function in a Table
• 9.05 Summarise With Pivot Table

Session 10: Introduction to Charts

• 10.01 Introduction
• 10.02 Chart Types
• 10.03 Instant Chart
• 10.04 Update Chart
• 10.05 Column Chart
• 10.06Picture Fill
• 10.07 Adjust Chart Size
• 10.08 Line Chart
• 10.09 Scatter Chart

Session 11:Formatting Charts

• 11.01 Introductions
• 11.02 Chart Styles
• 11.03 Chart Layouts
• 11.04Add Labels
• 11.05 Axis Options
• 11.06 Chart Title
• 11.07 Legends
• 11.08 Data Labels

Session 12: Protecting Data

• 12.01 Introductions
• 12.02 Workbook Passwords
• 12.03 Protecting Workbooks
• 12.04 Unlocking Cells

Session 13: Printing

• 13.01 Introductions
• 13.02 Page Orientation
• 13.03 Page Breaks
• 13.04 Print Area
• 13.05 Margins
• 13.06 Print Titles
• 13.07Headers and Footers
• 13.08 Scaling
• 13.09 Sheet Options