How to Use the Microsoft Excel to Set Up a Spreadsheet
Microsoft Office has a very powerful spreadsheet program known as the Microsoft Excel. In Excel, you can be able to create and format workbooks and spreadsheets, write formulas, do calculations, analyze data among other many functions. For more knowledgeable persons, it is also possible to prepare statements of profit and loss, cash flow and income statements, calendars and budgets. It is, therefore, a very crucial program for use in any office. However, it is always advisable to cross-check any work done using the program to confirm that the right formula has been applied. The following are guidelines on how to use the Microsoft Excel for a beginner.
When you open the Microsoft Excel program, the first step is to set up your spreadsheet. This is done by starting a new workbook by clicking "file", then "New." When it opens a new dialogue box, click under the "available templates," followed by "Blank Workbook," then click "Create." By doing this, a blank workbook is opened.
After opening a new workbook, it is advisable to save it in your preferred file name. This can be achieved by clicking the Office button and choosing "Save as." A dialogue box opens to enable you to choose the location of the computer where you want to save your file. Choose the location then type your file name and save. Make sure that the file type is saved as an "Excel Workbook".
After this, it is good to familiarize yourself with the page. It contains several tools such as Home, File, Page Layout, Formulas etc. It is also important to learn the language and terminology used in excel. This includes rows, columns, cells and you should research on their proper use so as to easily learn using the Excel, visit website!
Every workbook in Excel has three worksheets. If you want to rename the worksheet, you can do so by right-clicking and select the "Rename" button. After this, you may now enter your data as you wish and ensure that you keep saving frequently to avoid losing data. There is a symbol of a floppy disk at the top left of the screen, for saving. You may also save data by holding down the "Ctrl" key, then type "S." To close the file, click "File" then "Close." To re-open the file again, you will click on "Open" then look for your file name and click on it to open your file. To learn more about Microsoft Excel, go to https://simple.wikipedia.org/wiki/Microsoft_Excel.