This module introduces learners to the fundamentals of working with Excel, including launching the application, navigating worksheets, entering data, and using features like the fill handle for efficiency. It focuses on essential skills such as selecting cells, managing multiple sheets, and distinguishing between text and numeric entries.

This module covers essential Excel formatting techniques, including resizing rows and columns, using the Format Cells dialog box, and applying cell styles. Learners will gain the ability to customize worksheet appearance and manage hidden data effectively.

This module focuses on mastering Excel's printing features, including page layout, headers, footers, and print settings. Learners will gain the skills to format and print worksheets professionally and effectively. The content covers adjusting page breaks and optimizing reports for clarity and readability.

This module equips learners with essential Excel editing skills, focusing on modifying worksheets efficiently while preserving data integrity. It covers techniques for selecting ranges, editing data, managing multiple sheets, and using Find and Replace tools. Learners will gain practical knowledge to handle dynamic spreadsheet environments effectively.

This module equips learners with essential skills for constructing and managing Excel formulas, including using built-in functions, editing complex formulas, and handling external references and recalculation settings. It focuses on improving accuracy and efficiency in data analysis through formula management techniques.

This module covers essential spreadsheet skills, including copying formulas with different reference types, using range names, building array formulas, and troubleshooting errors. Learners will gain the ability to create accurate and efficient worksheets by mastering these techniques.

This module teaches learners how to construct and apply date and time formulas in Excel. It covers essential functions like TODAY, NOW, DATE, and advanced tools such as WEEKDAY and YEARFRAC to analyze and manipulate date data. Learners will gain practical skills for calculating elapsed time and managing date-related computations in spreadsheets.

This module provides an in-depth exploration of Excel's financial functions, focusing on investment analysis, project evaluation, and asset depreciation calculations. Learners will gain practical skills in applying these functions to real-world financial scenarios and understand how to interpret the results for informed decision-making.

This module covers essential math and trigonometric functions used in spreadsheet applications, focusing on operations like rounding, product calculation, power, square root, and conditional summation. Learners will gain practical skills in applying these functions to solve real-world business and engineering problems.

This module introduces essential Excel statistical functions for data analysis, including AVERAGE, MAX, MIN, and various counting functions like COUNT, COUNTBLANK, and COUNTIF. Learners will gain practical skills in using these tools to extract insights and support decision-making from datasets.

This module explores the use of lookup functions in Excel, including XLOOKUP, HLOOKUP, and VLOOKUP, to automate data matching and improve data retrieval efficiency. Learners will gain practical skills in designing formulas to return single values from lookup tables and understand the differences between horizontal and vertical lookups.

This module explores the use of logical functions in Excel to build decision-making formulas and handle errors effectively. Learners will gain skills in structuring complex conditions and improving formula reliability through functions like IF, AND, OR, and NOT. The focus is on practical application in real-world spreadsheet scenarios.

This module teaches how to manipulate and format text within spreadsheets using functions and formulas. Learners will discover techniques for combining text, adjusting case, and enhancing data clarity. The content focuses on practical applications for organizing and transforming textual data efficiently.

This module covers the essential skills for creating, formatting, and editing charts in Excel to improve data visualization. Learners will learn how to select appropriate chart types, customize layouts, and make effective visual presentations of worksheet data.

This module teaches learners how to enhance worksheets with various graphic elements, including shapes, icons, WordArt, and SmartArt. It covers the insertion and customization of images, the use of text boxes and callouts, and the integration of graphical tools to improve data visualization and presentation clarity.

This module covers the essential skills for creating, editing, and organizing data in Excel tables. Learners will gain hands-on experience with sorting, filtering, and subtotalling data, as well as importing data from external databases. The content is designed to enhance data management proficiency in real-world scenarios.

This module covers techniques for securing Excel workbooks and worksheets using passwords and protection features. Learners will gain skills in preventing unauthorized changes, managing data entry in protected sheets, and protecting the overall structure of a workbook.

This module teaches learners how to use Excel tools like data tables, scenarios, and goal seek to perform what-if analysis. It covers techniques for testing different input values and understanding their impact on outcomes, enhancing decision-making skills through data exploration.

This module teaches learners how to create, modify, and enhance PivotTables in Excel to effectively summarize and analyze data. It covers techniques such as pivoting fields, changing summary functions, and adding calculated fields to gain deeper insights. Learners will also learn how to create PivotCharts to visually represent data summaries.

This module teaches how to use macros in Excel to automate repetitive tasks, improve efficiency, and customize the user interface with custom buttons. Learners will explore recording macros, using relative cell references, and assigning macros to the Quick Access Toolbar.

This module provides an in-depth exploration of the Visual Basic Editor (VBE) in Excel, focusing on editing macros, adding user input dialog boxes, and creating custom functions to enhance automation and functionality. Learners will gain practical skills in VBA programming and how to integrate custom solutions into their Excel workflows.

This module covers essential Excel features focused on data visualization and formatting. Learners will discover how to effectively use charts, the Ribbon interface, and Backstage View to enhance and present data. The content provides practical skills for creating professional-looking spreadsheets quickly.

This module provides practical strategies for mastering Excel, focusing on efficiency techniques such as using AutoFill, freezing panes, and array formulas. Learners will gain hands-on experience in optimizing worksheet design and data management. The content emphasizes real-world applications to enhance productivity and accuracy in Excel tasks.