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

  • Microsoft Excel: 2013 & Online Training Essentials

    Microsoft Excel: 2013 & Online Training Essentials

    SGD $99.00

    Course Description

    Microsoft Excel 2013 is a powerful spreadsheet application that is perfect for maintaining long lists of data, budgets, sales figures and other data. In this online series of training tutorials, we'll show you how to navigate through the basics of Excel and use some new features including Skycloud -- which allows you to share and store files in a location where you can access them with any computer that has Excel. Additionally, you'll learn how to create tables, move information around with ease, and use formulas that can calculate the totals of everything from a monthly budget to a loan payment. Microsoft 2013 has been redesigned and several common functions are now much easier to use.This training series will make sure you get the most out of the Microsoft Excel 2013.- Learn the essential components of Microsoft Excel 2013- Learn about the new features of Microsoft Excel 2013- Understand how to apply the functions into real excel spreadsheets - Equip yourself with these skillset and improve your productivity This course is SkillsFuture Credit Eligible.

    Read more...

  • PowerPoint & Prezi: Includes Powerpoint 2013, 2016 and Powerpoint Online

    PowerPoint & Prezi: Includes Powerpoint 2013, 2016 and Powerpoint Online

    SGD $99.00

    Course Description

    Learn the power of presentation through the two popular tools of Prezi and Microsoft PowerPoint. Whether you are presenting by yourself in front of a group, or collaborating with others for a presentation with others, you will find what you need in this training. Add media, pictures, share with others, and make your presentation look professional and polished after participating in this training. Prezi is a web-based presentation application and storytelling tool that uses a single, infinite canvas instead of traditional slides. In this online training series, you'll learn how to create non-linear presentations, zoom in and out of a visual map, create a path through different objects, add 3D backgrounds, and add a layout to represent the order of the information to be presented. You'll also learn how to collaborate with others on Prezi presentations and share your Prezis in engaging live presentations, in simple and convenient remote presentations, and on social media. Wow your audience with dynamic presentation slides! - Learn how to produce effective presentation materials - Find out more about creating presentation with Prezi - Learn how to utilize the functions of both applications  - Know how to customize your slides with Microsoft PowerPoint and Prezi  This course is SkillsFuture Credit Eligible.

    Read more...

  • Understand your Database with Microsoft Access 2010

    Understand your Database with Microsoft Access 2010

    SGD $49.00

    Course Description

    As part of the release of the Office 2010 software suite, Microsoft is introducing the latest version of Access, their entry-level database application software. Don't let the words 'entry-level' fool you, this is one very powerful database tool. Access was designed to collect, store, manage, report, and dissect data for individuals and small businesses. The release of the 2010 version continues to raise the bar of what an entry-level database product can do. In this course, Mark Long takes you from opening Access 2010 for the first time through the entire process of creating a database. He covers tables, queries, forms, reports, and many of the other bells and whistles that make up Access 2010. Realise the full potential of your data with Microsoft Access. - Learn about the functions in Microsoft Access that can help your understand data better - Know the different ways of vizualising your data with Microsoft Access- Pick up the knowledge of utilizing Access 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.