Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Excel 2016 Course - Excel Spreadsheet Protection to your Wishlist.

Add to Wishlist

Excel 2016 Course - Excel Spreadsheet Protection

Excel 2016 tutorial course on protecting Excel spreadsheets. Learn how to password your work.
4.3 (3 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,521 students enrolled
Last updated 4/2016
English
$10 $20 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 32 mins on-demand video
  • 5 Articles
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Users will be able to confidently apply password protection to their workbooks, worksheets and workbook structure
Users will be able to choose a good password according to best practice
View Curriculum
Requirements
  • Users should have a working knowledge of Excel
  • Users will need a copy of Excel 2007-2016
Description

Do you love Excel? Do you want to protect your work? Then take this Excel 2016 course! This course is intended to help the Excel user in protecting your spreadsheet from average office users! No protection Excel method is 100% secure so the best defense is basically to combine more than one method.

Note this course will not teach you how to break passwords so please don't take this thinking it will. This short course will simply teach you how to use built in Excel features to protect your work.

This Excel bite size course will help you to understand better how to use certain types of protection and walk you through how to activate them. All support is provided via discussion forums and like all our Excel courses a full 30 day money back guarantee is given. So don't just make Excel spreadsheets..protect them now!

Who is the target audience?
  • Users wanting to feel confident they know how to protect their Excel work
  • Users wanting a short refresher on Excel security
  • Analysts who regularly send out spreadsheets and wish to protect their master sheets
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 14 Lectures Collapse All 14 Lectures 36:25
+
Introduction to Excel 2016 spreadsheet protection course
1 Lecture 03:12

Lecture introduces Excel course, aims of course and best ways to learn from this course

Preview 03:12
+
Passwording your worksheet
1 Lecture 06:52

This lecture shows you how to password a worksheet

Preview 06:52

Quiz on worksheets

Quiz on worksheets
2 questions
+
Passwording and unpasswording your workbook
3 Lectures 06:25

This lectures shows you how to add a password to an Excel workbook

Preview 04:14

Quick note on unpasswording lecture
00:12

Shows you how to take out your Excel password. Please note this is using the standard 'remove function' in Excel from the menu and does not cover how to break a password (sorry!)

How to unpassword your Excel workbook
01:59

Quiz on workbooks

Quiz on workbooks
2 questions
+
Protecting the workbook structure
1 Lecture 03:33

Protect the structure of a workbook in Excel

How to protect the structure of a workbook
03:33
+
Hiding sheets in Excel
1 Lecture 06:17

This lecture shows you how to hide a sheet in a workbook

Hiding Excel sheets from plain sight
06:17

Quiz on hiding sheets

Quiz on hiding sheets
2 questions
+
Passwording your VBA project
3 Lectures 05:26

This lecture covers how to password a VBA project

Passwording a VBA project
05:11

Quick note if you are thinking about passwording a VBA project

Note about a passworded VBA project
00:15

Hi all, just in case the Developer tab is missing and you prefer to access the VBA window like that, then this slide will show you how to add it.

Adding the VBA Developer tab
1 page

Quiz on VBA passwording

Quiz on VBA passwording
2 questions
+
Good password ethics
2 Lectures 01:17

Tips on choosing a good password for Excel

Choosing a good password
00:51

Use Excel 2013 onwards
00:25
+
End lecture
2 Lectures 02:25

Lecture wraps up course

Wrap up lecture
00:38

Bonus lecture to course

Bonus lecture
01:47
About the Instructor
4.5 Average rating
343 Reviews
13,397 Students
12 Courses
Excel Tutoring/Consulting Services, 13,000+ students

Our Udemy Excel courses have been developed to cover a wide range of needs for the Excel user. There is a course to suit everyone from beginners level to advanced. We provide all workbooks and full support via the discussion forums. Simply put our Excel courses use real life examples and not just theory to help you learn and improve yourself and give you proper skills you can use in your workplace.

Our Excel IT Consultant/Instructor Navin has been in the IT industry for approximately ten years. Recently featured nationwide in Costco Magazine, Navin has over 6 years experience as an Analyst. Having self-taught himself Microsoft Excel and VBA, he achieved MCAS (now known as Microsoft Office Specialist) certification in Excel in 2010. His work in Excel has been varied having worked on automating and streamlining reports to building and deploying real time dashboards to monitor performance.

During his time as an Analyst, he often assisted colleagues who needed problems solved in Excel. By relating the functions to use, to the context of their problem, his colleagues were able to grasp the concepts of what functions to use and in what context.

This spurned Navin's need to develop these range of Excel courses which to date have over 13,000 students enrolled. So please have a look at our range of fantastic courses and join us on our journey. You won't be disappointed.

Report Abuse