|
|
|
|
In this newsletter: |
|
|
Hi everyone, Welcome to Productivity Plus, your weekly newsletter on how to get more done in less time. VALERIE’S TIP: The best time-saving tool - EVER!  When Paul taught me this tip (okay, so it’s really Paul’s tip!) I had no idea how much time it would save me. "Format painter" is the little brush that looks the icon in the picture on the right:You'll find it in Word, Excel, PowerPoint and Outlook. If you have formatted some text with several format properties such as bold, italics, blue, indented, 14 point, and you want many other paragraphs to adopt the same formatting - it could take you a while if you format each section manually. Remember Paul’s mantra: If it's slow and tedious, there must be a better way. All you have to do is: Highlight the text that has the correct formatting and double-click the Format Painter. Yes, you can double-click to lock the tool on. Then highlight any text you want to adopt the same formatting. And voila! It’s done. Remember to click the format painter again to turn it off when you're done. One-day workshop: Advanced Excel - Thursday 12 February 2009  Would you like to be a power user of Excel? In one day, this course will help you unlock the full potential of what Excel can do. You’ll learn the more advanced features of Excel including advanced anaylsis tools, especially PivotTables and Solver. You’ll learn outlining and summarising, as well as key automation features such as macros.By the end of the course you will be able to: * use a range of lookup and reference functions * create and work with headers and footers * filter data in a table * use a range of techniques to enhance charts * protect data in worksheets and workbooks * use the Data Consolidation feature to combine data from several workbooks into one * use data linking to create more efficient workbooks * understand and create PivotTables, so you can manipulate data for multiple scenarios * use goal seeking to determine the values required to reach a desired result * use Solver to solve more complex and intricate problems * create recorded macros in Excel
This one-day course is on Thursday 12 February 2009 What: Excel - Advanced 9.00am - 5.00pm Course fee: $325 (includes GST) You will receive a comprehensive take-home manual which is a handy reference for the future. If you’d like a more comprehensive course outline, click here. Or you can enrol online here. PAUL'S TIP: The magic of Alt + K in Outlook  Let Outlook do the checking for you. It can be embarrassing to incorrectly address an email. This keyboard shortcut is recommended more as a habit than a time-saver.After you have typed all of your email recipient addresses, hold Alt and press K. This will check all of the addresses to ensure all of the required components are included. 1. Name Outlook checks the name is there. (But note that it does not check the name is correct.) 2. @ This universal symbol identifies the text as a “mail to” address and separates the name from the domain. 3. Domain name This could be a company name such as Cocacola or an internet service provider's name such as bigpond. 4. Domain extension Preceded with a period such as .com or .gov. 5. Country extension Preceded with a period for all countries other than USA, such as Australia .au or New Zealand .nz. When Outlook finds a recipient address that does not contain four out of the five items above, you will be prompted to edit the address or select a name from your address book. By pressing Alt + K just before you send, Outlook will alert you to the problem before potential embarrassment. Fun and interactive tailored group training  Do you have several members of your team who need upskilling in Word, Excel or Outlook?We can tailor training to your needs. This means your team will leave the workshop with the EXACT skills they need to excel in their jobs and grow your business. Talk to us about what you need. Your team will learn in a beautiful harbourside training centre with a top presenter. Lunch is catered and we ensure everyone leaves with a comprehensive workbook for handy future reference. We can tailor for groups as small as 5 team members. Feel free to call us on (02) 9923 2882. Upcoming courses: To find out more or to receive a comprehensive course outline, just click on the course you're interested in. Course: Office 2007 Essentials Date: Wednesday 17 December 2008 - BOOKED OUT Time: 9.30am - 4.30pm Fee: $325 Course: Writing for the web Date: Thursday 5 February 2009 - ENROL NOW Time: 9.30am - 4.00pm Fee: $325 Course: Microsoft Excel 2007 - Advanced Date: Thursday 12 February 2009 - ENROL NOW Time: 9.00am - 5.00pm Fee: $325 Course: Microsoft Word 2007 - Advanced Date: Wednesday 18 February 2009 - ENROL NOW Time: 9.00am - 5.00pm Fee: $325 Course: Excel - Basic to Intermediate Date: Thursday 19 February 2009 - ENROL NOW Time: 9.30am - 4.30pm Fee: $325 Course: Outlook 2007 Date: Wednesday 25 February 2009 - ENROL NOW Time: 9.30am - 4.30pm Fee: $325 Course: Word 2007 Intermediate Date: Thursday 26 February 2009 - ENROL NOW Time: 9.30am - 4.30pm Fee: $325 Thanks for signing up to this newsletter. Remember, if you'd like to leave this list at any time just reply to this email letting us know. Wishing you much success, Valerie Khoo and Paul Neale Directors Business and Careers Institute Suite 3, 55 Lavender Street Milsons Point NSW 2061 (02) 8006 2112 courses@bcinstitute.com.au www.bcinstitute.com.au The Business and Careers Institute is for people who use Word, Excel, Outlook, Powerpoint and other Microsoft software. In this newsletter, you'll learn insider tips, shortcuts and resources on how to get more done in less time. At our one-day courses, we'll reveal how you can use technology to set yourself free. |
|
• VALERIE’S TIP: The