Want create site? Find Free WordPress Themes and plugins.

Microsoft Excel Basic, Intermediate and Advanced Course at $185 (Each Level)

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

Introduction to Excel

  • The program
  • Interface

Introduction to Spreadsheet basics

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

Formatting for better view

  • Font Formatting: Italic, Underline, Bold
  • Alignment
  • Number
  • Styles
  • Themes
  • Format Painter

Printing the Workbook

  • Printing Setups
  • Page Views: Layout and Break
  • Various outputs (PDF, emails, etc)

Formulas and Calculations

  • Straightforward Mathematical Computations
  • Utilizing AutoSum Functions: Sum, Min, Max and Average
  • Operators: Add operator, Subtract operator, Multiply operator, Divide operator, Percentage(%) operator
  • Spreedsheet Foundations
  • Auto Calculate
  • Simple Formulas

Windows Management

  • Different views
  • Multi windows (Freeze/Split/Window)
  • Arranging the windows

Additional Features

  • AutoCorrect
  • Construct Window Panes
  • Emailing Worksheet
  • Find & Replace
  • Freezing/Locking panes
  • Splitting windows
  • Arrange All

Data Organisation

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

Data Analysis

  • Conditioning Formatting
  • Understand Formatting

Data Management

  • Using Name Range
  • Absolute Cell Referecing
  • VLOOKUP
  • HLOOKUP

Conditional Formulas and Formatting

  • Understand Formatting

Advanced Functions

  • Absolute Cell Referencing
  • VLOOKUP formula
  • HLOOKUP formula
  • Data Validation

Pivot Tables and Pivot Charts (Basic)

Working with Data Tables

Charts

  • Creation of Charts and the Various Chart types
  • Basic editing of charts
  • Resizing and Moving
  • Choices of Colour
  • Switching Data
  • Printing Charts with or without data
  • Switching Chart Location
  • Customising Charts
  • Manipulating Chart titles, Chart Legend, Chart Data, and Chart labels
  • Handling and Controlling of Data
  • How to create a Combination Chart

Supplementary Tools

  • Paste Unique
  • Functioning with Sheets
  • Hide or Show Comments
  • Hyperlinks
  • Worksheet and Password Security Protection
  • Finding duplicates

Macros

  • Switching on the developer tab
  • Creation of macros
  • Switching the macro security settings
  • Recording and Executing macro

Workbooks

  • Multiple Workbooks
  • Merging Workbooks
  • Sharing a workbook
  • Functioning with external data
  • Creating a formula to link workbooks

Worksheets

  • Multiple Worksheets
  • Handling between worksheets
  • Constructing 3-D formulas
  • Utilizing the Paste Link Option
  • Controlling link updates
  • Dealing with Broken Links

Pivot Tables and Pivot Charts (Advanced)

Advanced Charting

  • Advanced graphing and charting option that you can use to decorate your excel presentation
  • Sparklines

Scenario Manager

  • Building Scenarios

Solver

  • Solver Parameters
  • Cell Reference/Constraints

Documenting and Auditing

  • Determining Precedent and Dependents Cells
  • Revealing Formulas within the Sheet
  • Adding, Displaying, Editing, and Removing Comments
  • Realizing Formula Errors
  • Utilizing the Trace Error Commands
  • Running with Error Checking
  • Evaluating Formulas

Advanced Calculations

  • Area and Volume
  • Investment and Loan
  • Time and Date
  • Relative Cell Reference

Microsoft Excel Basic Course Dates

  1. 16th January 2017, Monday, 9.30am to 5.30pm [Registration Closed]
  2. 13th February 2017, Monday, 9.30am to 5.30pm [Registration Closed]
  3. 18th February 2017, Saturday, 9.30am to 5.30pm [Registration Closed]
  4. 8th March 2017, Wednesday, 9.30am to 5.30pm [Registration Closed]
  5. 25th March 2017, Saturday, 9.30am to 5.30pm
  6. 4th April 2017, Tuesday, 9.30am to 5.30pm
  7. 6th May 2017, Saturday, 9.30am to 5.30pm
  8. 15th May 2017, Monday, 9.30am to 5.30pm
  9. 5th June 2017, Monday, 9.30am to 5.30pm

Microsoft Excel Intermediate Course Dates

  1. 17th January 2017, Tuesday, 9:30am to 5:30pm [Registration Closed]
  2. 25th January 2017, Wednesday, 9:30am to 5:30pm [Registration Closed]
  3. 14th February 2016, Tuesday, 9:30am to 5:30pm [Registration Closed]
  4. 25th February 2016, Saturday, 9:30am to 5:30pm [Registration Closed]
  5. 9th March 2016, Thursday, 9:30am to 5:30pm [Registration Closed]
  6. 26th March 2016, Sunday, 9:30am to 5:30pm
  7. 5th April 2017, Wednesday, 9.30am to 5.30pm
  8. 7th May 2017, Sunday, 9.30am to 5.30pm
  9. 16th May 2017, Tuesday, 9.30am to 5.30pm
  10. 6th June 2017, Tuesday, 9.30am to 5.30pm

Microsoft Excel Advanced Course Dates

  1. 18th January 2017, Wednesday, 9:30am to 5:30pm [Registration Closed]
  2. 15th February 2017, Wednesday, 9.30am to 5.30pm [Registration Closed]
  3. 4th March 2017, Saturday, 9.30am to 5.30pm [Registration Closed]
  4. 10th March 2017, Friday, 9.30am to 5.30pm [Registration Closed]
  5. 1st April 2017, Saturday, 9.30am to 5.30pm
  6. 6th April 2017, Thursday, 9.30am to 5.30pm
  7. 13th May 2017, Saturday, 9.30am to 5.30pm
  8. 17th May 2017, Wednesday, 9.30am to 5.30pm
  9. 7th June 2017, Wednesday, 9.30am to 5.30pm

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

We wish to highlight that dates may be subjected to changes without notice.

Classes will be postponed if there are less than 6 participants.

We can also arrange a close class specially for your company as long as you have a minimum of 6 participants.

We only accept payments transacted in Singapore Dollars and all payments are neither exchangeable nor refundable for other items.

Note: We conduct the training using MS Excel 2013.

Microsoft Excel Courses In Singapore (SkillsFuture Approved / PIC Claimable)

Excel remains as one of the most appealing software applications that the community around
the world relies on till this day. What makes Excel so appealing to users? Well, there are numerous advantages of Excel, which consists of its user-friendliness, effectiveness and easy entry to help users improve their efficiency using Excel. The course will also lead you through the basics of Microsoft Excel, and will help you acquaint to the numerous functions and formulas of Excel.

 

myob-course-banner

Excel Champion Bundle

Sign up for our Excel Champion Bundle (3 Days – Basic, Intermediate and Advanced Courses) at the affordable price of $488 instead of $555!

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

The Excel Champion Bundle is a 3 in 1 deal comprising of our Basic, Intermediate and Advanced training courses. You can master all Excel functions and formulas within a short period of 3 days at an affordable price!

Call us at 6100 6613 to Register for the

Microsoft Excel Course Now!

Did you find apk for android? You can find new Free Android Games and apps.