June’s local Friday training session is Intermediate Microsoft Excel. The course is ideal for anyone who is either a basic knowledge of Excel’s formulas and functions, or has been on our Intermediate course. Here is a brief overview of the course content:
- Excel overview refresher
- Linking workbook data
- Protecting workbooks & cell ranges
- Advanced conditional formatting techniques
- Finding data records with VLookups
- Filtering data with the Auto & Advanced filters
- Calculating Subtotals and working with Levels
- Sorting data using Pivot Tables & Pivot Charts
- Consolidating data in multiple spreadsheets
- Linking worksheets with 3D formulas
- Data validation & creating drop-down lists
The venue is our training centre at Normanby Gateway, Normanby Enterprise Park, Scunthorpe, DN15 9YG. The course starts at 9.30am and finishes at 1pm. Price is £49 per person + VAT. There is ample free parking along with complimentary refreshments. To reserve your place please call 0800 2922842 or email info@microsofttrainingcourses.org
