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 X3: Create Digital Art Pieces

    Corel Painter X3: Create Digital Art Pieces

    SGD $58.00

    Course Description

    Painter X3 is Corel's latest update to their powerful and popular natural media emulator which is used by professional creative artists in a wide variety of genres and styles. This VTC course, taught by longtime illustrator and fine artist Jason Maranto, is designed to quickly familiarize you with the core features of this powerful application. Focusing on all the main tools and functions with an in-depth yet easy-to-follow style, this course is packed with professional workflow tips and tricks that it will help you to master Painter in no time.  Dive into Corel Painter and unleash your artistic flare! - Learn about the tools and techniques available in Corel Painter X3  - Know about the different types of tools and techniques used in Corel Painter X3 - Discover the capability of Corel Painter X3 to create dynamic creative content  - Be able to produce content that can rival physical painting  This course is SkillsFuture Credit Eligible.

    Read more...

  • Microsoft OneNote 2013

    Microsoft OneNote 2013

    SGD $40.00

    Course Description

    Microsoft OneNote 2013 is used to store information in a central location where it can easily be shared, backed up, and searched. In this VTC course, author Brian Culp compares OneNote to a digital version of a spiral-bound notebook as he shows you how to quickly add text, pictures, video, and even handwritten notes. He also explains how OneNote integrates with other Office 2013 applications, especially Word, Excel, and Outlook. Additionally, Brian covers how to leverage powerful features such as the ability to link notes automatically, customize the interface, and quickly track down unread notes. Find out more about Microsoft's productivity tools!- Learn and understand the purpose of Microsoft's tools- Know more about the functionality and features of each application- Learn about functions that you never knew existed in Microsoft's tools- Be fluent and an efficient user in Microsoft tools by the end of this course 

    Read more...

  • Getting Started with Office 365 for Business

    Getting Started with Office 365 for Business

    SGD $45.00

    Course Description

    Office 365 for business provides a cloud-based service that gives users access to email, calendars, files and programs on a variety of platforms. In this course students will learn how to manage an Office 365 organization. Students will work with basic online applications such as Word, Excel, PowerPoint and OneNote and learn how to collaborate with others on files created in those programs. Students will learn how to utilize the extensive options within Outlook, OneDrive, Lync and create public sites or team sites. Organization administrators will understand how to work with the many settings and tools in the online Office 365 Admin Center, Exchange Admin Center, Lync Admin Center & SharePoint Admin Center.Get a head start on your tasks with Office 365!- Learn about the different products in Office 365- Know more about each of their purpose and functions- Improve your productivity by adopting Office 365 - Be fluent in Office 365 and accomplish your tasks effectively 

    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.