Nobody intends to make mistakes. Still, they happen. Sometimes users may not be aware of requirements or make typos. What begins as a small error, later leads to unnecessary work that costs time, money, and nerves. Here, you'll learn how to guide users in a way that makes errors less likely or even impossible. Or to inform them on input what's required.
In other cases, you may want to prepare data for decision making in a way that one does not need actual typing anymore.
And of course, there are the new cloud functionalities of Excel 365 opening new dimensions of co-operations. All of this is explained here.
Author(s): Ina Koys
Publisher: Computertrainerin.de
Year: 2023
Language: English
Commentary: excel 2019 & 365, guide user to less mistake makin in excel
Pages: 75
Tags: excel 2019 & 365, guide user to less mistake makin in excel
Contents
0 What we’re going to look at
1 What’s the difference between the two Excel versions?
2 Don’t allow any access to your workbook
3 Prevent changes
3.1 Option 1: using file protection
3.2 Option 2: Protect the sheets
3.3 Option 3: Hide sheets
4 Prevent sheets from getting deleted
5 Allow editing in certain cells
6 Only allow pre-defined edits
6.1 Data Validation
6.2 For flashy presentations: the slider
7 Examine what happened in the past
8 Repeat free input
9 Special cooperation features in Excel 365
More
