Introduction to M, the Power Query Formula Language

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, […]
Read More ›

Templates – leveraging pre-built Excel workbooks

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 […]
Read More ›

Using Microsoft Excel Collaboration Mode

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 […]
Read More ›

Five Microsoft Word Typography Techniques to Make Your Documents Look Better

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 […]
Read More ›

Monte Carlo Methods in Excel: Part 4 – The Triangle Distribution

A mathematician friend of mine worked for the Navy on calculations involving the movement of sound waves through water. It’s a difficult problem, since the speed of sound varies with temperature and salinity. Being a mathematician to the core, he always wanted the exact answer. At times the Navy had to shake him by the […]
Read More ›

Type to search blog.learningtree.com

Do you mean "" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.