Excel : Working with Data and Lists
Venue Hennessy Park Hotel Ebene
Date Tuesday 10th July 2018
Time 09:30 - 12:30

    This course covers the most useful tools used to summarise and analyse lists of data. You will learn how to structure data lists sort and filter lists (including advanced filters) and use summarising tools including Consolidate SubTotal Tables and PivotTables. You will also learn how to create conditional calculations using SUMIF(S) AVERAGEIF(S) and COUNTIF(S). Finally you will learn how to apply conditional formatting to data. At the end of this course you will be able to structure and analyse data using a variety of methods and have many of the summarising tools required to set up an Excel Dashboard.
Vickie Watt
CPD Units 3 units on full attendance
Seats Left 1
Price Rs 4000
Booking Deadline Tuesday 10th July 2018
Map View Map