Word AutoCorrect If you’re a touch typist and use Word, it’s quite likely you make more typo errors than you realize. That’s because every time you type teh or adn, Word is automatically fixing your spelling. Or maybe you struggle with “I before E except after C” and other rules of spelling the English language.…
Technology can be Tricky Each week you have the opportunity to sharpen your skills. In just thirty minutes of free tips Friday you can pick up more efficient ways to accomplish your tasks. Topics covered vary from one week to another, so contact us if you would like added to the weekly reminder email. Regular…
We’ve started a YouTube channel! The idea is to post quick (5 minutes) videos for how to accomplish quick tasks. Right now it’s organized into four playlists. Expect periodic modifications and reorganization, as the whole YouTube thing is new and we’re just figuring it out. Playlists: The Windows playlist will feature topics relevant to windows…
Custom date formats are often useful in your reports. Excel has two quick formats for a date, one is “Short Date” the other is “Long date.” Google Sheets has a simple “Date” format which looks just like Microsoft Excel’s Short Date. Hopefully, by the time you finish this post, you’ll be able to create a…
XLOOKUP is a newer function that surpasses the awesomeness of VLOOKUP, but it’s only available in the Office 365 (Excel 2019) versions (and newer as they’re developed). There is still great value in VLOOKUP (and HLOOKUP as well), it just takes nesting more functions. Read the XLOOKUP post to learn more about it. Manually eyeball…