42 posts tagged microsoft excel 2007

PC Magazine (June 200 has a list of “11 Killer Excel 2007 Shortcuts”: Ctrl-Shift-& Apply the outline border to the selected cells Ctrl-Shift-# Apply the Date format with day, month and year Ctrl-Shift-@ Apply the Time format: hour, minute, AM or PM Ctrl-Shift-: (colon) Enter current time Ctrl-;

If you use Excel to store data, chances are you sort that data in some way. Sorting helps you find items and rank numeric values for analysis. However, sorting is a challenge if you reg­ularly add items to the data because it means you have to resort the range after you enter each item.

Excel allows you to work on several worksheets simultaneously by grouping them together.  When worksheets are grouped, any formatting, data entry or changes you make to the active sheet are made to every sheet in the group.  Grouping sheets is a quick way to apply formatting to or delete several

If you want to reduce the size of data on a printout, you can use the Scale to Fit tools on the Page Layout Ribbon.  This is especially helpful if your data spans more than one page in width or height and you wish to shrink it so that it fits on one page.  Reducing the scale of your printout allows

AT&T officially offers the new LG Vu (CU920) 3G TV mobile phone. With a sleek minimalist bar design, the Vu features a 3-inch touchscreen, a 2 Megapixel camera with auto focus, Bluetooth, and a microSD card slot.

If you use Excel to store data, chances are you sort that data in some way. Sorting helps you find items and rank numeric values for analysis. However, sorting is a challenge if you reg­ularly add items to the data because it means you have to resort the range after you enter each item.

HTC has officially launched the new Touch Diamond WM6 smartphone. HTC Touch Diamond is powered by a Qualcomm MSM7201A 528 MHz processor, 256MB ROM, 192MB SDRAM and 4GB of internal storage. The Touch Diamond has also a 2.8-inch LCD touchscreen, TouchFLO 3D touch-sensitive navigation control, a 3.2 Megapixel camera, a VGA secondary camera for video calls, Bluetooth, and WiFi 802.11b/g.

If you use Excel to track your investments, it can be handy to get the latest quotes for the stocks in your portfolio. Excel comes with a Financial Symbol smart tag that includes an option to insert a “refreshable” stock price for a given stock symbol.

I have a copy of Microsoft Office 2007 on my laptop. When I save files from Word, I can’t open them on my PC, which has Office 2003. So, why can’t Microsoft Office 2007 files be opened in Office 2003? The reason is due to Microsoft creating a new file format called Office Open XML.

missingmanuals.com - This screencast from Matthew MacDonald, author of Excel 2007: The Missing Manual, guides you through building and modifying a pivot table in Excel. ShareThis