Skip to main content

Course Overview

This one-day course is intended for anyone who has completed an Excel Intermediate course, or for competent existing users seeking to expand their knowledge of Microsoft Excel.

The course content will include:        

  • Protecting data in worksheets and workbooks
  • Linking cells, worksheets and workbooks
  • Using Logical functions (IF, Nested IFs, AND and OR)
  • Using Data validation techniques
  • Creating Pivot tables and Pivot charts
  • Using What-If Analysis (Scenarios, Goal Seek)
  • Creating and using simple Macros

 

 

If you have completed the Intermediate course at BPC, this is the next logical step to take to expand your knowledge and skills. Or, if you are a competent user of Excel, this will be a perfect way of building up expertise.

To join this course we recommend that you have either attended the intermediate level course, or an equivalent and have a good working knowledge of Excel.

Progress monitoring is informal with continuous assessment throughout the day.

On completion of the Advanced Excel  One Day Course you will have achieved a proficient standard in using Excel, and can progress onto other courses available at The College.

Course price (£220.00 per delegate)  includes refreshments during the day.

Dates during 2024/2025 will be confirmed shortly.

Please call 01202 205739 for details. 

 

 

Awarding Body:
Bournemouth & Poole College

Curriculum Area:
Business, Service Industries and ESOL - Business and Finance

Course Options

Wed 6th November 2024

Attendance

Part-time

Enrol

From courses to careers

£3,182.87

Potential Salary

£17,478.00

Entry Level Salary

£1,671.70

Average Salary

3

Annual Openings

£29,152.18

Potential Salary

£17,964.00

Entry Level Salary

£16,232.24

Average Salary

3

Annual Openings

£44,794.67

Potential Salary

£18,828.00

Entry Level Salary

£29,537.13

Average Salary

1

Annual Openings

£48,148.40

Potential Salary

£21,204.00

Entry Level Salary

£29,424.17

Average Salary

5

Annual Openings

£32,812.58

Potential Salary

£18,666.00

Entry Level Salary

£20,229.84

Average Salary

31

Annual Openings

£42,933.26

Potential Salary

£17,856.00

Entry Level Salary

£26,690.44

Average Salary

4

Annual Openings

£32,768.09

Potential Salary

£19,206.00

Entry Level Salary

£20,371.03

Average Salary

2

Annual Openings

£33,444.73

Potential Salary

£18,756.00

Entry Level Salary

£20,791.67

Average Salary

36

Annual Openings

£29,924.51

Potential Salary

£18,288.00

Entry Level Salary

£19,709.00

Average Salary

130

Annual Openings

£29,079.14

Potential Salary

£15,786.00

Entry Level Salary

£18,567.17

Average Salary

3

Annual Openings

£38,341.34

Potential Salary

£16,092.00

Entry Level Salary

£20,356.88

Average Salary

14

Annual Openings

£30,905.75

Potential Salary

£17,352.00

Entry Level Salary

£17,077.00

Average Salary

1

Annual Openings

£24,249.45

Potential Salary

£18,360.00

Entry Level Salary

£15,151.99

Average Salary

15

Annual Openings

£30,905.75

Potential Salary

£18,342.00

Entry Level Salary

£17,077.00

Average Salary

1

Annual Openings

£34,075.83

Potential Salary

£19,152.00

Entry Level Salary

£18,828.63

Average Salary

7

Annual Openings

£36,228.52

Potential Salary

£17,172.00

Entry Level Salary

£20,018.10

Average Salary

6

Annual Openings

£35,569.92

Potential Salary

£19,152.00

Entry Level Salary

£19,654.18

Average Salary

22

Annual Openings

£34,197.13

Potential Salary

£17,622.00

Entry Level Salary

£20,456.09

Average Salary

6

Annual Openings

£44,478.10

Potential Salary

£18,612.00

Entry Level Salary

£27,587.11

Average Salary

10

Annual Openings

£34,593.71

Potential Salary

£17,586.00

Entry Level Salary

£20,324.00

Average Salary

80

Annual Openings

£38,921.38

Potential Salary

£17,802.00

Entry Level Salary

£24,140.61

Average Salary

5

Annual Openings

£29,707.31

Potential Salary

£18,414.00

Entry Level Salary

£21,787.00

Average Salary

23

Annual Openings

£41,804.76

Potential Salary

£17,460.00

Entry Level Salary

£25,929.00

Average Salary

17

Annual Openings

£31,368.27

Potential Salary

£17,892.00

Entry Level Salary

£21,568.51

Average Salary

6

Annual Openings

£34,246.57

Potential Salary

£18,576.00

Entry Level Salary

£23,353.57

Average Salary

10

Annual Openings

£33,585.10

Potential Salary

£18,936.00

Entry Level Salary

£23,304.00

Average Salary

16

Annual Openings

£40,576.16

Potential Salary

£19,368.00

Entry Level Salary

£25,099.22

Average Salary

4

Annual Openings

£36,146.74

Potential Salary

£19,476.00

Entry Level Salary

£22,359.31

Average Salary

32

Annual Openings

£58,617.14

Potential Salary

£20,700.00

Entry Level Salary

£28,399.73

Average Salary

19

Annual Openings

£41,887.93

Potential Salary

£20,016.00

Entry Level Salary

£24,062.00

Average Salary

46

Annual Openings

£29,567.40

Potential Salary

£18,378.00

Entry Level Salary

£21,737.00

Average Salary

7

Annual Openings

£27,519.40

Potential Salary

£20,160.00

Entry Level Salary

£20,231.37

Average Salary

15

Annual Openings

£57,348.35

Potential Salary

£21,168.00

Entry Level Salary

£28,406.00

Average Salary

1

Annual Openings

£47,576.11

Potential Salary

£20,196.00

Entry Level Salary

£23,565.57

Average Salary

7

Annual Openings

£56,688.34

Potential Salary

£21,204.00

Entry Level Salary

£28,720.00

Average Salary

44

Annual Openings

£62,851.78

Potential Salary

£19,980.00

Entry Level Salary

£31,051.33

Average Salary

3

Annual Openings

£46,267.55

Potential Salary

£17,298.00

Entry Level Salary

£22,858.05

Average Salary

1

Annual Openings

£45,511.61

Potential Salary

£21,060.00

Entry Level Salary

£28,994.44

Average Salary

3

Annual Openings

£36,654.85

Potential Salary

£18,936.00

Entry Level Salary

£23,352.00

Average Salary

6

Annual Openings

£42,091.81

Potential Salary

£19,242.00

Entry Level Salary

£26,815.76

Average Salary

3

Annual Openings

£49,971.33

Potential Salary

£26,334.00

Entry Level Salary

£38,782.72

Average Salary

3

Annual Openings

£35,579.02

Potential Salary

£20,970.00

Entry Level Salary

£24,874.73

Average Salary

5

Annual Openings

£40,794.08

Potential Salary

£19,494.00

Entry Level Salary

£25,090.97

Average Salary

3

Annual Openings

£51,919.38

Potential Salary

£21,006.00

Entry Level Salary

£30,781.80

Average Salary

4

Annual Openings

£64,082.43

Potential Salary

£22,320.00

Entry Level Salary

£37,993.00

Average Salary

0

Annual Openings

£64,353.16

Potential Salary

£23,130.00

Entry Level Salary

£34,462.40

Average Salary

7

Annual Openings

£44,781.18

Potential Salary

£19,512.00

Entry Level Salary

£25,525.52

Average Salary

6

Annual Openings

£72,631.81

Potential Salary

£28,584.00

Entry Level Salary

£44,070.64

Average Salary

4

Annual Openings

£66,897.20

Potential Salary

£23,130.00

Entry Level Salary

£40,520.99

Average Salary

1

Annual Openings

£67,134.39

Potential Salary

£22,572.00

Entry Level Salary

£40,267.11

Average Salary

18

Annual Openings