Excel for Mac

Learn how to use Excel for Mac and read articles on how to take advantage of the Excel formulas to make awesome spreadsheets and solve common problems manipulating data in Excel.

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 …

How to Create Easy Time Dimension Table for Analysis in PowerPivot

easily-create-a-time-dimension-table-in-excel

When you’re storing large amounts of data, especially time-sensitive ones, it’s important to have a time dimension. This time dimension is important because you can better analyze data and generate relevant reports based on the information you need involving a certain date or time. Having a time dimension table at your disposal, without the need …

How To Make A Flowchart In Excel

If you often require showing a task or process in the form of a chart, then you would know the importance of flowcharts all too well. In previous posts we showed you ‘How To Make A Flowchart in PowerPoint’ and also presented a comprehensive guide regarding the ‘Meaning Of Different Flowchart Symbols’. This time we …

Free Assignment Schedule Template for Excel 2013

If you need to keep track of your assignments in Excel or download a free Assignment schedule template for Microsoft Excel then this free Excel 2013 template can be used for this purpose. Free Assignment schedule Excel 2013 template is a free spreadsheet template that you can download from Office.com website to keep track of your assignments …