This module explores the use of conditional formatting in Excel to enhance data visualization. Learners will discover how to apply tools like data bars, color scales, and icon sets to make data more intuitive and visually engaging. The module also covers best practices for customizing these features to suit different datasets and reporting needs.

This module covers essential skills for formatting and printing Excel sheets, including setting print areas, managing page breaks, fitting columns, and configuring print titles. Learners will gain the ability to produce professional and well-organized printed reports from Excel spreadsheets.

This module introduces the foundational concepts of formulas and functions in Excel, covering their roles, differences, and practical applications. Learners will explore various function types and gain hands-on experience in creating and using basic formulas. The content emphasizes how to efficiently perform calculations and automate tasks within spreadsheets.

This module covers essential Excel functions such as SUM, AVERAGE, COUNT, COUNTA, MAX, and MIN, teaching learners how to perform calculations, analyze data, and apply these tools in real-world business scenarios.

This module covers essential Excel formula referencing techniques, including relative and absolute references, named ranges, and best practices for managing and applying these concepts in real-world scenarios. Learners will gain the ability to create dynamic and maintainable spreadsheets through practical examples and knowledge checks.

This module covers advanced logical functions and operators in Excel, including IF, AND, OR, SUMIF, AVERAGEIF, and more. Learners will gain skills in performing complex logical tests, aggregating data based on conditions, and using wildcards and multiple criteria in formulas. The module also includes practical assignments to reinforce real-world Excel problem-solving.

This module equips learners with essential and advanced Excel text functions to manipulate, clean, and format text data efficiently. You'll gain hands-on experience with functions like LEFT, RIGHT, MID, CONCAT, and TEXTBEFORE, as well as learn how to handle delimiters, case transformations, and text formatting. By the end, you'll be able to work confidently with complex text data in Excel.

This module equips learners with essential skills to work with date and time functions in Excel. It covers extracting and manipulating date components, calculating time intervals, and using specialized functions for business data analysis. Learners will gain practical knowledge applicable to real-world spreadsheet tasks.

This module provides a comprehensive overview of lookup functions in Excel, focusing on VLOOKUP and XLOOKUP. Learners will explore how to use these functions for data retrieval, understand their limitations, and apply them in various business scenarios. The course also covers advanced techniques like wildcards, approximate matches, and horizontal datasets.

This module covers essential Excel rounding functions, including ROUND, ROUNDUP, ROUNDDOWN, MROUND, CEILING, and FLOOR. Learners will gain practical skills in applying these functions to solve real-world data manipulation problems.

This module explores the use of nested formulas in Excel, focusing on building, analyzing, and applying complex functions for advanced data manipulation. Learners will gain hands-on experience in constructing multi-step calculations and leveraging tools like ChatGPT to enhance their workflow. The content emphasizes logical reasoning and precision in formula design for real-world applications.

This module explores advanced Excel functions that allow users to clean, reshape, and manipulate data efficiently. Learners will discover tools like UNIQUE, TOCOL, TOROW, VSTACK, HSTACK, and data pipeline functions to streamline data processing without relying on pivot tables. By the end, they will be able to handle complex datasets with greater flexibility and precision.

This module explores various types of charts used in Excel, including column, bar, line, area, and pie charts. Learners will gain skills in creating, customizing, and interpreting different chart formats to effectively visualize data trends and comparisons. The content emphasizes selecting the right chart type for specific data scenarios.