Apply Now

Diploma in Advanced Spreadsheets

Award
Advanced Diploma
Study Mode
Course Duration
10 Weeks
+ 1 Saturday (10.00 - 1.00 pm)
Start/End Date
23/03/21 - 25/05/21
Day & Time
Tuesday
18.30 - 21.30
Delivery
Live Online Classes
1 Class Per Week
Course Fees
€895.00
*Check our Black November Offer for exclusive discounts*
Claim your Black November voucher. To secure a place on this course a deposit of €75.00 applies. Flexible Payment Terms available - see details on page below.

Why take this course?

You will learn how to use spreadsheet software correctly and gain a valuable skillset that will enable you to enhance your career options with the ability to contribute to generating significant efficiency savings in business.

Familiarity with the capabilities offered by spreadsheet software, and the ability to leverage such capabilities, is an important tool within a modern business.

What will I study?

This course will teach you how to create, format, analyse and share information in spreadsheets using logical, statistical and mathematical functions. You will also learn how to use the analysis and audit tools, and record and run macros.

Programme Modules

Study Units

The role of Spreadsheets

Use of spreadsheets in business; basic capabilities of spreadsheets; terminology associated with spreadsheets.

Designing Worksheets 1

Layout of data; commenting within a spreadsheet; auditing of information requirement.

Designing Worksheets 2

Protecting cells; hiding cells; formatting cells.

Getting Data

Where to get data; importing data from sources; converting data. 

Data Analysis:

Data cleansing; grouping data; extracting data; simple statistics tests.

Functions in Spreadsheets:

Prominent functions; using the formula tab; building functions; automating tasks.

On successful completion of this course you should be able to:

  • Explain concepts and terminology related to spreadsheets.
  • Identify, select and apply a range of spreadsheet techniques in order to prepare data for analysis.
  • Apply a wide range of spreadsheet techniques in order to analyse a variety of business decisions.
  • Design worksheets in a structured manner to ensure ease-of-use and ease of maintenance.

Diploma in Advanced Spreadsheets

Live Online Learning

You can now up-skill or re-skill from the comfort of your own home with an industry experienced Professional Teacher who will provide you with inspirational lectures and all support materials you need to achieve your goals.

Entry Requirements

This course is ideal for those us use spreadsheets as part of their job or those working in the accounts department of an organization.

Assessment & Awards

Assessment Method
Continuous Assessment and end of course examination

Award

Diploma in Advanced Spreadsheets
Awarded by: Dorset College

Career & Progression

This course will enable you to become more efficient and confident in your current role, develop highly valued skills that will enhance career prospects and it will enable you to make a valuable contribution to a wide range of business decisions.

Progression
The course will open up a wide range of professional or academic opportunities in business, finance, analytics and many more….

Flexible Payment Terms

To secure a place on this course a deposit of €75.00 applies and the remainder paid in instalments.  You have the flexibility of using our online payment facility to manage your course payments at any time, from the comfort of your own home.  Pay Online

Payment Plan

Deposit: €75.00 Secures your Place on the Course
1st Instalment:  €410.00 12/03/21
2nd Instalment: €410.00 23/04/21
Need Information?
Contact us and we will help you
APPLY NOW
Top cross
X