Business Office Technology - Microsoft Excel

Microsoft Excel (BTEC 2100)

Total Credits: 3
Lecture Credits: 3.00

Description: This Microsoft Office Excel course is designed to cover all of the learning objectives for the Microsoft Office Specialist (MOS) exam. MOS-approved textbooks and courseware are used for this course. You will learn to navigate Microsoft Office Excel software at the feature and functionality level. You will learn to use Microsoft Office Excel to create and edit professional-looking spreadsheets for a variety of purposes and situations. You will learn the features and capabilities of Microsoft Office Excel. You will learn skills in: managing the worksheet environment, creating cell data, formatting cells and worksheets, managing worksheets and workbooks, applying formulas and functions, presenting data visually, sharing worksheet data with other users, and analyzing and organizing Data. Must be taken A-F.

Topical Outline:

Learning Outcomes:
1. 1. Create, Save, Navigate, and Print an Excel Workbook
2. 2. Format Cells, Enter and Chart Data, Construct and Copy Formulas
3. 3. Use Functions, Create Tables, Manage Large Workbooks and Use Advanced Sorting and Filtering
4. 4. Analyze Data With Charts and What-If Analysis Tools
5. 5. Create PivotTables, Pivot Charts, and Reports
6. 6. Create a Shared Workbook, Track Changes, and Prepare a Workbook for Distribution

Prerequisites: 

BTEC 1020