Weekly Upcoming Events using Advance Formulas and Conditional Formatting

Hi, thanks for watching my video on How to create a weekly upcoming events tracker using advance Excel formulas and conditional formatting

In this video you will learn how to use Excel advance formulas and condtional formatting to create a weekly eventtracker. You will also learn how you can use COUNTIF and COUNTIFS to conditionallydisplay data set based on multiple condtions.

#IF #Excel #Functions #COUNTIF #COUNTIFS #INDEX #ROW #COLUMN #MIN #SMALL #WEEKDAY #TODAY

TIMESTAMPS
0:00 Intro
0:30 Data Preparation
1:30 Creating the Dashboard
5:25 Create Weeks
10:00 Using COUNTIFS function to count number of staff
16:00 Adding Conditional Formatting
27:30 Prepare Data Extraction
33:00 Write the Formula to Extract Data using Multiple Conditions

ABOUT MY Channel
JT for Excel channel is about different topics on MS Excel. I cover various topics on Excel ranging from basic MS Excel features to advance topics such as, Pivot Tables, Advance Charts and Dashboards.
Check out my channel here:
https://www.youtube.com/channel/UCqQd4wKwqbkAMoLJe5Mh0DQ
Don’t forget to subscribe!

CHECK OUT MY OTHER VIDEOS
https://www.youtube.com/watch?v=7UXDEELkfrc&t=13s
https://www.youtube.com/watch?v=A-r7XHGMj3s&t=14s
https://www.youtube.com/watch?v=KR_TDocJDGM&t=7s
https://www.youtube.com/watch?v=sK-ISH8kBzo&t=6s

FIND ME AT
https://www.jufailitech.com/

GET IN TOUCH
Contact me on [email protected]

FOLLOW ME ON SOCIAL
Get updates or reach out to Get updates on our Social Media Profiles!
Twitter: https://twitter.com/jufailitech
Instagram: https://twitter.com/jufailitech