Category: Excel®

Creating a Flowchart in Excel

Have you been tasked with creating a flowchart to document a business process? Some companies invest in expensive, specialized software that builds flowcharts for you with just a few points and clicks. Other businesses prefer to use a tool which they already have, and in which the employees have already…
Read More

Excel Macro Loop – Limit Redundancy to Save Time and Energy

Does your code need to execute the same action more than once? Instead of programming it multiple times, try writing it once and repeating it with a loop. Excel offers several different loop structures, depending on the conditions under which it should execute. Check out the table below to see…
Read More

Where is the Chart Wizard in Excel?

Microsoft eliminated the Excel Chart Wizard in Excel 2007, and it has not returned in the successive versions. In fact, the company rebuilt the entire chart system, and the team decided it would not be worthwhile to update the wizard and all of its options. On the bright side, the…
Read More

Using VLOOKUP in an Excel Formula

Have you ever needed to look up current prices for an invoice for goods shipped? What about looking up the price discount for a loyal customer? Excel can do these or any other data lookup using the VLOOKUP function. This function’s precise parameter requirements can seem intimidating at first, and…
Read More

Excel Date Formula

Have you ever entered a project due date into a spreadsheet by manually counting the number of days and typing in the number? If so, then you’ve also experienced the tedium of recalculating those dates by hand and retyping them. Fortunately, Excel has all the functions to do the date…
Read More

Organize Projects and Count the Time between Dates with the Help of Excel Date Formulas

Have you ever entered a project due date into a spreadsheet by manually counting the number of days and typing in the number? If so, then you’ve also experienced the tedium of recalculating those dates by hand and retyping them. Fortunately, Excel has all the functions to do the date…
Read More

Excel Offset Formula

How do you find a single value in a table? How do you find, say, the number in the fifth column of the third row? Try out the Excel offset formula! The OFFSET function finds a cell (or range of cells) that is a specific number of cells away from…
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

Excel Dynamic Charts: A Great Time Saving Tool

If you use Excel for reporting on results each month, you have probably needed to adjust your charts automatically to add a new month, state, or sales rep. Typically, that means clicking on each chart and adding a new data series or expanding the range of the current series. Unfortunately,…
Read More
< >