Your Office Microsoft 365 Excel 2021 1st Edition Amy S. Kinser – Test Bank

COMMON FEATURES

1. Understanding File Administration and the Widespread Options of Microsoft Office

MICROSOFT TEAMS

1. Collaborating with Microsoft Groups

EXCEL BUSINESS UNIT 1: UNDERSTANDING THE FUNDAMENTALS

1. Create, Navigate, Work With, and Print Worksheets
2. Codecs, Formulation, and Features

Excel Enterprise Unit 1: Capstone

EXCEL BUSINESS UNIT 2: CONDUCTING BUSINESS ANALYSIS

3. Cell References, Named Ranges, and Features
4. Efficient Charts

Excel Enterprise Unit 2: Capstone

EXCEL BUSINESS UNIT 3: INTEGRATING COMPLEX FUNCTIONS INTO BUSINESS ANALYSIS

5. Advanced Logical and Retrieval Features
6. Integrating Advanced Features into Enterprise Evaluation

Excel Enterprise Unit 3: Capstone

EXCEL BUSINESS UNIT 4: BUILD AN APPLICATION WITH MULTIPLE WORKSHEETS AND WORKBOOKS

7. A number of Worksheets, Workbooks, and Templates
8. Constructing an Software with A number of Worksheets and Workbooks

Excel Enterprise Unit 4: Capstone

EXCEL BUSINESS UNIT 5: MANIPULATING DATA SETS FOR DECISION MAKING

9. Arrange, Import, Export, and Cleanse Knowledge Units
10. Knowledge Tables, Situation Supervisor, and Solver

Excel Enterprise Unit 5: Capstone

EXCEL BUSINESS UNIT 6: BUILDING FINANCIAL AND STATISTICAL MODELS

11. Mortgage Amortization, Funding Evaluation, and Asset Depreciation
12. Enterprise Statistics and Regression Evaluation

Excel Enterprise Unit 6: Capstone

EXCEL BUSINESS UNIT 7: ENABLING DECISIONS WITH DATA VISUALIZATION AND VBA

13. The Excel Knowledge Mannequin and Enterprise Intelligence
14. Visible Primary for Purposes, VBA

Excel Enterprise Unit 7: Capstone

APPENDICES

1. Leveraging Microsoft’s Energy Enterprise Intelligence (“BI”) Desktop Suite
2. Keyboard Shortcuts and Mac Compatibility
3. Excel Microsoft Certification Reference
4. Excel Knowledgeable Microsoft Certification Reference