Excel MasterMind

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.

Parabola raises $2.2 million to simplify programming for employees stuck in Excel all day 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…

Click here to watch Microsoft Build 2018, Day 2!

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

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

How to record macros in Google Sheets 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.

Microsoft Excel is about to get a lot smarter 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..

Intelligent Laziness: Connecting to a GoDaddy SQL Server using SSIS and Tableau 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…

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

business.facebook.com

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!

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

"Simplicity is the ultimate sophistication."
-Anonymous

"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."

Gartner Reprint 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.