Notice : You are now accessing LOOP SIT SERVER. This is not meant for public access. For the actual LOOP Website please visit www.LOOP.sg instead


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

  • An Essential Online Course: Digital Collaboration with Office 365

    An Essential Online Course: Digital Collaboration with Office 365

    SGD $79.60

    Course Description

    Working with several separate software applications can be challenging. Microsoft Office 365 simplifies the process with an integrated collaboration and communication solution. Combining well known software applications with cloud features helps individuals and teams work together more productively. This course looks at the common features of Office 365 and how they can be used to support collaboration and communication. You and your staff will learn how to monitor and collaborate on projects and tasks, share knowledge and content with colleagues, and use social and communication tools efficiently. Discover the different products of Office 365 today! - Explore the different features in Office 365 - Know more about the functions of each individual product  - Learn about the purpose of the different products in Office 365 - Discover the usefulness of Office 365 for your job  This course is SkillsFuture Credit Eligible.

    Read more...

  • Microsoft Visio Training: From 2007 to 2013

    Microsoft Visio Training: From 2007 to 2013

    SGD $99.00

    Course Description

    Learn how Microsoft Office Visio makes it easy to visualize, explore, and communicate complex information. Instead of static pictures, create data-connected Visio diagrams that display data and are easy to refresh. Use the wide variety of diagrams in Visio to understand and share information about organizational systems, resources, and processes throughout your enterprise. You’ll learn about Visio’s interface: including the ribbon, stencils and shapes, and setting document properties. You’ll also learn how to work with pages, and backgrounds and layers. Lastly, we will demonstrate how to create an organization chart and a flowchart.Learn and adopt Microsoft Visio and improve your productivity.- Know and understand the different versions of Microsoft Visio - Know how Microsoft Visio can be applied into your work-life - Understand how Microsoft Visio can change your productivity - Enable yourself to produce work with satisfactory deliverables with Microsoft Visio This course is SkillsFuture Credit Eligible.

    Read more...

  • Learn about Digital Audio with Steinberg Cubase 6

    Learn about Digital Audio with Steinberg Cubase 6

    SGD $49.00

    Course Description

    Steinberg's Cubase 6 is the latest update to the extremely popular professional digital audio workstation music software. In this course, author Mark Struthers will demonstrate how to make initial input and output connections to the program from the soundcard before examining routing in more detail. Additionally, insert and group effects are explored to help show how to enhance recorded audio tracks. Mark will walk you through the many-featured project window before showing you how to create and save your own project. Within the Cubase workflow, important terms such as clips, events, and parts are explained along with the distinction between lanes and tracks. Mark also covers insert and send effects, quantization, time stretch, and the Media Bay. Cubase comes equipped with VST instruments and, in particular, Groove Agent One and Halion Sonic SE are explored before working through the concepts behind a final mix and export to a finished audio track. Be able to produce music recording, arranging and editing with Steinberg. - Learn how to work with audio files using Steinberg- Know how Steinberg works as an audio editing software- Enable yourself to be able to produce your own music with Steinberg - Learn about the different techniques used in Steinberg to achieve quality audioThis 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.