Microsoft Excel Tutorial
Microsoft Excel is allows you to create professional spreadsheets and charts. It performs numerous functions and formulas to assist you in your projects. This tutorial will help you get started and may solve some of your problems. In this tutorial, there are two types of tutorials. One is animated version and one is html version. To view the animated version, click the link that been provided in every section.
List of tutorials
Know About Excel
- What we can do with MS Excel
MS Excel is a spreadsheet application where you can insert mathematical formulation into a big table calls worksheet.
- How to open Microsoft Excel
There are few ways to open an excel application. Here we will show you two of it thats are by windows menubar and by double click the excel file.
- How to close microsoft excel
Here you will learn on how to close microsoft excel 2003.
- Screen element of Microsoft Excel
There are 2 main elements in excel, that are Sheets and function bar. Sheets are a workspace to input data and make graph. While the function bar such as menu bar, tools bar and etc are used to execute the excel function.
How to make report with Excel
- Overall flow of making report
Here you will learn on how to create a table, graph. Also you will learn on how to save the book and print out the sheet. And lastly on how to close the saved book and re-open it.
- How to make a new book
In MS Excel 2003, there are 3 way to make a new book. There are by the support menu at work panel, using the menu at menu bar or using shortcut icon at tools bar. Here we will show you all of it.
- Entering the word
In this lesson, you are going to learn how to enter the word into your worksheet and format the style of it.
- Auto fill month data
In this lesson, you are going to learn how to auto fill the word and cell style into your worksheet.
- Enter and format number
In this lesson, you are going to learn how to enter the number and format it into your worksheet.
- Using autosum function
In this lesson, you are going to learn how to total up the data by row and column using autosum function.
- Adjust column width
In this lesson, you are going to learn on how to adjust the column width of the cells.
- Adjust row height
In this lesson, you are going to learn on how to adjust the row height of the cells.
- Draw border line
In this lesson, you are going to learn on how to draw border lines of the cells.
- Right alignment
In this lesson, you are going to learn on how to align the text or data in the cell to the right.
- Fill background color of the cells
In this lesson, you are going to learn on how to change the background color of the cells.
- Create Graph
In this lesson, you are going to learn on how to create the graph from the data that had been input in the microsoft excel.