Blog

NH Learning Solutions Blog

How to Create Pivot Tables in Excel

How to Create a Pivot Table in Excel

Pivot Tables can be used to create comprehensive tables of information, even combining two to compile data. They help you create better charts, graphics and tables, as well as make it easier to export to other applications within Office. Pivot tables are a quick way to help up presentations and keep data organized. Utilize them with other tips to make your Excel experience better.

Big Data Analytics with PowerPivot & Power View

Big Data Analytics with PowerPivot & Power View

In an effort to be more user-centric, Microsoft has evolved its approach to business intelligence, offering user-friendly Excel add-ins such as PowerPivot and Power View. One advantage of putting more power into the hands of business end users is that these are the individuals who are most familiar with the data and stand to gain the most by learning from it. Excel is a useful tool for numerous purposes, but it has limitations, particularly when working with large sets of data.

Top 6 Features of Microsoft Office 2016

Top 6 Features of Microsoft Office 2016

Microsoft’s 2015 reboot of its flagship software suite was a major update, offering a wealth of collaboration capabilities that integrate more tightly with SharePoint and OneDrive. Office 2016 isn't just about new Microsoft Word and PowerPoint layouts, either; for the business user, there are several features that can help you better communicate, collaborate, and create. Below is our list of the top six.

7 Signs You May Need Microsoft Excel Training

7 Signs You May Need Microsoft Excel Training

Microsoft Excel is the standard spreadsheet application for both the business world and for personal use. However, there are several important reasons why Excel training can make a large impact on employee and company productivity.

How to Remove Duplicate Values in Excel in Just 5 Steps

How to Remove Duplicate Values in Excel in Just 5 Steps

Data duplication can happen when records are entered into the spreadsheet more than once (or you're combining records from multiple sources). You might also find duplicates for one or more fields, such as a name or state field, with the same data and want to limit the records to unique data for some fields.