Excel computing course
Master Excel from the ground up and turn raw data into clear, actionable results. This course covers everything from basic navigation and formatting to PivotTables, advanced functions, and dashboard design. Whether you're managing budgets, analysing sales, or building reports, you'll gain the practical Excel skills employers actually need.
What you will learn:
You'll start with the Excel interface and core data entry skills, then move into formulas, functions, and data organisation techniques. From there, you'll learn how to use lookup functions, build PivotTables, and design professional charts. The course also covers Power Query for data transformation, financial modelling functions, and macro basics for automation. You'll finish with dashboard design, collaboration tools, and business intelligence features including Power Pivot and forecasting. Every topic is taught with real-world application in mind so you can put your skills to work immediately.
How you study in practice Excel computing course
How you practise Excel computing course
For companies looking to train their teams
With Dedika for businesses, the course includes exercises and examples tailored to your company and its specific needs.
Course content
8 Chapters • 38 LessonsDuration between 4 and 360 hours (you decide)
Chapter 1HideHide detailsSee detailsExcel Interface and Workbook Basics
Excel Interface and Workbook Basics
Lesson 1 • Navigating the Excel Interface
Covers the Ribbon, Quick Access Toolbar, and worksheet tabs. Builds the spatial awareness needed for all subsequent Excel tasks.
Lesson 2 • Cell Selection and Basic Navigation
Introduces cell references, ranges, and keyboard shortcuts for navigation. Speeds up data entry and selection across large datasets.
Lesson 3 • Working with Worksheets
Explains inserting, renaming, moving, and protecting sheets. Provides structural control over multi-sheet workbooks.
Lesson 4 • Creating and Managing Workbooks
Teaches file creation, saving formats, and workbook properties. Establishes file hygiene habits critical for professional use.
Chapter 2HideHide detailsSee detailsData Entry and Cell Formatting
Data Entry and Cell Formatting
Lesson 1 • Conditional Formatting Fundamentals
Introduces rules-based formatting to highlight key values automatically. Connects visual cues directly to data patterns for faster insight.
Lesson 2 • Rows, Columns, and Cell Management
Covers inserting, deleting, resizing, and hiding rows and columns. Structural control is essential before building complex spreadsheets.
Lesson 3 • Font, Alignment, and Cell Styles
Applies font styling, alignment options, and cell style presets. Consistent formatting improves readability and brand presentation.
Lesson 4 • Entering and Editing Data
Covers text, number, date, and time entry methods. Accurate input at this stage prevents errors in all downstream calculations.
Lesson 5 • Number and Date Formatting
Teaches built-in and custom number formats for currency, percentages, and dates. Ensures data displays correctly for professional reporting.
Chapter 3HideHide detailsSee detailsCore Formulas and Functions
Core Formulas and Functions
Lesson 1 • Text Functions for Data Cleaning
Teaches LEFT, RIGHT, MID, TRIM, CONCATENATE, and TEXT functions. Prepares raw text data for analysis and reporting.
Lesson 2 • Formula Syntax and Operators
Explains formula structure, operator precedence, and error indicators. Correct syntax is the prerequisite for every function in this chapter.
Lesson 3 • Math and Statistical Functions
Covers SUM, AVERAGE, COUNT, MIN, MAX, and ROUND families. These functions underpin virtually every business calculation in Excel.
Lesson 4 • Cell References: Relative, Absolute, Mixed
Distinguishes reference types and their behaviour when copied. Mastery here prevents the most common formula errors in practice.
Lesson 5 • Logical Functions and Conditionals
Introduces IF, AND, OR, NOT, and nested logic structures. Enables decision-based outputs essential for business rule automation.
Chapter 4HideHide detailsSee detailsData Organisation and Table Management
Data Organisation and Table Management
Lesson 1 • Sorting Data Effectively
Covers single-level and multi-level sorting by value, colour, or icon. Ordered data is the foundation for accurate analysis and reporting.
Lesson 2 • Filtering and Advanced Filtering
Teaches AutoFilter, custom filters, and Advanced Filter for complex criteria. Filtering isolates relevant subsets without altering source data.
Lesson 3 • Removing Duplicates and Data Cleanup
Uses built-in tools and formulas to identify and remove duplicate records. Clean data ensures reliable results in all subsequent analysis.
Lesson 4 • Excel Tables and Structured References
Converts ranges to Excel Tables and uses structured references in formulas. Tables auto-expand and simplify formula maintenance significantly.
Lesson 5 • Data Validation and Input Controls
Sets rules to restrict cell input to valid values, lists, or ranges. Validation prevents data entry errors before they reach analysis.
Chapter 5HideHide detailsSee detailsLookup and Reference Functions
Lookup and Reference Functions
Lesson 1 • VLOOKUP and HLOOKUP Fundamentals
Explains syntax, match types, and common errors for VLOOKUP and HLOOKUP. These functions are the entry point for all table-based data retrieval.
Lesson 2 • INDEX and MATCH for Flexible Lookups
Combines INDEX and MATCH to overcome VLOOKUP column-order restrictions. Enables left-side lookups and dynamic column selection.
Lesson 3 • MATCH, OFFSET, and Dynamic Ranges
Uses OFFSET and MATCH to build dynamic named ranges and references. Supports dashboards and reports that update automatically with new data.
Lesson 4 • XLOOKUP for Modern Data Retrieval
Introduces XLOOKUP as the unified replacement for VLOOKUP and HLOOKUP. Covers default values, search modes, and array returns.
Chapter 6HideHide detailsSee detailsPivotTables and Data Summarisation
PivotTables and Data Summarisation
Lesson 1 • Advanced PivotTable Techniques
Covers GETPIVOTDATA, multiple consolidation ranges, and data model basics. Extends PivotTable capability to enterprise-level reporting scenarios.
Lesson 2 • Summarising and Grouping Data
Applies value field settings, grouping by date or number, and calculated fields. Transforms raw counts into meaningful business metrics.
Lesson 3 • Filtering PivotTables with Slicers
Adds slicers and timelines for interactive, visual filtering of PivotTables. Enables non-technical users to explore data without modifying the report.
Lesson 4 • Building Your First PivotTable
Walks through source data requirements, field placement, and layout options. A correctly built PivotTable is the basis for all summarisation tasks.
Lesson 5 • PivotCharts and Visual Summaries
Creates PivotCharts linked to PivotTables for dynamic visual reporting. Charts update automatically when PivotTable filters or data change.
Chapter 7HideHide detailsSee detailsCharts and Data Visualisation
Charts and Data Visualisation
Lesson 1 • Dynamic Charts with Named Ranges
Links charts to dynamic named ranges so visuals update as data grows. Automates chart maintenance in live reporting environments.
Lesson 2 • Choosing the Right Chart Type
Maps data relationships to appropriate chart types including bar, line, pie, and scatter. Correct chart selection prevents misleading visual representations.
Lesson 3 • Specialised Chart Types
Introduces combo, waterfall, funnel, and sparkline charts for advanced storytelling. Expands the visual toolkit beyond standard chart categories.
Lesson 4 • Formatting Charts Professionally
Applies titles, labels, legends, gridlines, and colour themes to charts. Professional formatting ensures charts meet business presentation standards.
Lesson 5 • Creating and Editing Charts
Covers chart insertion, data source selection, and element editing. Builds the technical skills needed to produce any standard Excel chart.
Chapter 8HideHide detailsSee detailsAdvanced Functions and Automation
Advanced Functions and Automation
Lesson 1 • What-If Analysis and Scenario Tools
Uses Goal Seek, Scenario Manager, and Data Tables for sensitivity analysis. Supports evidence-based decision-making by modelling multiple outcome scenarios.
Lesson 2 • Array Formulas and Dynamic Arrays
Explains legacy array formulas and modern dynamic array functions like FILTER and SORT. Dynamic arrays spill results automatically, eliminating manual range management.
Lesson 3 • Advanced Logical and Statistical Functions
Covers SUMIFS, COUNTIFS, AVERAGEIFS, and nested IFS for multi-condition analysis. Enables precise aggregation across complex, multi-criteria datasets.
Lesson 4 • Date and Time Functions
Teaches TODAY, NOW, DATEDIF, NETWORKDAYS, and EDATE for date arithmetic. Automates deadline tracking, aging reports, and scheduling calculations.
Lesson 5 • Introduction to Macros and VBA
Records and runs simple macros, then introduces the VBA editor for basic scripting. Automation at this level eliminates repetitive formatting and data tasks.
Your valid completion certificate
This course is for you:
Administrative professional: needs to produce cleaner, faster, more reliable workplace reports.
Recent graduate: wants Excel proficiency to stand out in competitive job applications.
Small business owner: needs to track finances and operations without hiring a specialist.
Career changer: moving into analytics or operations and needs foundational data skills.
Project coordinator: manages timelines and budgets but struggles with complex spreadsheet tasks.
Accountant or bookkeeper: ready to move beyond basic entries into dynamic financial modeling.
What our students say
Your lessons are perfect. I purchased the one-year package and finally have the opportunity to follow various topics of interest without needing to change platforms... I'm grateful for everything you do, I've already recommended you to other people...
I like how the lessons are straight to the point and how I can change chapters and skip content I don't need.
I like the content and the way videos are presented and transcribed, which speeds up the process!
The platform is fast, simple to use. The diversity of content and complementary videos really help with learning.
Top qualifications
FAQ
Who is Dedika?
Is the certificate valid in South Africa?
Are the courses free?
What is the course workload?
What are the courses like?
How do the courses work?
What is the duration of the courses?
What is the cost or price of the courses?
What is an EAD or online course and how does it work?
PDF Course