Brilliant Microsoft Excel

About the Author

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. http://www.dropshippers.co.za/

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. http://www.dropshippers.co.za/

Table of Contents

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
http://www.dropshippers.co.za/

II Harnessing The Power of Functions

1. Understanding Functions
2. Working with Text Functions
3. Working with Logical and Information Functions
4. Working with Lookup Functions
5. Working with Date and Time Functions
6. Working with Math Functions
7. Working with Statistical Functions
http://www.dropshippers.co.za/

III Building Business Models

1. Analyzing Data with Tables
2. Analyzing Data with Pivot Tables
3. Using Excel's Business-Modeling Tools
4. Using Regression to Track Trends and Make Forecasts
5. Solving Complex Problems with Solver
http://www.dropshippers.co.za/

IV Building Financial Formulas

1. Building Loan Formulas
2. Building Investment Formulas
3. Building Discount Formulas
http://www.dropshippers.co.za/

Index