Course Details
  • Duration

    Beginner Level | 3 Months

    Intermediate Level | 3 Months

    Advanced Level | 3 Months

  • Start Date

    10th February 2025

  • Format

    In Person

  • Location

    African Christian University

  • Fees

    Application Fee | K100

    Course Fee K3,000 | Flexible Payments

    Please note that both the application fee and course fee are charged for each individual level of study

  • For more information, please contact the registrar at registrar@acu-zambia.com

  • Apply Now

Mastering Excel

In today’s data-driven world, Microsoft Excel is an essential tool for professionals across industries. While basic proficiency in Excel enables users to perform standard tasks, advanced knowledge unlocks the full potential of the software, allowing for greater efficiency, accuracy, and insights. This course is designed for beginners and intermediates who want to develop expertise in excel’s advanced features and applications.

By focusing on topics such as advanced formulas and functions, data analysis tools, pivot tables, macros, and automation, this course equips participants with the skills needed to manage complex datasets, streamline workflows, and make data-informed decisions. These competencies are invaluable for roles in finance, business management, analytics, and other fields requiring high-level data management and reporting.

Through hands-on activities, real-world scenarios, and problem-solving exercises, this course enables learners to harness Excel’s advanced capabilities, driving productivity and enhancing professional value in their respective industries.

Outline
Beginner level

Starts : 10th February 2025

Introduction to Excel.

  • Overview of the Excel interface and navigation
  • Understanding workbooks and worksheets
  • Data entry basics (text, numbers, and dates)
  • Introduction to basic functions and formulas
  • Basic Functions and Formatting.

  • Performing simple calculations (addition, subtraction)
  • Introduction to functions (SUM, AVERAGE, COUNT)
  • Formatting cells for better presentation (fonts, colors)
  • Using formatting tools (alignments, borders, conditional formatting)
  • Chart Creation and Workbook Management.

  • Introduction to charts (bar, line, pie) and their uses
  • Creating and customizing charts (titles, axis labels)
  • Saving workbooks in different formats and printing settings
  • Final project: Creating a personal budgeting workbook
  • Intermediate Level

    Start date to be announced

    Intermediate Functions

  • Logical functions (IF, AND, OR)
  • Lookup functions(VLOOKUP, HLOOKUP)
  • Nested functions for complex calculations
  • Introduction to text functions (CONCATENATE, LEFT, RIGHT)
  • Data Management and Visualization

  • Sorting and filtering data (basic and advanced)
  • Creating and managing tables
  • Advanced charting techniques (customizing chart elements)
  • Introduction to PivotTables (creating, filtering, sorting)
  • Data Analysis Tools

  • Introduction to charts (bar, line, pie) and their uses
  • Creating and customizing charts (titles, axis labels)
  • Saving workbooks in different formats and printing settings
  • Final project: Creating a personal budgeting workbook
  • Advanced level

    Start date to be announced

    Advanced Formulas and Functions

  • Using array formulas
  • Advanced statistical functions (STDEV, MEDIAN, MODE)
  • Introduction to advanced lookups (INDEX and MATCH)
  • Introduction to basic functions and formulas
  • Basic Functions and Formatting.

  • Performing simple calculations (addition, subtraction)
  • Introduction to functions (SUM, AVERAGE, COUNT)
  • Formatting cells for better presentation (fonts, colors)
  • Creating matrix calculations and scenarios
  • Collaboration and Advanced Visualization

  • Sharing workbooks for collaboration
  • Reviewing and tracking changes in shared workbooks
  • Advanced chart types (bubble, waterfall) and their applications
  • Final project: Creating a comprehensive financial report using advanced techniques
  • Font Awesome 5 Icons Font Awesome Icons