Discover Hidden Secrets of Microsoft Excel 2013

  • Discover Hidden Secrets of Microsoft Excel 2013, Singapore elarning online course
  • Discover Hidden Secrets of Microsoft Excel 2013, Singapore elarning online course
  • Discover Hidden Secrets of Microsoft Excel 2013, Singapore elarning online course
  • Discover Hidden Secrets of Microsoft Excel 2013, Singapore elarning online course
  • Discover Hidden Secrets of Microsoft Excel 2013, Singapore elarning online course
  • Discover Hidden Secrets of Microsoft Excel 2013, Singapore elarning online course

Course Description

This VTC course will give you the knowledge and skills you need to get the most out of Microsoft Excel 2013. You will learn about the Excel interface by working in it. You will create and format worksheets, make calculations, create charts, and use tools to analyze data in meaningful ways. Author Helen Bradley teaches Excel from a business perspective, focusing on tools that maximize productivity and accuracy. She demonstrates how to design worksheets intelligently and then shows you how to check for accuracy to ensure that worksheets return correct results. She also covers automating data entry, testing formulas, and using PivotTables for data analysis. She concludes with a discussion of SkyDrive and the Excel WebApp.

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

Course Objectives

1. Know and understand the basics of Microsoft Excel 
2. Know how to navigate the interface and tool panel in Microsoft Excel 
3. Able to apply the basic steps such as - Creating a Workbook, Working in a Workbook
4. Understand the basic formulas available and be able to apply them into projects 
5. Able to work with charts, images and art in Microsoft Excel 
6. Understand about PivotTable and working with big data in Excel
7. Know how to navigate Excel when working with Spreadsheet Design 

Related Courses

  • Microsoft Office: From 2010 to 2016 & Office 365

    Microsoft Office: From 2010 to 2016 & Office 365

    SGD $99.00

    Course Description

    Take a look at many of the new changes that have been made to Microsoft® Office® Suite 2013, specifically Word®, Excel®, and PowerPoint®.  Not only has the user interface changed, but Office 2013 also includes many new features and commands that will allow you to customize your environment and help you become more productive. This online training series will give you a jump start on getting acquainted with the new look and features in Office Suite 2013.Learn about the major changes to Word, Excel, and PowerPoint as well as the user interface.- Be more productive by incorporating Microsoft® Office® Suite into your daily task - Learn more about their tools and functions in each application- Understand and be able to utilize the applications - Learn the purpose and features of each product This course is SkillsFuture Credit Eligible.


  • Learn about Digital Audio with Steinberg WaveLab 7

    Learn about Digital Audio with Steinberg WaveLab 7

    SGD $45.00

    Course Description

    Steinberg Wavelab 7 is a professionally featured audio editor and mastering suite that also includes the option to create podcasts. It enjoys a fantastic reputation not only with professionals, but also with enthusiasts because of its simple and elegant user interface. Aimed at new and experienced users, this course walks through the program requirements while looking at the user interface and its many new features including the Switcher, Workspaces, Master Section Effects, and Tool Windows. By working with provided audio files, the course demonstrates implementing effects and works toward using the Audio Montage feature that allows Wavelab to act in a similar way to an audio sequencer. Along the way, Wavelab's visual analysis tools are scrutinized as they help the user sculpt their audio recordings. Additionally, the course looks at how to convert audio files into Red Book standard CDs and finishes with a look at the Podcasting workspace that has now become an integral aspect of Wavelab 7. 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 audio


  • 1st step towards 3D Modelling: Substance Designer 2.1

    1st step towards 3D Modelling: Substance Designer 2.1

    SGD $45.00

    Course Description

    Substance Designer is a revolutionary next generation tool for the creation of smart textures for 3D. Designed to fully leverage Raster, Vector, and Procedural image-making technologies along with advanced filtering techniques to create multichannel texture assets which can be dynamically changed by the end user at run time. The resulting files, known as “Substances,’ are a remarkably flexible solution for many 3D texturing needs including Video Game Design and Architectural Visualization. This latest version of Substance Designer is a must-have for anybody who is serious about working in 3D. Taught by 2D and 3D artist Jason Maranto, this VTC course is designed to quickly elevate your understanding of this powerful application. Focusing heavily on the sophisticated tools available within Substance Designer and taught in an in-depth but easy-to-follow style, this course will help you master Substance Designer to create 3D texture assets of unparalleled flexibility and power.Discover more possibilities with 3D modelling.- Learn about the multiple functions in Substance Designer - Find out how Substance Designer can produce satisfactory models - Know more about the versatility of creating 3D models- Upgrade your modelling process to the latest software available in the market This course is SkillsFuture Credit Eligible.



Excel Basics

Preview Available


About Excel

Start Screen

Ribbon QAT and Status Bar

Backstage View

Menus / Mini Toolbar / Task Panes

Get Help

Getting Started


Open and Close a Workbook

Move Around in a Workbook

Save a Workbook

Work with Accounts in Excel

Create a New Workbook

Use an Excel Template

Entering Data


Enter Text and Headings

Enter Numbers

Enter Dates

AutoFill Dates

AutoFill Numbers

AutoFill Text

Create an AutoFill Series

Enter Hyperlinks

Rearranging a Worksheet


Size Columns and Rows

Insert & Delete Rows & Columns

Copy or Move Data

Copy or Move a Worksheet

Transpose Data

Basic Formulas & Functions

Preview Available


Using SUM and AutoSum

Doing Simple Math

Order of Operations

Calculating Averages

Quick Analysis - Totals

Adding & Subtracting Dates

Copy Formulas

Absolute & Relative Addressing

Naming Ranges

Calculating Using Names

Understanding Errors

Evaluating a Formula

Formatting a Worksheet


Format Numbers

Format Dates

Format with Color

Use Worksheet Themes

Add Borders

Conditional Formatting pt. 1

Conditional Formatting pt. 2

Borrow Table Formats

Create and Use Styles

Paint and Clear Formats

Creating Charts


Create a Chart

Add Chart Titles and Legends

Format a Chart pt. 1

Format a Chart pt. 2

Create a Pie Chart

Understanding Chart Types

Plot Data on Multiple Axes

Create Sparklines

Adding Art


ClipArt and Photos

Worksheet Backgrounds & Watermarks



More Complex Functions


Using IF to Make Calculations


Calculating with SUMPRODUCT

Random Numbers with RANDBETWEEN

Find and Use Functions

Building a Mortgage Calculator

Working with Tables


Create and Format a Table

Create a Chart of Table Data

Calculations in a Table

Use the Subtotal Function

Filter Table Data

Sort Data in a Table

Working with PivotTables


PivotTables Introduction

Create a PivotTable

Query a PivotTable

Use Slicers

Create a PivotChart

Working with Large Worksheets


Freeze Panes

Headers & Footers


Find & Replace

Manipulate Data with Flash Fill

Remove Duplicate Data

Advanced Tools & Techniques


Goal Seek

Create and Use a Watch Window

Create and Save a Template

Calculate Across Multiple Worksheets

Working with Comments

Use a Lookup Table pt. 1

Use a Lookup Table pt. 2

Import Data into Excel

Find Precedents and Dependents

Use Data Validation

Enter Data Using Data Validation

Work with Other Office Programs

Printing a Worksheet


Set Up a Worksheet for Printing

Shrink to Fit

Configure Printing Options

Print a Chart

Print a Selection

Print to PDF

Spreadsheet Design


Design Basics

Create a Data Area

Work with Multi-Sheet Workbooks

Protect a Worksheet

Error Checking and Testing

Spell Check and AutoCorrect

Automating with Macros


Understanding Macros

Record a Macro

Run a Macro

Explore the Visual Basic Editor

Working with Skydrive


SkyDrive Introduction

Save and Open SkyDrive Files

Work in the Excel Web App

How to Use SkyDrive


Resource Files

Course Wrap Up



About the Author

SGD $45.00
(Price excludes GST)
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.