Microsoft Excel for Beginners (2010/2013/2016) 2017-09-15T13:55:46+00:00

Project Description

Loading...
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 Professional Recognition

mos-certificate

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

$960

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
Enquiry/Booking
COURSE INFODATES(dd/mm)TIMEDURATIONDAY(S)AMOUNT
SS0I-6A30K
 Mongkok
 Cantonese / PC
30/9~7/10
1000-13006 hrs/
2 sessions
SAT960.00
SS0I-6A7E
 Central
 English / PC
7/10~14/10
1000-13006 hrs/
2 sessions
SAT960.00
SS0I-17101K
 Mongkok
 Cantonese / PC
31/10~31/10
0930-1230
1400-1700
6 hrs/
2 sessions
TUE960.00
SS0I-17111C
 Central
 Cantonese / PC
7/11~7/11
0930-1230
1400-1700
6 hrs/
2 sessions
TUE960.00
SS0I-13C73C
 Central
 Cantonese / PC
13/11~15/11
1900-22006 hrs/
2 sessions
MON, WED960.00
SS0I-45C16K
 Mongkok
 Cantonese / PC
16/11~17/11
1900-22006 hrs/
2 sessions
THU, FRI960.00
SS0I-45C23E
 Central
 English / PC
23/11~24/11
1900-22006 hrs/
2 sessions
THU, FRI960.00
SS0I-17121K
 Mongkok
 Cantonese / PC
5/12~5/12
0930-1230
1400-1700
6 hrs/
2 sessions
TUE960.00
SS0I-6A70C
 Central
 Cantonese / PC
30/12~6/1
1000-13006 hrs/
2 sessions
SAT960.00
Microsoft Excel 2010 for Beginners
Complete your Enrol
How to enrol/pay online
COURSE INFODATES(dd/mm)TIMEDURATIONDAY(S)AMOUNT
SX3I-17091K
 Mongkok
 Cantonese / PC
27/9~27/9
0930-1230
1400-1700
6 hrs/
2 sessions
WED960.00
SX3I-6D7C
 Central
 Cantonese / PC
7/10~7/10
1000-1300
1400-1700
6 hrs/
2 sessions
SAT960.00
SX3I-17101C
 Central
 Cantonese / PC
12/10~12/10
0930-1230
1400-1700
6 hrs/
2 sessions
THU960.00
SX3I-12C33C
 Central
 Cantonese / PC
23/10~24/10
1900-22006 hrs/
2 sessions
MON, TUE960.00
SX3I-51C27E
 Central
 English / PC
27/10~30/10
1900-22006 hrs/
2 sessions
MON, FRI960.00
SX3I-24C31K
 Mongkok
 Cantonese / PC
31/10~2/11
1900-22006 hrs/
2 sessions
TUE, THU960.00
SX3I-17111K
 Mongkok
 Cantonese / PC
30/11~30/11
0930-1230
1400-1700
6 hrs/
2 sessions
THU960.00
SX3I-45C7C
 Central
 Cantonese / PC
7/12~8/12
1900-22006 hrs/
2 sessions
THU, FRI960.00
SX3I-6A9K
 Mongkok
 Cantonese / PC
9/12~16/12
1000-13006 hrs/
2 sessions
SAT960.00
SX3I-6A34E
 Central
 English / PC
9/12~16/12
1000-13006 hrs/
2 sessions
SAT960.00
SX3I-17121C
 Central
 Cantonese / PC
22/12~22/12
0930-1230
1400-1700
6 hrs/
2 sessions
FRI960.00
SX3I-24C23C
 Central
 Cantonese / PC
23/1~25/1
1900-22006 hrs/
2 sessions
TUE, THU960.00
SX3I-45C25K
 Mongkok
 Cantonese / PC
25/1~26/1
1900-22006 hrs/
2 sessions
THU, FRI960.00
SX3I-45C1E
 Central
 English / PC
1/2~2/2
1900-22006 hrs/
2 sessions
THU, FRI960.00
SX3I-35C7K
 Mongkok
 Cantonese / PC
7/3~9/3
1900-22006 hrs/
2 sessions
WED, FRI960.00
SX3I-6A10C
 Central
 Cantonese / PC
10/3~17/3
1000-13006 hrs/
2 sessions
SAT960.00
SX3I-6A84E
 Central
 English / PC
17/3~24/3
1000-13006 hrs/
2 sessions
SAT960.00
SX3I-6D24K
 Mongkok
 Cantonese / PC
24/3~24/3
1000-1300
1400-1700
6 hrs/
2 sessions
SAT960.00
Microsoft Excel 2013 for Beginners
Complete your Enrol
How to enrol/pay online
COURSE INFODATES(dd/mm)TIMEDURATIONDAY(S)AMOUNT
SX6I-6D30C
 Central
 Cantonese / PC
30/9~30/9
1000-1300
1400-1700
6 hrs/
2 sessions
SAT960.00
SX6I-51C6E
 Central
 English / PC
6/10~9/10
1900-22006 hrs/
2 sessions
MON, FRI960.00
SX6I-24C10C
 Central
 Cantonese / PC
10/10~12/10
1900-22006 hrs/
2 sessions
TUE, THU960.00
SX6I-12C23K
 Mongkok
 Cantonese / PC
23/10~24/10
1900-22006 hrs/
2 sessions
MON, TUE960.00
SX6I-6A18C
 Central
 Cantonese / PC
18/11~25/11
1000-13006 hrs/
2 sessions
SAT960.00
SX6I-6A45E
 Central
 English / PC
25/11~2/12
1000-13006 hrs/
2 sessions
SAT960.00
SX6I-45C7K
 Mongkok
 Cantonese / PC
7/12~8/12
1900-22006 hrs/
2 sessions
THU, FRI960.00
SX6I-6D32C
 Central
 Cantonese / PC
23/12~23/12
1000-1300
1400-1700
6 hrs/
2 sessions
SAT960.00
SX6I-6A32C
 Central
 Cantonese / PC
13/1~20/1
1000-13006 hrs/
2 sessions
SAT960.00
SX6I-13C15K
 Mongkok
 Cantonese / PC
15/1~17/1
1900-22006 hrs/
2 sessions
MON, WED960.00
SX6I-45C18C
 Central
 Cantonese / PC
18/1~19/1
1900-22006 hrs/
2 sessions
THU, FRI960.00
SX6I-35C24E
 Central
 English / PC
24/1~26/1
1900-22006 hrs/
2 sessions
WED, FRI960.00
SX6I-6D10E
 Central
 English / PC
10/2~10/2
1000-1300
1400-1700
6 hrs/
2 sessions
SAT960.00
SX6I-6A32K
 Mongkok
 Cantonese / PC
24/2~3/3
1000-13006 hrs/
2 sessions
SAT960.00
SX6I-6D3C
 Central
 Cantonese / PC
3/3~3/3
1000-1300
1400-1700
6 hrs/
2 sessions
SAT960.00
SX6I-13C26E
 Central
 English / PC
26/3~28/3
1900-22006 hrs/
2 sessions
MON, WED960.00
SX6I-24C27K
 Mongkok
 Cantonese / PC
27/3~29/3
1900-22006 hrs/
2 sessions
TUE, THU960.00
Microsoft Excel 2016 for Beginners
Complete your Enrol
How to enrol/pay online

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. 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. 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. 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. Proceed with on-line registration or send the completed enrolment form (download) to us together with a cheque (made payable to Welkin Compuer Training) for the program fee.
  2. CEF applicants have to complete the CEF Application Form (download) and send it to us for certification. They will then send the form to the Office of the Continuing Education Fund, Room 916, 9/F, Kwai Hing Government Offices, 166-174 Hing Fong Road, Kwai Chung, New Territories, together with a photocopy of their HKID Card before course commencement.
  3. Applicants will receive application results from the Office of the CEF within 14 working days.

 

You may also be interested in