Category: Microsoft Office

Its name is Power Query Formula Language. But if you call it that, no one will know what you are talking about. The original informal language name M seems to have stuck, and even the Microsoft documentation refers to M. Every time you create a query in Power Query, whether in Excel or Power BI, […]

The power of Microsoft Word Microsoft Word has some very powerful hidden features that allow you to use the software much more efficiently. We have all been using the Mouse to navigate our documents for decades. But there is a real benefit of using the combination of the Keyboard and Mouse at the same time. […]

Don’t reinvent the wheel – use Templates! Every Microsoft Office application leverages templates to help users achieve greater results faster and more efficiently. Excel also supports templates. Templates are Excel workbooks that have been pre-built for a specific purpose. Microsoft offers thousands of its own Excel templates that are free for you to use. If you […]

Make better Excel workbooks by collaborating with others It has often said that “two heads are better than one” or “many hands make light work”. From my own experience I know that I learn new ideas and concepts more effectively when I am learning with a partner. Some people are better at observing the details […]

Poking around in the menus of Microsoft Word and other document processing tools, you may run across terms such as “widows,” “orphans,” and “kerning.” These are terms from typography that refer to how the text in a document is formatted. In this article, I’ll discuss a few of those terms you might see in Microsoft […]