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

  • 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...

  • Microsoft Visio 2013

    Microsoft Visio 2013

    SGD $40.00

    Course Description

    Microsoft Visio 2013 is a powerful diagramming tool that helps create pictures out of complex information. Business plans, processes, flowcharts, organization charts, network diagrams, and more can be easily created with a few clicks of the mouse. In this VTC course, author Brian Culp introduces you to diagram creation by looking at a variety of diagram types and then by adding and editing the shapes these diagrams contain. He then shows you how to add personal touches to your diagrams by adding text, pictures, and changing shape styles. He also demonstrates how to integrate Visio with other Office applications, allowing for easy collaboration and sharing between diagram stakeholders. 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...

  • Google Docs & More: Maximize your online collaboration with Google

    Google Docs & More: Maximize your online collaboration with Google

    SGD $99.00

    Course Description

    Use Google Docs to create documents for collaboration with others online. Google™ Docs has numerous tools for editing and formatting your documents. In this online training series, we’ll learn to format text, add images, links, and comments. We’ll also explore tools for replacing words, checking spelling, and adding a table of contents. Make it easy to share your documents online and collaborate with others. We’ll explore some sharing options through email, invite individuals to collaborate, and manage our list of editors. You’ll also learn to assign ownership of a document, and set downloading options. Make it easy to share your documents online and collaborate with others! - Learn and understand the basics of Google Docs and their features - Be updated on the new kind of Web mail  - Learn techniques of Goggle's spreadsheet functions  - Know how Google™ Forms can bring productivity and results  This course is SkillsFuture Credit Eligible.

    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.