Objective:
Participants will learn how to use Microsoft Excel to perform calculation and some simple functions, creating chart and understanding the use of spreadsheet.
Course Outline
Getting Started
- Spreadsheets
- File Ribbon Tab
- Ribbon
- Quick Access Toolbar
- Tell me what you want to do (New!)
Working with a Workbook
- Create a Workbook
- Save a workbook
- Open a Workbook
- Entering a Data
Manipulating Data
- Select Data
- Copy and Paste
- Cut and Paste
- Fill Handle
- Undo and Redo
- Flash Fill
Modifying a Worksheet
- Insert Cells, Rows and Columns
- Delete Cells, Rows and Columns
- Modifying column, row and cells
- File and Replace
- Go To Command
- Spell Check
- Entering Formulas
- Function Library
Formulas
- Excel Formulas
- Function Library
- Relative and Absolute
- Linking Worksheets
Formatting a Worksheet
- Convert Text to Columns
- Modify Fonts
- Format Cells Dialog Box
- Add Borders and Colors to Cells
- Formatting Value
- Creating a Custom Number
- Hide or Unhide Rows and Columns
- Merge Cells
- Align Cell Contents
Developing a Workbook
- Format Worksheet Tab
- Reposition Worksheets in a Workbook
- Insert and Delete Worksheets
- Copy and Paste Worksheet
Page Properties and Printing
- Set Print Titles
- Create a Header and Footer
- Set Page Margins
- Change Page Orientation
- Set Page Breaks
- Print a Range
Charts
- Create a Chart
- Recommended Chart
- Modifying a Chart
- Chart Tools
- Sparklines
Sort and Filter
- Basic Sorts
- Custom Sorts
- Filtering
Customize the Layout
- Split a Worksheet
- Freeze Rows and Column
- Hide and Unhide Worksheets
For individial, you may submit your claim via http://www.skillsfuture.sg/credit.
Register online @ http://www.onepa.sg
SDF Applicant, please register @ https://www.skillsconnect.gov.sg
IT Centre reserves the right to reschedule the course without prior notice due to class size or unforeseen circumstances. |