I frequently post new videos, how-tos, tutorials and blog posts on how to use various functions in Microsoft Office applications. Make sure to visit often or subscribe to receive an update every time there's something new.
Excel SORTBY Function | Excel One Minute Quick Reference
The SORTBY function in Excel sorts the contents of a range or array based on the values in a corresponding range or array. Use SORTBY to see a list of employees sorted by highest paid, but you don't show their salaries. USE SORTBY to sort a customer list by the most profitable customer but not see the revenue.
Excel DATEDIF Function | Excel One Minute Quick Reference
Need to know the number of years, months, or days between two dates? Excel's DATEDIF function will calculate it for you. This is a great function if you work in Human Resources (HR), or any job position where you need the difference in dates.
How to use XLOOKUP function in Excel
Quick introduction to the XLOOKUP function in Excel, with easy examples. XLOOKUP looks both left and right. XLOOKUP also allows column to be inserted to deleted. VLOOKUP will not look left and right and you can't insert and delete columns.
Outlook Speed Up Emailing by Using Voice Commands and Dictation
The Dictate feature in Microsoft is great. Outlook has a new feature with Dictate. You can now dictate the subject, add people to the To, CC, and BCC line, and at mention people. Several commands you can use are "add [Name] to email", "add [Name] to bcc", and "send email".