黑料网大事记
Business School

Training modules

Integrated the 黑料网大事记 Excelerate Program into any of your course across disciplines that require Excel skills.

Personalise
Business School Quad Students Postgraduate

Each 黑料网大事记 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聽
    • 鈥疭elect multiple cells, rows/columns聽
    • 鈥疭elect all聽
    • 鈥疭elect to a particular row聽
    • 鈥疭elect all missing data/blank聽
    • 鈥疷苍诲辞

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 鈥淩andom 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鈥檙e here to help.
Send us an email