Sharing Your Zoom Screen is Easy Sharing your screen in Zoom enables you to work on the Word document or Excel file you’re trying to understand and have another person (such as the trainer) see what you’re doing. And you can be anywhere. Additionally, you can share mouse and keyboard control. Sharing remote control allows…
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…
Stay on top of learning, regardless of Covid-19 No mater what you want or need to learn, we can get through this together. General Windows topics (such as creating folders, learning how to save (and find them later) files Using email (attaching or downloading photos for example) Ground level experience with Word, Excel, or PowerPoint Even cell phones
Using Absolute References The Fill Handle is Awesome Using the Fill Handle to copy formulas down (or across) a list of data is an incredible time saving feature. However, problems arise when you want to reference a specific cell over and over again. The first formula works great. 10% x $10 results in a $1…
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…
This is so cool. Mind Blown. XLOOKUP is conceptually similar to the other LOOKUP Functions, eXcept it doesn’t have the limitations of VLOOKUP and is easier to use! Use it in place of VLOOKUP or HLOOKUP. Default match is exact not approximate Match options are greater File_not_found options Searches a range for a match and…