Excel vLookup Example While teaching Excel classes over the past few semesters I get many questions on how to perform certain fuctions in Excel. Below is another request for and Excel vLookup example. This is for a student that needed this for real world work. My student had two lists of customers. The first was […]
Posts in category Tips
How to use simple Excel Date Calculations Several students have asked about Excel Date Calculations. Here is a good quick example to calculate the difference between todays date ( “today()”) and a date entered in a cell. For a real world example, I use this to track the time I follow up on small projects. For […]
For my students in the Excel classes, here is some Free Online Excel Training. These training videos are from Microsoft and LinkedIn and walk you through many features of Microsoft Excel. The training videos are split up into topics such as Formulas, Functions, Tables, Charts and many others. If you are new to Excel 2016 […]
Users receiving Winmail.dat instead of real attachments It seems that some non – Exchange or Office 365 users are getting winmail.dat attachments in emails rather than the actual attachments. I cannot take the credit for this solution as I found it on a technet forum, but I wanted to add my two cents to the […]
For my students in the PowerPoint 2016 classes, below is a reference card with Microsoft PowerPoint Shortcut Keys. To download click the link below. For Microsoft Excel Shortcuts Keys For Microsoft Word Shortcut Keys Please consider ordering these books as well as they provide some great information.
For those that recently were introduced to the Google Home Mini (or other Google Home Devices) there is a very helpful site to look up the possible voice commands to use. The site is https://assistant.google.com I find I use the weather and schedule commands most frequently. There are quite a few very useful commands. You have […]
This is going around again. PLEASE SHARE This phone scam is going around again. You may get a call from “Microsoft Support” or other Computer Tech Services company claiming that your pc is infected and they need to connect to your pc to fix it. They will charge you hundreds of dollars and then do […]