Excel Training

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

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

The key to maximizing the return on investment seen from transcription is the speed, accuracy, and overall efficiency with which the transcription can be completed. A large portion of the responsibility in realizing these goals lies with the person performing the task. As a general rule, the more experienced and skilled a transcriptionist is, the […]

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

  Excel is the Top End-User Application Excel has been a valuable tool for people in many different professions for some time now. Many careers require that applicants demonstrate their knowledge of this Microsoft program. Almost every user knows the basic features that Excel offers, which includes data gathering, storage and analysis, but even daily […]

Consistent Training Creates Long-Term Results   One of the oldest and most repeated adages in the business world is that “people are your greatest asset,” and it is certainly an attractive statement. However, as the Harvard Business Review tells us, it isn’t always that simple. This belief needs to be taken a step further, and […]

When you implement the use of business dashboard reporting in Excel, it offers a number of benefits. You can use the information to make important decisions, develop strategies, and more.   With a customized excel dashboard in place, you can have an effective view of the data, and give you and managers information they need […]

The need to see data with clarity will never disappear in business. A spreadsheet that is well formatted, flexible and professional looking reduces the potential for errors and misinterpretation. Excel offers a nearly universal means by which to communicate data and numbers. Excel has been around since 1985, and it’s one of the few software […]

Excel 2016 has released a powerful set of convenient tools referred to as “Get & Transform.” Utilizing technology from Power Query, users can readily connect, shape and combine data from different sources. The update will change the ribbon layout for fast access to the available Get & Transform tools. This upgrade is available as part of the Office […]