Looking for Excel books in PDF? We've gathered 29 free Excel books and guides in PDF, covering formulas, functions, data analysis, VBA programming, and step-by-step tutorials for every level.
These resources come from universities, training centers, and Excel experts. Whether you need a quick formulas reference or a full textbook to learn from scratch, it's all here.
Browse by topic or scroll through our picks. Every book is free to read online or download as PDF.
Excel Books
These are full-length textbooks and manuals. They cover Excel from the ground up, including navigation, formatting, formulas, charts, and pivot tables.
Start with one of these if you want a complete guide to Excel in a single PDF.
Practical manual covering cells, navigation, formatting, formulas, and chart creation in Excel. From the University of Mary Washington training department.
Covers spreadsheet basics for both Excel 2016 and Google Sheets, including functions, conditional logic, and time calculations. From the University of York IT Services.
Detailed guide to VLOOKUP, HLOOKUP, and Pivot Tables in Excel 2010 with real-world examples from Carnegie Mellon University. Covers filtering, formatting, and drilling into data.
Covers navigation, formatting, formulas, functions, charts, and printing in Excel. Includes practice exercises for each topic. Published by Watsonia Publishing.
Open-access digital literacy handbook covering advanced Excel 2010 spreadsheet concepts. Part of the ITdesk.info project with Creative Commons license.
Step-by-step guide to Excel 2016 covering the interface, document creation, formulas, sorting, conditional formatting, charts, and printing. From Montgomery County-Norristown Public Library.
Comprehensive course covering formula syntax, conditionals, statistical functions, VLOOKUP/INDEX-MATCH, text formulas, date functions, and array formulas.
Complete alphabetical reference of all Excel functions with descriptions and links to Microsoft documentation. Essential quick-reference for any Excel user.
Covers formula creation, functions, cell references, operators, and precedence rules including 3-D references across worksheets. From Syracuse University.
Collection of keyboard shortcuts, time-saving tips, must-know formulas, and power features for Excel. Freely shareable resource from My Online Training Hub.
Covers Text to Columns, Concatenate, absolute references, data validation, conditional formatting, IF functions, 3D formulas, Pivot Tables, and charts. From Towson University.
Basic workshop handout covering navigation, formatting, formulas, AutoSum, and practical exercises. From the University of Florida Health training program.
Basic introduction to Excel covering the interface, entering data, formulas, copying cells, charts, and printing. A concise starter resource for complete beginners.
Practical guide covering the VBA editor, variables, conditional logic, strings, loops, arrays, subs and functions, text files, and user forms. Corporate training material from Oceaneering.
