Year-end offer: Save 50% on Able2Extract Professional single license purchases before December 31!

27 Microsoft Excel Experts Predict The Future Of Excel In Business Intelligence

With over 750 million users worldwide, Microsoft Excel is the traditional tool of choice for presenting and analyzing data.

And now, it’s in a position to be the new BI tool of choice, as well. With Excel 2016, Microsoft announced some forward thinking built in Business Intelligence (BI) features. In the age of big data, this is huge.

This announcement, however, raised many questions in the field of big data manipulation. Is Excel powerful enough? Can it manipulate the amount and types of data businesses deal with today? Does Excel have a future in Business Intelligence workflows?

In the search of answers to these questions, we rounded up renowned MS Excel experts and picked their brains on it. We asked them one visionary question:

Where do you see the future of MS Excel in Business Intelligence Workflows?

And here is what they shared with us:

1. Purna Duggirala – Chandoo

Chandoo.org // @r1c1

Purna DuggiralaThere is a running joke in BI communities.

“What is the most used feature in any business intelligence solution?”
It is the Export to Excel button.

Jokes aside, Excel continues to be the #1 platform when it comes to analyzing data, finding information, preparing charts and presenting them to decision makers. In that sense, I see Excel playing a strong role in BI workflows in future.

Excel continues to be the #1 platform when it comes to analyzing data, finding information, preparing charts and presenting them to decision makers. In that sense, I see Excel playing a strong role in BI workflows in future.

– Purna Duggirala

With the addition of features like Power BI (Power Pivot, Power Query, Power View, Power Maps etc.) that naturally integrate with Excel, analysts, reporting professionals and BI people are finding Excel more relevant for full-length BI implementations.

In order to remain the favorite analytics app of everyone, Excel needs to do what it is amazingly good for. These are – offer a sandbox-like environment where anyone can play with data and come up with information, keep the Excel software offerings clean & simple (with the addition of Power BI, buying and using Excel has become a complex process), give users competent & compatible Excel apps for tablet & phone devices and include features to do powerful data analytics processes with one-click (as against a complex set of formulas, pivot tables & manual steps that many analysts do now).

Long live Excel.

2. Ken Puls – Excel Guru

Excelguru.ca // @kpuls

Ken PulsI personally see Excel as THE future of Business Intelligence workflows.

No matter how many systems a company has, how big they are, or how many millions of dollars have been spent on them, the reality is that the majority of data is exported to Excel before decisions of serious consequence are made. I’d go so far as to say that there are only a handful of finance departments in the world who don’t run their critical decision making analysis through Excel.

With the increasingly diverse toolset being added to Excel — Power Query to source and clean data from disparate dirty sources, Power Pivot to aggregate those disparate sources into business intelligence models, Power View to create dynamic dashboards from those models and Power Map to tell the data story on a geo-spatial plane – it’s very clear that Microsoft is investing heavily to make Excel the Business Intelligence tool of choice.

I personally see Excel as THE future of Business Intelligence workflows.

– Ken Puls

The killer for Excel today is not the fact that it isn’t the best out there for building business intelligence, it is the fact that far too many users are ignorant of the vast amount of capability that was added in the last five years. The attitude of “Excel can’t do that” is still pervasive and relied upon by its competitors to sell THEIR products.

My advice to anyone looking at building business intelligence systems today and considering switching to a competitor’s product: find a business intelligence expert who REALLY uses Excel. Ask them what can be done. Chances are you already own the software that will do it all, you’re just not aware of how.

3. Bill Jelen

Mrexcel.com // @MrExcel

Bill Jelen

The new Power BI Desktop offering from Microsoft will make it easy to create powerful dashboards that you can share to various end points such as iPads within your organization. The easiest way to get data into Power BI is from an Excel file, so Excel continues to be the most important component in the Power BI workflow.

Continue reading →

9 Handy IFTTT Recipes To Automate Office 365 Tasks

When you have the Internet, your productivity can increase drastically. It all depends on how you use it.

If you constantly work on the Internet, then you probably already know all about IFTTT (If This Then That), the online service that automates your daily tasks by connecting popular web services that you use every day.

And IFTTT recently got Office 365 signed on as a service. Now a few of your favourite Office 365 apps are available as IFTTT channels: OneDrive, Mail, Calendar, and Contacts.

Knowing how often you use Office 365 yourself, you can imagine what kind of automated tasks are possible. In this blog post, you’ll learn how to start up your collection of Office 365 IFTTT recipes for some of the most simplest and common tasks you do on a daily basis.

Remember—if you don’t see a recipe that works for you, you can always create your own when you sign up to IFTTT.

Office 365 Contacts Reminder

Create A Calendar Reminder To Follow Up With Newly Added Contacts In A Week

Networking can be considered an art, which admittedly sometimes, requires help in not only remembering people, but proper networking etiquette, as well. Set a calendar reminder to follow up with new Office 365 contacts when you add them on.

Create A Task Card In Trello For Each Of  Your Meetings

Sometimes your schedule can be too hectic to remember the standard follow up tasks–esecially for meetings. Well, if you’re a Trello user, there’s a recipe that will allow you to create task cards reminding you to follow up with meeting notes.

Weather Office Calendar Reminder

Add A Calendar Reminder To Bring An Umbrella

Hate it when you get caught in the rain? If you aren’t in the habit of checking the weather forecast, this neat little recipe can  check in for you. It can give you an automatic Office 365 Calendar reminder to take your umbrella if rain is predicted for the day. Don’t ever get caught unprepared ever again!

Send Your Team A Note That Food Has Arrived

Who doesn’t love group lunches at the office? In workplaces where everyone is spread out among departments, you can save yourself a trip around the office and instantly inform your co-workers that their food has arrived. This “Do” Button Recipe isn’t your traditional “if this, then that recipe.” Instead of combining two actions, you use a single “Do” button on your phone to send an email to their inboxes.

Get A Notification When You Receive A High Priority Email

If you’re expecting an important email, you don’t have to sit around and wait for it. With this recipe, you can get iPhone notifications when you receive a high priority email in your Office 365 Mail inbox. This is a great way to free up your time and let IFTTT keep an eye out for you.

Save Gmail Attachments IFTTT

Archive Incoming Email Attachments To OneDrive

This recipe can help you save attachments you receive to your OneDrive account, allowing you to create an online database that makes it easy to store and find any important files you receive.

Download Liked Tracks From SoundCloud To OneDrive

Where would your productivity be without your music? If you’re a SoundCloud user, you can collect your favourite music and access it directly from your computer with this recipe that lets you download liked tracks on SoundCloud to OneDrive.

Save Your Instagram Photos To OneDrive

If you love taking pictures or are into photography, then you’re probably posting your shots to Instagram on a regular basis. With this recipe you can automatically save your Instagram photos to OneDrive and create an instant backup of all your photos.

Facebook Photos OneDrive IFTTT

Save the Facebook Photos You’re Tagged In To OneDrive

Can’t keep track of the Facebook photos you’re in? Just connect the Facebook and OneDrive channels to stay on top of it. This recipe lets you save any Facebook pictures that your friends tag you in. It’s a neat and easy way to start your own collection of photos with your friends.

There are a ton of other channel combinations you can use with Office 365. It’s just a matter of making the connections between the services you use on a daily basis.

Got your own suggestions? Help expand on this list by sharing some of your own recipes.

11 Awesome Data Visualizations Way Ahead of Their Time [Infographic]

In this day and age of big data and information overload, data visualizations are, hands down, the most effective way of filtering out and presenting complex data.

A single data visualization graphic can be priceless. It can save you hours of research. They’re easy to read, interpret, and, if based on the right sources, accurate, as well.  And with the highly social nature of the web, the data can be lighthearted, fun and presented in so many different ways.

What’s most striking about data visualizations though is that they aren’t as modern a concept as we tend to think they are.

In fact, they go back to more than 2,500 years—before computers and tools for easy visual representation of data even existed.

Curious to see how data visualizations developed over time?

Below is an infographic that highlights 11 unique data visualizations from across different—yet significant, periods in history. It includes the first world map created by Anaximander, the elaborate Catalan atlas commissioned by King Charles V of France, Dr. John Snow’s map of cholera deaths in London that helped in combating the disease in the second half of the 19th century, and so on.

From ancient Greece and Medieval France to Victorian England and 19th century Sweden, these data visualizations and creators were ahead of the times, innovating the way in which information could be presented.

Whether they knew it or not at the time, these creators helped to develop an essential modern-day tool that is now invaluable to the world of statistics. Take a look.

Embed this infographic on your website:

Data Visualizations Infographic

Embed this infographic on your website:

How To Turn Chrome Into A Notepad

How To Turn Chrome Into A Notepad

Among the many things you do online in a single day, we bet that taking down a note or two is somewhere at the top of your list. Was it for research? Recording a reference number? Brainstorming? Whatever the reason, having a scratch pad at arm’s length is a necessity.

One trick that can solve that problem—turn your browser into a note pad. It may sound odd, but it’s entirely possible. For this tip, we tried it in Chrome, and we have to admit that this is a neat little trick everyone should have handy.

All you have to do is copy and paste this single line of code into your browser’s URL bar:

data:text/html, <html contenteditable>

Then hit enter. Click on the blank tab window that shows up and start typing away. Testing it on the latest Chrome build, it worked out great.  You can even bookmark the URL and call it up anytime for instant access.

Chrome Browser Notepad

This tip originally comes from Jose Jesus Perez Aguinaga, web engineer and Javascript developer, who shared this tip on his blog, Coderwall.com, a few years ago. And it still works.

Right off the bat, you can get a good idea of how this can make things easier for you while you’re on the web. As a writer, student or researcher, you can use this as a distraction free writing tool or quick text editor.

You don’t have to install a plugin or open another application. And without having to worry about any formatting frills, you can get in a good chunk of writing without having to leave the browser.

The one drawback, however, is that if you close the tab, you’ll lose all your notes. If you jot down reminders or to-do lists which you don’t need afterwards, then this shouldn’t be a problem.  In fact, it may even be convenient as you can skip over the usual dialog reminding you to save the file.

But if you do need those notes, then you can easily save them before closing the tab.  To do so, just use Chrome’s “Save page as…” function from the menu and save it as an HTML webpage. You should then be able to access the file in any browser.

If you hated the hassle of opening up a second app just to copy-paste or record something, try this out. This little trick will help simplify the process and speed things up.

5 Hats All Budding Entrepreneurs Should Expect To Wear

Preparing For Business

Nowadays, you can’t sift through a business news feed without hearing news about small startups that went from rags to riches and made it big. And if a success story provides you with anything, it’s the idea that anyone can do it, that all it takes is your passion and one great idea.

But that is NOT enough.

As a successful entrepreneur, you need to be versatile, open to risk, and committed to seeing your vision through. Not only that, but there are a ton of hurdles known as “work” standing in your way. They’re all too easy to forget when you’re excited about your idea, brainstorming on how to finance and pitch your product. Keeping your business afloat will mean a lot of business-related stress and becoming a jack of all trades.

Already have the entrepreneurial spirit and ready to take that first step? That’s great. But before you do, think about your second step: what roles and shoes will you have to fill?

To prep you with an idea of what to expect, consider a few of these essential hats you should expect to wear as you turn your pipe dream into a successful startup.

The Administration Hat

At the beginning, entrepreneurs will need to consider the nitty-gritty details of handling business operations on the most basic level.  Depending on what your business is, this will include any aspect needed to keep your company and product line running: office space, payroll, supplies, accounting, and setting up workflows, just to name a few.

If one part in the administration chain doesn’t work out, you have to be open to different solutions, looking at the process from all angles. That first year as an entrepreneur will be about discovering and testing both yourself and your ability to think outside the box. So be prepared.

The Team Management Hat

Don’t forget that it also takes interpersonal skills to build a successful company. Once you build a solid business team, you need to be able to work with and lead them.  This means being able to delegate tasks, mediate conflicts, listen to concerns, know everyone’s strengths and weaknesses, or simply give credit when and where it’s due.

Managing Office Teams

Whatever decisions you make regarding the team and your office, you need to be able to listen to the dynamics going on around you. With the management hat on, you lead and generate the company’s culture, creating an atmosphere and tone for the company.

The Marketing Hat

Nowadays, new businesses won’t even make an impact without some online exposure. Marketing will play a major factor in staying ahead of the field. On the technical side of things, this means being familiar with web technology, SEO, ads, marketing tools, and analytics.  On the human side of things, it means having a clear goal in mind to create a sincere brand you and loyal users can stand behind.

Once you have both, you’ll have to be able to decide what type of marketing works for your business and what doesn’t. And while it’s easy to mimic what other companies are doing, remember that one size doesn’t fit all. When it comes to marketing, expect to invest some serious time in researching your own demographics. A marketing campaign is only successful if it fits your company and your vision.

The Social Hat

Web presence and social image is everything now. From blogging to networking, wherever you choose to promote your business, you need to have a community behind you. It’s a great way to get feedback, support, and loyal fans. The relationship you build with your users is what will set you apart.

Making Business Connections

And note that this social hat doesn’t only apply to an online audience. This also includes in-person meetings, presentation pitches, board room discussions and even swapping business cards at conventions. Making the right connections can help put you in a good position in your niche.  No one ever does it alone!

The Tech Hat

Before you even start pushing your product out there, be sure you know the tech behind it—especially if you’re a tech start up. Be active in the development and testing stage. Do everything you can to be in-the-know about your niche, don’t leave this side of the project to only one person on the team. Don’t forget, if you’re helping to field the support lines too, you can’t blank out on basic usage and troubleshooting issues.

Learning New Business Technology

For non-tech start ups, this is still a necessity. No matter what product or service you offer to the public, you need to know about the tools needed to run your business. Dealing with customers online, for instance, may mean creating an entirely new database and digital document management system.  From simple emailing to document processing, you have to make sure your tech makes things work smoothly.

Debating on whether or not you can hack it?  Just reading about someone else’s success is enough to inspire you to make your own entrepreneurial dream happen. So before you quit your day job, do your homework first.  Be prepared for the tasks you’ll be spending most, if not all, of your time on.

Ever dreamed about starting your own business? How do you plan on getting it off the ground?