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

  • Corel Painter 12 Advanced: Create Digital Art Pieces

    Corel Painter 12 Advanced: Create Digital Art Pieces

    SGD $45.00

    Course Description

    Corel Painter 12 is a completely revolutionary update for the popular natural media emulator. Awesome new features, massive computing power improvements, and a completely redesigned user interface make this version a must have for anybody serious about producing artwork on a computer. Taught by longtime illustrator and fine artist Jason Maranto, this Corel Painter 12 Advanced course is designed to quickly take your understanding of this powerful application to a higher level. Focusing heavily on the highly customizable nature of Painter while using an in-depth but easy-to-follow style, this VTC course will help you to master Painter and create with confidence like never before. Dive into Corel Painter and unleash your artistic flare! - Learn about the tools and techniques available in Corel Painter  - Know about the different types of tools and techniques used in Corel Painter  - Discover the capability of Corel Painter to create dynamic creative content  - Be able to produce content that can rival physical painting  This course is SkillsFuture Credit Eligible.

    Read more...

  • Strategize with Service Oriented Architecture - Part 2

    Strategize with Service Oriented Architecture - Part 2

    SGD $40.00

    Course Description

    SOA: Service Orientated Architecture part 2 This training has been created to provide you with relevant and important information concerning SOA: Service Orientated Architecture. During this training we will be concentrating on the main points of applying design strategies to a service orientated architecture. You will also learn all there is to know about SOA, how to design and apply the best principles, tips and techniques with detailed practices and principles. We will also be covering various aspects of legacy systems and applications, providing information on security, and appropriate governance with clear details to help you achieve success with SOA, including the design and creation of services for implementation within your enterprise. By the end of this training you will have a high level overview of the benefits of SOA, how to design and implement SOA in your business today. Very little is discussed regarding APIs or code unless used to display the implications of certain technologies and standards. This is a technical training, which is focused on architects, designers, business analysts, IT managers and executives. Achieve success with Service Oriented Architecture.  - Know how to align your business strategy  - Identify what sort of strategy your business needs to strive  - Learn how strategies can help bring your business to greater heights - Know the benefits of Service Oriented Architecture 

    Read more...

  • Know how to Code with Microsoft C# 2010

    Know how to Code with Microsoft C# 2010

    SGD $49.00

    Course Description

    C# is the Microsoft flagship programming language. It is a simple, powerful, type-safe, and object-oriented language. The many innovations of C# enable rapid application development while retaining the expressiveness and elegance of C-style languages. Since its introduction in the early 2000s as a competitor to Java, C# has steadily developed a very strong identity and is outpacing all competitors as a platform for mission critical applications. In this VTC course, author Mark Long will teach you how to program with C#. He will explain the language's features, quirks, and functionalities in a way that is easy to follow and understand. From simple variable declaration to understanding delegates and events, you'll learn a lot about developing with C#. Pick up a new programming language into the mix of new skills!- Learn a new programming language - Increase your employability with an extra language under your belt - Learn how the different languages work to develop web site and applications - Be able to create cutting edge applications with this course

    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.