NH Learning Solutions Blog
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.
3 Ways Excel Training Can Make You a Better Employee
Because of the seemingly mathematical, formula-oriented nature of its infrastructure, some people mistakenly assume that Microsoft Excel is a program only for people in the tech sphere. However, it’s potential applications extend far beyond that, to practically any business and any job that deals in data.
5 Reasons Why You Should Create Excel Macros
For many of my Excel students, macros are the scariest part of the program. Granted, VBA (which is the programming language behind Excel macros) cares about every single punctuation mark and typo, which can be scary. But Excel macros can also significantly improve your Excel productivity and with the proper instruction, they aren’t scary at all.