Your Office

<div class="c-section-headers-number-list_container"> <h3>COMMON FEATURES</h3> <ol> <li>Understanding the Common Features of Microsoft Office</li> </ol> <h3>EXCEL</h3> <h3>EXCEL BUSINESS UNIT 1: UNDERSTANDING THE FUNDAMENTALS</h3> <ol> <li>Create, Navigate, Work with, and Print Worksheets</li> <li>Formats, Functions, and Formulas <ul> <li>Excel Business Unit 1 Capstone</li> </ul></li> </ol> <h3>EXCEL BUSINESS UNIT 2: CONDUCTING BUSINESS ANALYSIS</h3> <ol start="3"> <li>Cell References, Named Ranges, and Functions</li> <li>Effective Charts <ul> <li>Excel Business Unit 2 Capstone</li> </ul></li> </ol> <h3>EXCEL BUSINESS UNIT 3: INTEGRATING COMPLEX FUNCTIONS INTO BUSINESS ANALYSIS</h3> <ol start="5"> <li>Complex Logical and Retrieval Functions</li> <li>Integrating Complex Functions into Business Analysis <ul> <li>Excel Business Unit 3 Capstone</li> </ul></li> </ol> <h3>EXCEL BUSINESS UNIT 4: BUILD AN APPLICATION WITH MULTIPLE WORKSHEETS AND WORKBOOKS</h3> <ol start="7"> <li>Multiple Worksheets, Workbooks, and Templates</li> <li>Building an Application with Multiple Worksheets and Workbooks <ul> <li>Excel Business Unit 4 Capstone</li> </ul></li> </ol> <h3>EXCEL BUSINESS UNIT 5: MANIPULATING DATA SETS FOR DECISION MAKING</h3> <ol start="9"> <li>Organize, Import, Export, and Cleanse Data Sets</li> <li>Data Tables, Scenario Manager, and Solver <ul> <li>Excel Business Unit 5 Capstone</li> </ul></li> </ol> <h3>EXCEL BUSINESS UNIT 6: BUILDING FINANCIAL AND STATISTICAL MODELS</h3> <ol start="11"> <li>Loan Amortization, Investment Analysis, and Asset Depreciation</li> <li>Business Statistics and Regression Analysis <ul> <li>Excel Business Unit 6 Capstone</li> </ul></li> </ol> <h3>EXCEL BUSINESS UNIT 7</h3> <ol start="13"> <li>The Excel Data Model and Business Intelligence</li> <li>Visual Basic for Applications--VBA <ul> <li>Excel Business Unit 7 Capstone</li> </ul></li> </ol> <h3>Appendices</h3> <ol type="A"> <li>Leveraging Microsoft’s Power Business Intelligence (‘BI’) Desktop Suite</li> <li>Mac Appendix</li> <li>MOS Core</li> <li>MOS Expert</li> </ol> </div>