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: –
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