Using AutoText Building Blocks

AutoText Building Blocks Word has many reusable elements you can add to your document. These reusable elements are called “building blocks” and examples include Headers and Footers, as well as cover pages. You can create your own custom building blocks which are specific and relevant to your needs. AutoText is one of those building blocks.…

AutoCorrect in Word

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.…

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…