Table of Contents
Student Success Guide.
Managing Your Files.
Tutorial 1: Getting Started with Excel.
Tutorial 2: Formatting Workbook Text and Data.
Tutorial 3: Calculating Data with Formulas and Functions.
Tutorial 4: Analyzing and Charting Financial Data.
Tutorial 5: Working with Excel Tables, PivotTables, and PivotCharts.
Tutorial 6: Managing Multiple Worksheets and Workbooks.
Tutorial 7: Developing an Excel Application.
Tutorial 8: Working with Advanced Functions.
Tutorial 9: Exploring Financial Tools and Functions.
Tutorial 10: Performing What-If Analyses.
Tutorial 11: Connecting to External Data.
Tutorial 12: Collaborating on a Shared Workbook.
Appendix A: Working with Text Functions and Creating Custom Formats.
Appendix B: Advanced Filters, Database Functions, and Summary IFS Functions.
Appendix C: Enhancing Excel with Visual Basic for Applications.
Appendix D: Working with Enhanced Formatting Tools.
Appendix E: SAM Projects.
Appendix F: Capstone Projects.
Appendix G: Microsoft Office Specialist Certification.