| |
| |
| |
| Workshop 1: Understanding and Manipulating Microsoft Excel | |
| |
| |
| Prepare Case: Red Bluff Golf Club Golf Cart Purchase Analysis | |
| |
| |
| Excel Worksheets-What if Data and Information could speak? | |
| |
| |
| Understanding Spreadsheet terminology and components | |
| |
| |
| Starting Excel | |
| |
| |
| What is a Workbook? | |
| |
| |
| Opening a Workbook | |
| |
| |
| Saving and renaming a Workbook | |
| |
| |
| Cells, Rows, and Columns | |
| |
| |
| Worksheet Navigation | |
| |
| |
| Scrolling | |
| |
| |
| Keyboard Navigation | |
| |
| |
| Go To | |
| |
| |
| Navigating among Worksheets | |
| |
| |
| Documentation | |
| |
| |
| Failing to plan is planning to fail | |
| |
| |
| Enter and Edit Data | |
| |
| |
| Text, Numbers, Dates, and Times | |
| |
| |
| How Excel really stores Date and Time Data | |
| |
| |
| Text Wrapping and Hard Returns | |
| |
| |
| Manipulate Cells and Ranges | |
| |
| |
| Selecting Cells and Cell Ranges | |
| |
| |
| Drag and Drop | |
| |
| |
| Cut/Copy and Paste | |
| |
| |
| Series (AutoFill) | |
| |
| |
| Modifying Cell Information | |
| |
| |
| Inserting Cells | |
| |
| |
| Deleting Cells | |
| |
| |
| Merge & Center vs. Center Across | |
| |
| |
| Manipulate Columns and Rows | |
| |
| |
| Select Contiguous and Noncontiguous Columns and Rows | |
| |
| |
| Rows | |
| |
| |
| Inserting Columns and Rows | |
| |
| |
| Column Width and Row Height | |
| |
| |
| Changing Column Widths using AutoFit | |
| |
| |
| Delete vs. Clear | |
| |
| |
| Inserting Columns that contain Data | |
| |
| |
| Printing Worksheets and Manipulating Workbooks | |
| |
| |
| Preview and Print Worksheets | |
| |
| |
| Worksheet Views | |
| |
| |
| Print Preview, Printer Selection, and Print | |
| |
| |
| Print Titles | |
| |
| |
| Print Headers/Footers | |
| |
| |
| Page Margins | |
| |
| |
| Page Orientation | |
| |
| |
| Scaling | |
| |
| |
| Manipulate Worksheets and Workbooks | |
| |
| |
| Name a Worksheet | |
| |
| |
| Insert or Delete a Worksheet | |
| |
| |
| Move a Worksheet | |
| |
| |
| Deleting a Worksheet | |
| |
| |
| Concept Check | |
| |
| |
| Key Terms | |
| |
| |
| Visual Summary | |
| |
| |
| Practice | |
| |
| |
| Practice Case 1 | |
| |
| |
| Practice Case 2 | |
| |
| |
| |
| Workshop 2: Formatting, Formulas, and Functions | |
| |
| |
| Prepare Case: Red Bluff Golf Club Golf Pro Shop Sales Analysis | |
| |
| |
| Worksheet Formatting | |
| |
| |
| Format Cells, Cell Ranges, and Worksheets | |
| |
| |
| Copying a document from one Workbook to another | |
| |
| |
| Numbers | |
| |
| |
| Formats | |
| |
| |
| Negative Values and Color | |
| |
| |
| Dates and Times | |
| |
| |
| Cell Alignment | |
| |
| |
| Content Orientation | |
| |
| |
| Fill Color | |
| |
| |
| Cell Borders | |
| |
| |
| Copying Formats | |
| |
| |
| Paste Options/ Paste Special | |
| |
| |
| Built-in Cell Styles | |
| |
| |
| Table Styles | |
| |
| |
| Workbook themes | |
| |
| |
| Creating Information for Decision Making | |
| |
| |
| What is a Function? | |
| |
| |
| AutoSum Functions | |
| |
| |
| SUM() | |
| |
| |
| COUNT() | |
| |
| |
| AVERAGE() | |
| |
| |
| Min() and Max() | |
| |
| |
| What is a Formula? | |
| |
| |
| Operators | |
| |
| |
| Order of Operations | |
| |
| |
| Hiding Information in a Worksheet | |
| |
| |
| Show Functions and Formulas | |
| |
| |
| Decision Making | |
| |
| |
| Conditional Formatting | |
| |
| |
| Removing Conditional Formatting | |
| |
| |
| Concept Check | |
| |
| |
| Key Terms | |
| |
| |
| Visual Summary | |
| |
| |
| Practice | |
| |
| |
| Practice Case 1 | |
| |
| |
| Practice Case 2 | |
| |
| |
| |
| Capstone | |
| |
| |
| More Practice | |
| |
| |
| Problem Solve | |
| |
| |
| Problem Solve Case 1 | |
| |
| |
| Problem Solve Case 2 | |
| |
| |
| Problem Solve Case 3 | |
| |
| |
| Perform | |
| |
| |
| Perform in Your Life | |
| |
| |
| Perform in Your Career | |
| |
| |
| Perform in Your Career | |
| |
| |
| How Others Perform | |
| |
| |
| |
| Workshop 3: Conducting Excel Analysis through Functions and Charts | |
| |
| |
| Prepare Case: Massage Table Analysis | |
| |
| |
| Cell References and Formula Basics | |
| |
| |
| Reference Cells within Formulas or Functions | |
| |
| |
| Absolute Cell Reference | |
| |
| |
| Mixed Cell Reference | |
| |
| |
| Working with Named Ranges | |
| |
| |
| Creating Named Ranges in the Name Box | |
| |
| |
| Creating Named Ranges from Selections | |
| |
| |
| Modifying Named Ranges | |
| |
| |
| Using Named Ranges | |
| |
| |
| Creating Formulas Using Named Ranges | |
| |
| |
| Functions | |
| |
| |
| Understanding the Syntax of a Function | |
| |
| |
| Function Structure | |
| |
| |
| Function Construction with Function Arguments Dialog Box | |
| |
| |
| Function Construction with the Formula Bar | |
| |
| |
| Common Functions | |
| |
| |
| Date and Time Functions | |
| |
| |
| Math and Trig Functions | |
| |
| |
| Statistical Functions | |
| |
| |
| COUNTA | |
| |
| |
| Financial Functions | |
| |
| |
| Logical Functions | |
| |
| |
| Adding an IF Function to an existing Formula | |
| |
| |
| Editing and Troubleshooting Functions | |
| |
| |
| Concept Check | |
| |
| |
| Key Terms | |
| |
| |
| Visual Summary | |
| |
| |
| Practice | |
| |
| |
| Practice Case 1 | |
| |
| |
| Practice Case 2 | |
| |
| |
| |
| Workshop 4: Using Charts | |
| |
| |
| Prepare Case: Turquoise Oasis Spa Sales Report | |
| |
| |
| Designing a Chart | |
| |
| |
| Exploring Chart Characteristics-Types, Layouts, and Styles | |
| |
| |
| Navigating a Chart | |
| |
| |
| Chart Locations | |
| |
| |
| Creating Charts in an existing Worksheet | |
| |
| |
| Modifying a Chart's Position | |
| |
| |
| Placing Charts on a Chart Sheet | |
| |
| |
| Chart Types | |
| |
| |
| Pie Charts | |
| |
| |
| Line Charts | |
| |
| |
| Column Charts | |
| |
| |
| Bar Charts | |
| |
| |
| Scatter Charts | |
| |
| |
| Area Charts | |
| |
| |
| Chart Layout, Styles, and Data | |
| |
| |
| Laying out a Chart | |
| |
| |
| Inserting Objects | |
| |
| |
| Working with Labels | |
| |
| |
| Titles for the Chart and Axes | |
| |
| |
| Working with the Legend and Labeling the Data | |
| |
| |
| Modifying Axes | |
| |
| |
| Changing Gridlines | |
| |
| |
| Analysis with Trendlines | |
| |
| |
| Editing and Formatting Charts | |
| |
| |
| Colorizing Objects | |
| |
| |
| Working with Text | |
| |
| |
| Exploding Pie Charts | |
| |
| |
| 3-D Charts and Rotation of Charts | |
| |
| |
| Effectively Using Charts | |
| |
| |
| Strategic Statements with Charts | |
| |
| |
| Emphasizing Data | |
| |
| |
| Sparklines | |
| |
| |
| Data Bars, Color Scales, and Icon Sets | |
| |
| |
| Recognizing and Correcting Confusing Charts | |
| |
| |
| Correcting a Line Chart | |
| |
| |
| Changing the Chart Type and Legend | |
| |
| |
| Preparing to Print and Copy | |
| |
| |
| Concept Check | |
| |
| |
| Key Terms | |
| |
| |
| Visual Summary | |
| |
| |
| Practice | |
| |
| |
| Practice Case 1 | |
| |
| |
| Practice Case 2 | |
| |
| |
| |
| Capstone | |
| |
| |
| More Practice | |
| |
| |
| Problem Solve | |
| |
| |
| Problem Solve Case 1 | |
| |
| |
| Problem Solve Case 2 | |
| |
| |
| Problem Solve Case 3 | |
| |
| |
| Perform | |
| |
| |
| Perform in Your Life | |
| |
| |
| Perform in Your Career | |
| |
| |
| Perform in Your Career | |
| |
| |
| How Others Perform | |
| |
| |
| |
| Workshop 5: Integrating Complex Functions into Excel Analysis | |
| |
| |
| Prepare Case: Red Bluff Pro Shop Sales Analysis | |
| |
| |
| Integrating Logical Functions | |
| |
| |
| Using Nested IF Functions | |
| |
| |
| Using Conjunction Functions in IF Functions | |
| |
| |
| Using Conditional Aggregate Functions | |
| |
| |
| Using Conditional Statistical Functions | |
| |
| |
| The COUNTIF and COUNTIFS Functions | |
| |
| |
| The AVERAGEIF and AVERAGEIFS Functions | |
| |
| |
| Using Conditional Math Functions | |
| |
| |
| The SUMIF Function | |
| |
| |
| The SUMIFS Function | |
| |
| |
| The DSUM Function | |
| |
| |
| Retrieving Data Using LOOKUP and Reference Functions | |
| |
| |
| Using LOOKUP Functions | |
| |
| |
| Retrieving Data with MATCH, INDEX, and INDIRECT | |
| |
| |
| The MATCH function | |
| |
| |
| The Index Function | |
| |
| |
| The INDIRECT Function | |
| |
| |
| Handling Errors with the IFERROR Function | |
| |
| |
| Concept Check | |
| |
| |
| Key Terms | |
| |
| |
| Visual Summary | |
| |
| |
| Practice | |
| |
| |
| Practice Case 1 | |
| |
| |
| Practice Case 2 | |
| |
| |
| |
| Workshop 6: Analyzing Data Using Data | |
| |
| |
| Prepare Case: Golf Course Marketing Strategies | |
| |
| |
| Organizing Data with Tables | |
| |
| |
| Working with Tables of Data | |
| |
| |
| Organizing Data Sets | |
| |
| |
| Organizing a Data Set within a Table | |
| |
| |
| Filtering Data Sets | |
| |
| |
| Using the Advanced Filter Feature | |
| |
| |
| Using the SUBTOTAL Function and Filters with Tables | |
| |
| |
| Organizing and Analyzing with PivotTables and PivotCharts | |
| |
| |
| Developing PivotTables | |
| |
| |
| Creating PivotTables | |
| |
| |
| PivotTable Options | |
| |
| |
| Adding a Slicer to the PivotTable | |
| |
| |
| Design options within PivotTables | |
| |
| |
| Updating and Sharing Data in PivotTables | |
| |
| |
| Creating PivotCharts | |
| |
| |
| Concept Check | |
| |
| |
| Key Terms | |
| |
| |
| Visual Summary | |
| |
| |
| Practice | |
| |
| |
| Practice Case 1 | |
| |
| |
| Practice Case 2 | |
| |
| |
| |
| Capstone | |
| |
| |
| More Practice | |
| |
| |
| Problem Solve | |
| |
| |
| Problem Solve Case 1 | |
| |
| |
| Problem Solve Case 2 | |
| |
| |
| Problem Solve Case 3 | |
| |
| |
| Perform | |
| |
| |
| Perform in Your Life | |