Excel Online

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 …

Read My Document Add-in Reads Out Office Documents

Select Text to be Read

Working in Microsoft Word has always been a breeze. It’s one of the world’s most widely used word processing program and almost everyone already knows how to use it. And with the many add-ins available through the Microsoft AppSource today, you can make the most out of Word. There are many add-ins that extend the …

Visualize And Analyze Your Hierarchical Data in Excel With HierView

Create Beautiful Hierarchy or Organizational Structures

Microsoft Office programs such as Word, PowerPoint and Excel have been around for so long. They’re widely recognized and used in many business and academic activities, and considered as reliable companions in creating documents, managing data, or presenting an idea. While these programs are great in themselves, add-ins are there to make things a little …

Cleanup and Standardize Excel Sheets with XL Tools

Select-Data-Range-You-Want-To-Cleanup

For some, working with Excel can be daunting. Filling up the blank cells, writing the correct formula, and just facing numbers can be challenging. Most likely, this is because working in Excel is not the same as working on Word, which is more straightforward. Of course, the two are different and there will be instances …

Professionally Design Your Financial Reports in Excel with Sage One Add-in

Sage Business Cloud

Financial reports are important in any business because these can give you detailed information about the financial health of the organization. They can help you in creating important business decisions and in creating business strategies that can direct your company to achieve its goals. Sage One Add-in for Excel makes financial report making easier.

Prevedere Forecasting Tools for Predictive Analytics in Excel

prevedere-excel-taskpane

Prevedere is recognized as one of the best business intelligence software out there. Now, you can have the power of the best intelligence platform right within Microsoft office. This is because Prevedere is now available as an add-in for Microsoft Excel. Prevedere is one of the world’s best and most revolutionary software when it comes …