ADVANCED MICROSOFT EXCEL
Microsoft Excel provides a range of advanced functions that greatly extend its capabilities. Powerful analysis, forecasting, automation and presentation techniques offer wide-ranging business benefits for members of staff that have learnt to harness them.
Our CPD Certified Advanced Excel course will take your staff’s Microsoft Excel abilities to the next level. It demystifies the most complex areas of Excel using written text, screenshots and 160 videos.
By the end of the course your team will be proficient in the more complex functions and formulae used in Excel. They'll be able to apply these to their work to deliver more in-depth analyses and become more efficient in their spreadsheeting. The course is available for PC versions 2007, 2010 and 2013, and the areas covered include Advanced Range Names, Array Formulae, Visual Basics and Macros, PivotTables and PowerPivots.
WHO'S IT FOR?
PC with a full version of Microsoft Excel (any version from 2007 to 2013 or Microsoft 365).
Not a requirement but a benefit to have some work-related projects to which you can readily apply what you learn.
For expert Excel users looking to take their proficiency to the next level.
Accountants, bookkeeppers, teachers, salespeople, managers. The list just doesn't end with Excel.
Use advanced graphics and presentation techniques to create impactful slides.
Increase interactivity and automate your spreadsheet with macros and Visual Basic.
Solve complex problems with superpower functions.
Use PivotTables and PowerPivots to turn raw data into refined information to support key decisions.
ABOUT THE AUTHOR
Simon Hurst is a Chartered Accountant and has been involved in computer software for 26 years during which he has provided a wide range of training services to professionals of all levels. His expertise lies in all the main Microsoft applications and he's been running hands-on Excel training courses for over 20 years, dealing with all aspects of Excel from basic competence to advanced data analysis. He is able to bring these years of practical experience to our Excel and Advanced Excel courses, ensuring that the courses explain advanced concepts clearly and concisely, and with real, practical applications and even the occasional joke.
"Learning and development had not been created as a continuous activity. Training was often one off interventions with the impact difficult to measure. Filtered has helped us change that in a short period of time. The cultural change it has driven in terms of reinforcing an expectation of continuous learning at all levels is the biggest achievement to me."
"We partnered with Filtered because we liked the idea of learners being able to tailor resources based on their knowledge gaps. The quality of reporting data provided allowed us to calculate an ROI of £1.80 for every £1 invested in a licence."