Course description
Intermediate Microsoft Excel
This course is for anybody wanting to increase their knowledge in Microsoft Excel and looks at Microsoft 365 but also looks at previous versions, of 2016, 2013, 2010 or 2007, as it covers all the aspects and differences between the versions. It helps participants improve their knowledge and skills to ensure that they are able to maximise the full use of MS Excel.
To ensure success, participants should have completed our Basic Microsoft Excel course or are familiar with the topics in this course
Upcoming start dates
Suitability - Who should attend?
Who should attend?
Anybody wanting to learn intermediate Microsoft Excel functions
Outcome / Qualification etc.
By the end of the course, participants will be able to:
- Understand basic functions of Microsoft Excel
Training Course Content
- If statements
- Conditional Formatting
- Inserting Charts
- The Insert Ribbon – Further Features
- Linking Workbooks
- Linking Excel with other applications
- Creating Basic Macros
- Data Validation
- Custom Views
- Working with large spreadsheets
- Further Chart Effects
- Hyperlinks
- Text Box & Format Drawing Tools
- Headers & Footers
- Page Layout
- Entering Basic Formulas
- Hiding Cells & Data Protection
- Relative Vs Absolute References
Expenses
Course Price:£180 + VAT
Request info
Oakley Services UK Ltd
Since its founding in 2007, Oakley Services UK Ltd trading as Oakley Training and Consultancy provides efficient, engaging, and practical training and consultancy covering a wide range of popular business needs. Hosted from our Head Office and dedicated training facility...