Pimp up your Task Tracker using a 'Status' column & Conditional Formatting - Download Tracker Sample
Excel Is Simple
Pimp up your Task Tracker using a 'Status' column and Conditional Formatting
Here are the various chapters o the video: 0:00 Introduction 1:42 Assigning statuses 2:50 Using the IF conditions 6:57 Nesting the IF function 9:01 Conditional Formatting
The detailed 'NESTED IF' function video can be found here: https://www.youtube.com/watch?v=Ejd7HGOS5Hs
Download the spreadsheet from this link: https://drive.google.com/file/d/1vINCagzOpWCOrPs--3SXNRnLy33ureKb/view?usp=sharing
#exceltasktracker #exceltracker #tasktracker #tasktracking
------------------------
Welcome to Excel is Simple. A place where excel is taught in the dumbest possible way. You will find every type of excel tutorial; excel 2013 tutorial for beginners, excel 2010 tutorial for beginners, excel formulas and functions, excel pivot table tutorial, excel vlookup. Aptly this is one place which has all excel tutorial for beginners. Subscribe to my channel at http://www.youtube.com/user/excelissimple?sub_confirmation=1 Want some focused playlists. Click here and lean back: The IF formula explained: https://www.youtube.com/playlist?list=PLRJY-_DDvSgK7khaQJLqhry-PELQ0hLTe All excel formulas in one place: https://www.youtube.com/playlist?list=PLRJY-_DDvSgKsM7G8qQEAa3oWLDCUn401 Excel basics if you have just started: https://www.youtube.com/playlist?list=PLRJY-_DDvSgLUOnfRBwVQYZVVzOxaVz76
Share, like and post any questions on the videos ... https://www.youtube.com/watch?v=u6ylNpviwuI
56184198 Bytes