Hi again. This is Maya (you can find me on Linkedin here), with my second post on DataChant: a revision of a previous tutorial. Removing empty rows or columns...
Power BI and Excel offer a wide variety of collaboration and sharing experiences. In today's blog post, we will share a useful method to easily obfuscate /...
In today's episode of the Pitfalls Series (here), we will briefly discuss the fifth pitfall, which is one of the most common mistakes that you always do, when...
As promised here, in today's post I am sharing an Excel template that analyzes Salesforce Opportunities, and allows you, with a single click of Refresh All in...
A Power Query Mystery I recently stumbled upon a mysterious Power Query behavior. A Power Query query was pulling data from an external Excel workbook that...
As a special gift to you for the coming holidays, I am about to share a FREE Excel template that analyzes Salesforce opportunities. While the template is...
In today's tutorial, we will solve a very common challenge in Excel. You start with an Excel table and you wish to condense it by removing all the columns...
Are You Ready for the Debate? Today is the US Presidential debate. It is also a perfect opportunity to hone our analytical skills and answer some of...
Today I would like to kickoff a special series on DataChant blog - For the first time ever, we will incorporate Sentiment Analysis to our Excel workbooks...