Microsoft Excel Basics

Name: Microsoft Excel Basics
Rating: 4.4 (65 reviews)

Excel, Formatting, Formulae, Spell Checks, Short Cuts

Created byArti Dilip Bendre

Last updated 9/2024

English

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

Course content

1 section • 7 lectures • 56m total length

Introduction2:04
Section 1: Anatomy of an Excel file9:06
This section covers the basics of an excel file - it talks about worksheets, different views, using zoom and navigating thru the menu bar. The excel sheet in lecture is used in all the subsequent lectures to demonstrate various features in excel
Section 2: Creating Basic Reports19:26
This section describes the various options available to format the font and numbers in excel.
Section 3: Formulae, Sorting and Advanced Formatting13:50
This section shows the options related to sorting and filtering the data. It shows how to apply conditional formatting and how to format data as tables.
Section 4: Spell Checks5:51
This section explains how to do spell checks in Excel
Section 5: Key Board Short Cuts3:42
This section shows various short cut keys available. The attached file is the cheat sheet that can be used for keyboard shortcuts
Recap2:47
This is a recap of all that we have learnt in this course
Practice Assignment on formatting and formulae

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

Who this course is for:

This course is meant for beginner level students who are interested in learning Excel. After completing this course, you should be able to use Excel for data entry operations and basic formatting