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 Level 2 course
This Office 365 Excel 2019 Advanced Level 2 course introduces delegates to a number of advanced features of data management including ‘What-if’ data analysis tools, form creation tools, customisation and automation as well as exploring some of the less commonly used features or the product.Download PDF
What will you learn?
- Creating, using and editing a template
- Read Only files
Creating Custom Views
- Goal seek
- Scenario Manager
- Data Tables (1 and 2 way)
- Simple Arrays
- Arrays using criteria
- Frequency function
- Tracing precedents and dependents
- Tracing errors
- Evaluating formulas
- Using the Watch Window
Summarising data using outlining tools
Advanced Pivot Tables
- Grouping / Timelines
- Adding calculated fields
- Slicing multiple Pivot tables
- Adding conditional formatting
- % Difference from
- Creating bespoke number formats
- Creating bespoke date formats
Data Consolidate feature
Create custom forms for users to fill out using:
- Check boxes, option buttons, combo boxes, lists and spinners
- (Macros are covered fully on the Excel VBA course)
- What is a Macro?
- Security levels
- Record a simple macro
- Assign shortcut keys
- Create a macro toolbar
- add a button to it
- assign a macro to a button
- Deleting macros and toolbar buttons
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.
“AEG Europe - Excel Advanced Sept 2018 Really Useful. So much to learn - could probably be 2 days. - Matt Great training day. The course was brilliant, didn't get bored which was brilliant! - Gabrielle”Excel Advanced course review
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.NOTE: We only offer this O365 Microsoft Excel 2019 Advanced course on a private in-house basis.
Contact us to discuss your training needs...