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.
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 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 Outlook Add-Ins: Starbucks
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!
How to Use the Co-Authoring Feature in Microsoft Word
When you and your colleagues want to collaborate on a Word document, use real-time co-authoring to see everyone’s changes as they happen. Here are the steps to utilize this productivity boosting feature.
How to Delete an Unwanted Blank Page in Microsoft Word
So there is a blank page either in the middle or at the end of your Word document that cannot seem to be deleted. This is a very common and often frustrating occurrence that many users face while creating content within Microsoft Word. Sure, you can choose to print only select pages, but that doesn’t exactly solve the problem.