Awesome Way To Log in Power Query M Using Diagnostics.Trace

Several authors have described how to use the M function Diagnostics.Trace to monitor the performance of queries built with Power Query. In this installment, we will look at how to use the same function to record row-level error information in the trace log. Regardless of how we intend to use Diagnostics.Trace, nothing at all can […]
Read More ›

The Benefits of Microsoft Office Document Versioning

Two ways to achieve Microsoft Office Document Versioning Have you ever worked for long hours on a document only to lose all of the changes you recently made to it? I believe that has happened to everyone at some point in the past whether it be with Word, Excel, or PowerPoint documents. Traditionally people save […]
Read More ›

How to Co-Author Documents in Microsoft Office

Co-Author Documents in Word, Excel, or PowerPoint Did you know that multiple people can work together at the same time as a co-author on a Word document, Excel spreadsheet, or PowerPoint presentation? If you have access to OneDrive or SharePoint you and colleagues are ready to get started as document co-authors. Office has functions that allow […]
Read More ›

Top 10 Excel Tricks for Increased Efficiency

Considering the time today’s IT professionals spend staring at Microsoft Excel spreadsheets, one might think we’d all be Excel wizards by now. The truth is that while Excel has a low barrier to entry, to become a true super user takes a lot of time, energy, and dedication. While you may think you’re an above-average […]
Read More ›

Why Every Small Company Needs a Disaster Recovery Plan

Does your company have a Plan B? Small company owners often don’t give enough thought to how they would respond to an unexpected natural disaster, data loss, or financial emergency, and when the unthinkable happens, they are left scrambling for a solution. Chances are that solution, however, will prove ineffective. Here are a few sobering […]
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.