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.

    Read more...

  • 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

    Read more...

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

    Read more...


Content

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

SmartArt

Shapes

More Complex Functions

+

Using IF to Make Calculations

Using SUMIF & COUNTIF

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

Views

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

Conclusion

+
Resource Files

Course Wrap Up

Credits

+

About the Author

SGD $45.00
(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.