✔ Programação GLOBAL®: 2024 | 100 Melhores Livros para Excel

Em Mar|24, tive o prazer de compilar essa lista dos principais recursos de ajuda para Excel na web. Claro, comecei com uma lista de uns Top 10, mas, à medida que comecei a receber muitos comentários sobre outros sites excelentes, a lista cresceu consideravelmente. E esse é um recurso fantástico que você pode conferir aqui, comente!

Enquanto compilava a lista, não pude deixar de notar que a maioria dos sites mais destacados é propriedade dos maiores autores de Excel do planeta, como John Walkenbach, Bill Jelen (Mr. Excel), Debra Dalgleish, entre outros. Há um conteúdo incrível disponível para usuários de Excel.

Portanto, essa é apenas a minha lista inicial dos melhores livros de Excel (Uma das maiores listas que conheço na internet em português, citando livros diversos). Estou segmentando a lista para torná-la mais digerível – todos os dias.

Por fim, como um ponto de total transparência, nenhum dos títulos ou links levam à Amazon. Não são links de afiliados. Mas eventualmente podem se tornar links de afiliados que me permitem comprar uma Coca diet ou um café se você comprar um livro do meus livros. Como sou um colega usuário de Excel, queria que soubesse de antemão — porque valorizo a honestidade e a transparência. Aliás, essa lista é para usuários de Excel. Excel… Não Word, nem PowerPoint. Separados por função e versão. Então, mergulhe.

Tópicos – Recomendados por Função/Profissão

Marketing

- Excel for Marketing Managers – Ivana Taylor, Bill Jelen

- Basic Marketing Research with Excel – Alvin C. Burns, Ronald C. Bush

- Excel Secrets for Highly Effective Marketers – Jason Khoo

- Marketing Analytics: Data Driven Techniques with Excel – Wayne L. Winston

Cientistas e Engenheiros

- Excel 2007 for Scientists and Engineers – Dr. Gerard Verschuuren

- Excel 2013 for Scientists – Dr. Gerard Verschuuren

- Excel for Scientists and Engineers: Numerical Methods – E. Joseph Billo

- A Guide to Microsoft Excel 2007 for Scientists and Engineers – Bernard Liengme

- Advanced Excel for Scientific Data Analysis – Robert de Levie

- Engineering with Excel (4th Edition) – Ronald W. Larsen

Finanças e Contabilidade

- Excel University – Training for CPAs and Accounting Professionals – Volume 1 – Jeff Lenning, CPA

- Excel University – Training for CPAs and Accounting Professionals – Volume 2 – Jeff Lenning, CPA

- Excel for Accountants – Conrad Carlberg

- Next Generation Excel: Modeling in Excel for Analysts and MBAs – 2nd Edition – Isaac Gottlieb

- Financial Modeling – Simon Benninga

- Financial Modelling for Project Finance – Dr Penelope Lynch

Estatísticas e Predição

- Statistical Analysis: Microsoft Excel 2010 – Conrad Carlberg

- Statistics with Microsoft Excel (5th Edition) – Beverly Dretzke

- Predictive Analytics: Microsoft Excel – Conrad Carlberg

- Decision Analytics: Microsoft Excel – Conrad Carlberg

Consultoria

- Excel Basics to Blackbelt – 2nd Edition – Dr Elliot Bendoly

Outros Profissionais

- Excel for the CEO – P.K. Hari

- Excel for the CFO – P.K. Hari

- Excel for Auditors – (Excel 97 through 2007) – Bill Jelen, Dwayne K. Dowell

- Excel for Chemists – E. Joseph Billo

- Construction Estimating Using Excel (2nd Edition) – Steven Peterson, MBA, PE

- Excel for Teachers – Colleen Conm, Bill Hazlett, Bill Jelen, Adrienne Soucy

- Excel for the Math Classroom – Bill Hazlett, Bill Jelen

- Decision Modeling with Microsoft Excel – 6th Edition – Jeffrey H. Moore, Larry H. Weatherford

- NOTA: Para cursos de graduação/MBA em Ciência da Gestão e Modelagem de Decisões

- Excel 2010: Business Basics and Beyond – Chris “Smitty” Smith

Livros de Excel: Por Versão

Power BI / Power Pivot / Power Query

- M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query – Ken Puls & Miguel Escobar

- DAX Patterns 2015 – Alberto Ferrari & Marco Russo

- Microsoft Excel 2013 Building Data Models with PowerPivot – Alberto Ferrari & Marco Russo

- Learn to Write DAX – Matt Allington

- Power Pivot and Power BI: The Excel User’s Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016 – Rob Collie & Avi Singh

Excel 2013

- Mr Excel XL: 40 Greatest Excel Tips of All Time – Szilvia Juhasz & Bill Jelen

- Guerilla Data Analysis 2nd Edition – Oz du Soleil & Bill Jelen

- Dashboards for Excel – Jordan Goldmeier & Chandoo

- Advanced Excel Essentials – Jordan Goldmeier

- Microsoft® Excel® 2013: Data Analysis and Business Modeling – Wayne L Winston PhD.

- Excel 2013 Charts and Graphs – Bill Jelen

- 101 Excel 2013 Tips, Tricks & Timesavers – John Walkenbach

- Excel 2013 Bible – John Walkenbach

- Excel 2013 Formulas – John Walkenbach

- Excel 2013 Power Programming With VBA – John Walkenbach

- Excel VBA Programming For Dummies, 3rd Ed. – John Walkenbach

- Excel 2013 in Depth – Bill Jelen

- Excel 2013 VBA and Macros – Bill Jelen & Tracy Syrstad

- Excel 2013 for Dummies – Greg Harvey

- Excel 2013 Formulas and Functions – Paul McFedries

- Excel 2013 Dashboards and Reports – Michael Alexander, John Walkenbach

- Excel 2013 Pivot Table Data Crunching – Bill Jelen, Michael Alexander

- Excel 2013 Building Data Models with Power Pivot – Alberto Ferrari, Marco Russo

- The VLOOKUP Book – Chandoo

- Ctrl+shift+enter: Mastering Excel Array Formulas – Mike ExcelIsFun Girvin

- PDF Version from Holy Macro Books – Mike ExcelIsFunGirvin

- Get the Book from Amazon – Mike ExcelIsFun Girvin

Excel 2010

- Excel 2010 Charts and Graphs – Bill Jelen

- Excel 2010 Bible – John Walkenbach

- Excel 2010 For Dummies Quick Reference – John Walkenbach

- Excel 2010 Formulas – John Walkenbach

- Excel 2010 Power Programming With VBA – John Walkenbach

- Excel Dashboards and Reports – John Walkenbach

Excel VBA Programming For Dummies – John Walkenbach

- John Walkenbach’s Favorite Excel 2010 Tips & Tricks – John Walkenbach

- DAX Formulas for PowerPivot – Rob Collie

- Excel in Depth 2010 – Bill Jelen

- Excel 2010 VBA and Macros – Bill Jelen & Tracy Syrstad

- Don’t Fear the Spreadsheets – Tyler Nash, Bill Jelen, Kevin Jones, Tom Urtis

- Learn Excel 2010 Essential Skills with the SMART Method – Mike Smart

- Excel 2010 All-In-One for Dummies – Greg Harvey

- Excel 2010 Formulas and Functions – Paul McFedries

- Slaying Excel Dragons – Mike ExcelIsFun Girvin, Bill Jelen

- Excel Outside the Box – Bob Umlas

- Excel 2010 Dashboards and Reports – Michael Alexander, John Walkenbach

- Excel 2010 Pivot Table Data Crunching – Bill Jelen, Michael Alexander

- Power Pivot for the Data Analyst 2010 – Bill Jelen

- Predictive Analytics: Microsoft Excel – Conrad Carlberg

- Excel Pivot Tables and Pivot Charts – Paul McFedries

- Microsoft® Excel® 2010: Data Analysis and Business Modeling – Wayne L Winston PhD.

Excel 2007

- Excel 2007 Charts – Bill Jelen

- Excel 2007 Bible – John Walkenbach

- Excel 2007 Charts – John Walkenbach

- Excel 2007 For Dummies Quick Reference – John Walkenbach

- Excel 2007 Formulas – John Walkenbach

- Excel 2007 Power Programming with VBA – John Walkenbach

- Excel 2007 VBA Programming For Dummies – John Walkenbach

- John Walkenbach’s Favorite Excel 2007 Tips & Tricks – John Walkenbach

- Microsoft Office 2007 Library – John Walkenbach

- Mr. Spreadsheet’s Excel 2007 Library – John Walkenbach

- Beginning Pivot Tables in Excel 2007 – Debra Dalgleish

- Excel Pivot Tables Recipe Book 2007 – Debra Dalgleish

- Excel 2007 VBA and Macros – Bill Jelen & Tracy Syrstad

- Excel 2007 All-In-One for Dummies – Greg Harvey

- Excel Gurus Gone Wild – Bill Jelen

- Excel 2007 Miracles Made Easy – Bill Jelen

- Excel 2007 Pivot Table Data Crunching – Bill Jelen, Michael Alexander

- Excel 2007 VBA Programmer’s Reference – John Green, Stephen Bullen, Rob Bovey, Michael Alexander

- Excel 2007 Advanced Report Development – Timothy Zapawa

- RibbonX: Customizing the Office 2007 Ribbon – Robert Martin, Ken Puls, Teresa Hennig

- This Isn’t Excel: Its Magic – Bob Umlas

- Microsoft® Office Excel® 2007 Visual Basic® for Applications Step by Step – Reed Jacobson

- Excel Hacks: Tips & Tricks for Streamlining your Spreadsheets – David Hawley, Raina Hawley

- Microsoft® Excel® 2007: Data Analysis and Business Modeling – Wayne L Winston PhD.

- Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET (2nd Edition) – Rob Bovey, Dennis Wallentin, Stephen Bullen, John Green

Excel 2003

- Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA – Stephen Bullen, Rob Bovey & John Green

- A Complete Guide to Pivot Tables: A Visual Approach – Paul Cornell

- Excel 2003 Bible – John Walkenbach

- Excel 2003 Formulas – John Walkenbach

- Excel 2003 Power Programming With VBA – John Walkenbach

- Excel VBA Programming For Dummies – John Walkenbach

- John Walkenbach’s Favorite Excel Tips & Tricks – John Walkenbach

Excel (Geral – Sem Versão Específica)

- Excel Tables: A Complete Guide for Creating, Using and Automating Lists – Zack Barresse

- PDF Version from Holy Macro Books – Zack Barresse

- Get the Book from Amazon – Zack Barresse

- Excel Pivot Tables Recipe Book – Debra Dalgleish

- Head First Data Analysis: A Learner’s Guide to Big Numbers, Statistics, and Good Decisions – Michael Milton