Scroll to top button

Microsoft Office Excel 2016 (with Expert Exam)

Glossary of terms
Pre-assessment Questions
Full Length Tests
Post-Assessment Questions
Performance lab
Video tutorials
  • TOPIC A: Navigate the Excel User Interface
  • TOPIC B: Use Excel Commands
  • TOPIC C: Create and Save a Basic Workbook
  • TOPIC D: Enter Cell Data
  • TOPIC E: Use Excel Help
  • Summary
  • TOPIC A: Create Worksheet Formulas
  • TOPIC B: Insert Functions
  • TOPIC C: Reuse Formulas and Functions
  • Summary
  • TOPIC A: Insert, Delete, and Adjust Cells, Columns, and Rows
  • TOPIC B: Search for and Replace Data
  • TOPIC C: Use Proofing and Research Tools
  • Summary
  • TOPIC A: Apply Text Formats
  • TOPIC B: Apply Number Formats
  • TOPIC C: Align Cell Contents
  • TOPIC D: Apply Styles and Themes
  • TOPIC E: Apply Basic Conditional Formatting
  • TOPIC F: Create and Use Templates
  • Summary
  • TOPIC A: Preview and Print a Workbook
  • TOPIC B: Set Up the Page Layout
  • TOPIC C: Configure Headers and Footers
  • Summary
  • TOPIC A: Manage Worksheets
  • TOPIC B: Manage Workbook and Worksheet Views
  • TOPIC C: Manage Workbook Properties
  • Summary
  • TOPIC A: Add Borders and Colors to Worksheets
  • TOPIC A: Customize General Options and the Excel UI
  • Mastery Builder 1-1: Creating and Saving a Workbook Activity
  • Mastery Builder 2-1: Creating and Reusing Formulas and Functions
  • Mastery Builder 3-1: Modifying a Worksheet
  • Mastery Builder 4-1: Formatting a Worksheet
  • Mastery Builder 5-1: Printing Workbooks
  • Mastery Builder 6-1: Managing Workbooks
  • TOPIC A: Work with Ranges
  • TOPIC B: Use Specialized Functions
  • TOPIC C: Work with Logical Functions
  • TOPIC D: Work with Date & Time Functions
  • TOPIC E: Work with Text Functions
  • Summary
  • TOPIC A: Sort Data
  • TOPIC B: Filter Data
  • TOPIC C: Query Data with Database Functions
  • TOPIC D: Outline and Subtotal Data
  • Summary
  • TOPIC A: Create and Modify Tables
  • TOPIC B: Apply Intermediate Conditional Formatting
  • TOPIC C: Apply Advanced Conditional Formatting
  • Summary
  • TOPIC A: Create Charts
  • TOPIC B: Modify and Format Charts
  • TOPIC C: Use Advanced Chart Features
  • Summary
  • TOPIC A: Create a PivotTable
  • TOPIC B: Analyze PivotTable Data
  • TOPIC C: Present Data with PivotCharts
  • TOPIC D: Filter Data by Using Timelines and Slicers
  • Summary
  • TOPIC A: Insert Graphical Objects
  • TOPIC B: Modify Graphical Objects
  • TOPIC C: Work with SmartArt
  • Mastery Builder 1-1: Working with Functions
  • Mastery Builder 2-1: Working with Lists
  • Mastery Builder 3-1: Analyzing Data
  • Mastery Builder 4-1: Visualizing Data with Charts
  • Mastery Builder 5-1: Using PivotTables and PivotCharts
  • TOPIC A: Use Links and External References
  • TOPIC B: Use 3-D References
  • TOPIC C: Consolidate Data
  • Summary
  • TOPIC A: Use Lookup Functions
  • TOPIC B: Trace Cells
  • TOPIC C: Watch and Evaluate Formulas
  • Summary
  • TOPIC A: Collaborate on a Workbook
  • TOPIC B: Protect Worksheets and Workbooks
  • Summary
  • TOPIC A: Apply Data Validation
  • TOPIC B: Search for Invalid Data and Formulas with Errors
  • TOPIC C: Work with Macros
  • Summary
  • TOPIC A: Create Sparklines
  • TOPIC B: Map Data
  • Summary
  • TOPIC A: Determine Potential Outcomes Using Data Tables
  • TOPIC B: Determine Potential Outcomes Using Scenarios
  • TOPIC C: Use the Goal Seek Feature
  • TOPIC D: Forecasting Data Trends
  • Summary
  • TOPIC A: Internationalize Workbooks
  • TOPIC A: Work with Forms and Controls
  • Mastery Builder 1-1: Working with Multiple Worksheets and Workbooks
  • Mastery Builder 2-1: Using Lookup Functions and Formula Auditing
  • Mastery Builder 3-1: Sharing and Protecting Workbooks
  • Mastery Builder 4-1: Automating Workbook Functionality
  • Mastery Builder 5-1: Creating Sparklines and Mapping Data
  • Mastery Builder 6-1: Forecasting Data

Hands on Activities (Labs)

  • Exploring the backstage view
  • Adding and replacing the data in an excel sheet
  • Saving a workbook
  • Copying and pasting the text
  • Opening the Excel help
  • Creating worksheet formulas
  • Using the SUM function
  • Using the Average function
  • Using the Autofill function
  • Finding and Replacing the text
  • Checking spelling and grammar
  • Changing the worksheet font color
  • Changing the number format
  • Wrapping text
  • Formatting a cell range as a table
  • Applying a theme to a table
  • Applying conditional formatting
  • Saving the workbook as an Excel Template file
  • Printing an area
  • Setting page margin
  • Configuring page setup for printing
  • Adding a header and footer
  • Adding color to the worksheet tabs
  • Freezing the top row
  • Creating a custom workbook property
  • Calculating the years of service values
  • Using the SUMIF function
  • Changing date format
  • Using the Concatenate function
  • Filtering data
  • Sorting data and using the Subtotal feature
  • Deleting duplicate rows and sorting the table
  • Formatting values that are above or below average
  • Using logical functions
  • Inserting a chart and changing the chart style
  • Changing chart color
  • Customizing a chart
  • Creating a combo chart
  • Creating a PivotTable and PivotChart and inserting slicers to filter the PivotTable
  • Consolidating the quantity of products data
  • Using VLOOKUP
  • Adding a watch to several cells
  • Adding comments
  • Protecting a workbook
  • Creating a scenario that preserves the original values
  • Copying the original data using the Goal Seek feature
  • Creating a forecast sheet from monthly sales data
  • ×