Project Description


Welkin Course Codes: SS0I, SX3I, SX6I

Course Features

This course is designed for learners with no experience in Microsoft Excel, or those who have begun using Excel in their work, but would like to acquire more knowledge and skills in basic Excel operation. In the course you will learn:

  • Basic operation of workbooks, worksheets, rows, columns and cells.
  • Creating worksheets for entering and organizing data in an efficient way and to facilitate multi-workbook processing and co-authoring
  • Using Excel functions to summarize data
  • Searching information effectively through sorting and filtering
  • Creating headers and footers and customizing print setup
  • Working with multiple documents

Learn from the Experts

Get Your Skills Certified

Certify your Excel skills with Microsoft Office Specialist Excel certification. The certification is not a requirement for course completion but we highly recommend you to get your skills professionally recognized.
Remark: The course fee does not include the certification exam.

Further Study

After completing this course you may further develop your knowledge and skills with the course Microsoft Excel for Advanced Users.

Course Fee


Course Duration

6 Hours

Course Prerequisites

Course participants should have a working knowledge of Microsoft Windows.

Title of Award

Upon successful completion of the course, students will receive a Certificate of Achievement for the course.

Schedule & Online Enrolment

Sign up for your course by clicking the Enrol button and proceed to Checkout to finish course registration.

Microsoft Excel 2016 for Beginners
Course No. 課程編號Info. 語言/系統/地點Start 開課日End 完課日Day(s) 上課日Time 上課時段Duration 課程長度Enrol 報名
SX6I-6D18EEnglish / PC / MongKok18/0918/09SAT1000-1300;1400-17006 hours / 2 sessions20210918


SX6I-12C18KCantonese / PC / MongKok18/1019/10MON,TUE1900-22006 hours / 2 sessions20211018


SX6I-21101KCantonese / PC / MongKok19/1019/10TUE0930-1230;1400-17006 hours / 2 sessions20211019


SX6I-21111KCantonese / PC / MongKok05/1105/11FRI0930-1230;1400-17006 hours / 2 sessions20211105


SX6I-35C17KCantonese / PC / MongKok17/1119/11WED,FRI1900-22006 hours / 2 sessions20211117


SX6I-21121KCantonese / PC / MongKok07/1207/12TUE0930-1230;1400-17006 hours / 2 sessions20211207


SX6I-23C14KCantonese / PC / MongKok14/1215/12TUE,WED1900-22006 hours / 2 sessions20211214


Microsoft Excel 2013 for Beginners
Course No. 課程編號Info. 語言/系統/地點Start 開課日End 完課日Day(s) 上課日Time 上課時段Duration 課程長度Enrol 報名
Microsoft Excel 2010 for Beginners
Course No. 課程編號Info. 語言/系統/地點Start 開課日End 完課日Day(s) 上課日Time 上課時段Duration 課程長度Enrol 報名

Microsoft Excel is the world’s most widely-used spreadsheet application. It is a necessary tool for office professionals in any fields of work. It allows the easy manipulation and analysis of data, and is therefore a very useful tool in preparing financial budgets and forecasts. You can also use Excel to produce professional-looking charts and reports.
Microsoft Excel for Beginners is a 6-hour course targeting beginners as well as intermediate users. It begins with the necessary basic skills and covers a wide range of intermediate level topics. No matter you are new to Excel or you know a little bit of Excel, this is the right course for you.

  1. Microsoft Excel Essential Features
    • The Excel Ribbon
    • Starting a New Workbook
    • Find Recent Files
    • Stay Connected
    • Set your Preferences
    • Share your Work with Others
  2. Managing Excel Workbooks
    • Creating a New Workbook
    • Save your Work
    • Save as PDF
    • Save an Excel 2016 Workbook for Compatibility with Earlier Versions of Excel
    • Share your Workbook with Others
    • Save Documents Online
  3. Managing Excel Worksheets
    • Enter Data in a Worksheet
    • Selecting Worksheet
    • Moving Around a Worksheet
  4. Manipulating Cells and Cell Content
    • Inserting Cells
    • Wrap Text in a Cell or Group of Cells
    • Merge Cells and Split Merged Cells
    • Finding and Replacing Cell Items
    • Working with Columns and Rows
    • Freeze Panes to Lock the First Row or Column
  5. Selecting, Copying, Moving, and Deleting Cell Contents
    • Select Cells, Ranges, Rows, or Columns on a Worksheet
    • Copy and Paste Format to Other Cells
    • Using Paste Options
    • Using the Paste Special Dialog Box
    • Moving Cells and Ranges
    • Clearing and Deleting Cells
    • Viewing Worksheets
  6. Worksheet Formatting and Management
    • Formatting Text Entries
    • Formatting Values
    • Rotate or Align Cell Data
    • Insert or Remove Cell Borders
    • Using Themes
    • Apply, Create, or Remove a Cell Style
  7. Filling and Entering Series
    • Using the Fill Handle
    • Display or Hide the Fill Handle
    • Creating Custom Fill Lists
    • Creating Custom Series
    • Using Flash Fill
    • Turn Flash Fill on
  1. Printing Worksheets
    • Headers and Footers
    • Using the Page Layout Commands
    • Set Page Margins before Printing a Worksheet
    • Print a Worksheet in Landscape or Portrait Orientation
    • Scale the Sheet Size for Printing
    • Set a specific Print Area
    • Inserting Page Breaks
    • Print the Top Row on Every Page
    • Working on the Print Page
  2. Overview of Formulas
    • Parts of an Excel Formula
    • Using Constants in Excel Formulas
    • Using Calculation Operators in Excel Formulas
    • Using Functions and Nested Functions in Excel Formulas
    • Using References in Excel Formulas
    • Fill a Formula down into Adjacent Cells
    • Copy and Paste a Formula to another Cell or Worksheet
    • Using Names in Excel Formulas
  3. Entering a Function in a Cell
    • Using AutoSum
    • Using the Status Bar
    • Using References in Formulas
    • Difference between Absolute, Relative and Mixed References
  4. Working with Function
    • Statistical Functions
    • Date & Time Functions
  5. Detect Errors in Formulas
    • Common Error Messages
    • Using the Auditing Tools
    • Correct Common Formula Errors one at a time
  6. Working with Chart
    • Creating a Chart
    • Change the Color or Style of a Chart
    • Add Axis Titles to a Chart
    • Add Data Labels to a Chart
    • Add a Data Series to a Chart
    • Change the Data Series in a Chart
    • Rename a Data Series
    • Add a Chart Legend
    • Copy an Excel 2016 Chart to another Office Application
    • Analyze Trends in Data using Sparklines
  1. Getting Started with Excel
    • What is Excel?
    • Starting Excel 2013
    • Viewing the Excel Window
    • Working with the Ribbon and Toolbars
    • Choosing Dialog Box Options
    • Creating a Blank Workbook
    • Opening a template from the File tab
    • Opening an Existing Workbook
    • Moving Around the Workbook
    • Viewing two or more worksheets or workbooks at the same time
    • Saving a Workbook
    • Saving a workbook in another file format
    • Save an Excel 2013 workbook for compatibility with earlier versions of Excel
    • Recovering unsaved a Workbook
    • Closing workbooks or workbook windows
  2. Basic Workbook Skills
    • Select specific cells or ranges
    • Selecting Rows, Columns, and Special Ranges
    • Enter data manually in worksheet cells
    • Fill data automatically in worksheet cells
    • Using Flash Fill
    • Split a column of data based on what you type
    • Editing Cell Contents
    • Understanding How Excel Copy and Pastes Data
    • Finding and Replacing
    • Checking Spelling
    • Adding word to your dictionary
    • Undoing and Redoing an Action
  3. Modifying Worksheets and Workbooks
    • Inserting and Deleting a Worksheet
    • Moving and Copying a Worksheet
    • Hiding and Unhiding Worksheets and Workbooks
    • Hiding and Unhiding a Column or Row
    • Inserting and deleting a Column or Row
    • Adjusting Column Width and Row Height
    • Freezing and Unfreezing a Columns or Rows
    • Zooming the View In and Out
  4. Font Formatting
    • Format text in cells
    • Change font style, size, or color
    • More font formatting in font dialog box launcher
    • Clear formatting
  5. Alignment Formatting
    • Align text in a cell
    • Undo alignment changes
  6. Numbers Formatting
    • Format numbers as currency
    • Format a date the way you want
    • Display numbers as percentages
    • Creating or deleting a custom number format
  7. Formatting a Worksheet
    • Applying a cell Styles
    • Copy formatting using the Format Painter
  8. Creating charts from start to finish
    • Create your chart
    • Available chart types
    • Creating a chart
    • Fine-tune your chart
    • Change the data in your chart
    • Save a custom chart as a template
  1. Analyzing trends in data using sparklines
    • Analyze trends in data using sparklines
    • Customize your sparklines
  2. Sorting data in a worksheet
    • Select the data that you want to sort
    • Sort quickly
    • Sort by specifying criteria
    • Sorting data by icon set
  3. Use AutoFilter to filter your data
    • Filter a range of data
    • Remove a filter
    • Filtering data by icon set
  4. Understanding Tables
    • Overview of Excel tables
    • Learn about the elements of an Excel table
    • Creating a table in a worksheet
    • Table features that you can use to manage table data
    • Deleting a table without losing the data or table formatting
  5. Working with Formulas and Functions
    • About formulas
    • Using calculation operators in formulas
    • Using functions and nested functions in formulas
    • The syntax of functions
    • Entering functions
    • Using references in formulas
    • The difference between absolute, relative and mixed references
    • Use Formula AutoComplete
    • Excel functions
  6. Define and use names in formulas
    • Defining a name for a cell or cell range on a worksheet
    • Manage names by using the Name Manager dialog box
    • Change a name
    • Delete one or more names
    • Defining and using names
    • Learn about syntax rules for names
    • Use AutoSum to sum numbers
    • Use AutoSum to quickly find the average
    • Calculating Totals with Quick Analysis
    • Copy cell values, not formulas
    • Use error checking to detect errors in formulas
  7. Viewing and Printing Worksheets and Workbooks
    • Previewing a Worksheet
    • Fine-tuning pages before printing
    • Change Margins
    • Change Page Orientation
    • Change Paper Size
    • Set a print area
    • Create manual page breaks in a worksheet
    • Add or remove a sheet background
    • Setting Print Titles
    • Making a worksheet fit the printed page
    • Printing row and column headings
    • Adding Headers and Footers
    • Removing header and footers
    • Printing a Worksheet and Workbook
  1. Using Excel 2010
    • Starting the Excel program
    • The Excel cell referencing system
    • Default text and number alignment
    • Entering a date
    • Worksheets and Workbooks
    • Saving a workbook
    • Closing a workbook and exiting the Excel program
    • Creating a new workbook
    • Opening a workbook
    • Switching between workbooks
    • Saving a workbook using another name
  2. Selection techniques
    • Why are selection techniques important?
    • Selecting a cell
    • Selecting a range of connecting cells
    • Selecting a range of non-connecting cells
    • Selecting the entire worksheet
    • Selecting a row
    • Selecting a column
  3. Manipulating rows and columns
    • Inserting rows into a worksheet
    • Inserting columns into a worksheet
    • Deleting rows within a worksheet
    • Deleting columns within a worksheet
    • Modifying column widths
    • Modifying column widths using ‘drag and drop’
    • Automatically resizing the column width to fit contents
    • Modifying row heights
  4. Manipulating cells and cell content
    • Copying a cell or range contents within a workbook
    • Deleting cell contents
    • Moving the contents of a cell or range within a workbook
    • Undo and Redo
    • AutoFill
    • Copying a data range using AutoFill
    • Sorting a cell range
    • Searching and replacing data
  5. Worksheets
    • Switching between worksheets
    • Renaming a worksheet
    • Deleting a worksheet
    • Copying a worksheet within a workbook
    • Moving a worksheet within a workbook
    • Copying or moving worksheets between workbooks
  6. Manipulating Worksheets
    • Splitting a Window
    • Hiding rows
    • Hiding columns
    • Hiding worksheets
    • Un-hiding rows
    • Un-hiding columns
    • Un-hiding worksheets
  7. Font formatting
    • Font formatting options
    • Font type
    • Font size
    • Bold, italic, underline formatting
    • Cell border formatting
    • Formatting the background colour
    • Formatting the font colour
  8. Alignment formatting
    • Horizontally aligning contents in a cell range
    • Centring a title over a cell range
    • Cell orientation
    • Text wrapping within a cell
    • Aligning cell contents vertically
    • Format Painter
  1. Number formatting
    • Number formatting
    • Decimal point display
    • Applying and removing comma style formatting (to indicate thousands)
    • Currency symbol
    • Date styles
    • Percentages
  2. Freezing
    • Freezing row and column titles
  3. Formulas
    • Creating formulas
    • Operators
    • Using operators in formulas
    • Formula error messages
    • Relative cell referencing within formulas
    • Absolute cell referencing within formulas
  4. Functions
    • What are functions?
    • Common functions
    • Sum function
    • Average function
    • Max function
    • Min function
    • Count function
    • The COUNTA function
    • The COUNTBLANK function
    • What are ‘IF functions’?
    • Using the IF function
  5. Functions and Formulas
    • Nested functions.
    • Consolidating data using a 3-D reference sum function.
    • Mixed references within formulas.
  6. Named Ranges
    • Naming cell ranges.
    • Removing a named range.
    • Named cell ranges and functions.
  7. Charts
    • Inserting a column chart
    • Inserting a line chart
    • Inserting a bar chart
    • Inserting a pie chart
    • Resizing a chart
    • Deleting a chart
    • Chart title or labels
    • Changing the chart background colour
    • Changing the column, bar, line or pie slice colours in a chart
    • Modifying the legend fill colour
    • Changing the chart type
    • Modifying charts using the Layout tab
  8. Setup & Printing Issues
    • Horizontally aligning contents in a cell range
    • Worksheet margins
    • Worksheet orientation
    • Worksheet page size
    • Headers and footers
    • Header and footer fields
    • Scaling your worksheet to fit a page(s)
    • Displaying gridlines when printing
    • Printing titles on every page when printing
    • Printing the Excel row and column headings
    • Spell checking
    • Previewing a worksheet
    • Viewing workbooks side by side
    • Zooming the view
    • Printing options
    • Setting the number of copies to print
    • Selecting a printer
    • Selecting individual worksheets or the entire workbook
    • Selecting which pages to print
    • Collation options
    • Paper size
    • Margins
    • Scaling
    • Printing
  1. You can enrol this course by our online system, or call (852) 3605 3322 for reservation.

You may also be interested in