Introduction to microsoft excel

Thank you so much again. Thanks very much for ur valuable info abt excel…. Table of Content Close. Introduction to Microsoft Excel 1. Microsoft Excel Window Components. Microsoft Excel Basic Functions. Microsoft Excel Basic Tutorials. Recommended Books. Learn More. I would like to know as to whether your recommended book is also suitable for Office So more keep it up thanks Reply.

It a budget workbook I designed Reply. Thank you for this post it really helped me. Keep it up. Thank you for your inconvenience. Very helpful for children Reply. I satisfy on these notes, good! It is very good Reply. Thanks Reply. This is very helpful main points for ms excel. Thanks for this.. This is very helpful. The ribbon provides shortcuts to commands in Excel.

A command is an action that the user performs. An example of a command is creating a new document, printing a documenting, etc. The image below shows the ribbon used in Excel Ribbon start button — it is used to access commands i. Ribbon tabs — the tabs are used to group similar commands together. The home tab is used for basic commands such as formatting the data to make it more presentable, sorting and finding specific data within the spreadsheet.

Ribbon bar — the bars are used to group similar commands together. As an example, the Alignment ribbon bar is used to group all the commands that are used to align data together.

A worksheet is a collection of rows and columns. When a row and a column meet, they form a cell. Cells are used to record data. Each cell is uniquely identified using a cell address. Columns are usually labelled with letters while rows are usually numbers. A workbook is a collection of worksheets. By default, a workbook has three cells in Excel. You can delete or add more sheets to suit your requirements. By default, the sheets are named Sheet1, Sheet2 and so on and so forth. You can rename the sheet names to more meaningful names i.

Daily Expenses, Monthly Budget, etc. Personally I like the black colour, so my excel theme looks blackish. Your favourite colour could be blue, and you too can make your theme colour look blue-like. If you are not a programmer, you may not want to include ribbon tabs i. All this is made possible via customizations. If you want to delete a row or column, pressing DELETE while the row or columns is selected clears the contents, leaving an empty row or cell.

To delete a row or column, right-click the row or column heading, and then click Delete Row or Delete Column. Note Excel displays an animated moving border around cells that have been cut or copied.

To cancel a moving border, press ESC. To copy or move a row or column, click the row or column header that follows where you want to insert the row or column you copied or cut. For rows or columns, right-click the row or column heading at the new location, and then click the Insert command.

The cells you copied or cut replace the cells at the new location. For more information about copying and pasting cells, see Move or copy cells and cell contents. When you sort information in a worksheet, you can see data the way you want and find values quickly. Use the mouse or keyboard commands to select a range of data, such as A1:L5 multiple rows and columns or C1:C80 a single column. The range can include titles that you created to identify columns or rows.

By filtering information in a worksheet, you can find values quickly. You can filter on one or more columns of data.

You control not only what you want to see, but also what you want to exclude. Click the arrow in the column header to display a list in which you can make filter choices. For more help with filtering, see Quick start: Filter data by using an AutoFilter.

Formulas are equations that can perform calculations, return information, manipulate the contents of other cells, test conditions, and more. Use the mouse to select other cells inserting an operator between them. Type a letter to choose from a list of worksheet functions.

For example, typing "a" displays all available functions that start with the letter "a. To complete a formula that uses a combination of numbers, cell references, and operators, press ENTER. To complete a formula that uses a function, fill in the required information for the function and then press ENTER.

For example, the ABS function requires one numeric value — this can be a number that you type, or a cell that you select that contains a number. A chart is a visual representation of your data. By using elements such as columns in a column chart or lines in a line chart , a chart displays series of numeric data in a graphical format. The graphical format of a chart makes it easier to understand large quantities of data and the relationship between different series of data.

A chart can also show the big picture so that you can analyze your data and look for important trends. Tip The data should be arranged in rows or columns, with row labels to the left and column labels above the data — Excel automatically determines the best way to plot the data in the chart. On the Insert tab, in the Charts group, click the chart type that you want to use, and then click a chart subtype. Tip To see all available chart types, click to launch the Insert Chart dialog box, and then click the arrows to scroll through the chart types.

For more information about any of the chart types, see Available chart types. Before you print a worksheet, it's a good idea to preview it to make sure that it looks the way you want. When you preview a worksheet in Excel, it opens in the Microsoft Office Backstage view. In this view, you can change the page setup and layout before you print. To print a portion of a worksheet, click the worksheet, and then select the range of data that you want to print.

To print the entire worksheet, click the worksheet to activate it. Note The preview window displays black and white, regardless of whether your document includes color, unless you are using a printer that can print color. Sometimes you will want to share your workbook with others. If you are sharing the workbook with someone who also has Excel, you can send your workbook as an attachment to an e-mail message.

The recipient can open the workbook in Excel to work with it. Note Using commands for sending e-mail attachments requires that you have an e-mail program, such as Windows Mail, installed on your computer. If your goal is for the recipient to see the workbook, rather than edit it, you can send a snapshot of the workbook, as a PDF or XPS file.

Your e-mail program starts an e-mail message for you, with the specified type of file attached.