Getting started with Excel
Excel is used by millions of people around the world. Excel can be used for personal use or business.
Excel has grown over the years. Whether you are using it for simple task or more complicated task, excel is a great tool to have around.
This Excel Basics section will cover 3 things:
1. Customizing the Ribbon.
2. Adding/Summing Cells.
3. List of commonly used shortcut keys in Excel.
The excel ribbon is located at the top of your excel spreadsheet. The ribbon can be customized to your needs.
To customize the ribbon, click anywhere in the ribbon. Then click on “Customize the Ribbon”:
When the customize ribbon box pulls up, you can move commands from the left side of the box to the right side of the box.
2. Adding/Summing Cells:
There are 2 different ways that you can add cells together. The first example uses a formula that adds each cell together. We will be adding cells C1, D1 & E1. The answer will be in cell F1
The other way to add the cells together is to use the SUM function. This will be the most useful way of adding multiple cells together that are in a straight row or straight column.
So, in the first example, we entered =C1+D1+E1 into the F1 cell
In the second example, we entered =SUM(C1:E1) into the F1 cell
3. 20 Commonly Used Excel Keyboard Shortcuts:
20 Excel Keyboard Shortcuts For New Users
|Keys||Image Of Keys||Description|
|Ctrl + A||Select all contents of a worksheet.|
|Ctrl + B||Bold all selected cells.|
|Ctrl + C||Copy all selected cells.|
|Ctrl + F||Search current sheet.|
|Ctrl + H||Find and replace.|
|Ctrl + N||Creates a new workbook.|
|Ctrl + O||Opens a workbook.|
|Ctrl + P||Print the current sheet.|
|Ctrl + S||Saves the open worksheet.|
|Ctrl + U||Underlines all selected cells.|
|Ctrl + V||Pastes what you previously copied.|
|Ctrl + W||Closes the current workbook.|
|Ctrl + Z||Undo the last action.|
|Ctrl + End||Move to last cell on worksheet.|
|Ctrl + Home||Move to cell A1.|
|Ctrl + PageDown||Move to the sheet tab to the right.|
|Ctrl + PageUp||Move to the sheet tab to the left.|
|F1||Opens the help menu.|
|F2||Edits the selected cell.|
|Tab||Move to the next cell on the right.|