Microsoft Excel Training
All Darren’s courses are tailored to your requirements allowing you to cherry pick the formulas and functions that will add the most value. Following contact, a short questionnaire will be emailed to understand the Excel formulas and functions you already utilise but also the formulas and functions that can help improve the way you use in Microsoft Excel.
Darren is a Certified Microsoft Excel Specialist with 20 years’ experience in the finance environment working as a financial analyst for large corporates such as Fender Musical Instruments, MiTAC Int. Corp and Thales Group.
Who is this course for?
This course is intended for employees wishing to further their Excel formula and function knowledge. Courses are specifically tailored to add instant value to your workplace.
The initial questionnaire will form the general direction of a course. The course is not aimed at a beginner, intermediate or advanced level necessarily to avoid covering topics not relevant to your workplace.
How good are you at Excel?
Download my Excel test file now to see how good you are!
Delegates should be using Excel regularly in the workplace.
£299 (inc VAT) per day for 1-to-1 course
£399 (inc VAT) per day for groups (max 4)
Delivered in your Workplace
1 Day (6 hours)
Microsoft Excel Training file supplied to aid course.
All courses are delivered by Daren Vick.
At the end of this course you will be able to instantly implement new formulas and functions in the workplace.
Update or create new more efficient Excel workbooks.
(You can cherry pick items that suit your requirements or Darren can advise items following a quick communication)
MAX, MIN, MAXIFS and MINIFS
MROUND, ROUND, ROUNDUP and ROUNDDOWN
PROPER, UPPER, LOWER and TEXT
SEARCH and SUBSTITUTE
TRIM, CLEAN and VALUE
IF, nested IF, OR and AND
ADDRESS and INDIRECT
CEILING and FLOOR
COLUMN and ROW
COUNT, COUNTBLANK and COUNTIFS
DATEDIF, EOMONTH, EDATE, NETWORKDAYS, NOW and WEEKNUM
HLOOKUP, VLOOKUP and MATCH
IFERROR and ISERROR
LEFT, RIGHT and MID
PIVOT TABLES and PIVOT CHARTS (inc Slicers and Timelines)
GROUP and UNGROUP
PROTECTING tabs and worksheets
Custom DATE and NUMBER Formats
Connect to External data (MS Access and MS Query)
Multi worksheet SUM