Microsoft Excel: 2013 & Online Training Essentials


  • Microsoft Excel: 2013 & Online Training Essentials, Singapore SKillsFuture elarning online course
  • Microsoft Excel: 2013 & Online Training Essentials, Singapore SKillsFuture elarning online course
  • Microsoft Excel: 2013 & Online Training Essentials, Singapore SKillsFuture elarning online course
  • Microsoft Excel: 2013 & Online Training Essentials, Singapore SKillsFuture elarning online course
  • Microsoft Excel: 2013 & Online Training Essentials, Singapore SKillsFuture elarning online course
  • Microsoft Excel: 2013 & Online Training Essentials, Singapore SKillsFuture elarning online course

Course Description

Microsoft Excel 2013 is a powerful spreadsheet application that is perfect for maintaining long lists of data, budgets, sales figures and other data. In this online series of training tutorials, we'll show you how to navigate through the basics of Excel and use some new features including Skycloud -- which allows you to share and store files in a location where you can access them with any computer that has Excel. Additionally, you'll learn how to create tables, move information around with ease, and use formulas that can calculate the totals of everything from a monthly budget to a loan payment. Microsoft 2013 has been redesigned and several common functions are now much easier to use.

This training series will make sure you get the most out of the Microsoft Excel 2013.

- Learn the essential components of Microsoft Excel 2013
- Learn about the new features of Microsoft Excel 2013
- Understand how to apply the functions into real excel spreadsheets
- Equip yourself with these skillset and improve your productivity

This course is SkillsFuture Credit Eligible.


Course Objectives

1. Create tables, move information around with ease, use formulas, etc.
2. Leverage the chart elements and formatting options to energize and highlight your data.
3. Set-up formulas to ensure you're using all the features Microsoft Excel 2013 has to offer.
4. Set, control and check that data entered into Microsoft Excel 2013 is valid.
5. Create PivotChart, Sparklines and other elements to better visually represent your data.
6. Protect your Excel cells, worksheets, and workbooks in Excel® 2013.


Related Courses

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

  • Effective Outlook

    Effective Outlook

    SGD $79.60

    Course Description

    Email is the most widely used form of business communication, but also one of the main causes of lost productivity in the workplace. Managing tasks and meetings is crucial to working effectively and professionally, so proficiency with emails and email-management systems has a powerful impact on the day-to-day productivity, efficiency, punctuality and success of businesses. This course will help you to improve the organization and productivity of your staff by optimizing their use of Microsoft Outlook. It will teach principles and techniques that ensure an efficient and effective use of emails, contacts, calendars and notes throughout the business. ​ Discover ways for you to stay afloat of your emails. - Learn the different functions in Outlook that can help with your emails - Discover ways that suit your style of maintaining your inbox - Enable yourself to be more productive with Outlook  - Learn about the advantages of using Outlook 

    Read more...

  • Microsoft SharePoint Server: 2007 & 2010

    Microsoft SharePoint Server: 2007 & 2010

    SGD $99.00

    Course Description

    Microsoft Office SharePoint Server 2007 is an integrated suite of server capabilities that can help improve organizational effectiveness by providing comprehensive content management including sharing of documents, photos and calendar events. This tutorial series covers the end user basics of this collaborative content management server. SharePoint “unleashes a suite of capabilities that dramatically improves the way people work”. Help improve organizational effectiveness by providing comprehensive content management including sharing of documents, photos and calendar events.  Know how to collaborate with SharePoint! - Learn about the features and functions offered in Microsoft SharePoint  - Find out how to improve your productivity using Microsoft SharePoint  - Understand the functionality of the tools in Microsoft SharePoint  - Know how you can adopt SharePoint into your daily work  This course is SkillsFuture Credit Eligible.

    Read more...


Content

Excel 2013 - Intro Training

+
Understand the basics introduction to Excel 2013
  • Basics, Customization
  • Controlling the Worksheet View
  • Working with Cells
  • Sorting and Filtering
  • Formulas and Functions
  • Formatting Cells
  • Working with Columns and Rows
  • Outlines
  • Styles
  • Theme and Tables
  • Workbook Views and Page Setup
  • Printing

Excel 2013 - Charting Training

+
Know how to chart your data, how to use the tabs and ribbons in Excel 2013
  • Getting Started
  • An Overview of Charts
  • Using the Chart Tabs and Ribbons
  • Formatting Your Chart
  • Presenting Your Chart
  • Working with Sparklines

Excel 2013 - Frequently Used Formulas & Functions Training

+
Explore the Frequently Used Formula and Functions in your excel
  • Getting Started
  • Formulas
  • Linking and Consolidating Worksheets
  • Auditing and Error Checking

Excel 2013 - Evaluating Data Training

+
Learn how to evaluate your data in Excel 2013
  • Getting Started
  • Data Validation
  • Conditional Formatting

Excel 2013 - Pivot Tables Training

+
Create PivotCharts, Sparklines and other elements to better visually represent your data.
  • Getting Started
  • Creating & Deleting
  • Custom Appearance & Layout
  • Printing Options & Copying a Pivot Table
  • Summarizing with Totals & Formulas
  • Refreshing Data
  • Pivot Charts
  • Sparklines and Slicers

Excel 2013 - Protecting Your Spreadsheets

+
Know how to protect your sheets in Excel 2013
  • Protecting Your Spreadsheet

Excel 2016 PC

+
Have an overview of the features of Excel 2016
  • Getting Started
  • Work with Data and Datasets
  • Create Formulas
  • Manage Data and Datasets
  • Format Your Table
  • Work with Sheets
  • Work with Charts
  • Share and Secure Data
  • Import and Export Data

Excel Online

+
Know the basics of Excel Online
  • Basics
  • Working with Cells and Data
  • Survey
  • Comment
  • File Tab 
  • Print
  • Share and Collaborate
SkillsFuture Credit Eligible
SGD $99.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.