Start Date
Wed 6th November 2024
Attendance
Part-time
Adult Fee
220.00
16 - 18 Fee
220.00
Adult Fee with Concession
220.00
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
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