Creating A Data Entry Screen In Excel

https://youtu.be/-YL6h4ZaPec - Creating A Data Entry Screen In Excel

This lecture covers how we create a simple data entry screen, giving the user the opportunity to enter the bare amount of data, to get the out put we're looking for.

I favour colouring the data entry cells, to guide the user to those cells they should be using. We cover how to protect cells in a later video.

We will use start time and finish time AM/PM, and using that we can calculate what lunch time was. Nice and simple...

This is a sample lecture from my course, Microsoft Excel Essentials: Level 2 - Intermediate/Advanced.

Get this course now!

Level 1: Microsoft Excel Essentials: Level 1 Basics - Excel Made Easy
The complete 4 hour course is yours for a low cost monthly subscription (first 2 months free!):
https://www.alangjarvis.com/excel-essentials-level-1

Level 2: Microsoft Excel Essentials: Level 2 - Intermediate/Advanced
The complete 9 hour course is yours for a low cost monthly subscription (first 2 months free!):
https://www.alangjarvis.com/excel-essentials-level-2

Level 3: Microsoft Excel Essentials: Level 3 - VBA Programming + Macros
The complete 13.5 hour course is yours for a low cost monthly subscription (first 2 months free!): https://www.alangjarvis.com/excel-essentials-level-3

Alternatively, you can purchase the complete set in...
Excel Essentials: The Complete Excel Series - Level 1, 2 & 3

The WHOLE 27.5 Hour Excel Mastery Series In One! From Excel Novice To VBA Programmer...
Available to buy with lifetime access for just $16.99 (normally $200) here:
https://www.alangjarvis.com/excel-essentials-complete

This course is for suitable Excel 2007, Excel 2010, Excel 2013, 2016, 2019 & 365

Videos in the Level 1 series:
https://youtu.be/uNFJNJk_kyo
https://youtu.be/g4ExVFkrj7I
https://youtu.be/Sd7w4YrVKmQ
https://youtu.be/XPfZA-KrOrM
https://youtu.be/CGNP1jKAhGA
https://youtu.be/6At4-dfrWSM
https://youtu.be/6QSm0iNA-gc
https://youtu.be/NWRFK2SOTtA
https://youtu.be/CYCFs4dQnm8

Videos in the Level 2 series:
https://youtu.be/4B4VFgHfcCI
https://youtu.be/B6G5Vu97GIw
https://youtu.be/-YL6h4ZaPec
https://youtu.be/fSwl1kEwMdg
https://youtu.be/ij0_SkPhB_M
https://youtu.be/MHbOHpBxTa0
https://youtu.be/bDPJP2t28_A
https://youtu.be/Y5E2FZ8KHgM
https://youtu.be/LSGUDpBPWb8
https://youtu.be/DhwXh6IplPk
https://youtu.be/B5k1lbIC5lQ
https://youtu.be/DZq9TxIaecI
https://youtu.be/41Ke-oEEGUk
https://youtu.be/xn0VSwQ0Vpc
https://youtu.be/haZpJhLJbdA

Videos in the Level 3 series:
https://youtu.be/IzbCv0yWAUI
https://youtu.be/zw9ydY-GVXo
https://youtu.be/DZc0ekkOFTg
https://youtu.be/L0V1WkC7bzQ
https://youtu.be/2vUSnj9ULYk
https://youtu.be/itTaurKxZp0
https://youtu.be/w4d_SUMqNxM
https://youtu.be/9OOJu4pxOGc
https://youtu.be/rkf7Wc-CQIY
https://youtu.be/2QXcBWYlL_I
https://youtu.be/rHqnzyw-asw
https://youtu.be/QeUgI_d-ljU
https://youtu.be/DjlzkGmDOok
https://youtu.be/JM7NFLDGaJE
https://youtu.be/kNkL21Iw9bk
https://youtu.be/Y6s3MEV1CIk
https://youtu.be/tGBsYjwbldQ
https://youtu.be/398-GMY0z78
https://youtu.be/k-r2N-Bz1Os
https://youtu.be/EELAr2myuog
https://youtu.be/qAbiXRHFkoI
https://youtu.be/BJiI0CrqG1E
https://youtu.be/NKaund7qNbU
https://youtu.be/IIf4vZgHvGE
https://youtu.be/9Vl8NxWmy00