Dennis demonstrates how to enter function names faster, provides tips for working with formulas in tables, and shows how to evaluate portions of formulas.
- [Instructor] Some function names are quite long,…and you just waste time typing them.…You can get to them easily if you simply double click…or tab in a function name.…In cell E2 on this worksheet called functions,…I want to tabulate the number of working days…between the starting and ending dates…over in columns B and C.…Column D is a formula that simply shows you the difference…in the two, but we want to count just the working days,…not the Saturdays and Sundays.…And furthermore, we've got a list of holidays over here…that we don't want to include.…
So, how many working days were there?…The function is called net workdays.…As soon as you type the letter N,…now with other formulas, you don't always see them,…sometimes you'll have to scroll to see the formula,…but if there's a particularly long one like net workdays,…here it is right here, we can either double click it,…or tab it into place.…Double click net workdays, that'll save some time.…Starting date, comma, ending date, comma,…let's highlight the holidays.…
Dennis 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 more.
- Streamlining data entry steps
- Using Excel shortcuts and automation features
- Protecting worksheets and workbooks
- Validating data
- Basing entries on formulas
- Detecting errors in formulas
- Using Range Names
- Finding mistakes in large, complex spreadsheets