Free Office Application Guides: From Basics to Advanced

Free PDFs for everyday productivity: Excel formulas, pivot tables and macros, Word and PowerPoint skills, and LibreOffice equivalents — printed references for real office work.

This shelf holds free office application PDFs, mostly about spreadsheets: Excel from the first formula to pivot tables, macros and data analysis, plus the Word, PowerPoint and LibreOffice material that goes with everyday office work. It is written for students, assistants, accountants and anyone who has to turn a raw list into a report by the end of the day.

What these office PDFs cover

• Spreadsheets: formulas, functions, references, charts and conditional formatting
• Data work: sorting, filtering, pivot tables, what-if analysis and dashboards
• Automation: recorded macros, VBA basics and simple analysis scripts
• Documents and slides: Word formatting, styles, PowerPoint design and LibreOffice
• Workflow: shortcuts, templates, printing and collaboration habits

Where to start

Absolute beginners get moving fastest with Excel Fundamentals or the short Microsoft Excel tutorial, which cover cells, formulas and charts in a few dozen pages. Once the basics feel natural, Advanced Microsoft Excel and Excel for advanced users introduce pivot tables, lookups and reporting techniques; Excel Analytics and Programming then moves into automation and analysis for readers who process data regularly.

Languages, formats and prerequisites

All files are free downloads: standard PDFs that open in any browser or reader, with no registration and no waiting timer. The exercises refer to Microsoft Office versions, but the concepts transfer directly to LibreOffice Calc and to Google Sheets; where a menu path differs, the books usually say so. No previous spreadsheet knowledge is needed for the introductory titles, and sample files are described step by step so you can rebuild them yourself.

How to get the most out of this shelf

• Rebuild each example in your own workbook instead of reading the screenshots.
• Learn the keyboard shortcuts in the first chapters — they save more time than any advanced function.
• When a report is due, filter by "Under 100 pages" and use a compact guide rather than a 300-page book.
• Download the sample exercises and redo them with your own data; familiar numbers make the techniques easier to remember.
• Keep a personal list of the formulas and shortcuts you actually use at work — that list becomes your real reference.

Related shelves

Once the data outgrows the spreadsheet, the query language is explained in computer database, and the general computer skills are covered in other IT topics.