Skill Details

View Skill (Open Access)

Skill Details

Skill Name

Skill Category

Is Accredited

NoYes

Is Apprenticeship

NoYes

Skill Overview

The course offers an exciting and innovative approach to Excel training. It consists of 10 modules and includes media demonstrations, hands-on activities, and knowledge check questions. At the end of the course, you will complete a consolidation exercise, which will help you review what you have learned and assess your understanding.

The course also contains quizzes at the end of each module and a Validation Test at the end of the course. With successful completion of the course, you will receive a Pitman Training certificate to verify your achievement.

Learning Objectives

- Describe the components of the Excel 2019 window 
- Explain the functions of the commands in Backstage View
- Enter text and numbers
- Create formulas
- Use relative, absolute, and mixed references in formulas
- Work with ranges
- Open workbooks
- Save Excel files in various formats
- Navigate worksheets and workbooks
- Freeze and split panes
- Add headers and footers
- Work with comments
- Adjust page setup options, add print titles, and print workbooks
- Adjust and modify rows, columns, and cells in a worksheet
- Move and copy cell content
- Use the Paste Options features
- Create formulas using functions
- Add, delete, and rename sheet tabs
- Move, copy, and hide worksheets
- Create three dimensional formulas
- Format cells and numbers
- Add borders and shading
- Format data as a table
- Use the Format Painter
- Apply styles
- Add sheet protection
- Use the Fill Handle
- Create lists

Funding Option

Funding Eligibility

Skill Price ex VAT (£)

Skill Length

Skill Level

Skill Timings

Delivery Method

Skill Eligibility (Prerequisites for skill/software requirements)

Last Application Date

Skill Enrolment

Skill Status

Skill Enquiry Details

First Name

Last Name

Telephone

Postcode

Are you a company owner or senior decision maker?

NoYes

No. of Delegates

What is your company name?

Would you like to explore skills support for your organisation through GM Business Growth Hub?

NoYes

I accept the Terms and Conditions and Privacy Policy

NoYes

Skill