• Twitter
  • Facebook
  • LinkedIn
  • Meeting Room
  • My Account
  • Basket
  • Checkout
01423 396780
  • 0Shopping Cart
Livius Training
  • Home
  • Our Courses
    • First Aid Training Courses
      • Emergency First Aid at Work
      • First Aid at Work
      • First Aid at Work Refresher
      • Emergency First Aid for Forestry – EFAW+F
      • Paediatric First Aid
      • Emergency Paediatric First Aid
      • Mental Health Awareness – 1 Day
      • Mental Health First Aider – 2 Days
      • Anaphylaxis & Epipen Training
      • Basic Life Support & Defibrillator
      • Mini Medics – 1/2 day
    • Health & Safety Training
      • Level 2 Health & Safety
      • Level 3 Health and Safety
      • Manual Handling
      • Working at Heights
      • Abrasive Wheels
      • UKATA Asbestos Awareness – 1/2 Day
    • Fire Safety Training
      • Fire Safety Awareness
      • Fire Marshal Training (Level 2)
    • Food Safety Training
      • Front of House Food Safety
      • L2 Food Safety in Catering & Manufacturing
      • Level 3 Supervising Food Safety
      • Level 2 HACCP
      • L3 HACCP
    • IOSH Courses
      • IOSH Managing Safely
    • Water Training
      • National Water Hygiene Card (Blue Card)
      • SHEA Water (Safety Health & Environmental Awareness) – 1 day
      • Managing Water Systems Safely – 1/2 day
    • Computer IT Training
      • Excel Beginners Workshop
      • Excel Intermediate Workshop
      • Excel Advanced Workshop
    • Forklift Training Courses
      • Forklift Training Courses
    • Business Training
      • Quickbooks Beginners Workshop – 1 day
      • L2 Personal Licence Holders (APLH) – 1 day
      • Customer Service Workshop
  • Open Courses
  • Onsite Training
  • Virtual Courses
  • e-Learning
  • Advice
  • Contact Us
  • Menu
computer training, excel advanced workshop training, microsoft, macros, spreadsheets, formula

CPD Icon

Complimentary CPD Service

All Livius candidates will receive at least 2 annual updates for their course subject, leading to quick & simple CPD.

Onsite Training Courses delivered by tutors across Yorkshire on your premises

Onsite Training

Book group training courses on your premises. Available across Yorkshire & the North of England.

Our Trainers

You’ll receive the best quality training from our engaging instructors that have educated hundreds of candidates.

Excel Advanced Workshop – 1 day

£240.00 Ex. VAT

Course Dates: 

  • Wednesday 6th July 2022 – Virtual Course
  • Wednesday 14th September 2022
  • Friday 18th November 2022
  • Wednesday 21st December 2022 – Virtual Course

Course Time: 9.30am – 4.30pm

Course Location: Livius Training Centre, Rabbit Hill Business Park, Boroughbridge, HG5 0RB

Virtual Courses: Held online using Zoom, Visit our Virtual Courses for more information.

For additional availability please call 01423 396780

Clear
SKU: N/A Category: Computer Skills Tags: excel advanced, excel training, IT skills, Microsoft excel training
  • Description
  • Reviews (0)

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.

Reviews

There are no reviews yet.

Be the first to review “Excel Advanced Workshop – 1 day” Cancel reply

Your email address will not be published. Required fields are marked *

You may also like…

  • computer training, Microsoft Excel Intermediate Training, Excel Intermediate workshop courses, North Yorkshire
    Rated 5.00 out of 5

    Excel Intermediate Workshop – 1 day

    £130.00 Ex. VAT
    Book Now
  • Emergency First Aid at Work
    Rated 4.88 out of 5

    Emergency First Aid at Work – 1 day

    £80.00 Ex. VAT
    Book Now

Related products

  • quickbooks beginners, accounting software

    Quickbooks Beginners Workshop – 1 day

    £300.00 Ex. VAT
    Book Now
  • computer training, microsoft, excel beginners, north yorkshire courses and training excel beginners workshops
    Rated 5.00 out of 5

    Excel Beginners Workshop – 1 day

    £95.00 Ex. VAT
    Book Now

Subscribe to our mailing list

* indicates required
Interest

Contact Us

Livius Training Centre
Rabbit Hill Business Park
Boroughbridge
HG5 0FF

T: 01423 396780
E: info@livius-training.co.uk

Terms & Conditions | Privacy & Cookie Policy

© 2010 - 2019 Livius Events Ltd - Website by Dales Creative
  • Twitter
  • Facebook
  • LinkedIn
Excel Intermediate Workshop – 1 day computer training, Microsoft Excel Intermediate Training, Excel Intermediate workshop courses, North Yorkshire Level 3 HACCP, Supervising HACCP, Food Safety Training North Yorkshire L3 HACCP – 2 Days
Scroll to top

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies.

OKLearn more


How we use cookies

We may request cookies to be set on your device. We use cookies to let us know when you visit our websites, how you interact with us, to enrich your user experience, and to customize your relationship with our website.

Click on the different category headings to find out more. You can also change some of your preferences. Note that blocking some types of cookies may impact your experience on our websites and the services we are able to offer.

Essential Website Cookies

These cookies are strictly necessary to provide you with services available through our website and to use some of its features.

Because these cookies are strictly necessary to deliver the website, refuseing them will have impact how our site functions. You always can block or delete cookies by changing your browser settings and force blocking all cookies on this website. But this will always prompt you to accept/refuse cookies when revisiting our site.

We fully respect if you want to refuse cookies but to avoid asking you again and again kindly allow us to store a cookie for that. You are free to opt out any time or opt in for other cookies to get a better experience. If you refuse cookies we will remove all set cookies in our domain.

We provide you with a list of stored cookies on your computer in our domain so you can check what we stored. Due to security reasons we are not able to show or modify cookies from other domains. You can check these in your browser security settings.

Google Analytics Cookies

These cookies collect information that is used either in aggregate form to help us understand how our website is being used or how effective our marketing campaigns are, or to help us customize our website and application for you in order to enhance your experience.

If you do not want that we track your visist to our site you can disable tracking in your browser here:

Other external services

We also use different external services like Google Webfonts, Google Maps, and external Video providers. Since these providers may collect personal data like your IP address we allow you to block them here. Please be aware that this might heavily reduce the functionality and appearance of our site. Changes will take effect once you reload the page.

Google Webfont Settings:

Google Map Settings:

Google reCaptcha Settings:

Vimeo and Youtube video embeds:

Accept settingsHide notification only