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

Excel Basic - Training Dates

  1. 1st August 2017, Tuesday, 9.30am to 5.30pm [Registration Closed]
  2. 12nd August 2017, Saturday, 9.30am to 5.30pm [Registration Closed]
  3. 6th September 2017, Wednesday, 9.30am to 5.30p [Registration Closed]
  4. 16th September 2017, Saturday, 9.30am to 5.30pm
  5. 9th October 2017, Monday, 9.30am to 5.30p
  6. 21st October 2017, Saturday, 9.30am to 5.30pm
  7. 7th November 2017, Tuesday, 9.30am to 5.30pm
  8. 4th December 2017, Monday, 9.30am to 5.30pm

Excel Intermediate - Training Dates

  1. 2nd August 2017, Wednesday, 9.30am to 5.30pm [Registration Closed]
  2. 19th August 2017, Saturday,  9.30am to 5.30pm [Registration Closed]
  3. 7th September 2017, Thursday,  9.30am to 5.30p[Registration Closed]
  4. 17th September 2017, Sunday,  9.30am to 5.30pm
  5. 10th October 2017, Tuesday,  9.30am to 5.30pm
  6. 28th October 2017, Saturday, 9.30am to 5.30pm
  7. 8th November 2017, Wednesday, 9.30am to 5.30pm
  8. 5th September 2017, Tuesday, 9.30am to 5.30pm

Excel Advanced - Training Dates

  1. 5th July 2017, Wednesday, 9.30am to 5.30pm [Registration Closed]
  2. 3rd August 2017, Thursday, 9.30am to 5.30pm [Registration Closed]
  3. 26th August 2017, Saturday, 9.30am to 5.30pm[Registration Closed]
  4. 8th September 2017, Friday, 9.30am to 5.30pm[Registration Closed]
  5. 30th September 2017, Saturday, 9.30am to 5.30pm
  6. 11th October 2017, Wednesday, 9.30am to 5.30pm
  7. 4th November 2017, Saturday, 9.30am to 5.30pm
  8. 9th November 2017, Thursday, 9.30am to 5.30pm
  9. 6th December 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.