Training modules
Integrated the UNSW Excelerate Program into any of your course across disciplines that require Excel skills.
Each UNSW 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
- Functions
- Tables and charts
- Output
-
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 “Random 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
- Print Area
- Scaling
- Page Orientation
- Margin
- 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
