Functions

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

Fill in the needed values

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 …

How to Draw a Sine Wave in PowerPoint 2010

If you need to draw a sinusoidal curve in PowerPoint for your presentations then here we will show different approaches that you can use depending on your needs. Sine Wave or Sinusoidal wave is a mathematical curve that describes a smooth repetitive oscillation. It is named after the function sine, of which it is the graph. Accordingly to …

Make 3D Plots for PowerPoint Presentations

Online 3D Function Grapher is a free online utility where you can make simple 3D plots from a Math function. You can use the online tool to make simple 3D graphs and plot mathematical functions in 3D. All functions can be set different boundaries for x, y, and z, to maximize your viewing enjoyment. There is …

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 …

How to Add Simple Matrix in PowerPoint 2010

Matrix in PowerPoint can be useful for many different purposes, especially if you are preparing a PowerPoint presentation for your algebra presentation in the classroom. Even if you can add Math functions and formulas in PowerPoint using Equation Editor, there are some simple alternatives if you need to show a simple algebra matrix. This procedure …

How to open VBA Macro editor in PowerPoint

In Excel it is straightforward the way to open VBA Editor to edit macros and functions. In PowerPoint you need to do something slightly different. However, it is pretty easy. In PowerPoint 2010 you can just create a new Macro by going to View tab and then click on Macros button. Here a new list of Macros will …