Manage workbook properties Record, create and edit a macro Create and use a template Use data validation in a workbook

In this course you will learn how to transform and sanitize data, use the Query Editor, model data, and manage relationships.

Starting with an understanding of the history and the current state of cyberattacks in terms of quantity and cost to business this course has the participant explore the various forms of cybercrime so they know how to recognize and defend against them at a company and an individual level. Further it explores the role of information obtained on social media platforms in these attacks and allows so the participant to understand what they should and should not be putting on these platforms. This ends with participants creating their own Personal Cybersecurity Plan.

In this course you will learn how to: insert PivotTables, work with PivotTable data, and sort and filter PivotTable data.

This course covers all the essential elements of corrective and preventive action, from identifying problems from customer complaints and internal audits and determining their significance through root cause analysis, to measuring the effectiveness of the action.