Course Duration
1 Day
Location
Cauldon Campus
Course Cost
£ 15.00
Do I have to pay this fee? These courses receive government funding, and some learners will be eligible for FREE tuition if they meet specific criteria. Some L code courses at Level 3 to 6 may also have an Advanced Learning Loan available for learners aged 19 and over.
Course Code
PL6132
Start Date
-
Start Time
09:00:00
Day
-
Enquire Now

Course Summary

This course is intended for those who have a good level of Excel and want to develop their skills further in the following areas:
​

Course Requirements

​
​

Entry Requirements

A good level of Excel knowledge.

How Is It Assessed

There is a test but no formal assessment.

How Is It Taught

Classroom based.

What Could I do Next

Higher IT courses in MS Word or PowerPoint.

What Else Do I Need To Know

1. Creating Tables in Excel 2. IF and nested IF Functions 3. V Lookups & H Lookups 4. Working with Formulas (SumIF, CountIF, CountA) 5. Advanced Filters 6. Advanced List management 7. Importing & Exporting Data 8. Spreadsheet Security 9. Pivot Tables 10. Advanced Graphs and Charts
​

Entry Requirements

A good level of Excel knowledge.

How Is It Assessed

There is a test but no formal assessment.

How Is It Taught

Classroom based.

What Could I do Next

Higher IT courses in MS Word or PowerPoint.

What Else Do I Need To Know

1. Creating Tables in Excel 2. IF and nested IF Functions 3. V Lookups & H Lookups 4. Working with Formulas (SumIF, CountIF, CountA) 5. Advanced Filters 6. Advanced List management 7. Importing & Exporting Data 8. Spreadsheet Security 9. Pivot Tables 10. Advanced Graphs and Charts

Related News

Courses you might like