Excel MasterMind

11/05/2019

At the Microsoft Ignite conference, going on now, Microsoft announced RPA (robotic process automation) is now built into Microsoft Flow. They’ve even renamed the application PowerAutomate to better suite its capabilities. The PowerPlatform (PowerBi, PowerApps, and PowerAutomate) is revolutionizing the way companies do business.

05/22/2018

While knowledge workers are handling increasingly difficult tasks — ones that may be much easier to handle with just a Python script — Alex Yaseen thinks that in the future not everyone will actual…

05/08/2018

Click here to watch Microsoft Build 2018, Day 2!

Microsoft’s developer conference begins 8:30 am PST on Monday May 7. Watch the livestream.

05/02/2018

Did anyone else discover the new feature in Google sheets released last month?

Google Sheets users have been asking for the ability to record macros for years, and Google finally delivered. Here's how to use this new feature.

09/27/2017

Microsoft Excel users rejoice -- your favorite spreadsheet is about to get a lot smarter. Thanks to the help of machine learning and a better connection to..

07/12/2017

I try to apply the principle of Intelligent Laziness to make life as straightforward as possible. It’s hard to find meaning and clarity in a world that guarantees neither, and the Absurd pers…

06/30/2017

Have you seen the new Facebook Adds Manager for Excel? It enables downloads from multiple Facebook accounts with the push of a button!

06/29/2017

Have you ever needed the same macro across several spread sheets? Have you seen custom ribbons, but don't know how to create one? Excel Mastermind would like to host a live webinar to walk you through it! Let me know in the comments below if this peaks your interest!

06/25/2017

Switching between the VBA Editor and Excel Reviewing the windows in the VBA Editor Inserting and removing a module

05/19/2017

"Simplicity is the ultimate sophistication."
-Anonymous

02/22/2017

"Strategic Planning Assumptions:
By 2020, smart, governed, Hadoop/Spark-, search- and visual-based data discovery capabilities will converge into a single set of next-generation data discovery capabilities as components of modern BI and analytics platforms.
By 2021, the number of users of modern BI and analytics platforms that are differentiated by smart data discovery capabilities will grow at twice the rate of those that are not, and will deliver twice the business value.
By 2020, natural-language generation and artificial intelligence will be a standard feature of 90% of modern BI platforms.
By 2020, 50% of analytic queries will be generated using search, natural-language processing or voice, or will be autogenerated.
By 2020, organizations that offer users access to a curated catalog of internal and external data will realize twice the business value from analytics investments than those that do not.
Through 2020, the number of citizen data scientists will grow five times faster than the number of data scientists."

The business intelligence and analytics platform market's shift from IT-led reporting to modern business-led analytics is now mainstream. Data and analytics leaders face countless choices: from traditional BI vendors that have closed feature gaps and innovated, to disruptors continuing to execute.