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 Pivot Tables, 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.
While you are with us we are focused on offering you a relaxed and productive learning environment.
When you book a course with use you get the following: The first session of this course reviews the concept of creating and using names for cells which is covered in our Intermediate Excel Course.
Excel will automatically sort all continuous columns that have headings and all contiguous rows from the top row under the heading labels down to the last row in the selected column that contains data.
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.There are several ways to create sheet-level names.They include: You can find more about sheet-level names and VBA on this page.We train on version 2013 which is almost identical to 2007, 20, 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 VBAIf you have not attended our Essential or Intermediate training courses we do send out an exercise once you have booked this course.Presented below is a dialog box which shows this expanded functionality.