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

  • Introduction to IPv6

    Introduction to IPv6

    SGD $40.00

    Course Description

    IPv6 is the next generation of the suite of protocols that make the Internet possible. By mid 2011, the available TCP/IP addresses will be exhausted and moving from IPv4 to IPv6 will no longer be a good idea, it will be an absolute requirement. Marketers are quick to announce that ’IPv6 provides integrated and interoperable technologies to enable exciting new scenarios for personal and enterprise computing.’ IT technicians and administrators fully understand that first and foremost, IPv6 will be a technical challenge. Re-building a 747 airliner while it is still in flight is one way to look at it. In this course, Mark Long will teach you the new concepts, terminologies, and processes of IPv6 to help you get ready for this exciting, albeit challenging, new functionality.Be informed on the latest changes of Internet Protocol.- Know the difference between IPv6 and the version before it - Understand the IPv6 Structure - Learn about IPv6 Protocol Structure and Addressing - Know about security in using IPv6

    Read more...

  • eLearning Brother Master Suite (SGD)

    eLearning Brother Master Suite (SGD)

    SGD $6,648.67

    Course Description

    Original Price: $6,998.60 SGD                                       Sale Price: $6,648.67 SGD   Checkout via Smoovpay   Become an eLearning Rockstar | Characters | Scenarios | Games & Quizzes | Stock Assets | Icons | xAPI Templates | Mobile Learning | To be a true eLearning Rockstar™, you need the entire tool set. Meet the eLB Master Suite—the ultimate collection of eLearning resources. The eLB Master Suite gives you an unparalleled asset library, fully developed, customizable eLearning courses, and games from the award-winning game authoring tool, The Training Arcade™. Whatever form of training you need to develop, the eLB Master Suite will help you shine. Includes the following: * Cutout People  * eLearning Templates  * Stock Assets  * PowerPoint Graphics * Icons 

    Read more...

  • Articulate 360 Team (USD)

    Articulate 360 Team (USD)

    SGD $1,234.05

    Course Description

    Original Price: $1,299 USD                                               Sale: $1,234.05 USD   Checkout via Smoovpay   Get everything you need to create e-learning   Articulate 360 includes both Storyline and Rise, plus a slew of other authoring apps. Use Storyline 360 to develop custom, interactive courses that work on every device—without any manual tweaking. It's powerful enough for experts, but easy for beginners to create virtually any interaction imaginable. Choose Rise when you want to build fully responsive courses in minutes. All you need is a web browser to quickly create beautiful courses optimized for every screen size. “A Guide on Instructional Design Theories and Design Application” worth $500 USD will be bundled at no cost for purchase during Black Friday.   Check out original pricing @ https://articulate.com/pricing      

    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.