MS Excel

Course Description

An interactive eLearning course that combines the "Try Me" and "Show Me" functionalities to provide an engaging and comprehensive learning experience. With seven micro modules covering essential topics are covered such as adding tables and charts, how to switch between sheets in a workbook, delve into data, etc. The "Try Me" feature allows hands-on practice in a simulated environment, while the "Show Me" feature provides step-by-step demonstrations. Whether you're a beginner or an experienced user, this course will help you unlock the full potential of Excel for data analysis, reporting, and decision-making.

What You will Learn

Open a new blank workbook

Insert and delete a worksheet

Change cell alignment

Create, edit and copy formula

Module 1 Spreadsheet

Part 1- Overview

Part 2- Parts of the Excel Window

Part 3- Enter data in cells

Module 2 Formatting the spreadsheet

Part 1- Add a header and footer

Part 2- Use gridlines

Part 3- Format font

Part 4- Use auto format

Module 3 Editing the Workbook

Part 1- Use AutoComplete

Part 2- Collect and Paste Multiple items

Part 3- Insert and Delete Cells, Rows and Columns

Module 4 One Workbook, Many Worksheets

Part 1- Switch between sheets in a Workbook

Part 2- Hide Columns and Rows

Part 3- Assessment (Try Me)

Module 5 Calculations are easy

Module 6 Data in a picture

Part 1 - Create a chart

Part 2- Data in a picture

Part 3- Assessment (Try Me)

Module 7 Delve Into Data

Part 1- Sort Data

Part 2- Assessment (Try Me)

Author : With Open Minds

Course Level : Beginner to Intermediate

Modules : 7

Duration : 260 mins

Certificate : Available

Language : English

Quiz : Available

Enrolled : 800+

Enquire Now

Why this course is important?

The course is designed to cater to the needs of individuals across various industries, it equips learners with the ability to efficiently organise, analyse, and manipulate data. Through flexible modules, learners can access course materials at their convenience, allowing them to fit their study time into their busy schedules. The interactive nature of the course engages learners through practical exercises and simulations, facilitating hands-on learning and enhancing their understanding of Excel concepts. By mastering MS Excel through e-learning, learners gain a valuable skillset highly sought after by employers, increasing their employability and opening doors to diverse career opportunities.

Related Courses

MS PowerPoint

Beginner

97 Minutes