Cornerstone Career & Technology Academy
All courses
Self-PacedIntermediate Certificate Printable Companion

Excel & Spreadsheets for the Real World

Master intermediate Excel skills: formulas, data organization, PivotTables, dashboards, and reporting. Build professional workbooks for real-world business scenarios.

20 hours Grades 7-12

About this course

A comprehensive Intermediate Excel course that takes you from foundational skills to professional-level data analysis and reporting. Master cell references, Tables, error handling, logical formulas, conditional aggregations, lookups, text/date functions, data validation, conditional formatting, PivotTables, dynamic arrays, charts, dashboards, and Power Query. Complete a capstone project that integrates all skills into a professional reporting workbook.

Learning objectives

  • Master cell references (relative, absolute, mixed), Excel Tables, and structured references
  • Handle formula errors using IFERROR, IFNA, and formula auditing tools
  • Build intermediate formulas using IF, IFS, AND/OR, SUMIFS, COUNTIFS, AVERAGEIFS, XLOOKUP, and text/date functions
  • Organize and clean data using sorting, filtering, data validation, and conditional formatting
  • Analyze data with PivotTables, PivotCharts, slicers, and dynamic array functions
  • Create professional charts, dashboards, and reporting workbooks
  • Apply Power Query for data cleaning and basic automation
  • Integrate all intermediate Excel skills in a capstone reporting project

Skills you'll build

Cell references and named rangesExcel Tables and structured referencesError handling with IFERROR and formula auditingLogical functions (IF, IFS, AND, OR)Conditional aggregations (SUMIFS, COUNTIFS, AVERAGEIFS)Lookup strategies (XLOOKUP, INDEX/MATCH)Text and date functionsData validation and conditional formattingData cleaning techniquesPivotTables and PivotChartsDynamic arrays (UNIQUE, FILTER, SORT)Chart creation and dashboard designPower Query for data cleaningProfessional workbook organization

Meet Your Instructor

Portrait of Liliana Delgado

Liliana Delgado

Founder & Lead Instructor, Career, Technology & Business Education

Liliana Delgado is a technology and business leader with more than 18 years of experience in technical support, operations management, project management, customer service, and business strategy. She holds a bachelor’s degree in Computer Networking and an MBA and is the author of The Tech Support Manager’s Guide. As founder of Cornerstone Career & Technology Academy and Managing Director of Cornerstone Site Operations, Liliana brings real-world experience into the classroom, helping students connect what they learn with practical skills they can use in school, the workplace, business, and everyday life. Her teaching focuses on career readiness, technology, professional communication, leadership, business operations, and practical problem-solving.

View Full Instructor Profile
$199.00
Duration20 hours
FormatSelf-Paced
Grades7-12
LevelIntermediate
CertificateIncluded