PART 4: EXCEL DATA INPUT BASICS
What’s the most basic and common usage of Excel? No, I mean really basic! Or, what’s the last thing you did in Excel? You probably use Excel most commonly to perform a simple task: input and store data. I know I certainly do.
The fact is this seemingly innocuous usage can cause huge problems later if not done effectively. Ever had to ‘cleanse’ a dataset in Excel, for example? It takes time, can be hugely frustrating, and is 100% avoidable with proper attention to data input including data validation techniques.
Yes, a stitch in time really can save nine, so let’s get started with our Excel Basics data input module!
Session Titles And Learning Outcomes
Session Titles And Learning Outcomes
SESSION 1: Planning Data Input In Excel
- analyse data input requirements
SESSION 2: Advanced Data Validation In Excel
- create A Custom Input Error Alert
- create An Input Message
SESSION 3: Data Validation And Dates
- create cell-based Input Guidance using IF
- know the conditional formatting rules manager
- know how dates work in Excel
SESSION 4: Present A Worksheet For Data Input
- format a sheet for data input (cell indentation etc.)
- protect cells and sheets
6 Lessons