Designing and Using Data in Spreadsheets
Category: Information Technology
Course No. 1014
Sessions: 8, Tuesday 7:30 PM - 9:30 PM
Fee: €120
The purpose of this course is to learn good data organization, how to clean data and quality control in a spreadsheet program. It will introduce data analysis. We will also look at data security, import and export processes.
We will explore common mistakes and edit sample data to provide machine readable spreadsheets. This will be achieved using advanced and nested formulas. Following this we will look at macros to automate repetitive tasks. We will create an email merge from the data with Word and Outlook desktop apps. The course will also introduce data collection, sharing and collaborative editing using Microsoft 365 apps.
Register Online
