Home > Microsoft Excel

3. Excel Inter (Level 1)


Our Price: £150.00
3. Excel Inter (Level 1)

Excel Intermediate (Level 1)
Duration 1 Day (9:00 am - 1:00 pm)
Location: Welwyn Garden City
Includes: Refreshments and Documentation
Price: £150 per delegate


Not sure if this course is right for you? Take our Quick Quiz or a FREE - Training Needs Analysis

Who is this course for? This course is designed for users who have previously attended an introductory course or who have an equivalent level of knowledge.

What will they learn? This course is for delegates who already have a good grasp of Excel formula and simple functions but would like to expand their function knowledge to use decision-making functions such as IFS and LOOKUPS. You will learn how to "nest" functions, so that you can use more than one function in any given cell.  It shows helpful tips for calculating over multiple sheets and linking information into other programmes such as Word or PowerPoint. You will be taught how to use conditional formatting to change the colour of a cell dependant on its value.

  • Linking Data Between Worksheets
  • Creating a 3-D Formula Across Worksheets
  • Password Protecting Data
  • IFS and Lookup Functions
  • Using Nested Functions
  • Creating Custom Number Formats
  • Predefined Conditional Formatting