Course: MO-100 Part 2

Topic outline

Select topic Start Here

Start Here

Collapse all Expand all
- Select activity Case Study: Townson University
  
  Case Study: Townson University Page
- Select activity Case Study: West Virginia State University
  
  Case Study: West Virginia State University Page
- Select activity Video: Excel Certified Employees
  
  Video: Excel Certified Employees Page
- Select activity How to Add Excel Skills to your Resume
  
  How to Add Excel Skills to your Resume File
- Select activity Case Study: Tulane University
  
  Case Study: Tulane University File
- Select activity Case Study: University of Denver
  
  Case Study: University of Denver File
- Select activity Overview: Microsoft Certified Associate Exam
  
  Overview: Microsoft Certified Associate Exam File
- Select activity Microsoft Certification - Productivity Study
  
  Microsoft Certification - Productivity Study File
- Select activity Post Your Questions Here
  
  Post Your Questions Here Forum
  
  Feel free to use this space post questions, comments, etc. for Professor Myers or others in the class.
- Select activity Course Syllabus
  
  Course Syllabus File
- Select activity Why You Need Excel Skills - Testimonial
  
  Why You Need Excel Skills - Testimonial Page
- Select activity Excel Certification Success Story
  
  Excel Certification Success Story Page
Select topic Objective Group 1: Manage Worksheets and Workbooks

Objective Group 1: Manage Worksheets and Workbooks
- Select activity Zoom Video Recording - Friday, September 20th 2024
  
  Zoom Video Recording - Friday, September 20th 2024 Page
- Select activity Getting Started with Excel
  
  Getting Started with Excel Course Activity
- Select activity Objective 1.1 Import data into workbooks (part 1)
  
  Objective 1.1 Import data into workbooks (part 1) Page
- Select activity Objective 1.1 Import data into workbooks (part 2)
  
  Objective 1.1 Import data into workbooks (part 2) Page
- Select activity Software Simulation: Objective 1.1
  
  Software Simulation: Objective 1.1 Course Activity
- Select activity Objective 1.2 Navigate within workbooks (part 1)
  
  Objective 1.2 Navigate within workbooks (part 1) Page
- Select activity Objective 1.2 Navigate within workbooks (part 2)
  
  Objective 1.2 Navigate within workbooks (part 2) Page
- Select activity Software Simulation: Objective 1.2
  
  Software Simulation: Objective 1.2 Course Activity
- Select activity Objective 1.3 Format worksheets and workbooks (part 1)
  
  Objective 1.3 Format worksheets and workbooks (part 1) Page
- Select activity Objective 1.3 Format worksheets and workbooks (part 2)
  
  Objective 1.3 Format worksheets and workbooks (part 2) Page
- Select activity Software Simulation: Objective 1.3
  
  Software Simulation: Objective 1.3 Course Activity
- Select activity Objective 1.4 Customize options and views (part 1)
  
  Objective 1.4 Customize options and views (part 1) Page
- Select activity Objective 1.4 Customize options and views (part 2)
  
  Objective 1.4 Customize options and views (part 2) Page
- Select activity Objective 1.4 Customize options and views (part 3)
  
  Objective 1.4 Customize options and views (part 3) Page
- Select activity Software Simulation: Objective 1.4
  
  Software Simulation: Objective 1.4 Course Activity
- Select activity Objective 1.5 Configure content for collaboration (part 1)
  
  Objective 1.5 Configure content for collaboration (part 1) Page
- Select activity Objective 1.5 Configure content for collaboration (part 2)
  
  Objective 1.5 Configure content for collaboration (part 2) Page
- Select activity Software Simulation: Objective 1.5
  
  Software Simulation: Objective 1.5 Course Activity
Select topic Objective Group 2: Manage data cells and ranges

Objective Group 2: Manage data cells and ranges
- Select activity Objective 2.1 Manipulate data in worksheets (part 1)
  
  Objective 2.1 Manipulate data in worksheets (part 1) Page
- Select activity Objective 2.1 Manipulate data in worksheets (part 2)
  
  Objective 2.1 Manipulate data in worksheets (part 2) Page
- Select activity Software Simulation: Objective 2.1
  
  Software Simulation: Objective 2.1 Course Activity
- Select activity Objective 2.2 Format cells and ranges
  
  Objective 2.2 Format cells and ranges Page
- Select activity Software Simulation: Objective 2.2
  
  Software Simulation: Objective 2.2 Course Activity
- Select activity Objective 2.3 Define and reference named ranges
  
  Objective 2.3 Define and reference named ranges Page
- Select activity Software Simulation: Objective 2.3
  
  Software Simulation: Objective 2.3 Course Activity
- Select activity Objective 2.4 Summarize data visually
  
  Objective 2.4 Summarize data visually Page
- Select activity Software Simulation: Objective 2.4
  
  Software Simulation: Objective 2.4 Course Activity
- Select activity Project Files: Objective Group 2
  
  Project Files: Objective Group 2 Assignment
Select topic Objective Group 3: Create tables

Objective Group 3: Create tables
- Select activity Objective 3.1 Create and format tables
  
  Objective 3.1 Create and format tables Page
- Select activity Software Simulation: Objective 3.1
  
  Software Simulation: Objective 3.1 Course Activity
- Select activity Objective 3.2 Modify tables
  
  Objective 3.2 Modify tables Page
- Select activity Software Simulation: Objective 3.2
  
  Software Simulation: Objective 3.2 Course Activity
- Select activity Objective 3.3 Filter and sort table data
  
  Objective 3.3 Filter and sort table data Page
- Select activity Software Simulation: Objective 3.3
  
  Software Simulation: Objective 3.3 Course Activity
- Select activity Project Files: Objective Group 3
  
  Project Files: Objective Group 3 Assignment
Select topic Objective Group 4: Perform operations by using formulas and functions

Objective Group 4: Perform operations by using formulas and functions
- Select activity Objective 4.1 Insert references in formulas
  
  Objective 4.1 Insert references in formulas Page
- Select activity Software Simulation: Objective 4.1
  
  Software Simulation: Objective 4.1 Course Activity
- Select activity Objective 4.2 Calculate and transform data using functions
  
  Objective 4.2 Calculate and transform data using functions Page
- Select activity Software Simulation: Objective 4.2
  
  Software Simulation: Objective 4.2 Course Activity
- Select activity Objective 4.3 Format and modify text by using functions
  
  Objective 4.3 Format and modify text by using functions Page
- Select activity Software Simulation: Objective 4.3
  
  Software Simulation: Objective 4.3 Course Activity
- Select activity Project Files: Objective Group 4
  
  Project Files: Objective Group 4 Assignment
Select topic Objective Group 5: Configure content for collaboration

Objective Group 5: Configure content for collaboration
- Select activity Objective 5.1 Create charts
  
  Objective 5.1 Create charts Page
- Select activity Software Simulation: Objective 5.1
  
  Software Simulation: Objective 5.1 Course Activity
- Select activity Objective 5.2 Modify charts
  
  Objective 5.2 Modify charts Page
- Select activity Software Simulation: Objective 5.2
  
  Software Simulation: Objective 5.2 Course Activity
- Select activity Objective 5.3 Format charts
  
  Objective 5.3 Format charts Page
- Select activity Software Simulation: Objective 5.3
  
  Software Simulation: Objective 5.3 Course Activity
- Select activity Project files: Objective Group 1
  
  Project files: Objective Group 1 Assignment

Topic outline

Start Here

Objective Group 1: Manage Worksheets and Workbooks

Objective Group 2: Manage data cells and ranges

Objective Group 3: Create tables

Objective Group 4: Perform operations by using formulas and functions

Objective Group 5: Configure content for collaboration