3. Excel Inter (Level 1)

Description

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