_________________________________

In This Issue

- Microsoft Excel Resources
- Excel Productivity Tips
- Upcoming Learning Events
_________________________________

Find. Click. Learn. Achieve.

Brandpointe provides easy and accessible tools to adapt Excel to your technology environment. Untie the Ribbon and seamlessly migrate to 2010 with the Excel Task Reference Guide and related course materials.

Request a complimentary copy of the Word, Excel or Powerpoint guide:
http://tinyurl.com/26xnscr

Excel Productivity - Managing Discovery Data

Three thousand patients in a single worksheet.
- How many patients were age sixty and over?
- Which patients had received a certain medicine dosage?
- What hospital had the highest fatalities?
- How many patients had recovered from recent surgery?

Paralegals at a local law firm contacted us for assistance with trial preparation for a medical malpractice case. They filtered the worksheet and manually counted the list. As new entries were added and deleted, however, manually counting data was daunting and time-consuming. The file began with 279 patients, but as the case grew, more data was added to the file.

Brandpointe met the trial team and helped them create formulas and structure the data for easy access and review.

• To get a recurring total of patients over the age of 60, and other filtered data, we showed the team how to use COUNTIF and other functions to view the data. We added names to specific ranges, tables, and showed the paralegal clerk how to quickly enter new information using a data form.

As part of the upgrade to Office 2010, the firm requested the Excel Task Reference Guide and course segments to ensure a successful transition. Attorneys, paralegals and administrative staff access the guide and course content anytime, in or out of the office, for independent review. Demonstration videos provide the processes for data entry and management for the firm's trial and appellate related workflow.

Learning Event - Spring 2010
ASTD - Learning Transfer Conference
http://tinyurl.com/4u9vzdf

Texas Distance Learning Association
Annual Convention
http://tinyurl.com/4e99aoz

Quotes:
Learning is a treasure that will follow its owner everywhere.
- Chinese Proverb
Learning without thought is labor lost.
- Confucius
_________________________________
Contact the learning specialists at Brandpointe to successfully configure and adapt Microsoft Excel. We're certified experts and instructors, who organize and clarify the new program interface and features.
www.brandpointeonline.com