Beginner level information
The unit of time in Excel is the Day. By using the NOW Function to show both date and time, you can see the underlying serial number by changing the cell format to General. This serial number is composed of two parts: the date part is the integer and the time part is the decimal. …
I’ve exported an iTunes playlist that shows the number of seconds per song and converted those seconds to a minutes:seconds format as you can see in column N in the spreadsheet below. I now want a running summary in column O to see the total time after each song. The SUM Function works perfectly when …
I’m new to the Excel 2008, the Mac version. Every time I open the program it just looks weird. What bothers me is that the default view is Page Layout. I guess it comes like that out of the box. The regular Excel programs (Windows) are all setup with a Normal page layout as the …
You can pin documents to the recent file list in Excel 2007 so they stay on the list and are easily found. Select the Office button to see the list of Recent Documents. Click the gray pin next to a document and the pin turns green and “pins” the document to the list. It’s great …
One of the things I frequently do is Freeze Panes in my worksheet. This command locks data into place, like column headings, row headings, or both. So when scrolling down (or to the right) I know what type of data I’m looking at because the headings are still visible. [UPDATE: There’s a command hidden from …
Navigating large regions of data can be very quick and easy using keyboard or mouse shortcuts. You can also select entire rows or columns, although multiple row and column ranges work slightly different with each method. Using the Keyboard to Navigate a Range of Data I prefer to navigate ranges using the keyboard. Holding down …
Finding the current region adjacent to the active cell is done in numerous ways. An quick and easy way to select a region of data that has a few quirks.
Organizing data into regions or ranges is the first step to harness the power of Microsoft Excel. If your data set is small, using the full power of Excel probably doesn’t mean very much. But as your data grows it’s important to let Excel do most of the work. Using features like sorting and filtering, …
Short article and video of how to expand menus in Excel 2003 so you can see all items on each menu.