Some of the more popular options are explained in the following links. CONVERT TEXT TO A NUMBERĮxcel allows you to change the view of your spreadsheet by zooming in or out, showing formulas, etc. In order to prevent problems, you may need to convert between the different Excel data types before using values in Excel functions and formulas. Click the links below for more details: EXCEL DATES & TIMES EXCEL CELL REFERENCESĭid you know that Excel stores Dates & Times as numbers? An understanding of how this works will help you to work much more effectively when using Dates & Times in Excel. COMMON EXCEL KEYBOARD SHORTCUTSĪn understanding of absolute and relative cell references is essential when you are copying formulas between Excel cells. You will find that the time invested in learning these shortcuts will soon be repaid many times over. It is worth spending a little time learning the Excel Keyboard Shortcuts for the actions that you perform most frequently in Excel. Many of these methods are shortcuts that will help you to save time and therefore work more efficiently.Ĭlick on the links below for details. There are several different ways of entering data into a spreadsheet. Many useful Excel basics are described in the links below, but if you are a complete beginner, you might also find some useful tips on the Microsoft Office Basic Excel page. This page introduces some of the Basic Excel skills that will help when you are using functions and formulas in Excel.