Effective work in Microsoft Excel
Please sign in so that we can notify you about a reply
The book discusses advanced work techniques in the Microsoft Excel tab, which not all users know about and which significantly accelerate the performance of standard operations.
Chapter 1 discusses the tools with data. It is shown how to quickly convert the date and numbers formats, remove the lines and fill them with the right values, edit the formulas and use a special insert.
Chapter 2 is devoted to the functions that turn the Excel document into "smart" table: its values are updated automatically when substituting new data.
From chapters 3 and 4, the reader learns about formatting techniques that improve the perception of tabular information, and about the features of working with diagrams.
In chapter 5, Power Query is considered - a tool for importing, cleaning and transforming data for further analysis and Power Pivot - a superstructure that allows you to store large volumes of information, create data models and produce powerful calculations.
The publication will be useful to specialists who often use Excel in their work and want to automate routine data processing processes
Chapter 1 discusses the tools with data. It is shown how to quickly convert the date and numbers formats, remove the lines and fill them with the right values, edit the formulas and use a special insert.
Chapter 2 is devoted to the functions that turn the Excel document into "smart" table: its values are updated automatically when substituting new data.
From chapters 3 and 4, the reader learns about formatting techniques that improve the perception of tabular information, and about the features of working with diagrams.
In chapter 5, Power Query is considered - a tool for importing, cleaning and transforming data for further analysis and Power Pivot - a superstructure that allows you to store large volumes of information, create data models and produce powerful calculations.
The publication will be useful to specialists who often use Excel in their work and want to automate routine data processing processes
Author:
Author:Murray Alan
Cover:
Cover:Hard
Category:
- Category:Computer & Technology
ISBN:
ISBN:978-5-97060-922-4
No reviews found