MICROSOFT EXCEL 2010/2013/ 2016/2019/365 : BEGINNER

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

Module 2 : Spreadsheet

Module 3 : Data

Module 4 : Diagrams

Module 5 : Calculation

Module 6 : Customising & Enhancing Excel Environment


Module 7 : Inserting Graphic Objects