Brilliant Microsoft Excel 2007 Formulas & Functions - Paul McFedries

Brilliant Microsoft Excel 2007 Formulas & Functions

(Autor)

Buch | Softcover
544 Seiten
2007
Prentice-Hall (Verlag)
978-0-273-71406-4 (ISBN)
27,70 inkl. MwSt
  • Titel ist leider vergriffen;
    keine Neuauflage
  • Artikel merken
Pivot tables are the most powerful feature in Excel. A basic pivot table will allow you to summarize 500,000 rows of transactional data in 30 seconds with just a few mouse clicks. Business productivity would skyrocket if everyone knew how to use pivot tables. However, only 12% of people using Excel can create a basic pivot table. Of this group only a small percentage actually harness all the power that pivot tables afford them. By the end of the book, users will be pivot table gurus automating pivot tables using VBA, creating pivot tables with external data in OLAP cubes, and even creating dynamic reporting systems so that managers can answer their own queries with a few mouse clicks. Throughout the book there are no-nonsense, step-by-step tutorials and lots of practical examples aimed directly at business users.

Bill Jelenis Mr. Excel! He is principal behind the leading Excel website, MrExcel.com and a Microsoft MVP for Excel. He is an accomplished author of books on Excel , and as an Excel consultant, he has written Excel VBA solutions for hundreds of clients around the English-speaking world. His website hosts over 12 million page views annually and his daily video podcast is regularly in the top tech podcasts in iTunes. Michael Alexanderis a Microsoft Certified Application Developer (MCAD) with over 13 years experience developing business solutions with Microsoft Office, VBA, and .Net. H e currently heads an analytical services group for a $700-million company. In his spare time he runs a free tutorial site, www.datapigtechnologies.com, where he shares basic Access and Excel tips with intermediate users.

Introduction I Mastering Excel Ranges and Formulas 1. Getting the Most Out of Ranges 2. Using Range Names 3. Building Basic Formulas 4. Creating Advanced Formulas 5. Troubleshooting Formulas II Harnessing The Power of Functions 6. Understanding Functions 7. Working with Text Functions 8. Working with Logical and Information Functions 9. Working with Lookup Functions 10. Working with Date and Time Functions 11. Working with Math Functions 12. Working with Statistical Functions III Building Business Models 13. Analyzing Data with Tables 14. Analyzing Data with Pivot Tables 15. Using Excel's Business-Modeling Tools 16. Using Regression to Track Trends and Make Forecasts 17. Solving Complex Problems with Solver IV Building Financial Formulas 18. Building Loan Formulas 19. Building Investment Formulas 20. Building Discount Formulas Index

Erscheint lt. Verlag 14.12.2007
Verlagsort Harlow
Sprache englisch
Maße 185 x 231 mm
Gewicht 1000 g
Themenwelt Informatik Office Programme Excel
ISBN-10 0-273-71406-6 / 0273714066
ISBN-13 978-0-273-71406-4 / 9780273714064
Zustand Neuware
Haben Sie eine Frage zum Produkt?
Mehr entdecken
aus dem Bereich
raffinierte Zaubereien für Excel-Kenner

von Ignatz Schels

Buch | Softcover (2024)
Markt + Technik (Verlag)
24,95
VBA-Programmierung

von Ignatz Schels

Buch | Softcover (2023)
Markt + Technik Verlag
19,95