Course Finder
Choosing the course that's right for you.
  • cpd
Course Category: Social Media

Microsoft Excel Expertise: Intermediate Training Course

New course
Who Would Benefit

This course is ideal for business professionals, data analysts, financial experts, and administrative staff who regularly work with Excel and wish to improve their productivity and efficiency.

Course Description

Elevate your Excel skills by delving into advanced functionalities and features. Whether you're a seasoned user or looking to expand your Excel expertise. You'll explore the power of conditional formatting, learn to create insightful charts, and discover the full potential of the Insert Ribbon and other features important for people who will be using Excel as a big part of their role.

 

  • Course Category: IT, Microsoft and Social Media
  • Recommended No. of Days: 1
  • Course Location: To be determined by Client
Learning Outcomes
  • Develop proficiency in using relative and absolute references, If statements, and popular formulas to streamline data analysis and decision-making processes.
  • Gain expertise in employing conditional formatting and features to customise your workbook.
  • Master the skills of linking workbooks and integrating Excel with other applications.
  • Implement data validation, perform advanced lookups, and utilise data protection techniques.
The Programme Includes:
  • Relative Vs Absolute References
  • If statements
  • Popular Formulas
  • Conditional Formatting
  • Inserting Charts
  • The Insert Ribbon – Further Features
  • Linking Workbooks
  • Data Validation
  • Vlookup, Hlookup & Xlookup
  • Further Chart Effects
  • Hyperlinks
  • Text Box & Format Drawing Tools
Need to ask us a question?
Use the submission for below

You can also find us here
  • 0333 5777 144
  • info@maguiretraining.co.uk