MSEB: MICROSOFT EXCEL ESSENTIAL
MICROSOFT EXCEL ESSENTIAL
Course Duration
Mode of Assessment
Nil
Who Should Attend
This course is intended for anyone who wants to learn the basics of working with Microsoft Excel.
Course Overview
NTUC LearningHub Course Code: MSEB
IBF Programme Code / TPGateway Code: NA
This course will cover the fundamentals of Microsoft Excel 2019.
Next available schedule
Course Objectives
After completing this course, participants will be able to:
- Create and format professional-looking spreadsheets
- Calculate totals, build simple formulas
Pre-requisites
- Knowledge, Skills & Experience
- Know the navigation of Windows operating system
- Hardware & Software
Laptop with Microsoft Windows 10 (8GB RAM minimum) installed (MAC not supported). This course will be conducted as a Virtual Live Class (VLC) via Zoom platform. Participants must have a laptop or a desktop with “Zoom Client for Meetings” installed. This can be downloaded from https://zoom.us/download
|
|
Minimum Specs |
Recommended Specs |
|
Others |
|
|
|
Software |
|
8GB RAM |
Course Outline
- Excel Fundamentals
- Understanding the Excel Screen
- Create Workbooks
- Create a Blank Workbook
- Create a Workbook from a Template
- Navigate Worksheets
- Select a Cell
- Jump to a Cell
- Navigate Between Cells
- Navigate Between Pages
- Go To Dialog Box
- Excel Keyboard Shortcuts
- Open Workbooks
- Open a Workbook
- Open a Different File Format
- Save Workbooks
- Save a Workbook
- AutoSave Workbooks
- Save Progress
- Save As a New File and/or Location
- Save To Different File Formats
- Print
- Print Preview a Worksheet
- Print a Worksheet
- Specify Printing Options
- Help
- The Tell Me Field
- The Help Pane
- Close and Exit
- Close a Workbook
- Close Excel
- Edit a Workbook
- Select Cells and Ranges
- Select a Cell
- Select Rows
- Select Columns
- Select a Cell Range
- Select Non-Adjacent Cells
- Select the Entire Worksheet
- Edit Cell Data
- Enter Cell Data
- Replace Cell Data
- Delete Cell Data
- Edit Cell DataPivotChart Styles
- Cut, copy and Paste
- Copy and Paste
- Cut and Paste
- Move Using Drag and Drop
- Undo, Redo, Repeat
- Make Changes
- Undo
- Redo
- Repeat
- More Pasting Options
- Transpose Data
- Paste Values
- Paste Formats
- Insert and Move Cells
- Insert Cells
- Insert Rows or Columns
- Move Cells
- Delete Cells
- Delete Cells
- Delete Rows and Columns
- Find and Replace Text
- Find Text
- Replace Text
- Hide Columns and Rows
- Hide Rows or Columns
- Unhide Rows or Columns
- Select Cells and Ranges
- Basic Formulas
- Formula Basics
- Create a Formula
- Automatic Recalculation
- Edit a Formula
- The Formulas Tab
- AutoFill
- Copy Data Using Auto Fill
- Enter a Series of Values with Auto Fill
- Auto Fill Options
- Sums and Averages
- Create a Sum Formula
- Create an Average Formula
- MIN and MAX
- Create a MAX Formula
- Create a MIN Formula
- COUNT
- Create a Count Formula
- COUNTA
- Formula Basics
- Basic Formatting
- Format Text
- Change Fonts and Font Appearance
- Change Font Size and Color
- Formatting a Part of a Cell
- Align and Merge Cells
- Change Cell Alignment
- Indent a Cell Contents
- Wrap Text in a Cell
- Merge Cells
- Split Merge Cells
- Format Numbers and Dates
- Format a Number or Date
- Advanced Number Formats
- Create a Custom Number Format
- Borders and Background Colors
- Add a Cell Border
- Advanced Border Options
- Add a Cell Shading
- Copy Formatting
- Row Heights and Column Widths
- Adjust Column Width
- Automatically Adjust Column Width
- Adjust Row Height
- Use Additional Size Options
- Format Text
- Insert Objects
- Images
- Insert Images
- Shapes
- Insert a Shape
- Format a Shape
- Hyperlinks
- Hyperlink Text or Images
- Images
- Manage Worksheets
- Move and Copy Worksheets
- Insert, Rename, and Delete Worksheets
- Insert a Worksheet
- Rename a Worksheet
- Change Tab Color
- Delete a Worksheet
- Freeze Rows and Columns
- Freeze Rows
- Freeze Columns
- Unfreeze Panes
- Hide Worksheets and Gridlines
- Hide a Worksheet
- Unhide a Worksheet
- Hide or Display Gridlines
- Print and Distribute
- Page Size and Scale
- Change Page Size
- Change Print Scale
- Print Area and Page Breaks
- Set the Print Area
- Remove a Print Area
- View Page Breaks
- Print Titles, Gridlines, and Headings
- Headers and Footers
- Add a Header or Footer
- Adjust the Header and Footer Height
- Margins and Orientation
- Set Print Margins
- Set Page Orientation
- Page Size and Scale
Certificate Obtained and Conferred by
Nil
Additional Details
Medium of Instruction: English
Trainer to Trainee Ratio is 1:20
Price
|
Course Fee |
|||||
|
|
Individual Sponsored Trainee |
Company Sponsored Trainee |
|||
|
before GST |
with GST |
before GST |
with GST |
||
|
Full Course Fee |
$330.00 |
$359.70 |
$330.00 |
$359.70 |
|
Funding:
Union Training Assistance Programme (UTAP)
NTUC members enjoy UTAP* benefit of up to $250 each year when you sign up for courses with NTUC LearningHub.
* UTAP supports 50% of the course fees paid cap at $250 per year. You must be a union member throughout the course duration and at the time of claim.
Terms and Condition apply.Terms and conditions apply. NTUC LearningHub reserve the right to make changes or improvements to any of the products described in this document without prior notice.Prices are subject to other LHUB miscellaneous fees.
| Batch ID | Course Period | Course Title | Funding Available |
Duration (Hours) |
Session (Hours) |
Venue | Available Seats |
Online Payment |
|---|
What Others Also Enrolled In
SKILLSFUTURE FOR DIGITAL WORKPLACE 2.0 (SFDW 2.0) - GENERAL (2 DAYS) (CLASSROOM WITH ASYNCHRONOUS ELEARNING)
View detail