Microsoft 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:
|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|
|IF (including NESTED IF)||EDATE|
|WORKSHEET PROTECTION||WORKBOOK PROTECTION|
|TABLES||FILTERS, ADVANCE FILTERS|
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.