I started writing a series of blogs on the use of Excel spreadsheets for circuit design on the now-defunct Microcontroller Central. Those blogs, though separate from this blog and future ones that I ...

Create a report using charts: Select Insert > Recommended Charts, then choose the one you want to add to the report sheet. Create a report with pivot tables: Select Insert > PivotTable. Select the ...

Much of the data that you use Excel to analyze comes in a list form. You might need to sort the data, filter it, sum it, and perhaps even chart it. Excel tables provide superior tools for working with ...

Excel validation lists avoid blanks and errors with TOCOL(ignore) plus FILTER; the spill range stays stable across worksheets.

Ever found yourself wondering if there’s a more efficient way to handle your data in Excel? If you’ve been using Pivot Tables but feel like you’re only scratching the surface, you’re in for a treat.

Excel 2007's new table feature eliminates the need to copy formulas; once you define a data range as a table, Excel will do it for you! Tables are new to Excel 2007 ...

How to calculate a conditional running total using a PivotTable in Excel Your email has been sent An expression to return a simple running total in Excel is easy — a few references and you’re done. A ...

Although getting into the habit of naming tables in Excel can take some time if it's not something you usually do, here's why today's the day to start. First, if you're working with a large workbook ...

Excel's GROUPBY function lets you group and aggregate data based on certain fields in your table of data. It also offers arguments that allow you to sort and filter your data, so you can tailor the ...

A few months back, Dave showed you how to use Excel pivot tables to better visualize your spreadsheet data. (If you missed the post, be sure to check it out -- it has video!) Of course, if you've ...

If Excel is not using threads efficiently, calculations may take a long time to complete. Learn how to speed up calculating threads in Excel.