NH Learning Solutions Blog
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.
Easily Create Templates with Slide Master
With the new year coming, many people will be presenting the numbers of last year and creating goals for next. This means a lot of presentations. Whether it's an end of the year address or a New Year boost meeting, you can easily create template presentations by using Slide Master in Microsoft PowerPoint.
How to Create More Effective PowerPoint Presentations
There's nothing worse than having to sit through a boring presentation. Unless, of course, you're the one presenting. Many presenters use Microsoft PowerPoint to share information and data more easily. But are these presentations engaging with the desired audience?
There are simple ways to pump up a PowerPoint, like adding relevant images, themes, and better organization. Making sure your PowerPoint presentation is more engaging can even help you feel more confident in your presenting skills. Here are some easy ways to help make that happen:
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.