Home > Microsoft Excel

Excel Inter (Level 1)

Dates

Our Price: £150.00
Excel Inter (Level 1)
Description
Excel Intermediate (Level 1)
Duration 1 Day (10:00 am - 2:30 pm)
Location: Welwyn Garden City
Includes: Lunch 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.
  • Using Multiple Worksheets
  • Creating and Opening a Workspace
  • Linking Data Between Worksheets
  • Creating a 3-D Formula
  • Protection
  • IFS and Lookup Functions
  • Using Nested Functions
  • Creating Custom Number Formats
  • Predefined Conditional Format