Want to develop your skills on Excel? This one-day intermediate Excel course will extend your basic knowledge and provide you with skills and knowledge to produce more effective and productive workbooks.
The session will cover formulas and function techniques, more intricate formatting, setting complex printing options, using intricate charting features, and working more effectively with existing worksheets and workbooks.
Course overview
- Working with multiple workbooks
- Formulas – recap the basics
- Formula referencing (understanding $ in formulas)
- Filtering data
- Working with Excel Tables
- Logical Functions (IF, AND, OR)
- Conditional Formatting
- Lookup functions (VLOOKUP and XLOOKUP)
- Introduction to Pivot Tables
- Filling series (Including Flash Fill)
Tips, tricks and shortcuts throughout
What outcomes can you expect from taking part
On completion of this course you should be able to use the fill operations available; understand and use absolute and relative formula referencing; sort data in a worksheet; use a range of logical and lookup functions; work with a variety of elements in a worksheet; work with more than one workbook at a time and filter large amounts of data in a table.