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.
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.
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.
Where to get data; importing data from sources; converting data.
Data cleansing; grouping data; extracting data; simple statistics tests.
Functions in Spreadsheets:
Prominent functions; using the formula tab; building functions; automating tasks.
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.
This course is ideal for those us use spreadsheets as part of their job or those working in the accounts department of an organization.
Continuous Assessment and end of course examination
Diploma in Advanced Spreadsheets
Awarded by: Dorset College
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.
The course will open up a wide range of professional or academic opportunities in business, finance, analytics and many more….
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
|Deposit: €75.00||Secures your Place on the Course|
|1st Instalment: €410.00||12/03/21|
|2nd Instalment: €410.00||23/04/21|