Training modules
Integrated the 91色情片 Excelerate Program into any of your course across disciplines that require Excel skills.
Each 91色情片 Excelerate Program module incorporates comprehensive learning materials.
Demonstration video
Practice datasets
Revision summaries
Flashcards
Allowing students to be guided through Excel functions, practice and apply their skills, and providing reference materials to reinforce learning.
Materials can be downloaded from the modules below.
Explore the modules
- Cell selection
- View and formatting
- Auto and Flash Fill
- Data entry and manipulation
- Analysis
- Advanced Problem Solving
- Output
- Excel and AI
-
Topics
- Customise Quick Access Toolbar to add common functions and improve efficiency
-
Topics
- Freezing Panes
- Hide/Unhide rows/columns聽
- Groups
- Zoom in and out
-
Topics
- Formatting Cells: colour, font, sizing, wrap text, auto fit聽
- Conditional Formatting
- Format Painter
-
Topics
- Entering data: currency, date, number
-
Topics
- Data validation
-
Topics
- Importing data table from other sources
-
Topics
- Inserting and deleting rows/columns
-
Topics
- Using Find and Replace聽
- Using "Text to Columns"
- Merging and Splitting Cells
- Combining text into one cell聽
- Removing duplicates
- Stack and merge dataset
-
Topics
- Data sorting and filtering
-
Topics
- Converting String/Numeric variable
- Upper/Lower Case聽
-
Topics
- Creating 鈥淩andom Numbers鈥
-
Topics
- Inserting hyperlinks
- Inserting notes and comments聽
-
Topics
- Common functions: COUNT/SUM/AVERAGE/MAX/MIN
-
Topics
- IF statement (and COUNTIF, SUMIF, AVERAGEIF, COUNTIFS, SUMIFS, AVERAGEIFS)
-
Topics
- Application of IF statement
-
Topics
- Boolean Operator (AND, OR, NOT)
-
Topics
- Using VLOOKUP, HLOOKUP, INDEX, MATCH
-
Topics
- Using Date and Time Functions
-
Topics
- Frequency
- Percentile and Quartile
- Median/Mode
- Variances and Standard Deviation聽
-
Topics
- Data Analysis Toolpak: Descriptive Statistics
- Correlation
- Covariance
-
Topics
- Identifying the standard errors of a variable
-
Topics
- Using the norm distribution command and inverse normal distribution command
- Using the t-distribution command and inverse t-distribution command
-
Topics
- Confidence Intervals
-
Topics
- Hypothesis Test
-
Topics
- Using CHISQ.INV.RT and CHISQ.DIST.RT commands
-
Topics
- Simple Linear Regression
-
Topics
- Multiple Linear Regression
-
Topics
- Offset function
-
Topics
- Simple Macros (record, name, edit)
-
Topics
- Iterative calculations (circular references); Solver
-
Topics
- Consolidate data: summarise data from multiple ranges
- What-if analysis using Goal Seek and Scenario Manager
- Use AND(), IF() and NPER() functions to forecast data
-
Topics
- Trace precedence and dependence
- Use Watch Window to monitor cells and formulas
- Use error checking rules to validate formulas
- Evaluate formulas
-
Topics
- Print Area
- Scaling
- Page Orientation聽
- 惭补谤驳颈苍听
- Print Titles, Headings, Header & Footer, Page Breaks
- Print as PDF
-
Topics
- Inserting an Excel chart/table to Word and PowerPoint (linked or non-linked)
- Formatting
-
Topics
- Sharing Excel workbooks in MS Teams and collaborating on Excel workbooks
-
Topics
- Prepare workbooks for collaboration (restrict editing, protect worksheets and cell ranges, protect workbook structure)
-
Topics
- Help learners use AI tools such as ChatGPT or Microsoft Copilot (chat interface) to find solutions, learn functions, and combine formulas effectively.
-
Topics
- (For Microsoft 365 Copilot subscribers) Using Copilot agent mode and introduce the new =COPILOT() function that allows users to directly create results in Excel using natural-language prompts.
