Table of Contents

1. Getting Started with Excel. 2. Formatting Workbook Text and Data. 3. Performing Calculations with Formulas and Functions. 4. Analyzing and Charting Financial Data. 5. Generating Reports from Multiple Worksheets and Workbooks. 6. Managing Data with Data Tools. 7. Summarizing Data with PivotTables. 8. Performing What-If Analyses. 9. Exploring Financial Tools and Functions. 10. Analyzing Data with Business Intelligence Tools. 11. Exploring PivotTable Design. 12. Developing an Excel Application. Excel Appendix A: Customizing Your Workspace Text and Graphics. (Digital Only). Excel Appendix B: Introducing Power BI (Digital Only). Excel Appendix C: Collaborating with Your Team. (Digital Only). Index.

About the Author

A leading textbook author, lecturer and instructor, Patrick Carey has authored or co-authored more than 40 popular academic and trade texts for the academic market. He has taught and written about a wide range of topics, including website design, JavaScript programming, Microsoft Office and Excel, statistics, data analysis and mathematics. Mr. Carey received his M.S. in biostatistics from the University of Wisconsin, where he worked as a researcher designing and analyzing clinical studies. Today, he splits his time between Wisconsin and Colorado, and when he is not writing, he can be found hiking and cycling.