About the Course
This concise summary highlights the scope of the Excel Teaching Guide & Practice Workbook. Using a realistic Music Industry Sales dataset, the course teaches essential Excel skills through practical, step-by-step exercises. Learners work with real examples to clean data, build formulas, use functions, create charts, build pivot tables, and present results clearly and professionally.
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.
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.
Your Instructor
Mirzet Velagić
