Up to 30% off e-learning!

Click here to view all offers

Use offer code: SALE0324UK
Learn now, pay later – payment options available
e5b89cba-eea6-41b0-a0f2-2ca929b8853b
Enhance your career now
generic.call_us
+44 (0) 1270 611 600
Without exams
Course type: Classroom
Delivery: Classroom
Spread the cost

Desktop IT Intermediate Excel Classroom

Course overview

About the course

Building on your existing knowledge of Excel, this course includes formulas that link worksheets together and linking workbooks, getting Excel to make decisions using the IF function and adding conditional formatting to highlight certain data. You will learn how to create templates for commonly used worksheets and protect data using the security features. You will gain an insight into data tables and use Excel lookup features to automate worksheets. This course will also enable you to create, build and customise graphs including plotting trend lines. You will learn how to use the new sparklines features and data bar enhancements.

  • Be able to use Excel to make decisions using the IF function
  • Understand conditional formatting and highlighting certain data
  • Be able to use lookup functions for range and exact matches
  • Know how to use the new Quick Analysis tools and sparklines, apply filters and sort larger data sets
  • Work with tables and see how useful they can be
  • Review of Excel fundamentals
  • Absolute and relative references
  • Utilising range names
  • Building 3-D worksheets
  • Protecting your formulas – security
  • Group editing
  • IF statements
  • Understanding lookup functions
  • Setting up VLOOKUP and HLOOKUP
  • Using range and exact match types
  • Database features
  • Filtering data with slicers
  • Sorting data
  • Adding filters
  • New table features
  • Creating a calculated column
  • Utilising conditional formatting
  • Adding sparklines
  • New formatting enhancements
  • Quick Analysis
  • Creating a chart
  • Printing

This course is suitable for those who have attended the introductory course or have sufficient knowledge and understanding of the basics of Excel.

Why Choose ILX Group?

Graduates
500,000+
graduates
Corporate clients
5,000+
corporate clients
Customer satisfaction
96%
customer satisfaction