Michael Alexander is a Microsoft Certified Application Developer (MCAD) with over 14 years experience developing business solutions with Microsoft Office, VBA, and .Net. He currently lives in Frisco, Texas, where he works as a senior program manager for a top technology firm.
Meer over de auteursExcel 2016 Formulas
Paperback Engels 2016 1e druk 9781119067863Samenvatting
Unleash the Power of Excel with Expert Techniques
If you're only using Excel to create simple tables and charts, it's time to dig into the software's true functionality: formulas. This book is your ideal guide, dedicated to comprehensive formula coverage that will show you just how much Excel can do for you.
You'll learn the tips and tricks that make your workflow faster, easier, and more accurate. You'll learn the expert techniques that you won't find anywhere else. Whether you're a beginner or a power-user, this essential reference will take you deep into Excel to maximize the power of the 2016 upgrade.
Let Mr. Spreadsheet show you how to:
- Leverage formulas to optimize productivity
- Perform Financial and Statistical analyses
- Work with pivot tables and conditional formatting
- Create your own custom functions using VBA
- Debug formulas and avoid common errors
Visit the website to download workbook files for all examples used in the book.
Specificaties
Lezersrecensies
Over Richard Kusleika
Inhoudsopgave
Part I: Understanding Formula Basics
1. The Excel User Interface in a Nutshell
2. Basic Facts About Formulas
3. Working with Names
Part II: Leveraging Excel Functions
4. Introducing Worksheet Functions
5. Manipulating Text
6. Working with Dates and Times
7. Counting and Summing Techniques
8. Using Lookup Functions
9. Working with Tables and Lists
10. Miscellaneous Calculations
Part III: Financial Formulas
11. Borrowing and Investing Formulas
12. Discounting and Depreciation Formulas
13. Financial Schedules
Part IV: Array Formulas
14. Introducing Arrays
15. Performing Magic with Array Formulas
Part V: Miscellaneous Formula Techniques
16. Importing and Cleaning Data
17. Charting Techniques
18. Pivot Tables
19. Conditional Formatting
20. Using Data Validation
21. Creating Megaformulas
22. Tools and Methods for Debugging Formulas
Part VI: Developing Custom Worksheet Functions
23. Introducing VBA
24. VBA Programming Concepts
25. Function Procedure Basics
26. VBA Custom Function Examples
Part VII: Appendixes
Appendix A: Excel Function Reference
Appendix B: Using Custom Number Formats
Index
Rubrieken
- advisering
- algemeen management
- coaching en trainen
- communicatie en media
- economie
- financieel management
- inkoop en logistiek
- internet en social media
- it-management / ict
- juridisch
- leiderschap
- marketing
- mens en maatschappij
- non-profit
- ondernemen
- organisatiekunde
- personal finance
- personeelsmanagement
- persoonlijke effectiviteit
- projectmanagement
- psychologie
- reclame en verkoop
- strategisch management
- verandermanagement
- werk en loopbaan