FREE Video Tutorials for the Busy Professional

New to Rikki's Tips? A few things you should know:

We created this site to be a resource for you to REFRESH what you already know.

Because over time, and without reinforcement, we tend to forget nearly all of what we have seen, heard and learnt.

We are continuously posting video tutorials on different skills that Busy Professionals need to master.

Several are FREE but you'll notice that many are available to Premium Members only.

Subscribe to Rikki's Free Refreshers in a News Reader    Podcast Rikki's Free Refreshers via iTunes

Saturday, 3 October 2009

23 Rikki's Refresher Free

EXCEL - Consolidations
A smart way to reduce time and errors

For more Refreshers, scroll down to the Archives

0 comments:

Refresh and learn - Treasure Trove (Archives)

01 EXCEL (FREE) - Consolidate data to get immediate results (no cut and paste). Reduce time and errors.

01 EXCEL (FREE) - Display two different sets of data in the SAME chart. Configure a Secondary Axis to do so.

01 EXCEL (FREE) - Excel Pivot Table Reports Cool Tip: Display results in values and percentages - side by side.

01 EXCEL (FREE) - Yes it is possible to create a Gantt Chart in Excel.

01 EXCEL (PREMIUM) - discover a hidden Excel function that makes calculating with dates super easy.

01 EXCEL (PREMIUM) - extract key data (statistics) with the COUNTIF( ) Function

01 EXCEL (PREMIUM) - make your spreadsheet interactive without programming

01 EXCEL (PREMIUM) - optimise your lists with automatic subtotals

01 EXCEL (PREMIUM) - smart ways to calculate with percentages and round a result.

02 WORD (FREE) - Great tip for students - authors - lawyers and all people who write long documents. Optimise Word's powerful cross-referencing features.

02 WORD (PREMIUM) - create an automatic Table of Contents.

02 WORD (PREMIUM) - in response to many requests for help - change print orientation - PORTRAIT vs LANDSCAPE - in one single document

02 WORD (PREMIUM) - save many versions in one single document

02 WORD (PREMIUM) - work smart - reuse recurrent text

03 POWERPOINT (PREMIUM) - a smart way to enter and move text - with Outline.

03 POWERPOINT (PREMIUM) - capture your audience's attention and explain more clearly - with chart animation.

03 POWERPOINT (PREMIUM) - create a Photo Album with a few simple mouse clicks.

04 GOOGLE (FREE) - Optimise your searches by applying the many clever search options.

05 SMART UPDATES (PREMIUM) - Migration to Office 2007 - (1/4) What you need to know absolutely...

05 SMART UPDATES (PREMIUM) - Migration to Office 2007 - (2/4) Viewing documents - some interesting changes

05 SMART UPDATES (PREMIUM) - Migration to Office 2007 - (3/4) The Office Button - replaces the File menu

05 SMART UPDATES (PREMIUM) - Migration to Office 2007 - (4/4) SmartArt - a great new feature to express visually our ideas and concepts

06 HEALTH (FREE) - Prevent computer related injuries in the fingers and arms

06 HEALTH (PREMIUM) - Prevent computer related injuries in the shoulders and neck

07 COMMUNICATION SKILLS (FREE) - Get your own way with effective writing

08 GRAPHICS AND MULTIMEDIA (FREE) - Learn the essentials about computer graphics so that you can talk knowledgeably to experts