An Essential Online Course: Microsoft Excel Course PC & MAC


  • An Essential Online Course: Microsoft Excel Course PC & MAC, Singapore SKillsFuture elarning online course
  • An Essential Online Course: Microsoft Excel Course PC & MAC, Singapore SKillsFuture elarning online course
  • An Essential Online Course: Microsoft Excel Course PC & MAC, Singapore SKillsFuture elarning online course
  • An Essential Online Course: Microsoft Excel Course PC & MAC, Singapore SKillsFuture elarning online course
  • An Essential Online Course: Microsoft Excel Course PC & MAC, Singapore SKillsFuture elarning online course
  • An Essential Online Course: Microsoft Excel Course PC & MAC, Singapore SKillsFuture elarning online course

Course Description

Cut Excel down to size with our tailored online course. Achieve certificated proficiency in hours. Available in all major PC and Mac versions. We reviewed Excel's 500 functions, ruthlessly stripping out all non-essentials, to arrive at our highly refined syllabus. Our diagnostic tool then focuses your time on those parts of that syllabus that will be most valuable to you. Our regularly updated course consists of a carefully balanced combination of text, illustrations, videos and end-of-unit tests to measure your progress.

Pick up the basics of Microsoft Excel and be fluent in all of its functions!

- Learn from the basics to advanced functions of Microsoft Excel
- Know about the features and functions in Microsoft Excel
- Understand the features and functions offered in Microsoft Excel
- Be able to apply the skill set into your daily work to improve productivity

Training for Excel PC (PC versions: 2013, 2007/10, 2003, 2016 | Mac versions: 2011, 2016)

This course is Skillsfuture Credit Eligible.


Course Objectives

1. Consists of 38 business focused Excel units from our distilled syllabus
2. Contains 100 hours of learning materials but can be completed in as little as 12 hours of dedicated study
3. Provides 24/7 access to all learning materials from the date you register
4. Is available in all the main versions of Excel (PC: 2003, 2007, 2010 and 2013, 2016 / 365; Mac: 2011)
5. Is taught through a blend of text-based articles, practice spreadsheets, video tutorials and podcasts
6. Comes with email support from our experts


Related Courses

  • Maximize your Database with Microsoft Access 2013

    Maximize your Database with Microsoft Access 2013

    SGD $40.00

    Course Description

    Microsoft Access 2013 is the latest version of the number one database application in the world, and this is a big release. Access 2013 brings quite a few changes, all designed to make database applications easier to design and implement. The ability to quickly create Web Applications that run in the user's browser, regardless of which device they use, is one of the major changes in the latest release. In this VTC course, author Mark Long takes you step by step through Access 2013 to quickly get you up to speed on these changes. Access is everywhere, from small one-person businesses up to the largest corporations in the world. It's where most data first gets stored before progressing to SQL Server, cloud delivery, and enterprise data services. Understanding Access is vital to real world database creation/maintenance/design and this course will show you what you need to get there. Realise the full potential of your data with Microsoft Access. - Learn about the functions in Microsoft Access that can help your understand data better - Know the different ways of vizualising your data with Microsoft Access- Pick up the knowledge of utilizing Access for better understanding your data- Learn how you can stretch your data for optimum analysis 

    Read more...

  • FL Studio 10: Know how to work with audio

    FL Studio 10: Know how to work with audio

    SGD $54.00

    Course Description

    Version 10 is the game changer that FL Studio users have been waiting for. This new version builds on the long tradition of FL Studio excellence while bringing meaningful new tools to the platform. In this VTC course, author Sam McGuire helps FL Studio users navigate the FL Studio application, focusing on real-world workflow and example projects. In addition to discussing the basic FL Studio interface and functionality, Sam will delve into the exciting new Pitcher and Newtone plugins. Building on the FL Studio 9 course, this new material is designed to sharpen your skills and provide the means to be a master user of the software. Sharpen your skills in digital audio with FL Studio. - Know about FL Studio and what it does - Understand how you can use FL Studio to edit your audio files- Learn about the different connections in audio systems- Learn how to use different sound mixers using FL StudioThis course is SkillsFuture Credit Eligible.

    Read more...

  • FileMaker Pro 12: Intermediate

    FileMaker Pro 12: Intermediate

    SGD $80.00

    Course Description

    FileMaker Pro is powerful enough to handle most database jobs yet easy enough to create simple solutions in minutes. This practical ’how to’ course by FileMaker expert John Mark Osborne starts from intermediate level and uses a single invoicing example to demonstrate FileMaker Pro 7, 8, 8.5, 9, 10, 11 and 12 features and techniques including: interface design, relational database design, relationship operators, multiple predicates, table occurrences, portal filters, security, scripts, calculations, FileMaker Pro Advanced, multi-user solutions, record locking, multi-keys, deleting duplicate records and new FileMaker Pro 11 features. Examples of the invoice file are provided at every stage of the creation process so the user can easily review one section without starting from the beginning.  Discover how data can be managed efficiently.  - Find out how you can manage your database - Learn ways to fully utilize your data's potential  - Know how queries can be implemented to run the data better  - Understand an effective solution to optimize your database's productivity  This course is SkillsFuture Credit Eligible.

    Read more...


Content

Excel 2003 PC

+
Learn the features and functions of Excel 2003
  • Section 1: Foundation
    • Unit 1.1 - Excel Introduction
    • Unit 1.2 - The Excel Interface
    • Unit 1.3 - Basic Navigation and Editing
    • Unit 1.4 - Getting Going
  • Section 2: Orientation & efficiency
    • Unit 2.1 - Editing
    • Unit 2.2 - Viewing
    • Unit 2.3 - Spreadsheet Structure
    • Unit 2.4 - Cell References
    • Unit 2.5 - Named Ranges
    • Unit 2.6 - Basic Macros
    • Unit 2.7 - Design
  • Section 3: Administration
    • Unit 3.1 - Customising Excel
    • Unit 3.2 - Housekeeping
    • Unit 3.3 - Connecting Workbooks
    • Unit 3.4 - Documentation
    • Unit 3.5 - Protecting and Sharing
    • Unit 3.6 - Excel Troubleshooting
  • Section 4: Data Handling
    • Unit 4.1 - Sorting and Filtering
    • Unit 4.2 - Controlling User Input
    • Unit 4.3 - Working with Dates & Times
    • Unit 4.4 - Working with Text
    • Unit 4.5 - Lookup and Reference
    • Unit 4.6 - Logical Functions
  • Section 5: Data Analysis
    • Unit 5.1 - Working With Numbers
    • Unit 5.2 - Summarising Data
    • Unit 5.3 - PivotTables 1 - Simple Summaries
    • Unit 5.4 - PivotTables 2 - Manipulating Data
    • Unit 5.5 - PivotTables 3 - Interpreting Data
    • Unit 5.6 - Formula Auditing
    • Unit 5.7 - Advanced Macros and VBA
    • Unit 5.8 - Modelling
  • Section 6: Presentation
    • Unit 6.1 - Cell Formatting
    • Unit 6.2 - Number Formatting
    • Unit 6.3 - Conditional Formatting
    • Unit 6.4 - Graphs and Charts
    • Unit 6.5 - Page and Print setup

Excel 2007/10 PC

+
Learn the features and functions of Excel 2007/2010 for PC
  • Section 1: Foundation
    • Unit 1.1 - Excel Introduction
    • Unit 1.2 - The Excel Interface
    • Unit 1.3 - Basic Navigation and Editing
    • Unit 1.4 - Getting Going
  • Section 2: Orientation & efficiency
    • Unit 2.1 - Editing
    • Unit 2.2 - Viewing
    • Unit 2.3 - Spreadsheet Structure
    • Unit 2.4 - Cell References
    • Unit 2.5 - Named Ranges
    • Unit 2.6 - Basic Macros
    • Unit 2.7 - Design
  • Section 3: Administration
    • Unit 3.1 - Customising Excel
    • Unit 3.2 - Housekeeping
    • Unit 3.3 - Connecting Workbooks
    • Unit 3.4 - Documentation
    • Unit 3.5 - Protecting and Sharing
    • Unit 3.6 - Google Docs
    • Unit 3.7 - Excel Troubleshooting
  • Section 4: Data Handling
    • Unit 4.1 - Sorting and Filtering
    • Unit 4.2 - Controlling User Input
    • Unit 4.3 - Working with Dates & Times
    • Unit 4.4 - Working with Text
    • Unit 4.5 - Lookup and Reference
    • Unit 4.6 - Logical Functions
  • Section 5: Data Analysis
    • Unit 5.1 - Working With Numbers
    • Unit 5.2 - Summarising Data
    • Unit 5.3 - PivotTables 1 - Simple Summaries
    • Unit 5.4 - PivotTables 2 - Manipulating Data
    • Unit 5.5 - PivotTables 3 - Interpreting Data
    • Unit 5.6 - PowerPivot: Handling Big Data
    • Unit 5.7 - Formula Auditing
    • Unit 5.8 - Advanced Macros and VBA
    • Unit 5.9 - Modelling
  • Section 6: Presentation
    • Unit 6.1 - Cell Formatting
    • Unit 6.2 - Number Formatting
    • Unit 6.3 - Conditional Formatting
    • Unit 6.4 - Graphs and Charts
    • Unit 6.5 - Page and print setup

Excel 2011 Mac

+
Learn the features and functions of Excel 2011 for MAC
  • Section 1: Pre-Syllabus
    • Unit 1.1 - The Excel Dashboard
    • Unit 1.2 - Basic Navigation and Editing
  • Section 2: Spreadsheet Administration
    • Unit 2.1 - Customising Excel
    • Unit 2.2 - Housekeeping
    • Unit 2.3 - Connecting Workbooks
    • Unit 2.4 - Sharing and Protecting
    • Unit 2.5 - Excel Crashes
  • Section 3: Orientation and Efficiency
    • Unit 3.1 - Editing
    • Unit 3.2 - Viewing
    • Unit 3.3 - Outline
    • Unit 3.4 - Cell References
  • Section 4: Data Handling
    • Unit 4.1 - Data Validation
    • Unit 4.2 - Sorting and Filtering
    • Unit 4.3 - Date and Time Functions
    • Unit 4.4 - Text Functions
    • Unit 4.5 - Lookup and Reference Functions
    • Unit 4.6 - Logical and Informational Functions
    • Unit 4.7 - Named Ranges
    • Unit 4.8 - Macros
  • Section 5: Data Analysis
    • Unit 5.1 - Mathematical Functions
    • Unit 5.2 - Summarising Data
    • Unit 5.3 - Pivot Tables
    • Unit 5.4 - Formula Auditing
    • Unit 5.5 - What-If Analysis
    • Unit 5.6 - Modelling Principles
    • Unit 5.7 - Modelling Techniques
  • Section 6: Presentation
    • Unit 6.1 - Cell Formatting
    • Unit 6.2 - Number Formatting
    • Unit 6.3 - Conditional Formatting
    • Unit 6.4 - Graphs and Charts
    • Unit 6.5 - Review
    • Unit 6.6 - Page and Print Setup

Excel 2013 PC

+
Learn the features and functions of Excel 2013 for PC
  • Section 1: Foundation
    • Unit 1.1 - Excel Introduction
    • Unit 1.2 - The Excel Interface
    • Unit 1.3 - Basic Navigation and Editing
    • Unit 1.4 - Getting Going
  • Section 2: Orientation & efficiency
    • Unit 2.1 - Editing
    • Unit 2.2 - Viewing
    • Unit 2.3 - Spreadsheet Structure
    • Unit 2.4 - Cell References
    • Unit 2.5 - Named Ranges
    • Unit 2.6 - Basic Macros
    • Unit 2.7 - Design
  • Section 3: Administration
    • Unit 3.1 - Customising Excel
    • Unit 3.2 - Housekeeping
    • Unit 3.3 - Connecting Workbooks
    • Unit 3.4 - Documentation
    • Unit 3.5 - Protecting and Sharing
    • Unit 3.6 - Google Docs
    • Unit 3.7 - Excel Troubleshooting
  • Section 4: Data Handling
    • Unit 4.1 - Sorting and Filtering
    • Unit 4.2 - Controlling User Input
    • Unit 4.3 - Working with Dates & Times
    • Unit 4.4 - Working with Text
    • Unit 4.5 - Lookup and Reference
    • Unit 4.6 - Logical Functions
  • Section 5: Data Analysis
    • Unit 5.1 - Working with Numbers
    • Unit 5.2 - Summarising Data
    • Unit 5.3 - PivotTables 1 - Simple Summaries
    • Unit 5.4 - PivotTables 2 - Manipulating Data
    • Unit 5.5 - PivotTables 3 - Interpreting Data
    • Unit 5.6 - PowerPivot: Handling Big Data
    • Unit 5.7 - Formula Auditing
    • Unit 5.8 - Advanced Macros and VBA
    • Unit 5.9 - Modelling
  • Section 6: Presentation
    • Unit 6.1 - Cell Formatting
    • Unit 6.2 - Number Formatting
    • Unit 6.3 - Conditional Formatting
    • Unit 6.4 - Graphs and Charts
    • Unit 6.5 - Page and print setup

 

Excel 2016

+
Learn the features and functions of Excel 2016
  • Section 1: Foundation
    • Unit 1.1 - Excel Introduction
    • Unit 1.2 - The Excel Interface    
    • Unit 1.3 - Basic Navigation and Editing
    • Unit 1.4 - Getting Going
  • Section 2: Orientation and Efficiency
    • Unit 2.1 - Editing
    • Unit 2.2 - Viewing
    • Unit 2.3 - Spreadsheet Structure
    • Unit 2.4 - Cell References
    • Unit 2.5 - Named Ranges
    • Unit 2.6 - Basic Macros
    • Unit 2.7 - Design
  • Section 3: Administration
    • Unit 3.1 - Customising Excel
    • Unit 3.2 - Housekeeping
    • Unit 3.3 - Connecting Workbooks
    • Unit 3.4 - Documentation    
    • Unit 3.5 - Protecting and Sharing
    • Unit 3.6 - Google Sheets
    • Unit 3.7 - Excel Troubleshooting
  • Section 4: Data Handling
    • Unit 4.1 - Sorting and Filtering
    • Unit 4.2 - Controlling User Input
    • Unit 4.3 - Working with Dates and Times
    • Unit 4.4 - Working with Text
    • Unit 4.5 - Lookup and Reference
    • Unit 4.6 - Logical Functions
  • Section 5: Data Analysis
    • Unit 5.1 - Working with Numbers
    • Unit 5.2 - Summarising Data
    • Unit 5.3 - PivotTables 1 – Simple Summaries 
    • Unit 5.4 - PivotTables 2 – Manipulating Data
    • Unit 5.5 - PivotTables 3 – Interpreting Data
    • Unit 5.6 - Power Pivot: Handling Big Data
    • Unit 5.7 - Formula Auditing
    • Unit 5.8 - Advanced Macros and VBA
    • Unit 5.9 – Modelling
  • Section 6: Presentation
    • Unit 6.1 - Cell Formatting
    • Unit 6.2 - Number Formatting
    • Unit 6.3 - Conditional Formatting
    • Unit 6.4 - Charts and Graphs
    • Unit 6.5 - Page and Print Setup

Excel 2016 Mac

+
Learn the features and functions of Excel 2016 for MAC
  • Section 1: Foundation
    • Unit 1.1 - Excel for Mac Introduction
    • Unit 1.2 - The Excel Interface    
    • Unit 1.3 - Basic Navigation and Editing
    • Unit 1.4 - Getting Going
  • Section 2: Orientation and Efficiency
    • Unit 2.1 - Editing
    • Unit 2.2 - Viewing
    • Unit 2.3 - Spreadsheet Structure
    • Unit 2.4 - Cell References
    • Unit 2.5 - Named Ranges
    • Unit 2.6 - Basic Macros
    • Unit 2.7 - Design
  • Section 3: Administration
    • Unit 3.1 - Excel Preferences
    • Unit 3.2 - Housekeeping
    • Unit 3.3 - Connecting Workbooks
    • Unit 3.4 - Documentation    
    • Unit 3.5 - Protecting and Sharing
    • Unit 3.6 - Google Sheets
    • Unit 3.7 - Excel Troubleshooting
  • Section 4: Data Handling
    • Unit 4.1 - Sorting and Filtering
    • Unit 4.2 - Controlling User Input
    • Unit 4.3 - Working with Dates and Times
    • Unit 4.4 - Working with Text
    • Unit 4.5 - Lookup and Reference
    • Unit 4.6 - Logical Functions
  • Section 5: Data Analysis
    • Unit 5.1 - Working with Numbers
    • Unit 5.2 - Summarising Data
    • Unit 5.3 - PivotTables 1 – Simple Summaries 
    • Unit 5.4 - PivotTables 2 – Manipulating Data
    • Unit 5.5 - PivotTables 3 – PivotCharts and Conditional Formatting in PivotTables (Not available in MAC version)
    • Unit 5.6 - Power Pivot: Handling Big Data (Not available in MAC version)
    • Unit 5.7 - Formula Auditing
    • Unit 5.8 - Advanced Macros and VBA (Not available in MAC version)
    • Unit 5.9 - Modelling
  • Section 6: Presentation
    • Unit 6.1 - Cell Formatting
    • Unit 6.2 - Number Formatting
    • Unit 6.3 - Conditional Formatting
    • Unit 6.4 - Charts and Graphs
    • Unit 6.5 - Page and Print Setup
SkillsFuture Credit Eligible
SGD $79.60
(Price excludes GST)
GET ACCESS NOW
Convince your boss email
This site is best viewed using the latest versions of Google Chrome, Apple Safari, Mozilla FireFox, Microsoft Internet Explorer 11 and Edge which supports HTML5/Webkit technologies.