Excel, Formatting, Formulae, Spell Checks, Short Cuts

What you will learn

The anatomy of an Excel file

How to apply formatting in an Excel workbook

How to use simple formulae for calculations

How to do spell checks

Key board shortcuts

Why take this course?

This course of Microsoft Excel Basics is a beginner level course – designed for those who are interested in learning Microsoft Excel. After completing this course, you should be able to use Excel for data entry operations and basic formatting.

This course is meant for data entry operators who are new to excel. It can also be used by students who want to explore the Excel features. It is not based on any specific version of Excel. The only prerequisite is a device with Microsoft Excel installed on it.

This course covers the “Home” tab in the main menu of Microsoft Excel.

This course uses a sample excel sheet and with the help of the sample sheet various concepts of formatting, filtering and formulae have been explained. The course is divided into 5 modules with each module covering one important aspect of Microsoft Excel.

The course is divided into 5 modules: –


Get Instant Notification of New Courses on our Telegram channel.


1. Anatomy of an Excel File

2. Creating Basic Reports

3. Formulae, Sorting and Formatting

4. Spell Checks

5. Key Board Short Cuts

The course has an assignment at the end. The course also provides a downloadable cheat sheet which can be used as a reference of keyboard short cuts

English
language