Russell's ebook Library

Excel Formulas Tip Card
Bill Jelen
Excel formulas

Guerilla Data Analysis Using Excel
Bill Jelen
This book includes step-by-step examples and case studies that teach users the many power tricks for analyzing data in Excel. These are tips honed by Bill Jelen, “MrExcel,” during his 10-year run as a financial analyst charged with taking mainframe d...

Pivot Table Data Crunching: Microsoft Excel 2010
Bill Jelen and Michael Alexander
PivotTables may be Excel's most powerful feature, but Microsoft has estimated that only 15% of Excel users take advantage of them. That's because PivotTables (and their companion feature, PivotCharts) have a reputation for being difficult to learn. N...

VBA and Macros: Microsoft Excel 2010
Bill Jelen and Tracy Syrstad
Using Microsoft Excel 2010 VBA scripting features, Excel users can save dozens - or even hundreds - of hours per year. But most Excel users have never written a VBA script: many haven't even used Excel's built-in Macro Recorder. VBA and Macros is the...