Enjoying the preview?
This is the free first lesson. Get full access — request a demo or sign in.
Microsoft Excel 2021: Security
Learn how to use multiple worksheets and secure your documents.Preview the first lesson free — get full access to all 3 lessons.
Advanced Provider : Bob Akbar 3 Lessons · 7m in English
Course Description
In the age of data security, how can you ensure that only the proper people have access to your sensitive data? The answer is by securing and encrypting your workbook.
In this course, we will discuss security in Microsoft Excel. You will learn how to scramble data by inserting a scramble function into VBA, or Visual Basic for Applications. Scrambling data can help you avoid revealing sensitive or confidential information. We will also explore ways to hide your data, as well as methods for encrypting your content to secure data. It is important to use multiple layers of encryption. By the end of this course, you will be able to effectively secure your Excel documents.
What You'll Learn
- Recognize the security options available for your Excel workbook
- Scramble data by inserting a scramble function into VBA (Visual Basic for Applications)
- Hide data within your Excel workbook to avoid revealing sensitive information
- Encrypt content to secure your data
- Apply multiple layers of encryption to protect your workbook
- Secure your Excel documents effectively by the end of the course
Key Takeaways
- Securing and encrypting a workbook helps ensure that only the proper people have access to sensitive data.
- Scrambling data by inserting a scramble function into VBA can help you avoid revealing sensitive or confidential information.
- Hiding data is one of the methods covered for protecting information in Excel.
- Encrypting content secures your data, and it is important to use multiple layers of encryption.
Frequently Asked Questions
What will I be able to do after completing this course?
By the end of the course, you will be able to effectively secure your Excel documents, including scrambling, hiding, and encrypting your data.
What topics does this course cover?
The course covers security in Microsoft Excel, including scrambling data with a VBA scramble function, hiding data, and encrypting content to secure data using multiple layers of encryption.
How is data scrambling achieved in this course?
Data is scrambled by inserting a scramble function into VBA (Visual Basic for Applications), which helps avoid revealing sensitive or confidential information.
What skills will I gain from this course?
You will build skills in Microsoft Excel, Data Encryption, Data Security, Microsoft Security Essentials, Secure Programming, and skills aligned with Microsoft Office Specialist (MOS) - Excel.
