Use formulas and functions Work with data, rows, and columns Sort and filter data

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, describe what Microsoft Teams is all about, use channels and post messages, and get help in Teams.

In this course you will learn how to: insert pictures and shapes, and format shapes.

Customize general, language, formula, proofing, and saving options Use Excel’s version control features Customize the ribbon and the Quick Access toolbar Customize the functionality of Excel by enabling add-ins Customize advanced and Trust Center options

Use text functions Use logical functions Use lookup functions Use date functions Use financial functions