Microsoft Excel 2013 - Smart Lessons for Absolute Beginners

An easy to follow, step by step guide to learn basics of Microsoft Excel 2013

1 year access

Course Introduction:

Microsoft Excel is the industry standard for spreadsheets and is a part of the ubiquitous Microsoft Office. Amongst its many features, it prominently supports calculation, graphing tools and pivot tables. Just like any other spreadsheet, Microsoft Excel has a grid of cells structured in numbered rows and letter-named columns to organize and manipulate data. This organization of Excel into cells makes it an indispensable tool for budgeting, financial forecasting and data entry amongst other functions.

Read more

Course Objectives:

There is a lot to learn and master in the world of Microsoft Excel and this course will provide a start in the right direction. At the end of the course, you will be able to:

  • Bring Data together
  • Use conditional formatting
  • Manipulate data
  • Perform various calculations using simple functions.

Pre-requisites and Target Audience:

Learning MS Excel is a must especially for business analysts, entrepreneurs and accountants. MS Excel is a good skill to pick up and anyone who wishes to do so can subscribe to this course. There are no pre-requisites for taking up this course.

If you are a beginner, you will be having to complete all the sections. If you are already familiar with the basics of data entry and manipulation, you can directly proceed to Sections 3 and 4.

Course Plan

1. Getting Started
4 videos
Introduction 01:12

Creating a new Excel Workbook on Excel 2013 00:37

Excel Workspace Layout 00:27

Using the Status Bar 01:02
2. Data Entry and Manipulation
8 videos
Entering Values into Cells 00:45

Editing Data in a cell 00:40

Inserting Rows and Columns 01:42

Navigating through Data 01:51

Selecting Data 01:06

Copying Data 01:27

Copying Data - Behind the scenes 00:35

3. Data Formatting
6 videos
Number Formatting 01:05

Text Formatting 00:45

Conditional Formatting 04:58

Sorting and Filtering Data 02:07

Finding Data 00:46

Freezing Header Panes 00:51
4. Functions and Formulas
5 videos  · 1 test
Calculations in Excel 01:40

Using Formulas 03:20

Autosum 00:57

Absolute and Relative Referencing 03:20

Introduction to Functions 04:30

Test 10:00