COR 276 - Excel Foundations: From Beginner to Intermediate
Course Description
This course is designed for learners who are new to Microsoft Excel or who wish to strengthen their foundational skills and progress to an intermediate level of data analysis and reporting. Through hands-on practice, participants will build confidence in navigating Excel, managing data, and creating basic reports and visualizations.
The course covers essential Excel operations, formulas, and formatting, and introduces structured data management and reporting tools. Learners will gain practical experience with data entry, cleaning, and organization, as well as creating charts and summary tables for effective communication. By the end of the course, participants will be able to apply Excel skills to real-world academic and workplace tasks.
Course Details
Learning Outcomes
- Identify and describe the components of the Excel environment, including workbooks, worksheets, and interface customization options
- Enter, clean, and organize data using Excel Tables, Flash Fill, and basic data validation tools
- Apply essential formulas and functions (SUM, AVERAGE, COUNT, MIN, MAX, IF)
- Create and customize charts and visual elements
- Sort, filter, and summarize data across multiple worksheets
Topics of Instruction
- Excel Environment and Workbook Setup
- Working with Data and Excel Tables
- Essential Formulas and Calculations
- Formatting and Workbook Appearance
- Introduction to Charts and Visuals
- Printing and Page Layout
- Advanced Data Entry and Data Quality
- Intermediate Formulas
- Tables, Sorting, Filtering, and Data Management
- PivotTables and Pivot Charts