Latest News

Excel & Office 365 Custom Solution Advice

All About Excel Pivot Tables

Friday, June 7th, 2019 / by Excel Champ

Pivot tables are a powerful data analysis tool that you can use to get insights into the data that you are working with. To create pivot tables, you need to first of all organize your data into clear rows and columns with labels that make sense for the data that you are working with, so […]

Read more

Using Power Query to Clean Your Excel Data

Thursday, May 9th, 2019 / by Excel Champ

Power Query is a handy feature in Excel that helps you to clean your data, and change it into the format that you need it in. Power Query has been available in Excel for a long time, although in Excel 2016 it was called Get and Transform instead. This tool is an ETL (Extract, Transform […]

Read more

Integrating Microsoft Flow Into Excel

Wednesday, April 3rd, 2019 / by Excel Champ

What Is MS Flow And How Can It Be Integrated Into MS Excel And Other Programs When Microsoft first introduced MS Flow the main goal was to help businesses become more automated. This was especially focused on those companies that had many semi-repetitive tasks that needed to be performed many times per day. The software […]

Read more

How Microsoft’s Excel Can Make Charts And Graphs To Expose Trends And Trendlines Used In Forecasting

Thursday, March 7th, 2019 / by Excel Champ

Microsoft’s Excel program has been helping businesses become more productive for over a decade now. It has the advantage of being one of the top applications that are taught in many college business, bookkeeping, finance, and secretarial classes. Plus, there are literally millions of businesses that have the program already installed on their computers so […]

Read more

New AI Features Available in Excel

Thursday, January 3rd, 2019 / by Excel Champ

Excel is an incredibly useful piece of software that can be found in offices across the world. However, many of the companies that use this software aren’t taking advantage of the full range of features. Microsoft recently added some new AI based features to Excel that can make this software tool even better. Ideas – […]

Read more

What Is The Difference Between Excel 365 and Excel 2019?

Tuesday, November 27th, 2018 / by Excel Champ

Technically Excel 2019 is not yet available, however, many of the new features are accessible to subscribers to the Office 365 version. Microsoft has been moving toward a subscription-based model in recent years in order to make incremental changes rather than big changes to file types that posed all sorts of difficulties for Excel users. […]

Read more

Select New Features in Excel 2019

Wednesday, October 24th, 2018 / by Excel Champ

Microsoft is rolling out several new features in Excel 2019, some of which are already available to Office 365 Subscribers.  Here we will highlight a few of our favorites:  Funnel Charts and the IFS, MAXIFS, MINIFS and SWITCH functions. Funnel Charts Funnel charts are commonly used in sales organizations to show how leads are converted […]

Read more

Data Prep: Unformat your Formatted Tables

Friday, October 19th, 2018 / by Excel Champ

Tables come in many styles and formats. For reporting purposes, the better a table is formatted, the easier it is to read. However, formatting is often our enemy when we attempt to use the data for analysis, database, and data integration purposes. In this blog post, we will demonstrate how to unformat a table and […]

Read more

Create a Heatmap from a Large Data Set using Excel’s Power Maps

Thursday, September 13th, 2018 / by Excel Champ

One of the exciting new features of Excel 2016 is the capability to generate geographical maps. This feature, called Power Maps, is now also available for Excel 2013. The types of maps that can be generated with Power Maps are only limited by your imagination! After covering the basics, we will demonstrate how to create […]

Read more

Venturing Away from Excel’s Home Tab: The Data Tab

Tuesday, August 28th, 2018 / by Excel Champ

If you tend to avoid venturing away from Excel’s home tab, where you feel most comfortable, you are missing out on some features that could make your life easier. The Excel 2016 Data Tab, for example, is packed with useful functionality. In this post, we will review the functionality available in the “Get & Transform,” […]

Read more

Bug Free Guarantee    Learn More