Description
Become an expert in Excel with our Excel advanced workshop.
This course is ideal for regular users who need or want to extend their knowledge of Excel and get into more complex functions.
On completion, candidates will have a greater knowledge of a range of tools to use. These will help automate processes, gather results from complex questions and create pivot tables.
We run the Excel advanced workshop in small groups to offer more 1-to-1 tuition. Plus, each candidate will receive a memory stick with all the coursework examples to take away with them.
Course Contents
Candidates will learn the advanced techniques. These are areas such as using goal seeker, creating advanced functions and list management.
The full course content is:
- Creating and maintaining a list
- Using the data form
- Sorting and filtering data
- Using subtotals
- Creating a user-defined function
- Creating pivot tables and chart reports
- Using goal seeker and solver
- Using scenario manager
- Recording and using macros
Requirements
Candidates will need to bring a laptop loaded with Excel 2010 or newer to the training day. Anything before 2010 has a different interface which will not be the same as the instructors. However if this is a problem please notify us on booking so we can make alternative arrangements for you.
Certification
Candidates will receive a certificate shortly after taking the course stating their workshop attendance.
Who needs the Excel Advanced Workshop?
This course is for those who use the Excel software day-to-day and need a greater understanding of its complex functions and processes.
As a guideline, those who have completed our Intermediate workshop or have a similar knowledge should complete this course. Look at our intermediate workshop contents to check your current knowledge.
Worried you don’t have adequate knowledge? View our Excel Intermediate workshop or contact us for guidance.
What can Excel do for my business?
Excel has grown into one of the most important pieces of software in the workplace. This is because it is used in many different areas, such as:
- Accounting
- Marketing
- Human resource planning
- Tracking and recording stock
Knowing how to use excel effectively means that more tasks can be integrated. This allows you to save time and money. A few of the important benefits are:
- Analysis can be performed on large data sets
- Easy comparison between data sets
- Automation of simple tasks
Stay on top of your training by downloading our exclusive Training Organiser.
Sophie (verified owner) –
The course was fantastic. I completed the advanced excel training with Nigel and it was a one to one session over zoom. I learned so much that I’m already now implementing into work and for the first time have actually been excited about spreadsheets! Thank you so much to Livius Training, from start to finish you made it easy, from making the booking, keeping me updated and Nigel was fantastic and made the course fun and easy to understand. Highly reccomend booking with Livius, I can’t imagine having gone with any other company now!!!