Excel Basic Course

By the end of this day, you'll go from raw data to a polished, presentation-ready Excel report — using real sales data from the music industry.

For whom is this course?

This course is designed for Excel beginners, business users, students, assistants, analysts, and anyone who wants a clear, hands-on path from basic spreadsheet work to confident reporting.

What to expect

Expect a practical learning experience with guided exercises, real dataset examples, clean spreadsheet habits, core formulas and functions, charts, pivot tables, and useful reporting techniques.

Key Topics Covered

=> Excel foundations: Understand the interface, workbook structure, cell references, and formula basics.

= Data cleaning and preparation: Import, inspect, format, clean, validate, sort, and filter data with confidence.

=> Core formulas and functions: Work with SUM, AVERAGE, IF, COUNTIF, XLOOKUP, SUMIFS, TEXT, YEAR, MONTH, DAY, and more.

=> Tables and structured references: Build cleaner models using Excel tables, total rows, and structured references.

=> Visual analysis: Create charts, compare regions and products, and present trends clearly.

=> Pivot tables and interactive tools: Summarize data quickly and use slicers and timelines for interactive analysis.

=> Output and presentation: Prepare worksheets for sharing, printing, PDF export, and professional presentation.

Prerequisites: Basic Excel skills (entering data, simple formulas, sorting). No VBA or programming knowledge required. Just Excel 365 and a willingness to learn something new.

Included: Practice dataset, full slide deck, and reusable Excel template file.

Ready to EXCELIZE your workflow and learn something new? Then check this handout before enrolment.