[TechRepublic] Harness the power of Subtotal in Excel

Trouble viewing this mail? Read it online | Manage my newsletters | Unsubscribe Microsoft Office Suite TechRepublic Member | June 28, 2011

Office challenge: Why can't I use Excel's Subtotals feature? In this week's Office challenge, test your Excel skills by solving a disabled feature mystery and learn the solution to last week's Excel custom view error challenge. Read more Resource of the day Download a Free Trial of Diskeeper 2011 EnterpriseServer Discover the only solution specifically designed for your largest servers, the ones that must be kept online with volumes up to 20TB and millions of fragments. Achieve peak performance 24-7 with Diskeeper 2011 EnterpriseServer. Harness the power of Subtotal in Excel to count grouped items Excel's Subtotal feature can render quick results when you need simple grouping calculations. Susan Harkins shows you how this powerful feature works. Read more Copy Excel subtotals without making a mess After using Excel's Subtotal feature, you can quickly collapse the outline to view only the subtotal rows. You might get a surprise if you try to copy them though - here's how to avoid a Subtotal... Read more Placement is everything when using aggregate functions in Access reports The same aggregate function will return different results in the same report. It's important that you understand how placement determines how an aggregate evaluates values in an Access report. Read more Additional TechRepublic resources   Increase capacity the easy way with the Data Robotics Drobo B800i The Data Robotics Drobo B800i is an all-in-one-box designed to be deployed as a Storage Area Network server adding needed storage capacity to an existing system. Read more The cloud is coming for you: Eight ways it may change how you work For network specialists, the shift to cloud computing will have a significant impact on several aspects of their jobs. Mark Underwood suggests eight areas of change to start thinking about now. Read more Has the Mozilla Foundation lost its collective mind? After a long downward trend in quality for the Firefox browser, the Mozilla Foundation has decided to add insult to injury by eliminating the ability to at least stick with an older version until extensions are updated to the newest -- and to do so after only three months of release status for version 4. Read more Will FTC derail Larry Page's supersized ambitions for Google? The FTC is about to launch a probe into Google's business practices. Learn how the inevitable government scrutiny could inadvertently assist new CEO Larry Page. Read more Is it practical to run your business via online subscription services? The beta of Microsoft Office 365 hit the Web in June 2011, but is it folly to think you can run your business entirely via online subscription services? Read more Featured multimedia   A closer look at the Data Robotics Drobo B800i As a small business grows the need for additional data storage grows with it. One of the most cost effective ways to add storage capacity is with a Storage Area Network (SAN) server. If your business has reached the point where SAN capacity is vital to continued operations, then perhaps it is time to consider the Drobo B800i. View on site The Eiffel Tower, Behind the Scenes (photos) Road Trip 2011: A view of the 'secret' bunker under the Eiffel Tower, and of the rest of one of the world famous landmark. View on site 35+ writing tips from TechRepublic Five simple tips that will improve your writing a thousand percent Another 10+ tips for keeping your writing sharp and professional 10 flagrant grammar mistakes that make you look stupid 10 wording blunders that make you look stupid Today's recommended downloads Take Control of Your IT Universe...Remotely (LogMeIn) Centralize! Automate tasks on hundreds of computers. (LogMeIn) Saving Money While Saving Money (Hewlett-Packard (HP)) Remote support for PCs, Macs and Smartphones (LogMeIn) Disk Performance Analyzer for Networks (Diskeeper) Our Most Popular Office Tips   10+ keyboard shortcuts to help you deliver a smooth PowerPoint presentation Do your part: Prevent PowerPoint abuse Key tips for putting the power back in your PowerPoint Four tips for a killer PowerPoint presentation   No more excuses: 9 reasons why smart businesses upgrade to Google Apps for Business If you use Google Apps for your business, you should upgrade from the free Google Apps solution to the paid Google Apps for Business solution. TechRepublic newsletters   Get smartphones news, product reviews, and need-to-know lists in the following TechRepublic newsletters. Automatically sign up today! Smartphones Five Tips 10 Things Featured training courses   Configuring, Managing, and Maintaining Server 2008 MCITP: Server and Enterprise Administrator Combo Boot Camp Configuring Windows Server 2008 Active Directory Domain Services Implementing and Administering Windows 7 in the Enterprise Microsoft Exchange Server 2007 Browse all training courses Presented by Global Knowledge

Send us your feedback here. Sign up for more free newsletters from TechRepublic! To manage your account settings or to remove yourself from all TechRepublic communications, please visit our Subscription Center. The e-mail address for your subscription is techsubscriptionss@cesabarre.com Unsubscribe from this e-mail | FAQ | Advertise | Privacy Policy Copyright 2011 CBS Interactive, Inc. All rights reserved. TechRepublic is a registered service mark of CBS Interactive, Inc. TechRepublic 235 Second Street San Francisco, CA 94105 U.S.A.