Excel level 2 – Intermediate
- Use Logic Functions
- Use Lookup Functions
- Sort and Filter data
- Understand and use Nested Functions
- Chart Formatting
1: Who is the Course for?
This course is designed for users who wish to increase their skills and knowledge of spreadsheets and Microsoft Excel. This level will help the delegate to produce more productive spreadsheets using formulas and function techniques.
2: The Course
The course is tutor led. The tutor will use demonstration and discussion along with hands-on practical tasks and assignments to ensure each user has gained an understanding of each topic. Questions are encouraged throughout the session. During each task and assignment the tutor will give one to one support as required.
Each delegate will receive a manual and a certificate of attendance
4: Course Content
| The Ribbon Bar
Import CSV or Txt
Absolute & Relative Referencing
Nested IF Function
|TRUE – FALSE
AND OR NOT
Naming Cells & Ranges
Available In-House Courses
|Microsoft Excel||Microsoft Word||Microsoft PowerPoint||Microsoft Outlook|
|Excel Introduction||Word Introduction||PowerPoint in a Day (All Levels)||Microsoft Outlook in a Day|
|Excel Intermediate||Word Intermediate||—||—|
|Excel Advanced||Word Advanced||—||—|