MS Excel is a spreadsheet application that lets you create, organize and analyze numerical and statistical data. MS Excel lets you perform calculations with the help of inbuilt functions. You can also create charts, budgets with excel etc

The Excel window

In this tutorial, you will learn about Microsoft Office Excel window with its features and how they work.

By the end of this tutorial, you should be able to interact or work with the Excel window and its features.

Cell addresses

In this tutorial, you will learn about cell addresses. You will learn how to use cells, read the cell addresses and more other tasks.

By the end of this tutorial, you should be able to work with MS Excel cell addresses to complete your Excel tasks.

Rows and columns

In this tutorial, you will learn how to deal with rows and columns in your worksheet.

By the end of this tutorial, you should be able to work with rows and columns contained in your worksheet to accomplish your tasks.

Hiding rows and columns

In this tutorial, you will learn how to hide rows and columns in a given worksheet.

You will also learn how to unhide the hidden rows in a given worksheet.

By the end of this tutorial, you should be able to hide and unhide rows and columns in a given worksheet.

Formatting cells

In this tutorial, you will learn how to format cells in a given worksheet. You will learn severals ways to format your worksheet

By the end of this worksheet, you should be able to format cells in your worksheet using different format tools.

Number formats

In this tutorial, you will learn about the number formats in an Excel file. You will also learn how to use number formats to control value display in a worksheet.

By the end of this tutorial, you should be able to work with number formats to control the display of values in your worksheet.

Dealing with Number formats in cells

This tutorial will let you learn how to deal with number formats in cells of a given worksheet.

By the end of this tutorial, you should be able to format the cells with dates and percentages and also be able to deal with such cells.

Inserting separators in cells

In this tutorial, you will learn how to insert separators in cells containing numeric data.

By the end of this tutorial, you should be able to insert automatic separators in your numeric data without the need for typing it.

Autofill feature

In this tutorial, you will learn how to use the autofill feature to speed up your data entry in your worksheet.

By the end of the tutorial, you should be able to work with autofill to quickly enter some series of data without typing.

Watch this tutorial for details!

Conditional formatting

In this tutorial, you will learn about conditional formatting

By the end of this tutorial, you should be able to use this feature to apply specific formatting to the cells

Formula basics

In this tutorial, you will learn about different simple formulas to perform calculations.

By the end of this tutorial, you should be able to work with the MS Excel basic formulas to perform calculations.

Complex formula with relative cell references

In this tutorial, you will learn about complex formula with relative cell references

By the end of this tutorial, you should be able to use complex formula while working with relative cell reference.

Complex formula with absolute cell references

In this tutorial, you will learn about complex formula with absolute cell references

By the end of this tutorial, you should be able to use complex formula while working with absolute cell reference.

Insert function assistant in excel

In this tutorial, you will learn how to use the insert function assistant in MS Excel to help you insert functions in your worksheet

By the end of this tutorial, you should be able to use the insert function assistant in MS Excel to help you insert functions in your worksheet

Freezing worksheet panes

In this tutorial, you will learn how to lock rows and columns contained in your worksheet.

By the end of this tutorial, you should be able to lock the rows and columns in your worksheet.

Watch this tutorial, to discover why we need to lock the rows and columns

Printing worksheets

In this tutorial, you will learn how to print worksheets. You will learn more about the print preview and learn more other settings before you can print your document

By the end of the tutorial, you should be able to to print your worksheet data, make some important settings as well.

Using the print title command

This tutorial is about the print title command feature in MS Excel. In this tutorial, you will learn how to use this feature to print sheets with specific row headings or column headings on each printout.

By the end of the tutorial, you should be able to print your sheet(s) with each sheet having title(s) (headings).

Displaying formulas

In this tutorial, you will learn how to display formulas in a worksheet.

By the end of the tutorial, you should be able to display formulas used to perform calculations in your worksheet.

Working with worksheets

In this tutorial, you will learn how to effectively manage and work with your worksheets.

By the end of this tutorial, you should be able to effectively manage you worksheets.

Sorting and filtering

In this tutorial, you will learn how to sort and filter data contained in your worksheet.

By the end of this tutorial, you should be able to sort and filter data contained in your worksheet.

Dealing with insert function assistant to manage functions

In this tutorial, you will learn how to use the insert function assistant to manage functions. The focus will be on several functions such as Sum, Min, Max, Average, Count, Countblanck, Countif etc

By the end of this tutorial, you should be able to use all these functions in your worksheet.

Rank function

In this tutorial, you will learn how to use the Rank function for grading purposes.

IF function

In this tutorial, you will learn about the IF function to perform logical comparison between values.

By the end of the tutorial, you should be able to use the IF function for logical comparison

Vlookup function

In this tutorial, you will learn how to use the Vlook up function in your worksheet

So, by the end of this tutorial, you should be able to use this function to manage your data.

Excel charts

In this tutorial, you will learn how to create and work with charts in worksheets

By the end of this tutorial, you should be able to create charts and work them in the worksheet containing your data.