Excel 2016

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 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 …

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 …

How to Use Mentions in PowerPoint to Get Advice and Feedback

Start Writing Comments and Mention People Involved

Ever wish you could easily and quickly get the attention of a certain team member or manager for feedback on your project? Usually, it goes like this. You finish your document, then email or share it with your team members or submit it to your client. Then you wait for their feedback. If you need …

How to Chat as You Edit Documents in Microsoft Office

Chat with Co-Authors with Office 365

When it comes to productivity and collaboration, Microsoft Office is leading the game. Not only does it have the most advanced programs and features; it also keeps updating them to suit the needs of today’s users. One of its biggest selling points today is its collaborative feature. This allows Office users to work on the …

How to Skip Conditional Formatting for Blank Cells in Excel

Skip Conditional Formatting for Blanks

Conditional formatting in Excel is a feature that allows you to apply certain formatting values on a cell or a range of cells in a table based on certain conditions, or criteria. With this feature, Excel will check the value of a specified cell or range of cells to see if it matches the condition …

How to Analyze Data Quickly in Excel

See Automatic Preview of Selection

Over the years, Excel has been widely used for collecting, documenting, and analyzing data. It has undergone many changes and improvements over time, adding different features that are relevant to the demands of today. With Big Data as one of the many important things businesses and organizations rely on to make sound plans and decisions, …