This lesson provides a quick review of all the essential computer skills covered in the course, including file management, document creation, spreadsheet basics, presentation design, and key typing functions. It helps learners refresh their understanding and ensures they are ready to apply their knowledge confidently in real-life situations.
This lesson introduces commonly used keyboard shortcuts that help users navigate through documents, select text efficiently, and format content quickly. Mastering these shortcuts boosts productivity and reduces reliance on the mouse, making computer use faster and more efficient.
This lesson explains how to personalize the Quick Access Toolbar and Ribbon in Microsoft Office applications to suit your workflow. Learners will discover how to add, remove, and rearrange tools and commands for easier access, making work faster and more efficient.
This lesson introduces powerful logical functions in Excel such as IF, IFS, AND, OR, and NOT, which are used to perform decision-making tasks in spreadsheets. Learners will understand how to use these functions to create dynamic formulas that evaluate conditions and return results based on logic.
This lesson introduces key lookup and reference functions in Excel—VLOOKUP, HLOOKUP, XLOOKUP, INDEX, and MATCH. These functions help retrieve data from large tables quickly and accurately. Learners will gain the skills to search for values across rows and columns and build dynamic, data-driven spreadsheets.
This lesson covers essential text functions in Excel used for extracting, formatting, cleaning, and combining text data. Learners will explore how to manipulate text strings using functions like TEXT, LEFT, RIGHT, MID, TRIM, LEN, and CONCAT, making it easier to manage and analyze textual information in spreadsheets.
This lesson focuses on key date and time functions in Excel that help automate calendars, deadlines, and time calculations. Learners will understand how to use TODAY() and NOW() to insert current dates and times, calculate date differences with DATEDIF(), and determine working days using WORKDAY(), enhancing productivity in time-sensitive tasks.
This lesson introduces essential error-handling functions in Excel that help identify and manage formula errors. Learners will explore how to use IFERROR and ISERROR to avoid displaying confusing error messages, and how ISBLANK and ISNUMBER assist in building more reliable and user-friendly spreadsheets.
This lesson covers how to use Data Validation in Excel to control and restrict user input. Learners will discover how to create dropdown lists, set valid date ranges, and limit number entries—ensuring data accuracy, consistency, and reducing input errors in spreadsheets.
This lesson explores how to create custom data validation rules using formulas in Excel. Learners will understand how to apply logical expressions within the Data Validation tool to enforce complex rules—such as restricting inputs based on values in other cells or enforcing specific patterns—giving them more control and flexibility over data entry.
This lesson introduces Conditional Formatting in Excel, a feature that automatically formats cells based on their values. Learners will explore how to apply highlighting rules, use data bars, icon sets, and color scales to visually analyze data, spot trends, and make worksheets more interactive and informative.
This lesson teaches how to use custom formulas within Excel’s Conditional Formatting to apply dynamic formatting based on complex logic. Learners will discover how to highlight cells, rows, or columns based on conditions involving other cells, dates, text patterns, or calculations—unlocking powerful ways to visually analyze data.
This lesson introduces the Text to Columns feature in Excel, which allows users to split data in a single column into multiple columns using delimiters such as commas, spaces, or custom characters. It is especially useful for separating names, addresses, or values from imported datasets.
This lesson covers how to create and format Excel Tables to manage and analyze data more efficiently. Learners will explore features like automatic filtering, sorting, table styles, and structured references, enabling clearer presentation and better control over growing datasets.
This lesson introduces Structured References, a feature in Excel Tables that allows you to use table and column names in formulas instead of traditional cell addresses. It makes formulas easier to read, maintain, and automatically updates them when the table grows—ideal for working with dynamic data.
This lesson introduces Pivot Tables, a powerful Excel feature used to quickly summarize, analyze, and explore large datasets. Learners will understand how to create a Pivot Table, drag fields into rows, columns, values, and filters, and gain insights using automatic totals, grouping, and drill-down capabilities—ideal for reporting and decision-making.
This lesson focuses on how to use Pivot Tables to summarize, group, and analyze data effectively. Learners will explore how to calculate totals, averages, counts, and percentages within Pivot Tables, enabling clear insights from large datasets without complex formulas.
This lesson explores how to visualize Pivot Table data using Pivot Charts and enhance interactivity with dashboard elements like Slicers and Timelines. Learners will discover how to create dynamic, easy-to-read dashboards for data-driven decision-making and reporting.
This lesson introduces learners to advanced chart types in Excel—such as Combo, Waterfall, Pareto, and Histogram—used for deeper data visualization and analysis. These charts help in showcasing relationships, identifying trends, and explaining variations more effectively in professional reports and dashboards.
This lesson covers how to create interactive and dynamic charts in Excel using formulas (like OFFSET, INDEX) and dropdown lists (Data Validation). These charts update automatically based on user selections, allowing you to build flexible dashboards and reports that adapt to different data views without manual editing.
This lesson teaches how to import data into Excel from various sources such as other Excel workbooks, CSV files, and web pages. Learners will understand how to use Excel’s built-in tools like Get & Transform (Power Query) to clean, combine, and manage imported data for analysis.
This lesson introduces essential techniques for cleaning and transforming raw data using Excel tools like Power Query, Text Functions, and Find & Replace. Learners will understand how to remove duplicates, fix formatting issues, split or merge columns, handle missing values, and prepare data for accurate analysis and reporting.
This lesson explains how to keep your data up to date in Excel using Data Refresh options. Learners will explore how to refresh manually or automatically when importing from external sources (Excel, CSV, Web, Power Query), ensuring reports and dashboards reflect the latest available data without reloading files.
This lesson guides learners through creating interactive dashboards in Excel using tools like PivotTables, PivotCharts, Slicers, Timelines, and dynamic charts. Students will learn how to design visually appealing dashboards that respond to user input, making data analysis easier, more engaging, and decision-friendly.
This lesson introduces Form Controls in Excel, such as drop-down lists, checkboxes, and option buttons, which are used to create interactive reports and dashboards. Learners will understand how to insert, link, and use these controls to make worksheets more dynamic and user-friendly.
This lesson explains how to link charts with filters such as Slicers, Timelines, and drop-downs to create interactive visualizations in Excel. Learners will discover how user selections can automatically update charts, enabling dynamic reports and dashboards that respond to real-time input.
— 28 February 2017
