[Free] Microsoft Excel Basics
Excel, Formatting, Formulae, Spell Checks, Short Cuts – Free Course
What you’ll 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
Requirements
- No prior experience on Excel is needed. This is an entry level course. Access to a computer with Excel (any version) installed is the only pre requisite for this course
Description
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: –
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
Author(s): Arti Dilip Bendre