Request info on Cape Town Excel training dates, prices and venue
We will be running a public Microsoft Advanced Excel tra
ining course in Cape Town covering advanced Excel functions, pivot tables and graphing.
The course will be held at the Rockwell Hotel in Greenpoint. We are offering a special 10% discount for early bird bookings. The course is over 3 days but you are able to either attend all 3 days or else attend the modules that are included in the course.
- Day 1 will cover pivot tables and graphing
- Day 2 and 3 will cover advanced excel tools and functions
The aim of the course is to provide practical excel tips, tricks and techniques to improve how you work with data. Over the 3 days, some of the areas covered will include:
- Reconcile accounts to identify the transactions that are missing, duplicated or different
- Creating conditional functions i.e. if one cell says this do something specific
- Deleting unnecessary lines from databases
- Removing duplicate entries from lists
- Joining excel databases together e.g. your invoice listings with your address listings
- Convert rows into columns (easily)
- Separate text in a cell e.g. names into first name and surname
- Join cells together to form a single cell e.g. names, sms messages, mail merging
- Convert dates from american style (mm/dd/yyyy) to ‘normal’ style (dd/mm/yyyy) with one or two clicks
- Calculate the working days in a year
- Categories lists into bands e.g. employee rankings, basket sizes, product types
- Find the missing transaction
- Format your reports so that the colours change (automatically) according to the results
- Record a macro to automatically hide unnecessary rows
- Group transaction into weeks, months, quarters, years
- and much much more
For full contents look at the Cape Town Advanced Microsoft Excel course page
Request info on Cape Town Excel training dates, prices and venue