Name: Microsoft Excel 2016: Beginner by NTUC LearningHub
Telephone: 6336 5482

Udemy courses up to 50% off

NTUC LearningHub Course Code: MSE16B

SSG SkillsConnect Reference Number: CRS-N-0033304

2 Days / 14 Hours

GETTING STARTED
- UNDERSTAND THE EXCEL SCREEN
- CREATE WORKBOOKS
  - Create a Blank Workbook
  - Create a Workbook from a Template
- NAVIGATE WORKSHEETS
- OPEN AND SAVE WORKBOOKS
  - Open a Workbooks
  - Save a Workbook
- PRINT
- HELP
- CLOSE AND EXIT
  - Close a Workbook
  - Close Excel

EDIT A WORKBOOK
- SELECT CELLS AND RANGES
  - Select a Cell
  - Select the Entire Worksheet
  - Select Rows
  - Select Columns
  - Select a Cell Range
- EDIT CELL DATA
  - Enter Cell Data
  - Replace Cell Data
  - Delete Cell Data
  - Edit Cell Data
- CUT, COPY, AND PASTE
  - Copy and Paste
  - Cut and Paste
  - Move Using Drag and Drop
- MORE PASTING OPTIONS
- AUTOFILL
  - Copy Data Using AutoFill
  - Enter a Series of Values with AutoFill
- INSERT AND DELETE CELLS
  - Insert Cells
  - Delete Cells
- FIND AND REPLACE TEXT
  - Finding Text
  - Replacing Text
- HIDE COLUMNS AND ROWS
  - Hide Rows or Columns
  - Unhide Rows or Columns

FORMAT WORKSHEETS
- FORMAT TEXT
  - Changing Font Appearance
  - Changing Font Size and Color
  - Formatting a Part of a Cell
- ALIGN CELLS
  - Change Cell Alignment
  - Indent a Cells Contents
- WRAP TEXT AND MERGE CELLS
  - Wrap Text in a Cell
  - Merge Cells
  - Split Merged Cells
- FORMAT NUMBERS AND DATES
  - Format a Number or Date
  - Use Advanced Number Formats
- BORDERS AND BACKGROUND COLORS
  - Add Cell Shading
  - Add a Cell Border
  - Advanced Border Options
- COPY FORMATTING
- ROW HEIGHTS AND COLUMN WIDTHS
  - Adjust Column Width
  - Adjust Row Height
  - Use Additional Size Options
- FIND AND REPLACE FORMATTING
- INSERT AN IMAGE

BUILD FORMULAS
- FORMULA AND FUNCTION BASICS
  - Create Formula
  - Edit a Formula
  - Use a Function
- SUMS AND AVERAGES
  - Create a Sum Formula
  - Create an Average Formula
- REFERENCE EXTERNAL DATA
  - Reference Another Worksheet
- FORMULA ERRORS
  - #### Error
  - #VALUE! Error
  - #REF! Error

VIEW AND MANAGE WORKSHEETS
- MOVE AND COPY WORKSHEETS
- INSERT, RENAME, AND DELETE WORKSHEETS
  - Insert a Worksheet
  - Rename a Worksheet
  - Delete a Worksheet
- HIDING WORKSHEETS AND GRIDLINES
  - Hide a Worksheet
  - Unhide a Worksheet
  - Hide or Display Gridlines

PRINT WORKSHEETS
- PAGE SIZE AND SCALE
  - Change Page Size
  - Change Print Scale
- PRINT AREA AND PAGE BREAKS
  - Set the Print Area
  - Remove a Print Area
  - Use Page Breaks
- PRINT HEADINGS
  - HEADERS AND FOOTERS
  - Add a Header or Footer
  - Adjust the Header and Footer Height
- MARGINS AND ORIENTATION
  - Set Print Margins
  - Set Page Orientation

Microsoft Excel 2016: Beginner by NTUC LearningHub

You May Also Be Interested In