Course Duration

1 Day

Location

Cauldon Campus

Course Cost

£ 35.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

Multiple Options Available

Start Time

Multiple Options Available

Day

Multiple Options Available
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