Covid-19

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

Absolute References: Excel

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…

Date formats

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…

NEW! XLOOKUP

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…

What’s in a Name?

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…

Windows 10 Housekeeping

The Windows 10 Start menu includes so many apps that it can be overwhelming. With so many choices it can be hard to find the app you’re looking for. You may resort to saving shortcuts on your desktop because that’s what you’ve always done. But then your desktop is cluttered! The Solution The solution is…