Excel Semi-Pro
How to Use Microsoft Excel. Learn Online.
I like to use a PivotTable to figure out simple problems in Excel. So for this post I'm going to use Excel 2011 (Mac), where PivotTable controls look funky when compared to their Windows …
Continue Reading about Pay Periods and Funky PivotTable Controls →
I commented on a post that brought to light, the fact that, using the cell fill-handle to "shoot" a formula down a column doesn't always work when the adjacent column(s) have blank cells. So I decided …
The other day I was reading a post over at the Contextures blog about Dynamic Dependent Excel Drop Downs and realized that using an Excel Table would provide an alternative method that is both simple …
Continue Reading about A Dynamic Dependent Drop Down List in Excel →
Tables have structured data so you can easily use column references in formulas. But with the Table name AND column name, the reference can be rather lengthy and hard to understand at first …
Excel Tables have a Total Row that can be toggled on and off from the Ribbon. Several functions are available when the Total Row is turned on. In Excel 2010 and 2007 (Windows) select a cell inside …
I created a data table on a worksheet, then converted it to an Excel Table. Before the conversion, I had entered a formula for Gross Product in the last column. This formula looks like most formulas …
Continue Reading about Formulas and Structured Data in Excel Tables →
