- 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. Download the Entire Book for Free
- Full Color (5.7mb)
- Black & White (3.4mb)
- End of Chapter Files
Archives
-
Recent Posts
Meta
Category Archives: Excel PivotTables
Free Workbook to Record Actuals and Budget, and Compare Actuals vs Budget
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
Posted in Excel PivotTables
4 Comments
Packing for Vacation Using PivotTables
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
Posted in Excel PivotTables
1 Comment