Advanced Skills in Microsoft Excel

✔ Start to Upskill immediately

✔ 100% Online with tutor support

✔ Only €25 a Week

Key benefits

  • Learn advanced Microsoft Excel Skills and gain an accredited certificate
  • Developed by a highly qualified Microsoft Excel expert
  • Learning online allows you to study anytime, at home or the office
  • Receive tutor support via email or by calling our toll free number
  • You will learn how to

  • Apply advanced functions to access multiple sheets and manipulate data
  • Apply advanced chart features to visually represent your data
  • Protect your spreadsheet from accidental or intentional harm
  • Automate activities within your spreadsheet using macros
  • Gain a deeper understanding of your data using the data tools
  • Course Summary

    Investment: £399 + VAT or only £25 per week on a payment plan.

    Assessments: Case studies, quizzes, written assessments and practical exercises

    Duration: 8-10 hours 

    About the course developers: This course has been developed by the team at The Career Academy.

    CITU1003 – Covering the module

    Advanced Functions
  • Absolute referencing
  • Range names
  • Using the IF function
  • Using the VLookup function
  • Nesting functions
  • Advanced Chart Features
  • Formatting chart objects
  • Trendlines
  • Creating pivot charts
  • Manipulating pivot charts
  • Securing Spreadsheets
  • Protecting your worksheet
  • Protecting your workbook, including using passwords
  • Using Excel Macros
  • Creating macros with the macro recorder
  • Running a macro
  • Excel Data Tools
  • Removing duplicates
  • Text to columns
  • Goal seek
  • Scenario manager
  • This Course is accredited by ICOES

    ICOES, the International Council for Online Educational Standards guarantees you a high standard of content with measurable outcomes from a reputable training organisation. ICOES is the accrediting body that establishes, monitors and continually develops the educational standards of online teaching institutions.

    ICOES Logo

    Meet your Tutors

    Our tutors at The Career Academy are industry experts who are passionate about helping students succeed. Students receive unlimited tutor support via phone and email. Our tutors are committed to providing exceptional online courses and personal tutor support.

    We offer a range of employer recognised courses as well as specialist courses to improve job performance.

    Earn a Certificate

    Professional Certificates by The Career Academy help you get job-ready for an in-demand career field. Earn a career credential, apply your knowledge to hands-on projects that showcase your skills for employers, and get access to job search resources. Many programs also provide a pathway to an industry-recognized certification.

    Certificate

    Ready to start learning?

    1. Decide payment options

    2. Click on Enrol

    3. Receive account details via email and start learning!

    Hmm feeling unsure?

    Download a free course guide!

    All you need to know about The Career Academy, Full course modules, and Pricing!

    submitform

    Get Your Free Course Guide

    0

    Your Cart

    Close Bitnami banner
    Bitnami