NH Learning Solutions Blog
VLOOKUP vs. MATCH/INDEX in Microsoft Excel
If you need to get data from one data range into another, most people rely on the VLOOKUP function. But did you know there is another alternative with the combination of the MATCH and INDEX functions? This blog will cover both options, explain the differences, and when you might want to use one vs. the other.
How to Use AutoFill in Microsoft Excel
Do you use Excel frequently? Are you looking for a way to shorten the time you spend on your spreadsheets? Instead of entering all your data manually, you can use the AutoFill feature to fill cells with data that follows a pattern or that is based on data in other cells.
How to Use VLOOKUP in Microsoft Excel
How often does this situation happen to you? You have 2 spreadsheets full of data and they need to be combined into one. What makes it even more difficult is that both tables are not organized in the same way, leaving you with data all over the place. There's an easy way to fix this.
How to Use Freeze Panes in Microsoft Excel
Having long entries of data is what Excel was made for. However, it can cause confusion when you have large tables of data that can take some time to scroll to find the right information. Freeze Panes helps you keep track of categories as you scroll.
3 Conditional Formatting Features in Microsoft Excel
Excel is one of the most utilized tools in the Microsoft Office series. It's great for compiling data and organizing information. But in extremely large spreadsheets, single cells can get lost in the sea of numbers. Customizing cells helps those using the spreadsheet easily find and keep track of specific names, numbers, and other data. Tools like Conditional Formatting are made to help create easily identifiable cells based of certain settings. Below are 3 quick and helpful features to help you keep your data better organized.
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
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
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
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
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.