Microsoft Office

Download free Microsoft Office templates for Office products like Excel, PowerPoint and Word and learn how to use Microsoft Office programs and tools to make business documents, spreadsheets or presentations. Boost your productivity learning the best productivity tools and download free clipart for PowerPoint presentations.

Office 365 is Becoming Microsoft 365

microsoft 365

On March 30, 2020 Microsoft announced that Office 365 is becoming Microsoft 365. This essentially means that Microsoft will be changing the brand name for the majority of its Office 365 products to Microsoft 365. There are a number of reasons why Microsoft is making this change. You can learn about the new changes from …

How to Use the SMALL Function in Excel

small function example

For those who have been using Excel, you may already be familiar with the many functions that you can create in your spreadsheets. However, not everyone is as comfortable working with functions. Our blogs offer many tips to help you navigate Excel. This program may truly be daunting, but once you know how to make …

How to Use the IF Function in Excel

budgeting application for if function

When you’re using Excel, it’s easy to be daunted by formula and function. This is especially true when you have just started using it for your data. However, once you get the hang of it, you will see how helpful Excel can be, especially when it comes to making sense out of a large amount …

How to use IFNA Function in Excel

if function in excel example

There is the Excel IF function that creates True or False results. However, if there is an N/A error, there is another function that takes care of that. This is the IFNA function in Excel. In a previous post we showed you how to use the AND function. This time we will show you how …

How to Use the AND Function in Excel

and function in excel

Excel is a nifty application for all kinds of data gathering, sorting, and analysis. One of its best features is that it allows users to make use of logical expressions. These are then used to check if certain conditions are met in a list of data. This particular function is called the AND function.

How to Freeze Panes to Lock Columns and Rows in Excel

freeze panes

When you’re working with spreadsheets, there can be a lot of data that your worksheet would take up many cells. It can be easy to get lost, if this is the case. You may have a hard time recognizing what row or column the cell you’re viewing belongs to. And this is where Microsoft Excel’s …

All About Using Real-Time Collaboration for a Word Document

Share Your Word Document for Collaboration

Also known as real-time collaboration, Word makes it now possible for users to co-edit a document remotely and at the same time. This is, of course, an answer to the growing inclination for apps, especially productivity apps, to become more collaborative. With Microsoft Word, multiple people can work together on a document. This allows people …

How to use Slicers in Excel to Filter Data

Choose Data to Display

Using a Slicer in Excel is one of the best ways for you to filter your data. This is especially true if you have a large and complex data set. If you want to figure out a single category or view a specific data set under specific conditions, then a slicer can help you with …

How to Create PivotTables in Excel to Calculate, Summarize and Analyze Data

Sample Pivot Table

One of the most powerful and most widely used features of Excel is the PivotTable. A PivotTable allows you to extract the data that you need from a large, complex, and detailed data set. Many may find themselves intimidated by pivot tables. However, once you get the hang of it, you will see how easy …

Accessibility Checker for Office Readies Documents for People with Special Needs

Check Accessibility in Microsoft Word

With our technology today, more and more people can have access to various kinds of files, such as documents, spreadsheets, and slideshows. However, there are still those who have accessibility issues, such as those who are physically handicapped or have special needs. This is why Microsoft Office has Accessibility Checker for Office that helps users …