210 posts tagged 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-;

A client was trying to import an Excel spreadsheet into a SharePoint list on a collaboration site and was receiving the following error: Method "Post" of object "IOWSPostData" failed Basically, the error is a result of Excel failing to recognize the current version of SharePoint and attempting to upload the data via a raw post instead of using the SOAP format that SharePoint 07 expects.

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

Ok, I am totally amazed I am just now learning this shortcut. I feel silly. In Excel, instead of clicking the AutoSum function button...press the shortcut: ALT + =

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.

The YouTube user “ExcelIsFun” has compiled several full playlists of video lessons on Excel that even you may not quite be familiar with! Once you get past the strange voice he uses, the videos are actually a great/quick way to learn a few things that can make you just a little more effective:

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.