Course Description

Diploma in Advanced Spreadsheets

Dorset College



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.

College Name Dorset College
Course Category Computers & IT (Information Technology), Microsoft Excel
Course Type Online Learning
Course Qualification Diploma
Course Location Dublin, Ireland
Location Postcode Dublin 1
Course Start Date 23rd March 2021
Course End Date 25th May 2021
Course Fee 895
Course Duration 10 Weeks
Course Times 18:30 to 21:30
For information about Dorset College, please visit our college page on www.nightcourses.com by clicking here.

Course Provider

Dorset College



+353 1 882 8934
8 Belvedere Place, Dublin 1, Dublin., 7 Belvedere Place, Dublin 1, Dublin., 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 Privacy Policy, Terms and Conditions & Cookie Information and agree to join the Nightcourses.com community.
 

Map

Dorset College
8 Belvedere Place, Dublin 1, Dublin., 7 Belvedere Place, Dublin 1, Dublin., Dublin, Republic of Ireland

Reviews

Submit a Review for
Diploma in Advanced Spreadsheets
Dorset College

Your email address will not be published. Required fields are marked *

Click to Rate

We'd love to send you the latest news and articles about evening classes, further learning and adult education by email. We'll always treat your personal details with the utmost care and will never sell them to other companies for marketing purposes.

Comments and Reviews Policy