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.

Course Tutor
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!
Requirements:
Delegates should be using Excel regularly in the workplace.
Price:
£299 (inc VAT) per day for 1-to-1 course
£399 (inc VAT) per day for groups (max 4)
Study Method:
Delivered in your Workplace
Duration:
1 Day (6 hours)
Additional info:
Microsoft Excel Training file supplied to aid course.
All courses are delivered by Daren Vick.
Overview
Course Objectives:
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.
Course details:
(You can cherry pick items that suit your requirements or Darren can advise items following a quick communication)
Formula options
MAX, MIN, MAXIFS and MINIFS
MROUND, ROUND, ROUNDUP and ROUNDDOWN
PROPER, UPPER, LOWER and TEXT
RANK
SEARCH and SUBSTITUTE
SUBTOTAL
SUMIFS
TRIM, CLEAN and VALUE
IF, nested IF, OR and AND
ADDRESS and INDIRECT
AVERAGEIFS
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
Function Options
CONDITIONAL FORMATTING
TABLES
CHARTS
PIVOT TABLES and PIVOT CHARTS (inc Slicers and Timelines)
HYPERLINKS
DATA VALIDATION
GROUP and UNGROUP
PROTECTING tabs and worksheets
FORM CONTROLS
FILTERS
Custom DATE and NUMBER Formats
Connect to External data (MS Access and MS Query)
Multi worksheet SUM