Microsoft Excel is an incredibly capable and complex spreadsheet program. If you wet your feet, these tips will help you create a spreadsheet and write a formula. Once you learn the vocabulary, the rest becomes easier.
Open Excel and choose an empty workbook
] To start in Excel, click on the Excel icon on your desktop or on the Start menu. Excel is opened with the cursor on the option Empty workbook .
A workbook is the Excel file. All you have to do is click once on Empty workbook or press the Enter key and an empty workbook opens to an empty spreadsheet. You can add spreadsheets to the workbook by clicking on the tab with a "+" sign at the bottom of the workbook screen. You can also change the order of spreadsheets in the workbook by sliding their tabs to the left or right along the tab row. Finally, you can name the tabs and give the entire workbook a name.
Setting up an Excel spreadsheet: Columns and fields
The classic spreadsheet format is similar to the ledger of an accountant or accountant. Column letters go at the top (these are the fields) and row numbers on the left (these are records). Consider the traditional calendar format: the days of the week are at the top and the days of the month that correspond to each day of the week are on the rows below the days of the week. The fields (or columns) are unique data and cannot be repeated ̵
Excel spreadsheet cells
Each small box in a spreadsheet grid is a cell that can contain numbers, letters, colors, and formulas. Every field, every row and every record is in its own cell in the Excel worksheet.
Each cell is fundamentally defined by the column letter and row number, such as & # 39; Cell A1 & # 39; for the cell at the top left. View this earlier story about navigating through the cells in an Excel spreadsheet.
How Excel ribbon menu & # 39; s work
The Excel menus & # 39; s (called ribbon menu & # 39; s) are at the very top of the screen. The tabs at the top are the main menu & # 39; s. Click on one of these tabs and the & # 39; s submenus for that tab appear below. The tabs have a dark green background and the selected / active tab turns white.
Now let's make a very simple worksheet to show how it's done.
If you have not moved your cursor since you opened Excel, it is currently in cell A1. If you have moved it, press the Ctrl + Home key that always returns you to cell A1. Normally row 1 is reserved for field / column names. So type the word Paints in A1, then press the right arrow and move the cursor to cell B1. Type Colors press the right arrow, type # Ordered press the right arrow, type Cost per piece right arrow, type Total then press the key Home .
Note that in column C # Ordered a sort of cell C1 slips away. Let's solve it.
While your cursor is still in the starting position, hold down the Shift key and press the right arrow button four times. The Shift key anchors your cursor at the current location; the arrow keys and then s-t-r-e-t-c-h highlight the highlight to the end of the area you want to select.
Click the Home tab and then note that six & # 39; s submenu are the Cells submenu. Click on Layout and then choose Column width from the drop-down list.
Enter the number 12 in the pop-up window and click OK . The columns are all widened to contain 12 characters.
Adjusting the Excel width and row height.
The default column width and row height settings are 8.43 characters wide and 15 high. If you hard code these settings, you must change them every time you enter a record that exceeds the current column width (or row height).
Use the Autofit settings instead. Highlight the range and then select Format > Autofit Column width or Format > Autofit Row height .
While row 1 is still highlighted, click the tab Home . Note the stacked lines in the Alignment submenu. The automatically selected option that is highlighted is Center, From top to bottom, because the top row is for vertical alignment. The second row is for horizontal alignment. Click on the middle set of lines on both the top and bottom rows and the field / column names center horizontally and vertically in each cell.
Save an Excel file
Click the File tab select Save in the side menu, browse to the location where you want to save this file, give it a name and then click on Save . After the first time you save a file, all you have to do is press the shortcut key Ctrl + S . View this previous story for more convenient Excel shortcuts.
Enter data in Excel
When entering data in Excel, always enter from top to bottom, from left to right. Because Excel is in principle the ledger of an accountant, the bookkeepers always enter figures from top to bottom. When you press Enter, the cursor moves to the next cell, not to the left or right, because that is how the old calculators worked.
Enter five paint companies in column A; five colors in column B; five quantities / # ordered in column C; and the cost of each paint in column D.
Here the fun begins.
Enter formulas in Excel.
Excel uses functions, predefined formulas, to calculate the numbers on your worksheets. Fortunately for all of us, there are more than 440, with more added in each version, not to mention external vendors who create plug-ins with their own unique functions.
Without the functions, Excel would simply be a word processor that creates lists. For more information about Excel functions and formulas, read my previous stories, including a cheat sheet about the Excel formula and a manual for the most popular Excel formulas.
Place the cursor on cell E2 after you have filled in columns A, B, C and D. Type this formula in that cell: = SUM (C2 * D2) (the asterisk stands for multiplication). Excel calculates the total of the Ordered Quantity / # times the cost of each.
You can also place your cursor at the cell location where you want the answer to appear, then press the + (plus) key (then move your cursor to cell C2), press the asterisk – for multiplication – (move the cursor to cell D2) and then press Enter.
Move your cursor in cell E2. Press the copy command Ctrl + C (a green dotted line rotates around the selected cell, such as an active marquee). Move your cursor to cell E3. Hold down the Shift key and press the down arrow three times, and then press Enter .
Excel copies the formula in E2 to E3 through E6. Move your cursor to cell A2. Hold down the Shift key four times to the right, four times down and center the text horizontally and vertically from the submenu Alignment under the Home tab.
Select a range of cells in Excel
You can also select a range cells (the term Excel used to identify a group of adjacent cells) with your mouse. Place your cursor in cell A2, hold down the left mouse button and drag the marker to cell E6 and then choose your options from the ribbon.