Search

Select theme:

Shopping cart

Subtotal
$97.00
View cart Checkout

Saved articles

You have not yet added any article to your bookmarks!

Browse articles
Newsletter image

Subscribe to the Newsletter

Join 10k+ people to get notified about new posts, news and tips.

Do not worry we don't spam!

GDPR Compliance

We use cookies to ensure you get the best experience on our website. By continuing to use our site, you accept our use of cookies, Privacy Policy, and Terms of Service.

  • Home
Guerrilla Data Analysis Using Microsoft Excel

Guerrilla Data Analysis Using Microsoft Excel

By Bill Jelen & Oz du Soleil Software 01/03/2022

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,” and Oz do Soleil during their careers run as a financial analyst charged with taking mainframe data and turning it into useful information quickly. Topics include data quality, validation, perfectly sorting with one click every time, matching lists of data, data consolidation, data subtotals, pivot tables, pivot charts, tables and much more.

Read More
More Books from Bill Jelen & Oz du Soleil
VLOOKUP Awesome Quick Bill Jelen
VLOOKUP Awesome Quick
Excel 2016 VBA and Macros Bill Jelen
Excel 2016 VBA and Macros
Slaying Excel Dragons Mike Girvin & Bill Jelen
Slaying Excel Dragons
Microsoft Excel 2019 VBA and Macros Bill Jelen & Tracy Syrstad
Microsoft Excel 2019 VBA and Macros
Learn Excel 2007 through Excel 2010 From MrExcel Bill Jelen
Learn Excel 2007 through Excel 2010 From MrExcel
Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365) Bill Jelen & Tracy Syrstad
Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365)
Using Microsoft Excel 2010, Enhanced Edition Tracy Syrstad & Bill Jelen
Using Microsoft Excel 2010, Enhanced Edition
Excel 2013 In Depth Bill Jelen
Excel 2013 In Depth
Don't Fear the Spreadsheet Tyler Nash, Bill Jelen & Kevin Jones
Don't Fear the Spreadsheet
Power Excel with MrExcel - 2017 Edition Bill Jelen
Power Excel with MrExcel - 2017 Edition
PowerPivot Alchemy Bill Jelen
PowerPivot Alchemy
MrExcel XL Bill Jelen & Szilvia Juhasz
MrExcel XL
Power OneNote Kathy Jacobs & Bill Jelen
Power OneNote
MrExcel LX The Holy Grail of Excel Tips Bill Jelen
MrExcel LX The Holy Grail of Excel Tips
Excel Gurus Gone Wild Bill Jelen
Excel Gurus Gone Wild
Power Excel 2019 with MrExcel Bill Jelen
Power Excel 2019 with MrExcel
Learn Excel 97 Through Excel 2007 from Mr. Excel Bill Jelen
Learn Excel 97 Through Excel 2007 from Mr. Excel
Power Excel with MrExcel Bill Jelen
Power Excel with MrExcel
Learn Excel from Mr. Excel Bill Jelen
Learn Excel from Mr. Excel
Excel for Marketing Managers Ivana Taylor & Bill Jelen
Excel for Marketing Managers
Guerilla Data Analysis Using Microsoft Excel Bill Jelen
Guerilla Data Analysis Using Microsoft Excel
Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365) Bill Jelen
Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365)
MrExcel LIVe Bill Jelen
MrExcel LIVe
Excel Dynamic Arrays Straight to the Point 2nd Edition Bill Jelen
Excel Dynamic Arrays Straight to the Point 2nd Edition
Excel for Auditors Bill Jelen & Dwayne K. Dowell
Excel for Auditors
Excel 2007 Miracles Made Easy Bill Jelen
Excel 2007 Miracles Made Easy
Using Microsoft Excel 2010 Tracy Syrstad & Bill Jelen
Using Microsoft Excel 2010
Microsoft Excel Inside Out (Office 2021 and Microsoft 365) Bill Jelen
Microsoft Excel Inside Out (Office 2021 and Microsoft 365)
MrExcel 2021 Bill Jelen
MrExcel 2021
Guerrilla Data Analysis Using Microsoft Excel Oz du Soleil & Bill Jelen
Guerrilla Data Analysis Using Microsoft Excel
Rev Up to Excel 2010 Bill Jelen
Rev Up to Excel 2010
Microsoft Excel Pivot Table Data Crunching Including Dynamic Arrays, Power Query, and Copilot Bill Jelen
Microsoft Excel Pivot Table Data Crunching Including Dynamic Arrays, Power Query, and Copilot
MrExcel 2022 Bill Jelen
MrExcel 2022
The Spreadsheet at 25 Bill Jelen
The Spreadsheet at 25
Excel for Teachers Colleen Conmy, Bill Hazlett, Bill Jelen & Adrienne Soucy
Excel for Teachers
Power Pivot dla Excela. Zaawansowane możliwości Bill Jelen & Rob Collie
Power Pivot dla Excela. Zaawansowane możliwości
Microsoft Excel VBA and Macros Tracy Syrstad & Bill Jelen
Microsoft Excel VBA and Macros
Guerrilla Data Analysis Using Microsoft Excel Bill Jelen & Oz du Soleil
Guerrilla Data Analysis Using Microsoft Excel
Excel Subtotals Straight to the Point Bill Jelen
Excel Subtotals Straight to the Point
Comments