鶹madou
Business School

Training modules

Integrated the 鶹madou Excelerate Program into any of your course across disciplines that require Excel skills.

Personalise
Business School Quad Students Postgraduate

Each 鶹madou 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

Excel Fundamentals

Module 1: Cell selection

  • Topics

    • Select cell, rows/columns 
    •  Select multiple cells, rows/columns 
    •  Select all 
    •  Select to a particular row 
    •  Select all missing data/blank 
    •  UԻ

Excel Fundamentals

Module 2: View and formatting

  • 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

Excel Fundamentals

Module 3: Auto and Flash Fill

  • Topics

    • Auto Fill 
    • Flash Fill

Excel Fundamentals

Module 4: Data entry and manipulation

  • 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 

Analysis

Module 5: Basic Functions

  • 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

Analysis

Module 5: Statistical 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

Analysis

Module 5: Tables and charts

  • Topics

    • PivotTable

  • Topics

    • PivotChart

  • Topics

    • Charts
    • Histogram

  • Topics

    • Bar charts

  • Topics

    • Pie charts

  • Topics

    • Line charts

  • Topics

    • Scatter plot

Excel Fundamentals

Module 6: Print

  • Topics

    • Print Area
    • Scaling
    • Page Orientation 
    • Ѳ
    • Print Titles, Headings, Header & Footer, Page Breaks
    • Print as PDF

Excel Fundamentals

Module 6: Use Excel output

  • 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

Feeling a little lost? We’re here to help.
Send us an email