Microsoft Office Made SimpleMicrosoft Excel is a very popular application used by many businesses. In my last financial year, I have delivered 78 days of Excel training and the most popular of them at Intermediate level. When I ask individuals what they find difficult in Excel, their answer usually is writing a formula. In this session I will explain and show you how easy it is to create/write a formula.

In the business world, large amounts of data is being captured, analysed and then presented on dashboards. No matter how big your business is, this course will help you to create worksheets to capture and analyse the information. On the session I will be covering the following:

Topics Covered

Excel Functions

Statistical Text
COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS LEFT
AVERAGE, AVERAGEA, AVERAGEIF, AVERAGEIFS LEN
Maths & Trig RIGHT
SUM, SUMIF, SUMIFS TEXT
Lookup & Reference TRIM
LOOKUP, VLOOKUP, HLOOKUP Date & Time
INDEX NOW
MATCH TODAY
Logical MONTH
IF (including NESTED IF) EDATE
AND WEEKDAY
OR
NOT

Excel Features

SUBTOTALLING CONSOLIDATE
WORKSHEET PROTECTION WORKBOOK PROTECTION
TABLES FILTERS, ADVANCE FILTERS
SORTING PIVOT TABLES
SLICERS

 

By the end of this session you will be able to analyse data, create pivot tables and charts that can be shown on a dashboard. So if you feel that this is for you then why not buy a ticket to secure a seat on the course.

Tickets to this event can be purchased by clicking on the button below. Hurry closing date 18th June 2017.

2017/06/18 23:30:00
Leave Comment

Your email address will not be published. Required fields are marked *

clear formSubmit