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

  • Google Apps for Business

    Google Apps for Business

    SGD $45.00

    Course Description

    Whether you are a business owner, personal google apps user, or google apps administrator, this VTC Google Apps for Business course has been designed to take you from a beginner to an advanced user in no time at all. It will cover each Google App in detail including lots of great functionality that will impress your friends, family, and co-workers. You can easily jump to sections of the course that are relevant to you, including Google Apps Setup, Gmail, Contacts, Tasks, Calendar, Groups, and Drive. Drive is really where cloud computing comes to life; Documents, Spreadsheets, Presentations, and Forms each get their own chapter because their functionality is so rich. This phenomenal course is packed to brim with goodness and draws upon Andrew Martin's many years of experience working with and teaching Google Apps. Get ready to transform your way of working while you bring collaboration and efficiency to your project or company. TKnow all about Google's Apps with this course!- Learn about the different applications in Google - Understand how the different applications function- Learn about the features and functions of Google Apps - Know how to make full use out of the features 

    Read more...

  • An Essential Online Course: Increase Your Productivity with Microsoft SharePoint

    An Essential Online Course: Increase Your Productivity with Microsoft SharePoint

    SGD $79.60

    Course Description

    As companies and organizations globalize and economies interweave, teams are increasingly separated by geography, time zones, languages and cultural differences. No matter the environment, SharePoint helps turn individuals into high-performing project teams by providing - a consistent web-site interface, content management, collaboration, work management and business intelligence and reporting through integration with MS Excel and Excel Services Increase your productivity by utilizing SharePoint. - Discover how SharePoint can be added to your advantage  - Explore the different features of SharePoint that can increase your productivity  - Know the different features in SharePoint to gain full usability   This course is Skillsfuture Credit Eligible.

    Read more...

  • PostgreSQL: Know how to handle database jobs

    PostgreSQL: Know how to handle database jobs

    SGD $45.00

    Course Description

    This VTC course is an introduction to the popular open source and free database management system PostgreSQL. Author Dima Kassab covers the basics needed to create databases and database objects. The course assumes no prior knowledge of database concepts. It sets the groundwork for more advanced topics such as database administration and development. Topics covered include: installations, data types, main database operators/functions, and creating/modifying database objects such as tables, views, indexes, and sequences. Take the first step in maintaining your database.- Learn how to maintain your database - Know about the features and functions of PostgreSQL.- Learn about the different administrative tools available- Be able to handle and monitor the activity in your database 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.