Duration: 3 days
Time: 9am to 6pm

What Will Be Taught For This Microsoft Excel 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. Additionally, trainee will be able to accomplish standard mathematical operations using basic formulas and functions. The trainee will be able to demonstrate competence in using some of the Excel features such as filtering, managing data and creating charts.

This course prepares the participants for the Microsoft Office Specialist exams.

Learning Outcomes

At the end of the course, participants will be able to:

  • Apply basic formula in Excel
  • Create Charts
  • Apply Conditional Formatting to highlight critical data
  • Import External Data to Excel
  • Use Page Setup for Printing
Module 1. Exploring Microsoft Excel 2016
  • Starting Excel 2016
  • The User Interface
  • The Backstage View
  • Excel Options
  • Working with Worksheets
  • Using the Ribbon
  • Hiding the Ribbon
  • Customizing the Quick Access Toolbar
  • Customizing Tabs
  • Customizing the Ribbon
  • Customizing the Status Bar
  • Exiting Excel
  • Practice - Exploring Microsoft Excel 2016
Module 2. Getting Help
  • Using Microsoft Excel Help and Resources
  • Working with Excel Help
  • Practice - Getting Help
Module 3. Basic Workbook Skills
  • Using the Keyboard to Select Cells
  • Using KeyTips
  • Using GoTo
  • Entering Text
  • Entering Numbers
  • Saving the Workbook
  • Closing the Workbook
  • Creating a Workbook
  • Opening a Workbook
  • Inserting a Worksheet
  • Shortcuts for Data Entry
  • Editing Data
  • Spell Check
  • Creating a New Folder When Saving
  • Saving the Workbook with Another Name
  • Practice - Basic Workbook Skills
Module 4. Selecting Cells and Ranges
  • Selecting a cell
  • Using the Name Box to select 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
  • Using AutoFill
  • Practice – Selection
Module 5. 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 6. Managing Worksheets
  • Increasing/Decreasing the Magnification
  • Changing the Magnification of a Range
  • Splitting the Window
  • Removing Split Windows
  • Creating a Hyperlink
  • Practice – Managing Worksheets
Module 7. Formatting Text and Numbers
  • Changing the Font
  • Changing Font Size
  • Bold and Italic
  • Underlining Text
  • Font Color
  • Rotating Text
  • Text Wrapping
  • Shrinking Text
  • Cell Alignment
  • Indenting Text
  • About Number Formats
  • Accounting Number Style
  • Percent Style
  • Comma Style
  • Decimal Places
  • Practice – Formatting Text and Numbers
Module 8. 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
  • Inserting Selected Cells
  • Inserting Cut or Copied Cells
  • Deleting Cells
  • Practice – Cell Formatting
Module 9. Using Styles
  • Applying a Predefined Style
  • Creating a Style by Example
  • Applying a Style
  • Creating a New Style
  • Editing an Existing Style
  • Practice – Using Styles
Module 10. 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 11. Essential 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
  • Using NOW, TODAY Function
  • Using IF Function
  • Using COUNTIF Function
  • Using SUMIF Function
  • Using CONCATENATE Function
  • Using Link formula
  • Practice – Basic Formulas
Module 12. Creating Charts
  • Inserting a chart
  • Deleting a chart
  • Adding a Chart Title
  • Changing the Chart Background
  • Changing the Chart Type
  • Adding a Data Table
  • Changing the Chart Layout
  • Copying and moving charts
  • Creating a 3-D Chart
  • Adjusting 3-D View
  • Inserting Sparklines
  • Practice - Creating Charts
Module 13. Working with Comments
  • Creating Comments
  • Viewing a Comment
  • Reviewing Comments
  • Printing Comments
  • Responding to Discussion Comments
  • Practice - Working with Comments
Module 14. Arranging and Finding Data
  • Sorting
  • Sorting Multiple Columns
  • Finding Data
  • Replacing Data
  • Finding and Replacing Cell Format
  • Practice – Arranging and Finding Data
Module 15. Working With Table
  • Creating a Table from Existing Data
  • Changing the Table Name
  • Changing the Table Style
  • Changing Table Style Options
  • Creating a Total Row
  • Adding Table Rows and Columns
  • Inserting/Deleting Table Rows/Columns
  • Creating a Calculated Column
  • Filtering Data
  • Creating Custom Filter
  • Sorting Data by Multiple Levels
  • Using Data Validation
  • Validating Data using a List
  • Creating a Custom Error Message
  • Removing Data Validation
  • Creating Subtotals in a List
  • Removing Subtotals from a List
  • Practice - Working with Databases
Module 16. Using Conditional and Custom Formats
  • Applying Conditional Formats
  • Changing a Conditional Format
  • Adding a Conditional Format
  • Creating a Custom Conditional Format
  • Using Data Bars
  • Deleting a Conditional Format
  • Creating a Custom Number Format
  • Practice - Using Conditional and Custom Formats
Module 17. Using Page Setup
  • 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
  • Practice - Using Page Setup
Module 18. Printing
  • Print Preview
  • Printing the Current Worksheet
  • Printing a Selected Range
  • Printing a Page Range
  • Printing Multiple Copies
  • Practice – Printing
Module 19. Importing Data
  • Import Delimited Data
  • Text to Columns Function
  • Practice – Importing Data

Who Should Attend This Advanced Microsoft Excel Course Training?

Ideal for beginners in Microsoft Office Excel to develop a solid foundational understanding of spreadsheet concepts and applications.

Pre-requisite

A basic working knowledge of Windows / MS Excel 2010/2013 will be an added advantage.

  w/o GST w GST
Course Fee $675 $722.25

Terms & Conditions

  • All prices stated above are in Singapore Dollars (SGD).
  • 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.



Please click on the course date to enrol.