The Magic of Spreadsheets. 100+ Tips for Speeding Up Work in Excel (and a little in Google Sheets)

— Everything needed for formatting tables and analysis: sorting and filtering, conditional formatting, custom formats

— Functions and formulas: calculations with conditions, working with dates and text, advanced filter and database functions, lookup functions (in particular, VLOOKUP)

— New functions for working with dynamic arrays and LAMBDA

— Working with pivot tables

— Power Query add-in

— Data visualization: sparklines, charts (including interactive ones), 3D maps

— Collaborative work in Excel and Google Sheets

And this is not a complete list. Examples are provided not only with screenshots from actual work practice with notes and comments. The book includes a link to example files — Excel workbooks where you can practice independently and work with formulas and tables from the book.

Features of the book:

Hundreds of functions and tools: from basics to advanced techniques Life hacks and keyboard shortcuts All explanations are accompanied by screenshots with comments from the author and example files For all tools and functions, it specifies in which versions of Excel they are available and whether they are in Google Sheets The names of all functions, commands, and tools are duplicated in Russian and English

Who the book is for:

For beginner and experienced users of Excel and Google Sheets.

For everyone who wants to understand the capabilities of Excel and Google Sheets, master unexpected ways to simplify their work, and learn a lot of new things. The book is also suitable for those who work in the English interface.