The Magic of Tables. 100+ Tricks to Speed Up Work in Excel and a Little in Google Sheets

With this engaging guide, you will master all the tools and functions of Excel and Google Sheets. It doesn't matter if you are a beginner or an experienced user, whether you have an old version of the program or a... new one. Everyone will find what they are looking for here, whether it be:
● Interface customization and keyboard shortcuts
● Tools for quick data entry. Data validation to protect against errors
● Everything needed for formatting tables and analysis: sorting and filtering, conditional formatting, custom number formats, and much more
● Functions and formulas: basic calculations, calculations with conditions, working with dates and text, advanced filtering and database functions, lookup functions (VLOOKUP and others)
● 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
● Online collaboration in Excel and Google Sheets
● And much more.
Examples include not only screenshots with notes and comments. The book contains a link to example files — Excel workbooks where you can practice independently and work with the formulas and tables from the book. For all tools and functions in the book, there is clarification on which versions of Excel they are available in — and whether they are in Google Sheets. For all functions, commands, and tools, the names are duplicated in Russian and English. Apply!