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
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?
- IF statements and nested IF’s
- Conditions – AND/OR/NOT
- SUMIF/s; COUNTIF/s; AVERAGEIF/s
- Range Names review
- VLOOKUP (range and exact match’s)
- MATCH & INDEX
- Using logical parameters
- Using date ranges
- Using formulas
Using Mixed references
Find and Remove duplicates
- Dynamic and Data dependent lists – OFFSET, INDIRECT
- Joining Text and Cells together (&)
- LEFT, MID, RIGHT, LEN, FIND, TRIM,
- SUBSTITUTE, VALUE, EXACT, DATEVALUE
- SUMPRODUCT, RANK
- Calculations using Dates and Times e.g. DATEDIF, TEXT, WEEKNUM
Text to Columns feature
- 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
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.
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...