Outlines

Course Objectives

The course will teach participants about the Excel interface, including the ribbon, the worksheet, and the basic navigation tools. The course also covers how to enter and edit data in Excel, including entering text, numbers, and dates, and using basic formatting tools.Participants will learn how to format data in Excel, including changing font styles and sizes, adding borders and shading, and using alignment and text wrapping.

Participants also will learn how to perform basic calculations in Excel, including using simple formulas and functions like SUM, AVERAGE, MAX, and MIN. Participants will learn how to manage worksheets in Excel, including inserting, deleting, and renaming sheets, and moving and copying data between sheets.

Participants will be taught how to insert diagrams using SmartArt

Course Outline

Module 1 : Excel components

• What the functions available in excel

• Brief on shortcuts and buttons

Module 2 : Spreadsheet

• How to create spreadsheet

• Rename the spreadsheet

• How to save worksheet

• Open the saved worksheet

Module 3 : Data

• Insert raw data to the cells

• Choosing proper format for the data

• Create tables

• Setup title for the data

Module 4 : Diagrams

• How to create diagram based on data entered

• Choosing proper diagram

• Edit settings of the diagram

• How to present diagram

Module 5 : Calculation

• Introduction to functions available in excel

• Basic functions : plus, minus, subtraction, division

• Formula : how to create formulas

Module 6 : Customising & Enhancing Excel Environment

• Using freeze panes

• Using split windows

• How to handle multiple windows

• Using sheet tab colours

• How to copy worksheets

• Grouping worksheets

Module 7 : Inserting Graphic Objects

• Drawing and modifying shapes

• Illustrating workflow with smart art

• Inserting and modifying pictures

• Removing picture background

• Layering, resizing and grouping objects