An Essential Online Course: Advanced Microsoft Excel Course (PC: 2013, 2007/2010, 2016)


  • An Essential Online Course: Advanced Microsoft Excel Course (PC: 2013, 2007/2010, 2016), Singapore SKillsFuture elarning online course
  • An Essential Online Course: Advanced Microsoft Excel Course (PC: 2013, 2007/2010, 2016), Singapore SKillsFuture elarning online course
  • An Essential Online Course: Advanced Microsoft Excel Course (PC: 2013, 2007/2010, 2016), Singapore SKillsFuture elarning online course
  • An Essential Online Course: Advanced Microsoft Excel Course (PC: 2013, 2007/2010, 2016), Singapore SKillsFuture elarning online course
  • An Essential Online Course: Advanced Microsoft Excel Course (PC: 2013, 2007/2010, 2016), Singapore SKillsFuture elarning online course
  • An Essential Online Course: Advanced Microsoft Excel Course (PC: 2013, 2007/2010, 2016), Singapore SKillsFuture elarning online course

Course Description

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, Mac OS X, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of Microsoft Office. Demystify some of the most complex business relevant areas of Microsoft Excel. With 160 videos and loads of practice exercises you will be able to use the most hard to grasp Excel functions in no time.

Grasp this chance to immerse in the knowledge of Advanced Microsoft Excel

- Further your knowledge in Microsoft Excel
- Learn about advanced steps and functions that you have yet to find out
- Gain an advantage when presenting your next spreadsheet
- Be equipped with an extra set of skills in Microsoft Excel

Training for Advanced Excel (PC version:2013, 2007/2010, 2016)

This course is Skillsfuture Credit Eligible.


Course Objectives

1. Using advanced graphs and presentation techniques to maximize impact
2. How macros and VBA automate your spreadsheets and increase interactivity
3. How superpower functions can solve complex problems
4. Using PivotTables and PowerPivot to turn raw data into clear information that supports key decisions


Related Courses

  • Discover More of Your Data with Microsoft Excel

    Discover More of Your Data with Microsoft Excel

    SGD $40.00

    Course Description

    Microsoft Excel is one of the most popular programs to use for analyzing, extracting, and cleaning the tremendous amounts of data that we have collected. Learn how Microsoft Excel can manage and summarize your data with PowerPivot and Pivot Tables, automation and coding, along with the standard features of Arrays, functions such as MATCH and INDEX, and the Data Analysis Tools. Understand speed and file size limitations while appreciating the art of data cleaning and manipulation. Explore how the What If Analysis tools can help with plans and forecasts and consolidate and link data for interactive reports. This course will allow you to unleash the power of Excel to make accurate decisions based on your data and Excel's power.Realise the full potential of your data with Microsoft Excel. - Learn about the functions in Excel that can help your understand data better - Know the different ways of vizualising your data with Excel- Pick up the knowledge of utilizing Excel for better understanding your data- Learn how you can stretch your data for optimum analysis This course is SkillsFuture Credit Eligible.

    Read more...

  • Corel Painter 2016

    Corel Painter 2016

    SGD $45.00

    Course Description

    Corel Painter 2016 is the latest new update for the powerful and popular natural media emulator which is used by professional creative artists in a wide variety of genres and styles. This 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 but easy to follow style, this course is packed with professional workflow tips and tricks, and 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 

    Read more...

  • Essential Online Course - Microsoft Excel 2016

    Essential Online Course - Microsoft Excel 2016

    SGD $299.00

    Course Description

    Microsoft Excel is the standard spreadsheet application for both personal and business use, so staying on top of the latest version is very important for anyone considering career advancement. Regardless of your level of understanding, you will benefit from this Microsoft Excel 2016 training course because it covers basic, intermediate and advanced competency levels. Our Microsoft Excel 2016 training course will help arm you with the knowledge to use it more effectively whether you are using it at home or in the workplace. Understand how to manipulate data within a spreadsheet, validate and present information using the built in structure and functions of Microsoft Excel. Realise the full potential of your data with Microsoft Excel. - Learn about the functions in Excel that can help your understand data better  - Know the different ways of vizualising your data with Excel - Pick up the knowledge of utilizing Excel for better understanding your data - Learn how you can stretch your data for optimum analysis

    Read more...


Content

Advanced Excel 2007/2010 PC

+
Know about the advanced features of Excel 2007/2010
  • Section 1: Design and Risk
    • Unit 1.1 - Templates
    • Unit 1.2 - Efficiency and Risk
    • Unit 1.3 - Data Validation
  • Section 2: Advanced Techniques
    • Unit 2.1 - Functions and Superpowers
    • Unit 2.2 - Array Formulae
    • Unit 2.3 - Tables
    • Unit 2.4 - Advanced Range Names
    • Unit 2.5 - What If?
    • Unit 2.6 - Problem Solving
  • Section 3: Excel Interactivity
    • Unit 3.1 - Form Controls
    • Unit 3.2 - Visual Basic and Macros
  • Section 4: Spreadsheet Impact
    • Unit 4.1 - Practical Interactivity with VBA
    • Unit 4.2 - Conditional Formatting
    • Unit 4.3 - Charts that Inspire
    • Unit 4.4 - Sparklines
    • Unit 4.5 - Graphics Tricks and Techniques
    • Unit 4.6 - Working with External Data
  • Section 5: Turning Data into Decisions
    • Unit 5.1 - Advanced Uses of PivotTables
    • Unit 5.2 - PowerPivot
    • Unit 5.3 - Reporting with PowerPivot

Advanced Excel 2013 PC

+
Know about the advanced features of Excel 2013
  • Section 1: Design and Risk
    • Unit 1.1 - Templates
    • Unit 1.2 - Efficiency and Risk
    • Unit 1.3 - Data Validation
  • Section 2: Advanced Techniques
    • Unit 2.1 - Functions and Superpowers
    • Unit 2.2 - Array Formulae
    • Unit 2.3 - Tables
    • Unit 2.4 - Advanced Range Names
    • Unit 2.5 - What If?
    • Unit 2.6 - Problem Solving?
  • Section 3: Excel Interactivity
    • Unit 3.1 - Form Controls
    • Unit 3.2 - Visual Basic and Macros
  • Section 4: Spreadsheet Impact
    • Unit 4.1 - Practical Interactivity with VBA
    • Unit 4.2 - Conditional Formatting
    • Unit 4.3 - Charts that Inspire
    • Unit 4.4 - Sparklines
    • Unit 4.5 - Graphics Tricks and Techniques
  • Section 5: Turning Data into Decisions
    • Unit 5.1 - Working with External Data
    • Unit 5.2 - Advanced Uses of PivotTables
    • Unit 5.3 - PowerPivot
    • Unit 5.4 - Reporting with PowerPivot

Advanced Excel 2016 PC

+
Know about the advanced features in Excel 2016
  • Section 1: Efficiency and Risk
    • Unit 1.1 - Templates
    • Unit 1.2 - Increasing Efficiency and Reducing Risk
    • Unit 1.3 - Data Validation
  • Section 2: Advanced Techniques
    • Unit 2.1 - Functions with Superpowers
    • Unit 2.2 - Array Formulae
    • Unit 2.3 - Tables
    • Unit 2.4 - Advanced Range Names
    • Unit 2.5 - What If Analysis
    • Unit 2.6 - Problem Solving
  • Section 3: Excel Interactivity
    • Unit 3.1 - Form Controls
    • Unit 3.2 - Visual Basic and Macros
  • Section 4: Spreadsheet Impact
    • Unit 4.1 - Conditional Formatting
    • Unit 4.2 - Charts that Inspire
    • Unit 4.3 - Sparklines
    • Unit 4.4 - Graphics Tricks and Techniques
  • Section 5: Turning Data into Decisions
    • Unit 5.1 - Working with External Data
    • Unit 5.2 - Advanced Uses of PivotTables
    • Unit 5.3 - PowerPivot
    • Unit 5.4 - Reporting with PowerPivot
  • Section 6: Course Plenary
    • Unit 6.1 - Course Plenary
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.