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
PL6131
Start Date
Multiple Options Available
Start Time
Multiple Options Available
Day
Multiple Options Available

Course Summary

This course is intended for those who have experience of Excel or have previously completed the beginners course.

Course Requirements

Entry Requirements

Excel users who would like to develop their skills further.

How Is It Assessed

There is a test but no formal assessment.

How Is It Taught

Classroom based

What Could I do Next

Microsoft Excel Advanced Course

What Else Do I Need To Know

We will be covering the following topics: 1. Worksheet management – comparing/moving/copying 2. Conditional Formatting 3. Linking excel data 4. Paste Specials 5. Freezing/Hiding Rows/Columns 6. Absolute Cell Referencing 7. Working with Date and Time Functions 8. Sorting Data 9. Filters 10. Creating sub-totals 11. Creating and formatting Charts

Entry Requirements

Excel users who would like to develop their skills further.

How Is It Assessed

There is a test but no formal assessment.

How Is It Taught

Classroom based

What Could I do Next

Microsoft Excel Advanced Course

What Else Do I Need To Know

We will be covering the following topics: 1. Worksheet management – comparing/moving/copying 2. Conditional Formatting 3. Linking excel data 4. Paste Specials 5. Freezing/Hiding Rows/Columns 6. Absolute Cell Referencing 7. Working with Date and Time Functions 8. Sorting Data 9. Filters 10. Creating sub-totals 11. Creating and formatting Charts