Hellow guys, Welcome to my website, and you are watching Essential Skill with Excel: Expiration Alerts with Conditional Formatting. and this vIdeo is uploaded by A2 Excel, Stats and Finance at 2018-11-14T12:33:11-08:00. We are pramote this video only for entertainment and educational perpose only. So, I hop you like our website.
| Name | Essential Skill with Excel: Expiration Alerts with Conditional Formatting |
| Video Uploader | Video From A2 Excel, Stats and Finance |
| Upload Date | This Video Uploaded At 14-11-2018 15:33:11 |
| Video Discription | Download the file here: https://s3.amazonaws.com/a2excel.com/Blog/Files/Expiration+Alerts.xlsx In this video we'll be learning how to use conditional formatting to create expiration alerts in Excel. In order to actually get to the conditional formatting, we'll need to know how to use the IF function, the TODAY function, a simple substraction. The Today function in excel is going to be necessary in order to figure out which dates are due, or nearing due. =TODAY() in excel is dependent on the computer clock. The =IF() function in excel will figure out, using conditional logic, if we have an expired or non expired invoice. We'll also use a nested if function to add a middle "about to expire" warning. Finally, we'll be using the Text that Contains conditinal formatting rule to highlight with different colors the cells that are expired or on time. As an added bonus, we'll use an excel pivot table to count how many invoices are expired. |
| Category | Education |
| Tags | excel | tips | tricks | conditional formatting | formatting | dates | expiration dates | due dates | techniques | excel tips | power | power tips | shortcuts | excel skills | text that contains | text that contains conditional formatting | if function | nested if | expiration alerts | expiration alerts excel | due dates excel | due date excel | excel alert |
