# Formulas

## How to Use the SMALL Function in Excel

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 IFNA Function in Excel

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 Skip Conditional Formatting for Blank Cells in Excel

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 use VLOOKUP to Find a Value in a Table or Range

So you’ve been organizing your data in Excel. You believe you’ve done a good job so far, but when it comes to looking for a particular piece of information, you spend so much time finding it. If this is you, then you may not have heard about the VLOOOKUP tool in Excel. It has many …

## Using LaTex in PowerPoint

Did you know that you can embed Math equations in your PowerPoint presentations using LaText? IguanaTex is a new addin that let you embed Math equations in PowerPoint presentations easily. If was wondering how to embed equations in PowerPoint this addin will be very helpful for you. IguanaTex is a free LaTeX Add-In for PowerPoint. …

## How To Prevent Editing in Excel Cells With Formulas

Microsoft Office’s Excel has come a long way since it started decades ago. Today, it’s one of the most used applications across various industries and practices. After all, it’s a convenient way to decode and organize large chunks of data, quantify information, and present it in visual format after thorough analysis. In this post we …

## Clearly Display Formulas in PowerPoint using a Simple Formula Template

Working with Math in PowerPoint can be funny and tedious at the same time. In Microsoft Office we could use the Equation editor to add formulas and equations to our slides but sometimes it comes very handy to have a simple formulas PowerPoint template where we can describe display the formula in a PowerPoint slide. For …

## Free Cash Flow Formula

The free cash flow formula is used to describe the cash that is free to be paid back to the suppliers of capital when valuing the operations of a firm using the discounted cash flow model. If you are creating a PowerPoint presentation and need to present the free cash flow then here we will try to …

## Make a Multiplication Chart in PowerPoint in Less than 2 Minutes

Here we will show you how to make a simple multiplication chart PowerPoint presentation from an Excel table. This article will guide you on how to make a simple but very useful multiplication table in Excel and then convert the table to a PowerPoint presentation. You can use this multiplication chart template for PowerPoint to …

## Calculating for Standard Deviation in PowerPoint 2010

One of the beneficial features of Microsoft PowerPoint 2010 is its ability to incorporate functions and applications . For instance, Microsoft Excel is an independent application which due to versatility of PowerPoint 2010, users are allowed to utilize  almost all functionality of Microsoft Excel via PowerPoint 2010. This includes computing data as well as graphing these data simultaneously in …