X

Microsoft Excel 2016 Basic 1 Day Course Singapore

Microsoft Excel 2016 Basic (1 Day)

Register Now Customize Training

Courses / Information Technology / Microsoft Office / Microsoft Excel / Microsoft Excel 2016 Basic 1 Day
  • Overview
  • Course Outline
  • Target Audience
  • Fees & Funding

What Will Be Taught For This Microsoft Excel 2016 Course?

The course empowers the trainee to understand the basic concepts of spreadsheets and to demonstrate the ability to use a spreadsheet application on a personal computer. He or she will understand and be able to accomplish basic operations associated with developing, formatting and using a spreadsheet.

Module 1. Basic Workbook Skills
  • Using the Keyboard to Select Cells
  • Using KeyTips
  • Using the Mouse to Scroll
  • Using the Scroll Bar Shortcut Menu
  • Using GoTo
  • Entering Text
  • Entering Numbers
  • Saving the Workbook
  • Closing the Workbook
  • Creating a Workbook
  • Opening a Workbook
  • Shortcuts for Data Entry
  • Editing Data
  • Spell Check
  • Practice - Basic Workbook Skills
Module 2. Selection
  • Selecting a cell
  • Selecting a range of contiguous cells
  • Selecting a range of non-contiguous cells
  • Selecting the entire worksheet
  • Selecting a row
  • Selecting a range of contiguous rows
  • Selecting a range of non- contiguous rows
  • Selecting an entire column
  • Selecting a range of columns
  • Selecting a range of non- contiguous columns
  • Practice – Selection
Module 3. Working with Columns and Rows
  • Adjusting the Column Width
  • Adjusting the Row Height
  • Automatically Adjusting Columns
  • Hiding and Un-hiding Rows and Columns
  • Inserting Columns and Rows
  • Deleting Columns and Rows
  • Freezing and Unfreezing Columns and Rows
  • Practice - Working with Columns and Rows
Module 4. Number Formatting
  • About Number Formats
  • Accounting Number Style
  • Percent Style
  • Comma Style
  • Decimal Places
  • Practice – Number Formatting
Module 5. Text Formatting
  • Formatting Text
  • Changing the Font
  • Changing Font Size
  • Bold and Italic
  • Underlining Text
  • Font Color
  • Rotating Text
  • Text Wrapping
  • Shrinking Text
  • Cell Alignment
  • Indenting Text
  • Practice – Text Formatting
Module 6. Cell Formatting
  • Merging Cells
  • Vertical Alignment
  • Splitting Cells
  • Adding Borders
  • Drawing Borders
  • Adding Fill Color to Cells
  • Pasting Formats
  • Format Painter
  • Copying Formats using Auto Fill
  • Clearing Formats
  • Practice – Cell Formatting
Module 7. Basic Formulas
  • Using Basic Formulas
  • Entering Formulas
  • Basic Functions
  • Using the AutoSum Button
  • Using the AutoSum List
  • Using Formula AutoComplete
  • Editing Functions
  • Using Auto Calculate
  • Modifying Formulas using the Range Border
  • Error Checking
  • Practice – Basic Formulas
Module 8. Cut, Copy and Paste
  • Copying and Pasting Data
  • Cutting Data
  • Copying Formulas
  • Paste Options
  • Paste List
  • Filling Cells
  • Drag-and-Drop Editing
  • Undo and Redo
  • Practice – Cut, Copy and Paste
Module 9. Using Page Setup & Printing
  • Worksheet margins
  • Worksheet orientation
  • Worksheet page size
  • Headers and Footers
  • Header and footer fields
  • Scaling your worksheet to fit a page(s)
  • Repeating Row and Column Labels
  • Changing Page Breaks
  • Setting/Removing a Print Area
  • Changing Sheet Options
  • Print Preview
  • Printing the Current Worksheet
  • Printing a Selected Range
  • Printing a Page Range
  • Printing Multiple Copies
  • Practice – Page Setup & Printing

Who Should Attend This Microsoft Excel 2016 Training?

Designed for anyone with minimal or no prior knowledge of Microsoft Excel 2016 and looking to acquire solid foundational skills to perform basic spreadsheet functions.

Pre-requisite

An understanding of Windows / Microsoft Excel 2007/2010/2013 will be an added advantage.

  w/o GST w GST
Course Fee $180 $192.60

This course is applicable for Skills Development Fund (SDF).

 

Terms & Conditions

  • All prices stated above are in Singapore Dollars (SGD). This funding support is only applicable for Singapore Citizen and Permanent Residents.
  • Trainee must attained minimum 75% attendance in order to qualify for Funding.
  • Trainee undertakes to reimburse ST Electronics (e-Services) FULL course fees should he/she be ineligible for course fee grant. ST Electronics (e-Services) is not liable for any other funding not approved by WSG.
  • ST Electronics (e-Services) reserves the right to change the date or venue without prior notice.
  • ST Electronics (e-Services) reserves the right to cancel or reschedule the course due to class size or unforeseen circumstances.

 

 

 

Course Dates
  AUG: 8
  SEP: 5
  OCT: 1
  NOV: 2

  Duration: 1 day
  Time: 9am to 5.30pm