Summary of BUSN 1168 - MS Excel - Master 2023

Notice: Please be aware Moodle will be unavailable for maintenance from 10:00 PM, Friday April 26, to 12:00 PM, Saturday, April 27.

Home My Media Help

BUSN 1168 - MS Excel - Master 2023

BUSN 1168 - MS Excel - Master 2022

Teacher: Robert Bradley
Teacher: Rodger Murray
Teacher: Sandy Olsen

Skill Level: Beginner

General

Course Overview

Announcements

Q &amp; A Discussion Forum

Administrative Professional Student Handbook

BUSN 1168 2023-2024 Course Outline

Steps to Install Microsoft Office created by Computer Commons

Mandatory Settings for your Computer

BUSN 1168-Excel How to Calculate Your Final Grade

Course Textbook / MindTap

MindTap Website

BlackBoard Sessions

Video: How to Add a Profile Picture to BB Ultra [0:59]

BUSN 1168 Excel Virtual Classroom (Blackboard Collaborate Ultra)

Excel Module 1 - Creating a Worksheet and a Chart

Module 1: Overview

Excel Module 1 Assignment (MindTap AND Moodle)

Excel Module 2 - Formulas, Functions, and Formatting

Module 2: Overview

Excel Module 2 Student Data File for Textbook Project

Module 2 Textbook Project Calculations

Excel Module 2 Assignment (MindTap AND Moodle)

Excel Module 3 - Working with Large Worksheets, Charting, and What-If Analysis

Module 3: Overview

Excel Module 3 Student Data File for Textbook Project

Excel Module 3 Assignment (MindTap AND Moodle)

Module 1-3 Capstone

Capstone Project 1a Excel Modules 1-3 (MindTap AND Moodle)

Excel Module 4 - Financial Functions, Data Tables, and Amortization Schedules

Module 4: Overview

Excel Module 4 Assignment (MindTap AND Moodle)

Excel Module 5 - Working with Multiple Worksheets and Workbooks

Module 5: Overview

Excel Module 5 Student Data File for Textbook Project

Excel Module 5 Assignment (MindTap AND Moodle)

Excel Midterm Exam (need to create a new exam each term)

Excel Module 6 - Creating, Sorting, and Querying a Table

Module 6: Overview

Excel Module 6 Student Data File for Textbook Project

Excel Module 6 Assignment (MindTap AND Moodle)

VLOOKUP Function

VLOOKUP vs Nested If Handout

VLOOKUP vs Nested If Student Data File

SumIf and CountIf Handout

Excel Module 7 - Creating Templates, Importing Data, and Working with SmartArt, Images, and Screenshots

Module 7: Overview

Excel Module 7 Student Data File for Textbook Project

Excel Module 7 Assignment (MindTap AND Moodle)

Module 4-7 Capstone

Capstone Project 1a Excel Modules 4-7 (MindTap AND Moodle)

Excel Module 8 - Working with Trendlines, PivotTables, PivotCharts, and Slicers

Module 8: Overview

Excel Module 8 Student Data File for Textbook Project

Excel Module 8 Assignment (MindTap AND Moodle)

Create a PivotTable

Excel Module 9 - Formula Auditing, Data Validation, and Complex Problem Solving

Module 9: Overview

Excel Module 9 Student Data File for Textbook Project

Excel Module 9 Assignment (MindTap AND Moodle)

Excel Module 10 - Creating Macros

Module 10: Overview

Excel Module 10 Macro Notes

Excel Module 10 Student Data Files for In-class Project

Excel Module 11 - User Interfaces

Excel Module 12 - Google Sheets

Google Drive 2023

Excel Final Exam (need to create a new exam each term)

Instructor Resources (please keep hidden from students)

Or login using your account

BUSN 1168 - MS Excel - Master 2023

Q & A Discussion Forum