Details
This advanced Microsoft Excel training course will teach you to use the advanced features of Excel in any version to their full extent. By the end of this course, you will be able to report on data in a list using PivotTables, edit and analyse complex data using advanced features such as Scenarios, Goal Seek and Solver, incorporate built-in functions into a worksheet, work with controls and record macros.
This course is instructor led, and involves lots of examples and exercises in a workshop environment. Led by highly experienced Microsoft Excel trainers with many years of experience our hands-on courses mean that you will leave with lots of practical Excel experience as well as useful tips and tricks. We train on version 2013 which is almost identical to 2007, 2010 and 2016, please make the trainer aware on the day if you use a another version and they can point out anything that may be slightly different.
Once you have completed this you will be ready to go on to our Excel Advanced Extra course or maybe Excel VBA
- create and use defined names in a workbook
- work with logical function in Excel
- use a variety of data validation techniques
- use a range of lookup and reference functions
- create summaries in your spreadsheets using subtotals
- understand and create simple PivotTables
- construct and operate PivotTables using some of the more advanced techniques
- perform a variety of analytical tasks using PowerPivot
- use the Data Consolidation feature to combine data from several workbooks into one
- create and work with scenarios and the Scenario Manager
- use Solver to solve more complex and intricate problems
- import data into Excel and export data from Excel
- create and use a range of controls in a worksheet
- create recorded macros in Excel
- import data into Excel and export data from Excel
It is recommended that students have experience with the fundamental use and features of Microsoft Excel including the ability to:
- Create formulae and basic functions
- Use Absolute Cell references
- Edit data using formatting and layout techniques including Charting
- Work with database tools, including database filtering and functions
If you have not attended our Essential or Intermediate training courses we do send out an exercise once you have booked this course. This is just to double-check that you are familiar with all the topics covered previously.
- A full colour advanced Excel training manual.
- The exercises that you have worked on during your course to allow you to practice afterwards.
- USB stick to take the exercises away (where relevant).
- Freshly prepared lunch in our onsite cafeteria.
- Refreshments though out the day.
- Training in fully air conditioned facilities from an experienced Excel instructor.
Founded in 2002, Acuity is focused on building long-term business relationships by offering high quality, interactive training that works.
Our trainers have years of experience working within commerce and industry, designing and delivering training programmes for all sorts of organisations. Most importantly, they really love what they do.
With class sizes limited to a maximum of 8 delegates (but typically running with between 2-6) our training courses are able to incorporate numerous hand’s on exercises to consolidate the learning and delegates are assured of detailed personal attention, with plenty of time to ask questions and tackle issues that are relevant to them. Each of our delegates receives a full colour manual and copies of the relevant course exercises to take away with them so that they can review the course material in their own time after the course.
Here are just a few reasons why our customers say they keep coming back to us:
•Easy booking procedure.
•Passionate, highly experienced trainers.
•Small, personal classes.
•Relaxed and highly supportive learning environment.
•Relevant and up-to-date training programmes.
•Proven track record, from SMEs to large government departments and multinationals ...
Related Courses
