_________________________________

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

Points and Views

In this Issue:
• Adobe Captivate
- Distance Learning Course
• Microsoft Word 2010
- Keyboard Shortcuts
- Building Blocks
_______________________
♦ Adobe Captivate
Our clients and colleagues requested it, and we've developed a distance learning course for Adobe Captivate. The course provides the flexible tools to create effective, engaging content, and is offered via Ovation, our global learning site. Students work independently, complete the course segments at their own pace, and have ongoing instructor collaboration.

View Course Information - (pdf)

♦ Microsoft Word 2010
New Word 2010 users look for familiar options as they learn to navigate the Ribbon. We start our migration classes by describing the Ribbon as a large circle that pivots and stops according to the currently selected tab, displaying specific functions for that tab. As students assimilate the new interface, we provide the old and new keyboard shortcuts for faster feature access.

Use Keyboard Shortcuts for Ribbon Options - Press the Alt key to display all shortcuts. To select a tab or option, press Alt and the letter or number.







Making the Move - Common Shortcuts
Files:
Close - Alt W
Open - Ctrl O
Print - Ctrl F2
Recent Documents - Alt FR
Save - Ctrl S
Save As - F12

Current Word Distance Learning Courses - (pdf)

♦ Building Blocks
Word 2010 includes a building blocks template containing preformatted objects. AutoText is included in the building blocks family, which contains galleries for Quick Parts, Headers/Footers, Page Numbering, Table of Contents, Equations, Bibliographies, Text Boxes, Tables, and Watermarks.

Add An Entry
1. Select the document text.
2. Press the Alt F3 keys.
3. Select a Category and click Ok.

Insert An Entry
1. The Ribbon - Insert, Quick Parts
2. Keyboard: Alt NQ
3. Type the first few letters of the entry. Press the F3 key.

Rename an Entry for Easier Retrieval
1. The Ribbon - Insert, Quick Parts, Building Blocks Organizer
2. Keyboard: Alt NQB
3. Locate the entry and click the Edit Properties button.

Use the Building Blocks Organizer
1. The Ribbon - Insert, Quick Parts, Building Blocks Organizer
2. Keyboard: Alt NQB
3. Click and sort the column titles to view entries.
4. Select an entry and click the Insert button.












Quotes of the Week:
"Everything should be made as simple as possible, but not simpler."
- Albert Einstein
"It is better to know some of the questions than all of the answers."
- James Thurber
_______________________

Brandpointe
The learning specialists at Brandpointe clarify and adapt technology. Contact us for information regarding our programs and services - www.brandpointeonline.com.

Points and Views

In This Issue:
- Word Master Class
- Distance Learning - January 2011
- Events

Word Master Class - Many of our clients are professional services groups with ongoing client service priorities. Technology has to be clear, focused and effective. Migrating and configuring Microsoft Office products has to fit and provide results. Brandpointe provides the technical knowledge that ensures successful rollouts and staff instruction.

The Master Class is designed for individuals who produce and format complex documents or provide technical support for Word 2010. We review and clarify the Template Hierarchy, Galleries, File Formats, Formatting and Configuration standards. Students learn at their location, and complete course segments at their own pace.

Distance Learning:
Our successful E-Learning program provides customized, flexibility courses. Students learn independently, with ongoing instructor collaboration. Tools and materials are structured for easy access and usage, and include course workbooks, reference sheets, quick notes, recap checklists and assessments.
January 2011 Courses - (pdf)

Events
Training 2011 - Conference and Expo
February 4-8
San Diego, California
http://www.trainingconference.com

Quotes for the Week:
I am always ready to learn although I do not always like being taught. ~Winston Churchill

The illiterate of the 21st century will not be those who cannot read and write, but those who cannot learn, unlearn, and relearn. ~Alvin Toffler


Contact the education specialists at Brandpointe for continuing education and workforce training. We offer JobReady career preparation for Administrative Specialists and Litigation Support Specialists. WorkReady programs help employees build job performance.

www.brandpointeonline.com

Ovation News

In This Issue:
- Association Events
- Continuing Education Courses
- Brandpointe Briefings
- This Week's Quotes

Association Events:
Administrative Professionals Conference
October 3-6, Las Vegas NV
http://tinyurl.com/2fw4xjo

Continuing Education Courses:
Business Skills Course - Customer Service Management
Designed for administrative and front-line employees. The course includes four learning segments incorporating key concepts, role simulation, communications techniques and service recovery practices.

Module 1 - Service Basics
Download (pdf)

Cloud Solutions for Employee Education - Part 1
Brandpointe helps our clients develop educational tools for employee job performance. We assess topics, workflow, client service requirements, individual learning styles and key management objectives. We collaborate and plan methods, tools and resources to deliver information, and build required skills.

With more organizations creating web-based training solutions, we're showing clients that learning in the cloud can be an effective tool.

Key Development Factors:
- What concepts and knowledge are necessary?
- Which skill proficiences are required?
- How do we identify and measure these components?
- How is this accomplished with our dispersed physical locations?
- How do we accommodate varied work schedules?

Case Study:
Training Day Program For Engineers Located on Two Continents - (pdf)

eLearning Briefing:
Topyx -
Implementing a Successful Learning Management System
9/23 and 10/14
Registration: http://tinyurl.com/2eoq57x

Review Topyx, a Moodle-based system with full reporting and social networking capabilities. It provides a seamless, turnkey solution for web-based learning. Our LMS has provided an excellent resource for managing program activities.

Session participants receive a copy of an Office 2010 course module, and our updated elearning kit.

This Week's Quotes:
Yogi Berra's instruction for spring training drills - "Pair off in threes."
"As long as you're going to be thinking anyway, think big."
- Donald Trump

Contact Brandpointe:

214.233.6594 - Course Registrar
helpdesk@brandpointeline.com

Ovation News

News and Events:
E-Learning Briefing: - Review distance learning processes and Topyx, a learning management system. Topyx provides options for managing users and courses, and customized reporting capability.

E-Learning Management With Topyx - 9/23/10
Register for the online event - helpdesk@brandpointeonline.com.

WorkReady - Continuing Education
Distance Learning - Register for Office 2010 or Adobe Captivate sessions through Ovation. Call our course registration line at 214.233.6594, or contact us via e-mail - helpdesk@brandpointeonline.com.

Current Distance Learning Courses (pdf)

Office 2010 Making the Move - Is your organization making the move? Use our courses and tools for successful migration to Office 2010.

Microsoft Word 2010
Demo Video Tutorial - Headers and Footers - (pdf)

JobReady - Career Programs
Litigation Support Specialist - Open enrollment: Current program begins August 30, 2010. Our LSS program is now offered via Ovation. Acquire the knowledge and software skills required in today's evolving legal environment. Program Brochure - (pdf).

Contacts:
Event or Course Registration - helpdesk@brandpointeonline.com
Courseware - pbcoleman@brandpointeonline.com
Career Programs - jbrand@brandpointeonline.com

This week's quotes:
Live as if your were to die tomorrow. Learn as if you were to live forever. - Gandhi

When you know something, say what you know. When you don't know something, say that you don't know. That is knowledge. - Confucius

Ovation News

WorkReady - Continuing Education

Distance Learning

Brandpointe offers software education - anytime anywhere. Learning tools are downloaded from Ovation, our global learning community. Download courseware, and upload completed materials.

Chart progress with activity reports and updates. Communicate with instructors via e-mail, telephone or Skype.

Instructor Availability:
Monday - Friday (8:30am-5:00pm)

Summer Course Listings:

http://tinyurl.com/2g8hxng

Office 2010 - Making The Move

Microsoft Word - This Week's Demo Lesson and Video

http://tinyurl.com/26wyuzh

Association Events - August 2010:

ILTA 2010 - Strategic Unity

http://conference.iltanet.org

Follow ILTA events on ILTA TV - http://ow.ly/2jHp3

JobReady - Career Programs

Updated Student Roster:

Carolyn Redic joins the Administrative Specialist program. It includes Microsoft and Adobe software training, extensive typing tutorials, English Grammar and Professional Development courses.

Welcome, Carolyn!

Quotes of the Week:

"Ninety percent of this game is half mental." - Yogi Berra

"Sandwich every bit of criticism between two layers of praise."
- Mary Kay Ash

Contacts:

Distance Learning - jbrand@brandpointeonline.com
Technical Support/Project Assistance - helpdesk@brandpointeonline.com

Office 2010 - Making The Move

Microsoft Outlook provides layered options for managing electronic mail, contacts, events and projects. Getting started with basic concepts is an important step to user adoption and productivity.

Brandpointe provides tools for Office 2010 migration. Our course packages are easy to use for both structured classroom sessions - or independent study.

This week's demonstration video - Outlook 2010 Basics
Click Here To Take the Quiz!


Contents:

1. Index Page
Learners view navigational links to materials.

2. Lesson Worksheets
Knowledge Tools: Review pages, exercises and projects.

3. Demonstration Videos
Adobe Flash files to enhance learning.

4. Student Checklist
List of objectives and competencies.

5. Glossary
Master list of concepts and terminology.

6. Quick Reference Guide
Topical guide for use after course completion.

Join our global learning community at www.beovation.com.
Create an account and download the Outlook 2010 demonstration.

Course Segments:
Outlook, Word, Excel, PowerPoint, Visio, and OneNote