- Robert F. Ryan, MBA, CPA is an independent business consultant, educator, writer and finance leader in a Fortune 50 multinational company. He has a passion for simplicity, quality, efficiency and a unique ability to explain things to people so they understand quickly and thoroughly. He's worked with spreadsheets extensively for almost thirty years including VisiCalc, Lotus 1-2-3 and Excel.
Category Archives: Excel PivotTables
In honor of Spreadsheet Day, 2011, I’ve prepared a workbook where a person with minimal knowledge of Excel can enter amounts they actually earned and spent, enter a budget for a month, and have Excel automatically show them a comparison … Continue reading
While PivotTables can certainly be used to summarize numerical information, they can also be used to organize non-numerical information. Case in point: packing for vacation. I used to have a vacation packing list in Word, but I found I needed … Continue reading