You can manually format numbers using the "Format Cells" dialog box. In this video we will show you how to manually format numbers as dates. This will work the same in Excel 2010 and Excel 2007.
You can use keyboard shortcuts to format numbers in an Excel worksheet. This video will cover shortcuts for 'General","Numbers" and "Currency". This will work in Excel 2010, Excel 2007 and Excel 2003.
If you have a worksheet that contains a lot of data and you are not sure where your selection is in the worksheet, you can use a keyboard shortcut to highlight the row or column containing the selected cell. This will work the same in Excel 2010, Excel 2007 and Excel 2003.
There are times you may have hidden data in a spreadsheet. If you use the ‘Sum’ function, you will receive a total based on all the information, including hidden cells. If you would like to see a ‘Sum’ that only includes the visible data, you will need to use a special formula with "Subtotal".
If you find yourself typing the same phrase over and over again when composing e-mails or text messages, there is a way to create a shortcut. Follow the instructions in this tutorial to save time when typing. This video is shown using iOS 6, but works exactly the same on iOS 7. New video for iOS 7 coming soon!