This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
CTA 326-Fall SEMESTER 2024
Microsoft Office Certification
Microsoft Certification Overview (Video) (2:17)
Microsoft Certification Overview (PDF Files)
Video: Microsoft Excel Associate Certification - Practice Questions (43:43)
Video: Microsoft Excel Expert Certification Exam - Practice Questions (31:08)
SimNet Files (these are the same files you would normally download from the SimNet website)
Chapter 1
Chapter 2
Chapter 3
Chapter 4
Chapter 5
Chapter 6
Chapter 7
Excel for Mac
SimNet Instructions for Mac Users
Excel Mac Training Documents
CTA 326: Week 1 Class Lectures
Excel for Business Study Guide
Simnet: How to upload files (0:30)
Case Study: You Must Have a Plan! (2:04)
Case Study: Why Icy Hot Doesn't Pay for Advertising (3:21)
Benefits of Microsoft Office Certification (1:58)
Major Assignment Video Tutorials
Final Project (PowerPoint)
PowerPoint: Designs and Layouts (3:32)
PowerPoint: Create Text Boxes with Animations (5:07)
PowerPoint: Apply Slide Transitions (2:33)
PowerPoint: Custom Presentations and Transitions (3:27)
Word: Create Cover Sheets (2:09)
Word: Create an Outline (2:25)
Take Screenshots using Windows (0:41)
Take Screenshots using the Paint application (0:38)
Inserting Text Boxes (2:28)
Adding Photos (0:49)
Headers, Footers and Page Numbers (2:19)
PowerPoint: Create Charts with Animations (5:33)
SimNet Video Tutorials
SimNet: How to Navigate (1:27)
SimNet: Launch a Lesson (4:38)
SimNet: Complete a Project (5:00)
SimNet: Taking Exams and Reading Results (1:24)
SimNet: View SimNet Grades (0:23)
Basic Instructions
CTA 326: Week 2 Class Lectures
Case Study: Planet Popcorn (Part 2) (3:56)
Case Study: Insane Pools (from the Animal Planet TV show) (4:03)
Case Study: Why McDonalds is not in the "Burger Business" (3:00)
Case Study: Know Your Numbers! (1:51)
Entering Data Into Cells (5:31)
Cut, Copy Paste and Paste Special (4:37)
The Digital Edge: Middle Skill Workers and Careers (PDF file)
CTA 326: Week 3 Class Lectures
Case Study: What is Capital Budgeting? (Mr. Green Tea) (2:25)
Case Study: The Downfall of Theranos (3:24)
Case Study: Uber and Air BnB (2:17)
Video Case Study: Introduction to Stock Investments (8:02)
Video Case Study: Bonds and Investment Strategies (5:43)
Case Study: Planet Popcorn (2:27)
Video Case Study: Planet Popcorn Pt 2 (5:13)
Case Study: What Is Reinvention? (Flicker, Twitter and Nike) (2:39)
Case Study: Zappos (2:22)
CTA 326: Week 4 Class Lectures
Case Study: Ford Motor Company and Dell (2:24)
Time Management Strategies (4:27)
Case Study: How Mark Cuban Become A Billionaire (4:14)
Activity 9.1 Introduction to PivotTables (3:29)
Activity 9.2 PivotTable Reports (1:49)
Activity 9.3 Calculated Fields (3:06)
Activity 9.4 Grouped Data (2:21)
Activity 9.5 Percent of Total (2:15)
Activity 9.6 Multiple Value Calculations (2:09)
Activity 9.7 Report Filter Pages (2:16)
Week 5 Class Lectures
Telling Purposeful Stories (6:02)
Case Study: Improve Your Thinking (2:35)
Case Study: What is Mindstorming? (2:41)
Case Study: The Buyer's Pyramid (a lesson on presentation skills) (3:00)
Five Rules for Creating World-Changing (PowerPoint) Presentations (4:15)
CTA 326: Week 7 Class Lectures
VLOOKUP: Basic Skills (4:35)
Week 6 Class Lectures
Case Study: Grow a Business using Social Media (8:29)
Week 7 Class Lectures
Case Study: The First 90 Days (3:28)
CTA 326 - Excel Training Class
Week 11: November 7th
Excel: Scenario Manager (2:09)
Excel: Data Tables (One and Two Input) (1:54)
Excel Lesson: Create and Manage a Data List (4:25)
Excel: Scenario Manager
Complete and Continue