This course is an in-depth introduction to Microsoft Excel 2021. The focus is to learn functions of Excel, to apply this knowledge to business situations, and to begin preparing students for the MOS (Microsoft Office Specialist) Expert certification exam.
Prerequisites
Quarters Offered
Fall,
Winter,
Spring
Course Outcomes
Upon successful completion of the course, students should be able to demonstrate the following knowledge or skills:
- Manage electronic files
- Develop a worksheet
- Change the format of a worksheet
- Work with functions and formulas
- Create and enhance charts and graphics
- Manage multiple worksheets and workbooks
Institutional Outcomes
IO2 Quantitative Reasoning: Students will be able to reason mathematically using methods appropriate to the profession
IO3 Human Relations/Workplace Skills: Students will be able to demonstrate teamwork, professionalism, and/or workplace specific skills.
IO3 Human Relations/Workplace Skills: Students will be able to demonstrate teamwork, professionalism, and/or workplace specific skills.
Course Content Outline
- Create, Save, Print, and Edit Worksheets and Workbooks
- Apply Formatting
- Insert, Write, and Edit Formulas
- Filter and Sort Data
- Insert, Copy, Edit, and Delete Graphics
- Manage Multiple Worksheets and Workbooks
- Create, Print, and Edit Charts
- Apply, Edit, and Delete Conditional Formatting
- Create and Use Statistical, Math, Lookup, Financial, and Logical Functions
Department Guidelines
The syllabus must contain evaluation/grading guidelines, class environment/expectations/rules, course learning outcomes, and a disability services statement. A schedule must be provided to students that contains content covered (text chapters, topics, etc.), tentative test dates (to include final date/time). If an LMS or similar site is used for the course, it must be created following the Quality Matters (QM) principals outlined in the QM workbook questions. These documents should be reviewed with the BIM instructor at least two weeks prior to class start.