sss

Microsoft Excel Training Courses

Enliten IT have an extensive range of Microsoft Excel training courses to give you the skills to ‘Excel’ at work!  Whether you are new to Excel, are self-taught or you think you know a fair bit, we've got a course for you.

We have certified Microsoft Excel trainers and consultants throughout the UK, so why not take advantage of our, cost effective, tailored onsite training options (we come to you!).  Alternatively, you can come to one of our training centers.

We train on ALL versions of Microsoft Excel and to All levels!

Office 365 Excel 2019 Advanced course

1 day

This Office 365 Excel 2019 Advanced course is predominantly mathematics based, concentrating on the use of complex formulae and logic within formulae.  It also covers some less used but still useful advanced features.

Download PDF

What will you learn?

At the end of this Office 365 Excel 2019 Advanced course, delegates will be aware of the capabilities, and uses, of some of the more advanced functions within Excel.

Audience?

Users who need to use and explore more complex formulas that will make Excel ‘do the work’ for them.

Course Contents


Using Logic

  • IF statements and nested IF’s
  • Conditions – AND/OR/NOT
  • IFERROR
  • SUMIF/s; COUNTIF/s; AVERAGEIF/s

Lookup Tables

  • Range Names review
  • VLOOKUP (range and exact match’s)
  • MATCH & INDEX

Conditional Formatting

  • Using logical parameters
  • Using date ranges
  • Using formulas

Using Mixed references

Find and Remove duplicates

Data Validation

  • Dynamic and Data dependent lists – OFFSET, INDIRECT

String Functions

  • Joining Text and Cells together (&)
  • LEFT, MID, RIGHT, LEN, FIND, TRIM,
  • SUBSTITUTE, VALUE, EXACT, DATEVALUE

Useful Functions

  • SUMPRODUCT, RANK
  • Calculations using Dates and Times e.g. DATEDIF, TEXT, WEEKNUM

Text to Columns feature

Advanced Charting

  • Adding non-adjacent data
  • Mixing chart types
  • Using dual Y-axis
  • Adding Trendlines
  • Bar of Pie; Pie of Pie

Optional Topics (time permitting)

  • Importing Data
    • Import data from text files (Import Wizard)
  • Hyperlinks - to link a cell, sheet, document or web page
  • Useful Add-ins
    • Printing grouped worksheets and multiple workbooks

Course Materials

Enliten IT will provide each delegate with a workbook and other useful reference materials where applicable.  These may be either paper based or in Adobe pdf format or a combination thereof.

“Individually focused for each user, able to pick poor trainer’s brain.  Access 2010 tailored course, August 2012”Able to pick poor trainer’s brain.

Additional Information

Enliten IT reserves the right to modify course content and materials as required in the interests of continuous course improvement, at any time, without notification.

The suggested course duration is a guideline.  Course topics and duration may be modified by the instructor based upon the knowledge and skill level of the course participants.

Contact us to discuss your training needs...

0845 108 5481 0845 108 5481
info@enliten-it.com info@enliten-it.com