- Click the File tab.
- Select Save As.
- The Save As dialog box will appear. Select the location where you want to save the workbook.
- Enter a name for the workbook, then click Save.
- Click the Save command on the Quick Access toolbar.
- The workbook will be saved in its current location with the same file name.
- Open a workbook that was previously closed without saving.
- In Backstage view, click Info.
- If there are autosaved versions of your workbook, they will appear under Versions. Click the file to open it.
- A yellow caution note will appear on the Ribbon of the workbook. To restore this version of the workbook, click Restore, then click OK.
- Office Store
- Excel Templates
Choose one of the subjects from above, and a list of relevant videos will appear. It includes many tutorial videos with easy step by step manual instructions.
This way you can immediately practice what you have just seen and learned.
Just look for the “Try it yourself” link above the video, click it and choose whether to open the spreadsheet inside your browser, or better download it to your computer and then open with Excel.
- School and College students learning an IT course (which usually includes the MS Office 2010 applications) and wish to rehearse at home the materials taught in class.
- Job applicants who are going to be tested on their spreadsheet skills as a part of their job interview.
- People already working with this application, who need help with freshening up their skills from time to time, or are looking for some specific answer to their problem such as how to create charts or to use formulas.
- logical1 – The first condition or logical value to evaluate.
- logical2 – [optional] The second condition or logical value to evaluate.
Excel is a powerful spreadsheet program made by Microsoft Office. You can create and format spreadsheets and workbooks (collections of spreadsheets), build models for analyzing data, write formulas, perform many calculations, and present professional charts. Cash flow statements, income statements, budgets, calendars, or profit and loss statements can all be easily created if you know how to use excel .
Open the Excel program. There may be a shortcut on your desktop, or you may need to go to “Start” and then “Programs” to locate the Excel icon.
Start a new workbook (an Excel file). Click “File” and “New.” Under “Available templates,” click “Blank Workbook,” then “Create.” A blank workbook will open.
Save the workbook. Click the Office button (or File tab if you have an earlier version of Excel) and select “Save as.” Choose a location on your computer to save your file (such as the “my documents” folder), type the name of your workbook in the “File name” box, and be sure your file type is set to “Excel Workbook”
Familiarize yourself with the tabs on the ribbon at the top of your workbook.They are File, Home, Insert, Page Layout, Formulas, Data, Review and View.
Familiarize yourself with the language needed to use Excel. Knowing the terminology of the technology is important for being able to use it easily and understand step-by-step guides.
A row is a section that goes right to left across the screen (indicated by numbers along the left side of the screen).
- A column is a set of data that goes from the top to the bottom of the worksheet, and it is identified with a letter at the top of the sheet.
A cell is any individual square of the worksheet that data may be placed in.
6. Prepare your worksheet for data storage. Every Excel workbook has 3 worksheets by default. Sheet 1 opens by default and you can see this tab at the bottom of the window.
Rename a sheet by right clicking on the Sheet 1 tab.
Select “Rename” and type the new name for your sheet.
On the top row of your sheet, type a title in each cell to identify what will be placed in each column. For example, you might type Name, Date, and Amount. The rows underneath these titles are for your data.
Save frequently. When you are entering data, you may want to save your work frequently by clicking the floppy disk symbol at the top left of your screen or clicking on the office button and selecting “Save.” Alternately, you can hold down the control “Ctrl” key on your keyboard while you type “S.”