Dennis demonstrates how to use AutoFill and other techniques to simplify and accelerate date/time entries.
- [Instructor] Many times, when you're trying to enter…dates or times in Excel,…there are shortcuts that eliminate typing…and speed up the process.…On this worksheet called AutoFill, in cell A1 I've got Jan.…Think of that as an abbreviation for January.…If I point to the fill handle…on the lower right-hand corner, click and drag downward,…you can see the pop-up tip…suggesting I'm going to get month after month after month.…If I drag more than 12 cells,…I'll just go into next year and start all over again.…We simply enter abbreviations.…
If we drag rightward from one of these entries,…and it can be from any one of them,…we'll get the months going this way.…Now, not all the columns are wide enough here,…but we see what's happening there, same general idea.…Dragging upward is very uncommon,…but that could be done too.…We go in reverse chronological order.…Same thing would happen if we go leftward.…Generally, we enter monthly entries like we see,…either down column A, or across a row.…I'm going to eliminate these: highlight, press Delete.…
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