Step by Step Guide to Learn Basic Tasks in Excel
This trick will deal with the step by step guide to Learn Basic Tasks in Excel. The trick start from the very basic step of creating a new workbook, and also includes adding data, selecting formats, how to to adds borders, how to create simple formala, formating numbers, inserting table, save works and finally printing the works.
About Microsoft Excel: (Learn Basic Tasks in Excel)
Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA). It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of the Microsoft Office suite of software.
The following are the Step by Step Guide to Learn Basic Tasks in Excel
A. Create a new workbook: (Learn Basic Tasks in Excel)
1. Click File, and then click New.
2. Under New, click the Blank workbook.
B. Enter your data: (Learn Basic Tasks in Excel)
1. Click an empty cell.
For example, cell A1 on a new sheet. Cells are referenced by their location in the row and column on the sheet, so cell A1 is in the first row of column A.
2. Type text or a number in the cell.
3. Press Enter or Tab to move to the next cell.
C. Apply cell borders: (Learn Basic Tasks in Excel)
1. Select the cell or range of cells that you want to add a border to.
2. On the Home tab, in the Font group, click the arrow next to Borders, and then click the border style that you want.
D. Apply cell shading: (Learn Basic Tasks in Excel)
1. Select the cell or range of cells that you want to apply cell shading to.
2. On the Home tab, in the Font group, choose the arrow next to Fill Color Button image, and then under Theme Colors or Standard Colors, select the color that you want.
E. Use AutoSum to add your data: (Learn Basic Tasks in Excel)
When you’ve entered numbers in your sheet, you might want to add them up. A fast way to do that is by using AutoSum.
1. Select the cell to the right or below the numbers you want to add.
2. Click the Home tab, and then click AutoSum in the Editing group.
F. Create a simple formula: (Learn Basic Tasks in Excel)
Adding numbers is just one of the things you can do, but Excel can do other math as well. Try some simple formulas to add, subtract, multiply, or divide your numbers.
1. Pick a cell, and then type an equal sign (=).
That tells Excel that this cell will contain a formula.
2. Type a combination of numbers and calculation operators, like the plus sign (+) for addition, the minus sign (-) for subtraction, the asterisk (*) for multiplication, or the forward slash (/) for division.
For example, enter =2+4, =4-2, =2*4, or =4/2.
3. Press Enter.
This runs the calculation.
You can also press Ctrl+Enter if you want the cursor to stay on the active cell.
G. Apply a number format: (Learn Basic Tasks in Excel)
To distinguish between different types of numbers, add a format, like currency, percentages, or dates.
1. Select the cells that have numbers you want to format.
2. Click the Home tab, and then click the arrow in the General box.
3. Pick a number format.
H. Put your data in a table: (Learn Basic Tasks in Excel)
A simple way to access Excel’s power is to put your data in a table. That lets you quickly filter or sort your data.
1. Select your data by clicking the first cell and dragging to the last cell in your data.
To use the keyboard, hold down Shift while you press the arrow keys to select your data.
2. Click the Quick Analysis button Quick Analysis button in the bottom-right corner of the selection.
3. Click Tables, move your cursor to the Table button to preview your data, and then click the Table button.
4. Click the arrow Filter drop-down arrow in the table header of a column.
5. To filter the data, clear the Select All check box, and then select the data you want to show in your table.
6. To sort the data, click Sort A to Z or Sort Z to A.
7. Click OK.
I. Save your work: (Learn Basic Tasks in Excel)
1. Click the Save button on the Quick Access Toolbar, or press Ctrl+S.
Save button on the Quick Access Toolbar
If you’ve saved your work before, you’re done.
2. If this is the first time you’ve save this file:
* Under Save As, pick where to save your workbook, and then browse to a folder.
* In the File name box, enter a name for your workbook.
* Click Save.
J. Print your work: (Learn Basic Tasks in Excel)
1. Click File, and then click Print, or press Ctrl+P.
2. Preview the pages by clicking the Next Page and Previous Page arrows.
Next and Previous buttons in the Print Preview pane
3. The preview window displays the pages in black and white or in color, depending on your printer settings.
4. If you don’t like how your pages will be printed, you can change page margins or add page breaks.
5. Click Print.
|Also Read||Creating Data Base in Microsoft Access|