Excel Skills for Business: Intermediate I Course Syllabus

Overview: This intermediate course builds on foundational Excel knowledge, guiding learners through essential techniques for managing and analyzing business data. With approximately 27 hours of content, the course offers a structured learning path covering data manipulation, advanced formulas, tables, and interactive dashboards. Designed for working professionals, it combines theory with hands-on practice, enabling immediate application in real-world business environments.

Module 1: Working with Multiple Worksheets & Workbooks

Estimated time: 6 hours

• Combining data from multiple worksheets
• Linking and referencing data across workbooks
• Managing external data sources
• Consolidating data for reporting

Module 2: Text and Date Functions

Estimated time: 4 hours

• Extracting and formatting text using LEFT, RIGHT, MID
• Using FIND, SUBSTITUTE, and REPLACE functions
• Manipulating dates with DATE, YEAR, MONTH, DAY
• Calculating date differences and workdays with NETWORKDAYS

Module 3: Named Ranges

Estimated time: 4 hours

• Creating and managing named ranges
• Applying named ranges in formulas
• Using named ranges for dynamic references
• Best practices for naming and organizing ranges

Module 4: Summarizing Data

Estimated time: 4 hours

• Using advanced formulas like SUMIFS, COUNTIFS, AVERAGEIFS
• Applying logical functions (IF, AND, OR) in data analysis
• Creating summary dashboards with graphical representations

Module 5: Tables

Estimated time: 4 hours

• Creating and formatting Excel tables
• Sorting and filtering table data
• Using structured references in formulas
• Automating table functionalities with Total Row and calculated columns

Module 6: Pivot Tables, Charts, and Slicers

Estimated time: 5 hours

• Building pivot tables from raw data
• Designing pivot charts for visual analysis
• Implementing slicers for interactive dashboards
• Customizing pivot table layouts and fields

Module 7: Final Assessment

Estimated time: 2 hours

• Consolidate data across multiple sheets
• Apply text and date functions to clean and prepare data
• Create a summary report using tables, pivot tables, and charts

Prerequisites

• Familiarity with basic Excel functions and formulas
• Understanding of cell referencing and worksheet navigation
• Experience entering and formatting data in Excel

What You'll Be Able to Do After

• Combine and manage data across multiple worksheets and workbooks
• Utilize advanced text and date functions for data manipulation
• Create and apply named ranges to enhance formula efficiency
• Summarize data using advanced formulas and generate graphical representations
• Design and manage tables and develop interactive pivot tables, charts, and slicers