Excel Training

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

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

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

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 Training: 5 Ways to Improve Microsoft Excel Skills Every day, millions of files around the world are created, opened, and edited in Microsoft Excel. As an original member of the Microsoft Office Suite, the cross-platform spreadsheet software has evolved over the decades to meet the demands of engineers, database programmers, accountants, administrators, educators, publishers, and […]

Microsoft Excel has been around for years, but that only means the software has continually improved to better meet the needs of modern businesses. Many small companies use Excel to help with their simple accounting tasks, but Excel offers much more than these basic functions. Companies that work with complicated financial analysis rely on Excel. […]

Like hiring processes and company publications, spreadsheets benefit from standardization and consistency among all staff. When employees follow company-wide conventions and formats, the documents they create are likely to be better understood, easier to read and more reliable. Additionally, others in the organization will be better able to edit worksheets designed according to a common […]

At ExcelHelp.com, our expert Microsoft Excel VBA developers have built applications for a wide variety of purposes in the Life Sciences Industry. In this post, some of our recent work will be highlighted to demonstrate the possibilities. Regulatory Compliance Tracker Temperature and Humidity Tracker Patient Progression Dashboard Quote and Work Order Generator Regulatory Compliance Tracker […]