Excel Training

Charts help to make various graphical representations visually impressive. In Excel, the visual representation of your data story will determine how well your presentation is received. But, where will you visualize data in Excel? Here’s what you need to do: 1. Error-free spreadsheet The first thing to ensure is to keep the excel sheet free […]

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 […]

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 […]

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 […]

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 […]

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 – […]

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. […]

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 […]

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 […]

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 […]