UBCx: Excel for Everyone: Core Foundations course Syllabus

Overview: This course is designed as a beginner-friendly introduction to Microsoft Excel, ideal for individuals with little to no prior experience. Over approximately 6–10 weeks, learners will build a solid foundation in Excel by mastering core functionalities such as navigation, data organization, formatting, formulas, and basic data visualization. Each module combines clear explanations with hands-on practice to ensure practical skill development. The course concludes with a final project that integrates all concepts covered, preparing learners for real-world applications and further study in data analysis.

Module 1: Introduction to Excel and Spreadsheet Basics

Estimated time: 4 hours

• Explore the Excel interface and ribbon layout
• Understand workbook and worksheet structure
• Learn basic navigation through cells, rows, and columns
• Enter and edit data in cells
• Identify common use cases for spreadsheets in personal and professional settings

Module 2: Working with Data and Formatting

Estimated time: 6 hours

• Format cells, numbers, text, and dates for clarity
• Apply table styles and cell formatting to enhance readability
• Sort and filter data to organize information effectively
• Use best practices for structuring clean and professional spreadsheets
• Navigate worksheets and manage multiple sheets within a workbook

Module 3: Formulas and Functions

Estimated time: 6 hours

• Write basic formulas using arithmetic operators
• Use essential functions: SUM, AVERAGE, COUNT, and IF
• Understand and apply relative and absolute cell references
• Build simple calculations to automate data processing
• Identify and correct common formula errors

Module 4: Charts and Basic Data Visualization

Estimated time: 4 hours

• Create bar, line, and pie charts from data ranges
• Choose appropriate chart types based on data and purpose
• Format chart elements (titles, axes, legends) for clarity
• Use visuals to communicate insights effectively

Module 5: Core Foundations Review and Application

Estimated time: 2 hours

• Review key concepts: navigation, formatting, formulas, and charts
• Practice integrating skills through guided exercises
• Prepare for the final project with checklist and examples

Module 6: Final Project

Estimated time: 3 hours

• Organize a dataset using proper formatting and structure
• Apply formulas and functions to perform calculations
• Create a basic chart to visualize key insights

Prerequisites

• Basic computer literacy
• Access to Microsoft Excel (any recent version)
• No prior Excel experience required

What You'll Be Able to Do After

• Confidently navigate the Excel interface and manage worksheets
• Organize and format data to create clear, professional spreadsheets
• Use essential formulas and functions to perform accurate calculations
• Create basic charts to visualize data and support decision-making
• Build a foundation for further learning in Excel and data analysis