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

  • An Essential Online Course: PivotTable Course (PC: 2013 & 2007/10)

    An Essential Online Course: PivotTable Course (PC: 2013 & 2007/10)

    SGD $49.60

    Course Description

    Microsoft Excel is an important and powerful program for many businesses. The PivotTable feature is one of the most useful, powerful and misunderstood features. PivotTables are absolutely not just about big data and large companies. Although PivotTables can work with very large data sets they are just as useful for micro businesses trying to understand where their sales opportunities lie or for individuals working on their household finances or even their fantasy football leagues. This PivotTable course from Skillsology teaches you how to draw these conclusions easily and present and manage your findings effectively. Using screenshots, video examples and exercises, you’ll soon be able to make the most out of your data, whether ‘Big’ or small, to further your business or personal life. Turn redundant data into useful analysis with PivotTable.  - Manage your data and information in a more intelligent system  - Realize your data's full potential to your advantage  - Discover ways to enhance your data output  - Learn about the advantages of PivotTable    This training is for PivotTable (PC version: 2013, 2007/10) This course is SkillsFuture Credit Eligible.

    Read more...

  • Maximize your Database with Microsoft Access 2013

    Maximize your Database with Microsoft Access 2013

    SGD $40.00

    Course Description

    Microsoft Access 2013 is the latest version of the number one database application in the world, and this is a big release. Access 2013 brings quite a few changes, all designed to make database applications easier to design and implement. The ability to quickly create Web Applications that run in the user's browser, regardless of which device they use, is one of the major changes in the latest release. In this VTC course, author Mark Long takes you step by step through Access 2013 to quickly get you up to speed on these changes. Access is everywhere, from small one-person businesses up to the largest corporations in the world. It's where most data first gets stored before progressing to SQL Server, cloud delivery, and enterprise data services. Understanding Access is vital to real world database creation/maintenance/design and this course will show you what you need to get there. 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...

  • 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

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.