We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?

Details

Excel Advanced Workshop

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.

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.

Outline

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 2007 or newer to the training day. Anything before 2007 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.

Speaker/s

Nigel Robertshaw

Schedules

No. of Days: 1
Total Hours: 7
No. of Participants: 6
Reviews
Be the first to write a review about this course.
Write a Review
Founded in 2010, we train business, industry and schools across the north of England. Our small team, led by Allison, recognise the importance complaint training plays in your workplace in helping you and your staff stay safe at work.

We hold full accreditation and offer a wide range of courses taught by tutors which are backed by years of industry experience. And, with our excellent customer service, you will always get through to a friendly voice that has your best interests at heart.
Livius Training
Rabbit Hill Business Park
01423 396780
Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.