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

  • Camtasia Studio 7 and Snagit 10: Know how to work with audio

    Camtasia Studio 7 and Snagit 10: Know how to work with audio

    SGD $49.00

    Course Description

    This VTC course introduces you to Techsmith's two programs: Camtasia Studio 7 and Snagit 10. Author Mark Struthers will first demonstrate how to use Camtasia Studio before moving on to Snagit so that you understand how both programs complement each other when creating screen recording videos. Additionally, you will see two mini Camtasia projects that illustrate how you can create educational resources for the classroom. Create your masterpiece with Camtasia and Snagit. - Learn the different tools and techniques to produce a screen recording videos- Know how to utilize both softwares in any projects - Discover the secrets of producing a quality video- Learn the ropes of creating your own master piece with this course This course is SkillsFuture Credit Eligible.

    Read more...

  • Explore iOS 6

    Explore iOS 6

    SGD $40.00

    Course Description

    iOS 6 is the world's most advanced mobile operating system. Version 6 brings tighter integration with social media, new maps, refinements with Siri, and so much more. This VTC course explores the new features of iOS 6 along with the basics of operation. VTC author Sam McGuire demonstrates how to set-up your device and get the most from its day to day use. Topics include: app usage, interfacing with iCloud, social media, and a host of other practical applications. This course covers everything you need to get the most from your mobile devices.Keep yourself updated with the new changes in iOS. - Learn about the changes in the latest version of iOS - Undersatand about the operating system - Discover the newly-added features in each new version - Go through an in-depth view of the features of each iOS 

    Read more...

  • An Essential Online Course: Microsoft PowerPoint Course (PC :2007/10 & 2013)

    An Essential Online Course: Microsoft PowerPoint Course (PC :2007/10 & 2013)

    SGD $79.60

    Course Description

    Make beautiful, impressive, effective slides with PowerPoint. Whether for yourself or for your business, our online course will teach you the basics and beyond of how to put together outstanding PowerPoint presentations. Rather than try to teach you everything, we have ruthlessly stripped out all business non-essentials from our syllabus. The result is our highly innovative and impactful online PowerPoint course. Wow your audience with your next presentation after taking this course! - Learn the secrets of creating dynamic PowerPoint slides - Know the different functions and purpose of PowerPoint  - Be able to apply these into your next presentation slides - Impress your audience at your next presentation  Training for PowerPoint (PC version:2007/10,2013)  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.