| |
| |
Common Features | |
| |
| |
| |
The Common Features of Microsoft Office | |
| |
| |
Prepare Case: Painted Paradise Resort and Spa Employee Training Preparation | |
| |
| |
Working with the Office Interface | |
| |
| |
Understand Office Applications and Accounts | |
| |
| |
Start Office Programs and Manipulate Windows | |
| |
| |
Use the Office Ribbon, Contextual Tools, and Other Menus | |
| |
| |
Manipulating Files and Finding Help in Office | |
| |
| |
Manage Files in Office | |
| |
| |
Get Help | |
| |
| |
Understanding the Cloud and Touch Integration | |
| |
| |
Use Windows SkyDrive | |
| |
| |
Use Touch Mode, Gestures, and Reading Mode | |
| |
| |
Concept Check | |
| |
| |
Key Terms | |
| |
| |
Visual Summary | |
| |
| |
Practice | |
| |
| |
Practice Case 1 | |
| |
| |
Problem Solve | |
| |
| |
Problem Solve Case 1 | |
| |
| |
Perform | |
| |
| |
Perform in Your Career | |
| |
| |
Perform in Your Life | |
| |
| |
Excel Module 1-Understanding the Fundamentals | |
| |
| |
| |
Navigate, Manipulate, and Print Worksheets | |
| |
| |
Prepare Case: Red Bluff Golf Course and Pro Shop Golf Cart Purchase Analysis | |
| |
| |
Excel Worksheets-What If Data and Information Could Speak? | |
| |
| |
Understand Spreadsheet Terminology and Components | |
| |
| |
Navigate Worksheets and Workbooks | |
| |
| |
Document Your Work! | |
| |
| |
Enter and Edit Data | |
| |
| |
Manipulate Cells and Cell Ranges | |
| |
| |
Manipulate Columns and Rows | |
| |
| |
Printing Worksheets and Manipulating Workbooks | |
| |
| |
Preview and Print Worksheets | |
| |
| |
Manipulate Worksheets and Workbooks | |
| |
| |
Concept Check | |
| |
| |
Key Terms | |
| |
| |
Visual Summary | |
| |
| |
Practice | |
| |
| |
Practice Case 1 | |
| |
| |
Problem Solve | |
| |
| |
Problem Solve Case 1 | |
| |
| |
Perform | |
| |
| |
Perform in Your Career | |
| |
| |
| |
Formatting, Functions, and Formulas | |
| |
| |
Prepare Case: Red Bluff Golf Course & Pro Shop Sales Analysis | |
| |
| |
Worksheet Formatting | |
| |
| |
Format Cells, Cell Ranges, and Worksheets | |
| |
| |
Creating Information for Decision Making | |
| |
| |
What Is a Function? | |
| |
| |
What Is a Formula? | |
| |
| |
Decision Making | |
| |
| |
Documenting Your Work | |
| |
| |
Concept Check | |
| |
| |
Key Terms | |
| |
| |
Visual Summary | |
| |
| |
Practice | |
| |
| |
Practice Case 1 | |
| |
| |
Problem Solve | |
| |
| |
Problem Solve Case 1 | |
| |
| |
Perform | |
| |
| |
Perform in Your Life | |
| |
| |
EXCEL Module 1 Capstone | |
| |
| |
More Practice | |
| |
| |
More Practice Case 1 | |
| |
| |
Problem Solve | |
| |
| |
Problem Solve Case 1 | |
| |
| |
Problem Solve Case 2 | |
| |
| |
Perform | |
| |
| |
Perform in Your Life | |
| |
| |
Perform in Your Career | |
| |
| |
Perform in Your Team | |
| |
| |
How Others Perform | |
| |
| |
Excel Module 2-Conducting Business Analysis | |
| |
| |
| |
Cell References, Named Ranges, and Functions | |
| |
| |
Prepare Case: Painted Paradise Resort and Spa Wedding Planning | |
| |
| |
Cell References and Named Ranges | |
| |
| |
Types of Cell References | |
| |
| |
Naming a Cell Range | |
| |
| |
Functions | |
| |
| |
Function Structure and Construction | |
| |
| |
Common Math and Statistical Functions | |
| |
| |
Common Date and Time Functions | |
| |
| |
Text Functions and Flash Fill | |
| |
| |
Financial and Lookup & Reference Functions | |
| |
| |
Concept Check | |
| |
| |
Key Terms | |
| |
| |
Visual Summary | |
| |
| |
Practice | |
| |
| |
Practice Case 1 | |
| |
| |
Problem Solve | |
| |
| |
Problem Solve Case 1 | |
| |
| |
Perform | |
| |
| |
Perform in Your Life | |
| |
| |
| |
Effective Charts | |
| |
| |
Prepare Case: Turquoise Oasis Spa Sales Reports | |
| |
| |
Designing a Chart | |
| |
| |
Exploring Chart Characteristics: Types, Layouts, and Styles | |
| |
| |
Chart Locations | |
| |
| |
Chart Types | |
| |
| |
Laying out a Chart | |
| |
| |
Chart Layouts, Styles, and Data | |
| |
| |
Editing and Formatting Charts | |
| |
| |
Strategic Statements with Charts | |
| |
| |
Recognizing and Correcting Confusing Charts | |
| |
| |
Concept Check | |
| |
| |
Key Terms | |
| |
| |
Visual Summary | |
| |
| |
Practice | |
| |
| |
Practice Case 1 | |
| |
| |
Problem Solve | |
| |
| |
Problem Solve Case 1 | |
| |
| |
Perform | |
| |
| |
Perform in Your Career | |
| |
| |
EXCEL Module 2 Capstone | |
| |
| |
More Practice | |
| |
| |
More Practice Case 1 | |
| |
| |
Problem Solve | |
| |
| |
Problem Solve Case 1 | |
| |
| |
Problem Solve Case 2 | |
| |
| |
Perform | |
| |
| |
Perform in Your Life | |
| |
| |
Perform in Your Career | |
| |
| |
Perform in Your Team | |
| |
| |
How Others Perform | |
| |
| |
Excel Module 3- Integrating Complex Functions into Business Analysis | |
| |
| |
| |
Complex Conditional and Retrieval Functions | |
| |
| |
Prepare Case: Red Bluff Golf Course & Pro Shop Sales Analysis | |
| |
| |
Integrating Logical Functions | |
| |
| |
Preview the Data | |
| |
| |
Use IF Functions | |
| |
| |
Build Nested IF Functions | |
| |
| |
Integrate Conjunction Functions into IF Functions | |
| |
| |
Using Conditional Aggregate Functions | |
| |
| |
Use Conditional Statistical Functions | |
| |
| |
Use Conditional Math Functions | |
| |
| |
Construct Database Functions | |
| |
| |
Retrieving Data Using LOOKUP and Reference Functions | |
| |
| |
Explore LOOKUP Functions | |
| |
| |
Retrieve Data Using MATCH, INDEX, and INDIRECT | |
| |
| |
Handle Errors with the IFERROR Function | |
| |
| |
Concept Check | |
| |
| |
Key Terms | |
| |
| |
Visual Summary | |
| |
| |
Practice | |
| |
| |
Practice Case 1 | |
| |
| |
Problem Solve | |
| |
| |
Problem Solve Case 1 | |
| |
| |
Perform | |
| |
| |
Perform in Your Life | |
| |
| |
| |
Analyze Data using Tables | |
| |
| |
Prepare Case: Golf Course Marketing Strategies | |
| |
| |
Organizing Data with Tables | |
| |
| |
Work with Data and Information | |
| |
| |
Work with Data and Information in Data Tables | |
| |
| |
Use the SUBTOTAL Function and Filters in Data Tables | |
| |
| |
Organizing and Analyzing with PivotTables and PivotCharts | |
| |
| |
Develop and Customize PivotTables | |
| |
| |
Develop and Customize PivotCharts | |
| |
| |
Concept Check | |
| |
| |
Key Terms | |
| |
| |
Visual Summary | |
| |
| |
Practice | |
| |
| |
Practice Case 1 | |
| |
| |
Problem Solve | |
| |
| |
Problem Solve Case 1 | |
| |
| |
Perform | |
| |
| |
Perform in Your Career | |
| |
| |
EXCEL Module 3 Capstone | |
| |
| |
More Practice | |
| |
| |
More Practice Case 1 | |
| |
| |
Problem Solve | |
| |
| |
Problem Solve Case 1 | |
| |
| |
Problem Solve Case 2 | |
| |
| |
Perform | |
| |
| |
Perform in Your Life | |
| |
| |
Perform in Your Career | |
| |
| |
Perform in Your Team | |
| |
| |
How Others Perform | |
| |
| |
Excel Module 4-Building an Application with Multiple Worksheets and Workbooks | |
| |
| |
| |
Multiple Worksheets, Workbooks, and Templates | |
| |
| |
Prepare Case: Turquoise Oasis Spa Therapist Sales and Service Analysis | |
| |
| |
Working with Multiple Worksheets | |
| |
| |
Group Worksheets | |
| |
| |
Create Summary Worksheets | |
| |
| |
Using Multiple Workbooks | |
| |
| |
Work with Multiple Workbooks | |
| |
| |
Collaborate Using Multiple Workbooks | |
| |
| |
Using and Creating Templates | |
| |
| |
Use Existing Templates | |
| |
| |
Create Templates from an Existing Workbook | |
| |
| |
Concept Check | |
| |
| |
Key Terms | |
| |
| |
Visual Summary | |
| |
| |
Practice | |
| |
| |
Practice Case 1 | |
| |
| |
Problem Solve | |
| |
| |
Problem Solve Case 1 | |
| |
| |
Perform | |
| |
| |
Perform in Your Life | |
| |
| |
| |
Refine an Excel Application | |
| |
| |
Prepare Case: Turquoise Oasis Spa Application | |
| |
| |
Auditing Formulas | |
| |
| |
View Formula Precedents and Dependents | |
| |
| |
Evaluate Formulas | |
| |
| |
Correct Circular References | |
| |
| |
Use the Watch Window | |
| |
| |
Creating Data Validation Rules | |
| |
| |
Control Data Entry with Data Validation | |
| |
| |
Developing User-Friendly Excel Applications | |
| |
| |
Create and Use Macros | |
| |
| |
Change How to Navigate a Workbook | |
| |
| |
Protect Workbooks and Worksheets | |
| |
| |
Concept Check | |
| |
| |
Key Terms | |
| |
| |
Visual Summary | |
| |
| |
Practice | |
| |
| |
Practice Case 1 | |
| |
| |
Problem Solve | |
| |
| |
Problem Solve Case 1 | |
| |
| |
Perform | |
| |
| |
Perform in Your Career | |
| |
| |
EXCEL Module 4 Capstone | |
| |
| |
More Practice | |
| |
| |
More Practice Case 1 | |
| |
| |
Problem Solve | |
| |
| |
Problem Solve Case 1 | |
| |
| |
Problem Solve Case 2 | |
| |
| |
Perform | |
| |
| |
Perform in Your Life | |
| |
| |
Perform in Your Career | |
| |
| |
Perform in Your Team | |
| |
| |
How Others Perform | |
| |
| |
| |
Manipulating Data Sets for Decision Making | |
| |
| |
| |
Organize, Import, Export, and Cleanse Data Sets | |
| |
| |
Prepare Case: Red Bluff Golf Course & Pro Shop Data Integration | |
| |
| |
Working with Data Sets | |
| |
| |
Understand the Importance of External Data Sets | |
| |
| |
Working with XML Data and Text Files | |
| |
| |
Connect to an Access Database | |
| |
| |
Making Data Useful | |
| |
| |
Clean Imported Data | |
| |
| |
Use Flash Fill to Cleanse Data | |
| |
| |
Separate Data Using Text Functions and Wizards | |
| |
| |
Clean Date-Related Data | |
| |
| |
Concept Check | |
| |
| |
Key Terms | |
| |
| |
Visual Summary | |
| |
| |
Practice | |
| |
| |
Practice Case 1 | |
| |
| |
Problem Solve | |
| |
| |
Problem Solve Case 1 | |
| |
| |
Perform | |
| |
| |
Perform in Your Life | |
| |
| |
| |
Data Tables, Scenario Manager, and Solver | |
| |
| |
Prepare Case: The Red Bluff Golf Course & Pro Shop Business Planning Analysis | |
| |
| |
Examining Cost-Volume-Profit Relationships | |
| |
| |
Perform Break-Even Analysis | |
| |
| |
Analyze Variables in Formulas Through the Use of Data Tables | |
| |
| |
Use Goal Seek | |
| |
| |
Using the Scenario Manager | |
| |
| |
Use the Scenario Manager to Create Scenarios | |
| |
| |
Create Scenario Reports | |
| |
| |
Using Solver | |
| |
| |
Understand the Use of the Solver Add-In | |
| |
| |
Solve Complex Problems Using Solver | |
| |
| |
Generate and Interpret Solver Answer Reports | |
| |
| |
Concept Check | |
| |
| |
Key Terms | |
| |
| |
Visual Summary | |
| |
| |
Practice | |
| |
| |
Practice Case 1 | |
| |
| |
Problem Solve | |
| |
| |
Problem Solve Case 1 | |
| |
| |
Perform | |
| |
| |
Perform in Your Career | |
| |
| |
EXCEL Module 5 Capstone | |
| |
| |
More Practice | |
| |
| |
More Practice Case 1 | |
| |
| |
Problem Solve | |
| |
| |
Problem Solve Case 1 | |
| |
| |
Problem Solve Case 2 | |
| |
| |
Perform | |
| |
| |
Perform in Your Life | |
| |
| |
Perform in Your Career | |
| |
| |
Perform in Your Team | |
| |
| |
How Others Perform | |
| |
| |
| |
Building Financial and Statistical Models | |
| |
| |
| |
Loan Amortization, Investment Analysis, and Asset Depreciation | |
| |
| |
Prepare Case: The Turquoise Oasis Spa Financial Analysis | |
| |
| |
Constructing a Financial Analysis on Loans | |
| |
| |
Construct a Loan Analysis with PMT, RATE, and NPER | |
| |
| |
Calculate Cumulative Interest and Principal Using CUMIPMT and CUMPRINC | |
| |
| |
Create an Amortization Schedule Using PPMT and IPMT | |
| |
| |
Constructing a Financial Analysis of Investments | |
| |
| |
Analyze Bonds Using PV and FV | |
| |
| |
Analyze Investments Using NPV, XNPV, IRR, and XIRR | |
| |
| |
Calculating the Depreciating Value of Business Assets | |
| |
| |
Calculate the Depreciation of Assets Using the SLN, DB, and DDB Functions | |
| |
| |
Concept Check | |
| |
| |
Key Terms | |
| |
| |
Visual Summary | |
| |
| |
Practice | |
| |
| |
Practice Case 1 | |
| |
| |
Problem Solve | |
| |
| |
Problem Solve Case 1 | |
| |
| |
Perform | |
| |
| |
Perform in Your Life | |
| |
| |
| |
Business Statistics and Regression Analysis | |
| |
| |
Prepare Case: The Turquoise Oasis Spa: Using Statistics in Decision Making | |
| |
| |
Applying Basic Statistical Methods to Business | |
| |
| |
Understand the Language of Statistics | |
| |
| |
Understand the Basic Types of Data | |
| |
| |
Conduct Basic Statistical Analyses in Excel | |
| |
| |
Generate Descriptive Statistics and Other Analyses Using the Analysis ToolPak | |
| |
| |
Applying Probability Distributions to Business | |
| |
| |
Predict Business Outcomes Using Probability Distribution Functions | |
| |
| |
Finding Relationships in Data | |
| |
| |
Find Relationships in Data Using COVARIANCE.S and CORREL | |
| |
| |
Determine Relationships Between Multiple Variables Using a Correlation Matrix | |
| |
| |
Use Regression Analysis to Predict Future Values | |
| |
| |
Concept Check | |
| |
| |
Key Terms | |
| |
| |
Visual Summary | |
| |
| |
Practice | |
| |
| |
Practice Case 1 | |
| |
| |
Problem Solve | |
| |
| |
Problem Solve Case 1 | |
| |
| |
Perform | |
| |
| |
Perform in Your Career | |
| |
| |
EXCEL Module 6 Capstone | |
| |
| |
More Practice | |
| |
| |
More Practice Case 1 | |
| |
| |
Problem Solve | |
| |
| |
Problem Solve Case 1 | |
| |
| |
Problem Solve Case 2 | |
| |
| |
Perform | |
| |
| |
Perform in Your Life | |
| |
| |
Perform in Your Career | |
| |
| |
Perform in Your Team | |
| |
| |
How Others Perform | |
| |
| |
| |
Enabling Decisions with Data Visualization and VBA | |
| |
| |
| |
Excel's Data Model, PowerPivot, and Power View | |
| |
| |
Prepare Case: The Red Bluff Golf Course & Pro Shop Dashboards, KPIs, and Data Visualizations | |
| |
| |
Exploring the Importance of Business Intelligence | |
| |
| |
Understand the Basics of Dashboard Design | |
| |
| |
Explore the New Data Model | |
| |
| |
Create Advanced Data Models Using PowerPivot | |
| |
| |
Create PivotTables and PivotCharts with PowerPivot | |
| |
| |
Use Apps for Office for Data Visualizations | |
| |
| |
Prepare a Dashboard for Production | |
| |
| |
Exploring the Benefits of Personalized Business Intelligence | |
| |
| |
Generate Visual Reports with Power View | |
| |
| |
Concept Check | |
| |
| |
Key Terms | |
| |
| |
Visual Summary | |
| |
| |
Practice | |
| |
| |
Practice Case 1 | |
| |
| |
Problem Solve | |
| |
| |
Problem Solve Case 1 | |
| |
| |
Perform | |
| |
| |
Perform in Your Life | |
| |
| |
| |
Visual Basic for Applications | |
| |
| |
Prepare Case: The Red Bluff Golf Course & Pro Shop Spreadsheet Enhancement with Form Controls and VBA | |
| |
| |
Enhancing the Readability and Interactivity of Dashboards | |
| |
| |
Enhance Spreadsheets with Form Controls | |
| |
| |
Leveraging the Power of Visual Basic for Applications (VBA) | |
| |
| |
Understand the Components of VBA | |
| |
| |
Create Custom Functions with VBA | |
| |
| |
Improve Readability of VBA with Formatting and Structure | |
| |
| |
Troubleshoot VBA | |
| |
| |
Create and Use Loops in VBA | |
| |
| |
Assign VBA Procedures to Events | |
| |
| |
Protect and Secure a Workbook | |
| |
| |
Concept Check | |
| |
| |
Key Terms | |
| |
| |
Visual Summary | |
| |
| |
Practice | |
| |
| |
Practice Case 1 | |
| |
| |
Problem Solve | |
| |
| |
Problem Solve Case 1 | |
| |
| |
Perform | |
| |
| |
Perform in Your Career | |
| |
| |
EXCEL Module 7 Capstone | |
| |
| |
More Practice | |
| |
| |
More Practice Case 1 | |
| |
| |
Problem Solve | |
| |
| |
Problem Solve Case 1 | |
| |
| |
Problem Solve Case 2 | |
| |
| |
Perform | |
| |
| |
Perform in Your Life | |
| |
| |
Perform in Your Career | |
| |
| |
Perform in Your Team | |
| |
| |
How Others Perform | |
| |
| |
Appendix: Efficient Interaction with a Touchscreen | |
| |
| |
Prepare Case: Painted Paradise Resort and Spa Works with Touch Features | |
| |
| |
Interacting with a Windows 8 Tablet PC | |
| |
| |
Understand Variations in Tablets | |
| |
| |
Understand Methods for Interacting with a Tablet PC | |
| |
| |
Using the Touch-Screen Interface | |
| |
| |
Use Flick, Touch, and Bezel Gestures | |
| |
| |
Use Office 2013 Touch Gestures | |
| |
| |
Use Other Touch Features | |
| |
| |
Concept Check | |
| |
| |
Key Terms | |