Excel - Smart ways to calculate with percentages and round a result.
Thursday, 30 April 2009
Subscribe to:
Post Comments (Atom)
REFRESH & LEARN - TREASURE TROVE (ARCHIVES) - Refreshers with an * are FREE
Busy Professionals - Master Series
Manage your time in the era of electronic communication
Connect with your Audience
- * Add emotion to your PowerPoint presentations by accompanying your slides with music
- * Enrich your PowerPoint presentation with a LIVE YouTube movie. No download necessary. Only a few mouse clicks are needed
- Create a Photo Album in PowerPoint with a few simple mouse clicks.
- Enrich your PowerPoint presentation with a DOWNLOADED YouTube movie. Learn how to capture movies and convert them into a format that PowerPoint can read.
- Share huge PowerPoint multimedia presentations in a clever way - with SLIDE SHARE
Advanced IT Refreshers for Connoisseurs
- * Let Excel do the legwork - Compare lists with the VLOOKUP function
- A smart way to enter and move text in PowerPoint - with Outline.
- Display two different sets of data in the SAME Excel chart. Configure a Secondary Axis to do so.
- Look up data in a list with the VLOOKUP Function - useful for calculating salaries - making invoices - searching employee details - and much more.
- Word - Create an automatic Table of Contents.
Business & Communication
IT Skills
EXCEL
- * Let Excel do the legwork - Compare lists with the VLOOKUP function
- * Pivot Table Reports Cool Tip: Display results in values and percentages - side by side
- * Yes it is possible to create a Gantt Chart in Excel
- Consolidate data from multiple worksheets - to get immediate results. No cut and paste. Reduce time and errors.
- Discover a hidden Excel function that makes calculating with dates super easy.
- Display two different sets of data in the SAME Excel chart. Configure a Secondary Axis to do so.
- Extract key data (statistics) with the COUNTIF Function.
- Look up data in a list with the VLOOKUP Function - useful for calculating salaries - making invoices - searching employee details - and much more.
- Make your spreadsheet interactive without programming
- Optimise your lists with automatic subtotals
- Smart ways to calculate with percentages and round a result.
POWERPOINT
- * Add emotion to your PowerPoint presentations by accompanying your slides with music
- * Enrich your PowerPoint presentation with a LIVE YouTube movie. No download necessary. Only a few mouse clicks are needed
- A smart way to enter and move text in PowerPoint - with Outline.
- Capture your audience's attention and explain more clearly - with chart animation.
- Create a Photo Album in PowerPoint with a few simple mouse clicks.
- Enrich your PowerPoint presentation with a DOWNLOADED YouTube movie. Learn how to capture movies and convert them into a format that PowerPoint can read.
- Share huge PowerPoint multimedia presentations in a clever way - with SLIDE SHARE
OUTLOOK, GMAIL, LOTUS NOTES
WORD
- * Great tip for students - authors - lawyers and all people who write long documents. Optimise Word's powerful cross-referencing features
- In response to many requests for help - change print orientation - PORTRAIT vs LANDSCAPE - in one single document
- Save many versions in one single document
- Word - Create an automatic Table of Contents.
- Work smart - reuse recurrent text
MIGRATIONS
- Migration to Office 2007 - (1/4) What you need to know absolutely...
- Migration to Office 2007 - (2/4) Viewing documents - Some interesting changes
- Migration to Office 2007 - (3/4) The Office Button - replaces the File menu
- Migration to Office 2007 - (4/4) SmartArt - a great new feature to express visually our ideas and concepts
No comments:
Post a Comment