Microsoft Office Workshops | Training | Neo Technolgies
Neo Technologies are suppliers of choice for IT equipment and services

Training :

Sorting and Filtering Data

​NEED HELP IN SORTING AND FILTERING LARGE AMOUNTS OF DATA IN EXCEL?

Ideal for people that has to analyse data and find the correct entries out of a list or a table.

  • The Table Feature
  • Finding Records in a List or Table
  • Sorting a List or Table
  • Filtering a List or Table
  • AutoFilter
  • The Top Ten Feature
  • Advanced Filters
  • Sort and Filter with Cell Colours

FOR BOOKINGS CONTACT MR. G: (012) 371 2338 | training@neo.co.za | www.neo.co.za


Click to ask for more

VLOOKUP and Related Functions

NEED HELP WITH VLOOKUP AND THEIR RELATED FUNCTIONS IN EXCEL?

This course is ideal for anyone that constantly have to update data from another list or table into their own list or table in Excel. This course will ensure that you will always be hundred percent sure that the results will be correct. Know how to refer correctly to a list or a table in a VLOOKUP.

  • Understand the syntax of the Vlookup Funtion
  • The correct procedures to ensure the Vlookup Function is used optimally
  • Understand the problems with data that causes the Vlookup Function not to work effectively
  • The related Functions to organise data before doing an Vlookup

FOR BOOKINGS CONTACT MR. G: (012) 371 2338 | training@neo.co.za | www.neo.co.za


Click to ask for more

Pivot Tables & Pivot Charts

NEED HELP WITH PIVOT TABLES & PIVOT CHARTS IN MICROSOFT EXCEL?

This course is ideal for Sales Managers wanting to compare & analyse sales data, Data Analysts frequently working with data & surveys, or anyone wanting to learn more about the use of these features in Microsoft Excel.

Course Structure:

  • Preparing source data for Pivot Tables & Pivot Charts
  • How to create Pivot Tables & Pivot Charts
  • How to format Pivot Tables & Pivot Charts
  • Filtering and managing Pivot Tables & Pivot Charts
  • Using Slicers to filter Pivot Tables

FOR BOOKINGS CONTACT MR. G: (012) 371 2338 | training@neo.co.za | www.neo.co.za


Click to ask for more

Formulas, Functions & Referencing

NEED HELP WITHFORMULAS FUNCTIONS & REFERENCING IN MICROSOFT EXCEL?

This course is ideal for anyone wanting to brush up on their Excel skills, Information workers that need to work with basic data or calculations and anyone wanting to ascertain basic Excel knowledge.

  • The order of operations for all formulas
  • The operators to use in formulas
  • Understanding the difference between formulas and functions
  • Relative versus Absolute referencing
  • The most often used functions (sum, average, min, max, count)
  • How to compound and nest functions
  • Introduction to practical & useful functions

FOR BOOKINGS CONTACT MR. G: (012) 371 2338 | training@neo.co.za | www.neo.co.za


Click to ask for more

Get more info

What you get
A phone call from one of or business consultants
A cost estimate based on your needs
An in person meeting (site visit) if needed
Your Privacy
Your information will not be shared with any Third Parties
×

Find a replacement cartridge

×
Item has been added to your cart.
Continue shopping
×
Your favourites have been updated
Continue shopping
×