Microsoft Excel Course Singapore ( SkillsFuture)

Excel Course Singapore

Excel Course Singapore costs

(SkillsFuture Approved)

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.

Please email admin@mocdstudio.com for training schedules.

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)
SkillsFuture Covers 100% of Course Fees (Self Sponsored)


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.