The Magic of Tables. 100+ Tips to Speed Up Work in Excel (and a bit in Google Sheets)

A detailed and engaging guide with the latest tools that will help you understand all the possibilities of Excel and Google Sheets. You can expect over 100 functions, tools, nuances, and keyboard shortcuts, examples from real work practice with an... interesting storyline. Also, a bonus: links to Excel books for self-study. What’s in the book: — Interface customization and keyboard shortcuts — Tools for quick data entry — Everything you need 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 the complete list. Examples are provided not only as screenshots from real work practice with annotations and comments. The book contains links to example files — Excel workbooks where you can practice independently and work with the formulas and tables from the book. Book features: Hundreds of functions and tools: from basics to advanced techniques Life hacks and keyboard shortcuts All explanations are accompanied by screenshots with author comments and files with examples For all tools and functions, there is clarification on which versions of Excel they are available in and whether they are in Google Sheets The names of all functions, commands, and tools are duplicated in Russian and English For whom the book is intended: For beginners and experienced users of Excel and Google Sheets. For anyone 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 working in an English-language interface.