Excel Advanced Training Course
This one day course is aimed at experienced users of Excel. This course will build on the skills acquired on the intermediate course and provide an in-depth knowledge of the software.
Course Details
This is a structured one
day course with expert tuition, demonstrations and hands on practice. A
training manual or reference guide and appropriate exercises are provided.
Course Objectives
- Use Excel's tools to solve what if problems
- Produce complex spreadsheets in Excel
- Gain experience of recording and running macros to automate your work
Course Content
- Brief revision of intermediate topics.
- Advanced Functions and Formulae; including, VLOOKUP, HLOOKUP, Nesting functions i.e If and functions for interrogating database lists on a worksheet.
- Using Excelâ..s forecasting tools to predict trends and analyse data.
- Creating an Outline to summarise data on large worksheets
- Linking workbooks and using data consolidation to link data
- Data validation, drop down lists etc.
- Linking files and data exchange with other programs.
- Creating customised Menus and Toolbars.
- Recording macros to automate frequently performed tasks.
- Working collaboratively, sharing workbooks and tracking changes.
- Using auditing to troubleshoot workbooks.
- Hyperlinks, templates and more...
Microsoft Excel Training Course Locations
- West Yorkshire: Leeds, Bradford, Halifax, Huddersfield, Wakefield, Bingley, Pontefract, Castleford, Dewsbury, Keighley
- South Yorkshire: Sheffield, Doncaster, Barnsley, Rotherham
- North Yorkshire: Skipton, York, Harrogate, Wetherby, Whitby, Scarborough
- Lancashire: Manchester, Preston, Blackburn, Accrington, Burnley, Oldham, Bolton, Wigan, Liverpool, Lancaster, Stockport, Southport, Rochdale
- Derbyshire: Derby, Chesterfield, Dronfield, Long Eaton
- Nottinghamshire: Nottingham, Ilkeston, Mansfield, Sutton in Ashfield, Worksop, Hucknall, Beeston
- Lincolnshire: Lincoln, Gainsborough, Boston, Sleaford, Market Rasen, Grantham, Grimsby, Scunthorpe, Cleethorpes, Skegness
- Leicestershire: Leicester, Loughborough, Hinckley, Melton Mowbray, Coalville, Lutterworth
- Staffordshire: Stafford, Stoke-on-Trent, Wolverhampton, Walsall, Cannock, Lichfield
Contact Us
Use our simple form to contact us for further information about this course.
