Excel DATABASE one to many - Contacts with multiple tasks or notes

1 Views
Published
First attempt at a long video - I hope it is practical.
Use excel as a database where your contact information can have multiple notes associated with it.
Use these notes as TASKS or general information.
View notes/tasks by contact.
View all notes/tasks combined.
Sort and manage data dropdown menu. COLUMN and COLUMN ORDER

*************** Contents of this video***************
00:00 - Overview
00:30 - Example of a working database
07:51 - Formulas
08:48 - Data structure
11:20 - Unique ID or CODE
17:33 - Filtered Dropdown
21:59 - Sort by column
25:23 - Combining all elements
28:02 - Copying contacts and notes
33:32 - Add data above heading


Index Master
*********************************************************************

Employee
Insurance
Medical
Banking
Private
Supplier
Notes
Contacts

Index Master & Sub
*********************************************************************

Employee Annual Leave
Employee Sick Leave
Employee Maternity
Employee Review
Employee Disciplinary
Employee Anniversary
Insurance Life
Insurance Property
Insurance Travel
Insurance Car
Medical Hospital
Medical Doctor
Medical Specialist
Medical NHS
Banking Accounts
Banking Correspondence
Private Paul
Private Leith
Supplier Product
Supplier Services
Notes Software
Notes General
Notes Passwords
Notes PIN codes
Contacts Friends
Contacts Family
Contacts Work
Category
Job
Be the first to comment