Microsoft Excel Training

M_EXcel.png

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.

Microsoft_specialist.png

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