Only logged in customers who have purchased this product may leave a review.
Preview
Availability: Available immediately
1001 tipů a triků pro MS Excel 2007/2010
Author: Jiří Číhař
12,76 €
1001 tipů a triků pro MS Excel 2007/2010 by Jiří Číhař is an extensive practical guide built from specific solutions for everyday and more advanced Excel work. It covers worksheets, workbooks, cells, formatting, filtering and sorting data, PivotTables, formulas and functions, data consolidation, array formulas, macros, and VBA basics. The tips-based format makes it a reference for quickly finding a solution to a particular task. The book focuses on Excel 2007 and 2010, so the interface and some features may differ in newer versions.
1001 tipů a triků pro MS Excel 2007/2010 by Jiří Číhař is an extensive practical guide for users who want to work faster and more efficiently in Excel. It offers numerous specific procedures for everyday tasks and more advanced problems rather than a continuous tutorial. Topics include worksheets, workbooks, cells, formatting, filtering and sorting data, PivotTables, formulas and functions, data consolidation, array formulas, macros, and VBA basics.
Book information
- Author
- Jiří Číhař
- Publisher
- Albatros Media a.s.
- Imprint
- Computer Press
- Formát
- E-book
- Language
- Czech
- Genre
- Microsoft Excel, Kancelársky softvér, Analýza dát
- ISBN
- 978-80-251-2587-8
- Publication date
- 1. January 2013
- Pages
- 488
- E-book formats
- EPUB (ISBN 978-80-251-3935-6) · PDF (ISBN 978-80-251-3934-9) · MOBI (ISBN 978-80-251-3936-3)
What is 1001 tipů a triků pro MS Excel 2007/2010 about?
The book collects a wide range of tips and solutions for Microsoft Excel 2007 and 2010. It begins with efficient work involving worksheets, workbooks, templates, cells, and values, then moves to data formatting, including conditional formatting. It also introduces features that were new in Excel 2010, such as sparklines. Data-analysis tools, filtering and sorting lists, and more advanced PivotTable techniques form an important part of the book. The author explores formulas and functions in detail, including text, time, lookup, and database functions, summary calculations, data consolidation, and array formulas. More advanced chapters cover recording and using macros and the basics of VBA. The book was designed for beginners and experienced users who need to find a specific procedure quickly.
Themes and motifs
Efficient Excel use
Tips for faster work with worksheets, workbooks, templates, cells, and values.
Data formatting
Standard and conditional formatting and other ways to format data ranges.
Data analysis
Filtering, sorting, summaries, consolidation, and other data-processing methods.
PivotTables
More advanced approaches to working with PivotTables.
Formulas and functions
Text, time, lookup, and database functions, along with array formulas.
Macros and VBA
Recording and using macros and an introduction to automation through VBA.
Who is this book for?
For beginners, advanced users, and experienced Excel 2007 and 2010 users seeking specific solutions and ways to improve productivity.
Book context
The first print edition, ISBN 978-80-251-2587-8, was published by Computer Press in 2011. Supplier data dates the electronic product to 2013.
Otázky o knihe
What is 1001 tipů a triků pro MS Excel 2007/2010 about?
It is a practical guide to specific procedures and solutions for working more efficiently in Excel 2007 and 2010.
Who wrote the book?
The author is Jiří Číhař.
Does the book cover PivotTables?
Yes. It includes more advanced techniques for working with PivotTables.
Does it include macros and VBA?
Yes. It covers recording and using macros and the basics of VBA.
Is the book suitable for beginners?
Yes. The publisher describes it as intended for beginners as well as advanced and experienced users.
How many pages does this edition have?
Both supplier data and the print bibliographic record list 488 pages.
Which e-book formats are available?
The supplier lists EPUB, PDF, and MOBI.
Reviews
There are no reviews yet.