Microsoft Excel - Basics to Advanced

Register

Course Details:

An interactive, 10-week online instruction program focused on increased proficiency and competency with Microsoft Excel. The course will be provided utilizing the Moodle Learning Management System (Moodle LMS) and Open-Source Learning Resources. Small class sizes (12-16 participants) will facilitate 1-on-1, personalized support. Appointment-based live tutoring sessions will be offered weekly to provide students with extra support and in-depth assistance with course material. Additionally, a series of five appointment-based 1-on-1 sessions will be offered as support and guidance following the completion of the final session.

Each unit will include:

• A baseline assessment of current skills
• Live sessions with detailed demonstrations of assignments 
• Comprehensive learning objectives
• Single-skill development activities and practice
• Combined-skill development activities
• Interactive quizzes
• Development of an Excel portfolio comprising course info and integrated skillsets
• Individualized feedback and assessment throughout

Learning outcomes:

Following the completion of the course, students will be able to: 

• Apply basic and complex formulas
• Apply absolute/relative references to spreadsheets and workbooks
• Create, edit, and format multiple chart types and chart elements
• Manage data and tables within complex workbooks
• Apply, modify, and create styles, themes, and templates
• Edit and review workbooks
• Create customized workbooks for personal/professional use
• Apply basic and advanced functions
• Integrate multiple worksheets and workbooks
• Apply filtering, sorting, and data validation features
• Apply pivot tables and pivot charts
• Develop personal and professional templates