Microsoft Excel Courses Singapore ( SkillsFuture / PIC Claimable)

Excel Course Singapore

Excel Courses Singapore costs at $185 (SkillsFuture Approved / PIC Claimable)

After PIC Price: $111 (Company Sponsored)
SkillsFuture Covers 100% of Course Fees (Self Sponsored)

Curriculum covered in Excel Courses

Introduction to Excel

  • 1. The program
  • 2. Interface

Introduction to Spreadsheet basics

  • 1. Create/Save/Open New/Existing Workbook
  • 2. Navigating around the Workbook/Worksheet
  • 3. Entering Data(text, numbers, date, functions, percentage)
  • 4. Editing and deleting data (cut, copy, paste, clear)
  • 5. Autofill and Flashfill
  • 6. Drag and Drop Options
  • 7. Find and Replace
  • 8. Autocorrect

Formatting for better view

  • 1. Font Formatting: Italic, Underline, Bold
  • 2. Alignment
  • 3. Number
  • 4. Styles
  • 5. Themes
  • 6. Format Painter

Printing the Workbook

  • 1. Printing Setups
  • 2. Insert Page Breaks
  • 3. Page Views: Layout and Break
  • 4. Various outputs (PDF, emails, etc)

Formulas and Calculations

  • 1. Straightforward Mathematical Computations
  • 2. Utilizing AutoSum Functions: Sum, Min, Max and Average
  • 3. Operators: Add operator, Subtract operator, Multiply operator, Divide operator, Percentage(%) operator
  • 4. Auto Calculate
  • 5. Simple Formulas

Windows Management

  • 1. Different views
  • 2. Multi windows (Freeze/Split/Window)
  • 3. Arranging the windows

Do note that we will be conducting the training using Microsoft Excel 2013.

Data Organisation

  • 1. Filtering: AutoFilter, Filter by Colour and Text Filters
  • 2. Criteria – contains, equal to, not equal to
  • 3. Grouping & Subtotals
  • 4. Using Sorting Options – Custom, ascending and descending, A-Z, Z-A
  • 5. Custom Filter

Data Analysis

  • 1. Conditional Formatting
  • 2. Understand Formatting

Data Management

  • 1. Data Validation
  • 2. Constructing Data Validation Rules
  • 3. Using a Formula to Validate Entries
  • 4. Using Database Functions
  • 5. Constructing a Criteria Range
  • 6. Opening the Database Function

Reporting

Charts

  • 1. Various Chart Types and Creation of Charts
  • 2. Basic editing of charts
  • 3. Resizing and Moving
  • 4. Choices of Colour
  • 5. Switching Data
  • 6. Printing Charts with or without data
  • 7. Customising Charts
  • 8. Switching Chart Location
  • 9. Manipulating Chart titles, Chart Legend, Chart Data, and Chart labels
  • 10. Handling and Controlling of Data
  • 11. How to create a Combination Chart

Pivot Table and Pivot Charts

  • 1. Setting up Data to Create a Pivot Table
  • 2. Constructing a Pivot Table
  • 3. Selecting Fields and Categorizing Data
  • 4. Pivot Table Tools Tab Analysis
  • 5. Switching the Data Displayed and Refreshing the Pivot Table
  • 6. Implementing a Style to Pivot Table
  • 7. Establish a Pivot Chart from a Pivot Table
  • 8. Coming up with a Pivot Chart from Data

Formulas

  • 1. IF Statement: SUMIF, COUNTIF, IF, AND, OR

Advanced Functions

  • 1. Name Range
  • 2. Absolute Cell Referencing
  • 3. VLOOKUP Formula
  • 4. HLOOKUP Formula
  • 5. Array Formula
  • 6. Index and Match
  • 7. Nested IF
  • 8. CONCATENATE
  • 9. Transpose

Supplementary Tools

  • 1. Paste Unique
  • 2. Functioning with Sheets
  • 3. Hide or Show Comments
  • 4. Hyperlinks
  • 5. Worksheet and Password Security Protection
  • 6. Finding duplicates

Do note that we will be conducting the training using Microsoft Excel 2013.

Macros

  • 1. Switching on the developer tab
  • 2. Creation of macros
  • 3. Switching the macro security settings
  • 4. Recording and Executing macro

Workbooks

  • 1. Merging Workbooks
  • 2. Multiple Workbooks
  • 3. Sharing a Workbook and Tracking changes
  • 4. Functioning with external data
  • 5. Creating a formula to link workbooks

Worksheets

  • 1. Multiple Worksheets
  • 2. Handling between worksheets
  • 3. Constructing 3-D formulas
  • 4. Utilizing the Paste Link Option
  • 5. Controlling link updates
  • 6. Dealing with Broken Links

Advanced Charting

  • 1. Advanced graphing and charting option that you can use to decorate your excel presentation
  • 2. Sparklines
  • 3. Pivot tables and Pivot charts (Advanced)

What-if Analysis

Scenario Manager

  • 1. Building Scenarios
  • 2. Goal Seek
  • 3. Data Table

Solver

  • 1. Solver Parameters
  • 2. Cell Reference/Constraints

Documenting and Auditing

  • 1. Determining Precedent and Dependents Cells
  • 2. Revealing Formulas within the Worksheet
  • 3. Adding, Displaying, Editing, and Removing Comments
  • 4. Realizing Formula Errors
  • 5. Utilizing the Trace Error Commands
  • 6. Run Error Checking
  • 7. Evaluating Formulas

Do note that we will be conducting the training using Microsoft Excel 2013.

Excel Basic - Training Dates

  1. 25th March 2017, Saturday, 9.30am to 5.30pm [Registration Closed]
  2. 4th April 2017, Tuesday, 9.30am to 5.30pm [Registration Closed]
  3. 6th May 2017, Saturday, 9.30am to 5.30pm [Registration Closed]
  4. 15th May 2017, Monday, 9.30am to 5.30pm [Registration Closed]
  5. 5th June 2017, Monday, 9.30am to 5.30pm
  6. 3rd July 2017, Monday, 9.30am to 5.30pm
  7. 1st August 2017, Tuesday, 9.30am to 5.30pm
  8. 12nd August 2017, Saturday, 9.30am to 5.30pm
  9. 6th September 2017, Wednesday, 9.30am to 5.30pm
  10. 9th October 2017, Monday, 9.30am to 5.30pm
  11. 7th November 2017, Tuesday, 9.30am to 5.30pm
  12. 4th December 2017, Monday, 9.30am to 5.30pm

Excel Intermediate - Training Dates

  1. 26th March 2016, Sunday 9:30am to 5:30pm [Registration Closed]
  2. 5th April 2017, Wednesday, 9.30am to 5.30pm [Registration Closed]
  3. 7th May 2017, Sunday, 9.30am to 5.30pm [Registration Closed]
  4. 16th May 2017, Tuesday, 9.30am to 5.30pm
  5. 6th June 2017, Tuesday, 9.30am to 5.30pm
  6. 4th July 2017, Tuesday, 9.30am to 5.30pm
  7. 2nd August 2017, Wednesday, 9.30am to 5.30pm
  8. 19th August 2017, Saturday,  9.30am to 5.30pm
  9. 7th September 2017, Thursday,  9.30am to 5.30pm
  10. 10th October 2017, Tuesday,  9.30am to 5.30pm
  11. 8th November 2017, Wednesday, 9.30am to 5.30pm
  12. 5th September 2017, Tuesday, 9.30am to 5.30pm

Excel Advanced - Training Dates

  1. 1st April 2017, Saturday, 9.30am to 5.30pm [Registration Closed]
  2. 6th April 2017, Thursday, 9.30am to 5.30pm [Registration Closed]
  3. 13th May 2017, Saturday, 9.30am to 5.30pm [Registration Closed]
  4. 17th May 2017, Wednesday, 9.30am to 5.30pm
  5. 9th June 2017, Friday, 9.30am to 5.30pm
  6. 5th July 2017, Wednesday, 9.30am to 5.30pm
  7. 3rd August 2017, Thursday, 9.30am to 5.30pm
  8. 26th August 2017, Saturday, 9.30am to 5.30pm
  9. 8th September 2017, Friday, 9.30am to 5.30pm
  10. 11th October 2017, Wednesday, 9.30am to 5.30pm
  11. 9th November 2017, Thursday, 9.30am to 5.30pm
  12. 6th December 2017, Wednesday, 9.30am to 5.30pm

Oasia Hotel Office Tower (PS100) or International Plaza – Beside Tanjong Pagar

Please take note that:

  • Training Classes will be postponed if there are less than 6 attendees.
  • We can arrange a close class if your company have a minimum of 6 participants.
  • All payments are accepted using only Singapore dollars, and are non-exchangeable or non refundable for other items.

Sign up for Microsoft Excel Training Bundle Promotion (3 Days – Basic, Intermediate and Advance Courses) at the promotional price of $488 instead of $555!
After PIC Price: $293 (Company Sponsored)
SkillsFuture Covers 100% of Course Fees (Self Sponsored)

MOCD Excel Course Banner


Excel Course Singapore presents:
Up till today, Microsoft Excel still remains as one of the most popular software applications that people all around the world rely on. What makes Excel so attractive to users? Well, there are numerous advantages of Excel, which includes its user-friendliness, effectiveness, and easy accessibility to help everyone improve their efficiency using Excel. The Excel course will guide you through the basics of Microsoft Excel, and will help you accustom to the numerous functions and formulas of Excel.