Category Archives: Basic Excel

Use an Excel Formula to Convert Text to Numbers

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 numbers were mistaken for text….
Read More

Why Is Your Excel Formula Not Calculating?

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 Options. On the dropdown list,…
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 values that meet your criteria…
Read More

Categories

Monthly Archives