Course Description

Diploma in Advanced Spreadsheets



Diploma in Advanced Spreadsheets is a course run by Dorset College, Dublin. It is a 'Online Learning' course with a duration of 10 Weeks. Diploma in Advanced Spreadsheets gives a Course Qualification of Diploma. For more information about Diploma in Advanced Spreadsheets at Dorset College, please review the details 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.
The Diploma in Advanced Spreadsheets course at Dorset College is listed in Courses.ie's national courses finder.
Training ProviderDorset College
Course LocationDublin
Location PostcodeDublin 1
Course TypeOnline Learning
Course QualificationDiploma
Course Start Date23rd March 2021
Course End Date25th May 2021
Course Duration10 Weeks
Course Time18:30 to 21:30
Course Fee895
Phone01 8309677
For more information about Dorset College, please visit our College page on Courses.ie by clicking here.

Course Provider

Dorset College



8 Belvedere Place, Dublin 1, Dublin., 7 Belvedere Place, Dublin 1, Dublin., Dublin City North, Dublin, Republic of Ireland

Make Enquiry

Please insert your contact details and any additional information you require and we will forward your request to Dorset College



Captcha code        I confirm I have read the Cookie Information, Terms and Conditions and Privacy Policy and I agree to join the Courses.ie community.
 

Map