Excel Consulting

The holidays are usually a pretty busy affair for everyone, from shopping to parties to travel. However, when you manage a team at your business, it gets even harder. You need to keep up with all the days off and time-off requests of employees, while also making sure you have enough coverage for all the […]

If you’re looking for quality project management software, you’ve most likely seen a vast number of options available. Sadly, many of these choices cost thousands of dollars and are simply out of reach for most small businesses. With that said, you most likely have a very powerful project management software solution already installed on your […]

Spreadsheets might seem boring, but they’re incredibly versatile and there are a lot of useful functions that can save you time and make you look like a genius at work. Here’s a quick list of Microsoft Excel functions everyone should know. 1 – Paste Special Do you ever find yourself struggling with copying and pasting […]

Excel remains one of the most popular and useful products developed by Microsoft, and is a common sight in most offices and even educational institutions. Microsoft released a number of fixes and security updates for Excel in October 2019. Here’s a quick look at whats new Microsoft Excel, October 2019 patches for Excel 2016 as […]

Entrepreneurs spend thousands on accounting experts so that they can provide a transparent picture of their company’s status for a specific period. The accounting experts and financial analysts spend a lot of time preparing annual reports to give their clients the report they need. This requires a lot of skills in Microsoft Excel. They need […]

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

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

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

Microsoft Office 365 provides users with a combination of widely used and familiar applications, such as Excel, Word, and PowerPoint, along with some new tools, cloud storage, and more. This post intends to bring some clarity to the use and sharing of files with Excel Online, and how that relates to Excel Desktop and OneDrive. […]

Excel users often need to find unique values in a data field and conduct some sort of analysis on those unique values. The larger the data set, the more efficient this process needs to be. Most certainly, using the “Find” functionality on each value is the last thing anyone wants to do. Fortunately, Excel has […]