CSFT-8082B Microsoft Excel 2021

Basic computer skills, keyboarding skills, and textbook are required. Recommended that student has access to a PC with office 365 installed. Learn introductory and intermediate Excel skills including entering and editing data in spreadsheets; organizing data; creating and modifying formulas and functions; charting data; and formatting worksheets. Students will also use Excel Tables to sort, filter, and group data. This course covers the objectives of Microsoft Office Specialist - Excel Associate Certification. 

Contact Hours: 24

• Upon completion of the course, students will use Excel to efficiently manage data
• Upon completion of the course, students will create formulas to aggregate data, extract insights, and identify conditions within a dataset
• Upon completion of the course, students will use Excel to effectively visualize data using appropriate charts and sparklines
• Upon completion of the course, students will import large datasets into excel and extract meaningful information using data tables and conditional formatting
• Upon completion of the course, students will transform data in Excel to effectively analyze a large dataset

• Create, Save, and Open a Workbook
• Enter and Edit Data in a Workbook
• Use Basic Aggregate Functions in a Workbook
• Format Cell Data
• Modify Columns, Rows, and Sheets
• Modify Screen Appearance of a Workbook
• Manage Page, Print, and Document Settings
• Customize Quick Access Toolbar
• Inspect Workbook for Issues
• Build and Edit Formulas
• Set Mathematical Order of Operations in Formulas
• Create Absolute, Relative, and Mixed References
• Use Formula Auditing Tools
• Work with Statistical and Date/Time Functions
• Use Financial, Logical and Lookup Functions
• Use Text Functions
• Format Text using: (RIGHT(), LEFT(), MID(), UPPER(), LOWER(), LEN(), CONCAT(), TEXTJOIN()
• Create a Chart Object
• Design Charts
• Manage Chart Elements
• Format Chart Elements
• Enhance a Chart
• Build Pie, Line, Combo, and Specialty Charts
• Insert and Format Sparklines
• Create and Format Excel Tables
• Apply Conditional Formatting
• Sort, Filter, Group and Subtotal Data in an Excel Table
• Import and Export Data
• Transform Data in Excel
• Create and Modify Pivot Tables

• Presentation
• Lecture
• Demonstration
• Hands-on practice

75% attendance is required; 100% attendance is recommended, as no special arrangements will be made for missing class.

75% = 18 hours.

Upon successful completion, this course will appear on the student’s Macomb Community College non-credit transcript.

Textbook
McGraw Hill, Excel Complete 2021, by Nordel, 9781266783692