NH Learning Solutions Blog
How to Embed a Web Video into Microsoft PowerPoint
Videos can add an extra boost to presentations. Many people are visual learners and videos have proven to help keep people engaged with the content being shown to them. They can also make long presentations more enjoyable. Here is an easy way to embed videos into your PowerPoint presentations:
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 Filter Out Automatic Replies in Microsoft Outlook
Emails are the most basic form of communication in a work environment. The average number of emails an employee can receive each day is about 121 from a various number of people. From those, a large number of those are automatic replies. There is nothing worse than expecting a speedy response, only to be fooled when that new message is an auto reply. Here's a way to filter those responses out of your inbox.
How To Customize Grammar Settings in Microsoft Word
Auto-Correct is a modern marvel that many people use without even knowing it. Combined with spellcheck, lessons on knowing proper grammar have become less frequent. Computers now make those corrections for us. However, our tech is only so smart and sometimes it does not understand phrasing and names that are common in some industries. Speaking specifically for the tech industry, try writing any kind of guide or case study in Microsoft Word without getting that red edit line somewhere.
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.
How to Use the Starbucks Add-In for Outlook
Outlook is the Microsoft powerhouse when it comes to email. Used mainly by businesses and heavily focused in practicality, Outlook works hard to create ease of use. It can also organize your calendar and integrate with Skype for Business to let you immediately schedule calls. Like many other great products of Microsoft, the new Office 365 version of Outlook has plenty of add-in features to make your business schedule more enjoyable. One of these latest features: schedule meetings at Starbucks, all from within Outlook.
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.
How to Search for Messages in Microsoft Outlook 2016
It happens to all of us: We are on a call with a coworker or a client, we know we have a specific message somewhere in our Outlook folder, but we cannot seem to find it!