When you’re looking for computer training related to your needs, use the search opiton on the title bar (top to the right) to search for posts you’ll find helpful. (It’s the magnifying glass, which some people say looks like a lollypop). Click that and search for the topic which interests you. Try searches like these:…
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…
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
Personal Computer Teacher Looking for Microsoft Office Training, or just need some basic computer training classes? My Reno Computer Tutor can provide the in-personal computer teacher you need. How is personal training effective? First, because you know the skills you would like to learn, that’s what we’ll teach you. Second, because you are familiar with…
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…
Using Excel Names When using formulas or referring to a specific cell in your worksheet, you’ll typically reference ‘range’ or specific cell. For example, B6:B10 is a range reference, where B6 is a cell reference. A problem with this sort of reference is that it’s not very meaningful and easy to forget. If you want…