Category: Basic Excel
Save Your Excel Chart as an Image
Excel is one of the best programs a person can use to turn hard data into an attractive and easily understood chart. An Excel chart can make a striking visual for a presentation or report. Here are three different ways to save an Excel chart as an image file, such…
Read More
How to Audit Formulas in Excel: The Formula Auditing Toolbar
The formula function in Excel is one of the most useful things any business owner or employee can use, especially when large volumes of data need to be evaluated. Sometimes you are given completed worksheets that you need to do extra analysis on. It is sometimes difficult to see where…
Read More
How to Convert Text to Number in Excel: 2 Ways
Excel is the go-to program when you need to organize data, create formulas and share information with the team. That being said, working with data in numerous places and applications can make the data import not as seamless as one would hope. Let’s say you transferred data from an external source into Excel and…
Read More
Ease the Pain of Data Entry with an Excel Forms Template
Excel makes it easy to work with data tables, but first you must get that data into tables. Keying data into a spreadsheet and moving the cursor after each entry can be frustrating at best; at worst, it can leave you with mangled data in an unusable format. Fortunately, Excel…
Read More
Excel Formulas Not Calculating? How to Fix it Fast
You’ve created the reports for your management meeting, and, just before you print copies for the executives, you discover that the totals are all showing last month’s values. How do you fix it—fast? 1. Check for Automatic Recalculation On the Formulas ribbon, look to the far right and click Calculation…
Read More
Excel Formula Count
Are you trying to count values in your worksheet and don’t understand why the result is too high? Or are you looking for a method that excludes blank cells? Maybe you want to count only values which are greater than 1,000. Excel gives you the power to count only the…
Read More
How to Create a Report in Excel: The PivotTable
Excel is a powerful reporting tool, providing options for both basic and advanced users. One of the easiest ways to create a report in Excel is by using the PivotTable feature, which allows you to sort, group, and summarize your data simply by dragging and dropping fields. First, Organize Your…
Read More
Basic Formula Series: The Excel® Average Formula
Let’s say that you’ve been given a new set of projects to work on, and you’re being asked to calculate how long you think your team will need to complete various pieces of each project. The best way to obtain those numbers is probably to look at other projects you’ve…
Read More
Basic Formula Series: The Excel® Sum Formula
Excel® formulas have their own logic and syntax, much like math problems. Once you understand the syntax, you can save a great deal of time by building basic and complex formulas to do the majority of your work for you. Where in math problems you combine numbers with variables, in…
Read More
Using the Excel PMT Function to Determine Loan Interest
We start out with a basic premise that we borrow $10,000.00 (D1). Our interest is 3.0% (D2) and the monthly payments are forty-eight months (D3). The PMT formula calculates what to pay back on a monthly payment loan. There are three arguments in this function; RATE,NPER,PV. Two other arguments shown…
Read More