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

  • Corel Painter 2016

    Corel Painter 2016

    SGD $45.00

    Course Description

    Corel Painter 2016 is the latest new update for the powerful and popular natural media emulator which is used by professional creative artists in a wide variety of genres and styles. This course, taught by longtime illustrator and fine artist Jason Maranto, is designed to quickly familiarize you with the core features of this powerful application. Focusing on all the main tools and functions with an in-depth but easy to follow style, this course is packed with professional workflow tips and tricks, and will help you to master Painter and create with confidence like never before.Dive into Corel Painter and unleash your artistic flare!- Learn about the tools and techniques available in Corel Painter - Know about the different types of tools and techniques used in Corel Painter - Discover the capability of Corel Painter to create dynamic creative content - Be able to produce content that can rival physical painting 

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

  • Microsoft Office for Mac 2011

    Microsoft Office for Mac 2011

    SGD $45.00

    Course Description

    Office for Mac 2011 is a powerful update of the widely used productivity suite. Mac users now have access to a slew of updated features which are designed to simplify workflow while still maintaining the incredible strength of inter-application collaboration. This VTC course explores the 2011 update through a detail driven approach and with the help of practical examples. All of the major applications in Office are covered, along with several of the lesser profile utilities. Office may be constantly changing, but that doesn't mean you need to be left behind! Jump on board with Sam McGuire and get the very most out of the tools you use on a daily basis. 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 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.