Another exquisit release
Lynda.Excel.2016.Avoiding.Common.Mistakes-XQZT
Title: Excel 2016: Avoiding Common Mistakes
Publisher: Lynda
Iso Size: 325M (339523584 B)
Files: 7F
Date: 08/24/2017
Course #: 604219
Type: Business Intelligence
Published: 8/22/2017
Modified: N/A
URL: www.lynda.com/Excel-tutorials/Excel-2016-Avoiding-Common-Mistakes/604219-2.html
Author: Dennis Taylor
Duration: 1h 44m
Skill: Intermediate
Exercise: [X]
Installation:
Unpack that shit, mount that shit, run that shit
Notes:
If you do a lot of work in Excel, you know that errors can
easily creep into your data. And even a small error can have big
consequences, throwing off important calculations or
transmitting incorrect information to your team. In this
concise course, Excel expert Dennis Taylor provides quick and easy
tips to help you avoid making common
mistakes.rneernDennis begins with the basics—how to display data so
that errors can be easily spotted. Next, he offers handy tips to
ensure data is entered correctly the first time, using the
AutoFill feature and using AutoCorrect shortcut codes for
frequently used entries. Dennis provides easy ways to validate
your data, which is particularly helpful when multiple team
members are contributing to the same spreadsheet. This
includes restricting the data that can appear in a
spreadsheet by setting value limits, pre-populating data with
drop-down lists, and other methods. He also shows how to avoid
mistakes in formulas, how to hide data that doesn't need to be
seen, and how to use workbook protection to prevent errors, and