Loading Events

« All Events

  • This event has passed.

August 2017 Workshop

Aug 23, 2017 @ 9:00 am

R100

Topic: Intermediate Excel

Super practical and great value! This is what will be covered:

  1. Creating a Filter and using Filters.
  2. Conditional Formatting
  3. Data sort by multiple Fields
  4. Remove Duplicate data
  5. Find and Replace
  6. Data Capturing Validation (Data rules, comes with errors if wrong data captured.
  7. Text to column using a common separator including SPACE, COMMA.
  8. Group / Ungroup data and Subtotal
  9. Name Manager.
  10. Dates
  11. Functions

Book HERE

Click on "Select Options" below to choose your booking options.

R100.00BOOK NOW

roger-1

Guest Speaker: Roger Ramseier

Roger Ramseier is the Managing Director of Ritzy IT Pty Ltd and has been in business since 1993.

Ritzy IT specializes in Sage Pastel Accounting and Payroll software. What makes us standout from our competitors is our advanced skill set. Rogers advanced skills comes from a solid understanding of excel and formulas, mastering excel helps with all aspects of your business. Having advanced excel skills can turn manual processes that took weeks to complete into something that takes only a few minutes.

 

Details

Date:
Aug 23, 2017
Time:
9:00 am
Cost:
R100
Event Category:

Organizer

KZNWIB
Phone:
031 266 2892
Email:
meetings@kznwib.co.za
Website:
www.kznwib.co.za

Venue

18 Burlington Conference Centre
18 Burlington Drive
Westville, Kwazulu Natal 3629 South Africa
+ Google Map
Website:
http://18burlington.durban