Facebook

Overview


Excel Top Tips

2020-097
CPD Points: 1.00
Duration: 1 hr
$89.00 +GST Retail
$74.00 +GST Learning Partner
Registration Closed

Event Detail

No matter where you store your database information, you can make magic happen with it in Excel. Learn how to do in 15 minutes; what takes others days. You’ll learn tricks on working with, cleaning, de-duping, massaging and fixing your information. However this webinar is not only about lists. The tips on summerising, graphing, tabulating, merging and printing will have you kicking yourself for not knowing them before. 

Some of The topics covered include:

  1. Fixing mixed upper and lower case
  2. Fixing that “zero” problem
  3. Saving time with Pivot tables
  4. How to automatically remove duplicates
  5. Separating data and conversely, joining data
  6. Deleting extra rows and columns
  7. Recovering unsaved files
  8. Importing your Outlook contacts into Excel
  9. Automatically colouring cells to make data stand out
  10. Effectively viewing large sheets of information

After this webinar you will be able to:

  • Get better use of your database information
  • Tabulate information to use for reports or presentations.
  • Learn how to free up a significant amount of time working in Excel
  • Use your lists/databases for effortless email marketing

 

All Coming Instances

10:30a.m. - 11:30a.m., Tue, 04 Aug 2020
Registrations Close: 03 August 2020
Class Limit: 100
Presenter: Debbie Mayo-Smith
Venue:
Online: For those registered by webinar the links will be sent the day prior.
Registration Closed
 

Terms and Conditions

Discounts are available for group bookings.  Please enquire. 

The running of this workshop is subject to minimum attendees. 

No refund will be given if you do not notify us prior to the start of the event.

Full terms and conditions are available here
© Copyright Professional IQ College Ltd. Private information collected for this website is governed by our Privacy Policy. Read our Terms & Conditions
Unit 4D, 2B William Pickering Drive, Rosedale, Auckland 0632

Powered by streamSWEET CMS