Table magic. 100+ techniques for accelerating work in Excel (and slightly in Google tables). Shagabutdinov R.

A detailed and interesting guide with the latest tools that will help you understand all the possibilities of Excel and Google tables.

You will find more than 100 functions, tools, nuances and hot keys, examples from real work practice with a non -casual plot. As well as a bonus: links to EXCEL books for independent practice.

What is in the book

• Interface setting up and hot keys
• Tools for quick data entry
• All that is needed for the design of tables and analysis: sorting and filtering, conditional formatting, user formats
• Functions and formulas: calculations with conditions, work with dates and texts, an extended filter and Database functions, search functions (in particular, VPR)
• new functions for working with dynamic arrays and lambda
• Work with consolidated tables
• Power Query Supporting
• /li>
• Data visualization: sparclayes, diagrams (including interactive), 3D cards
• joint work in Excel and Google tables

and this is not A complete list.

as examples are given not only screenshots from real work practice with notes and comments. The book has a link to examples - work books Excel, where you can practice yourself and work with formulas and tables from the book.

for beginners and experienced users Excel and Google tables.