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

  • Dive into the Diversity of Google Apps

    Dive into the Diversity of Google Apps

    SGD $40.00

    Course Description

    Google provides a suite of cloud-based applications that can be accessed anywhere, anytime on various platforms. In this course students will be shown how to use Google Drive, Docs, Sheets, Slides, Forms, Calendar, Gmail & Hangouts. Students will also be given information on other Google products such as Sites and Google+. For those that are interested in subscription based services, Google Admin Console information will be provided to acquire the knowledge needed to get started as an administrator. Google’s cloud based services are available to everyone to use for productivity and collaboration. Know all about Google's Apps with this course! - Learn about the different applications in Google  - Understand how the different applications function - Learn about the features and functions of Google Apps  - Know how to make full use out of the features 

    Read more...

  • Cakewalk SONAR X1 Producer Edition: Know how to work with audio

    Cakewalk SONAR X1 Producer Edition: Know how to work with audio

    SGD $54.00

    Course Description

    Cakewalk SONAR X1 is the most recent update in a long line of full-featured Digital Audio Workstations on the cutting edge of audio production. Packaged with one of the largest set of features and tools in any audio application, it can be overwhelming to master. Sam McGuire, audio engineer, author, and educator, explains Sonar using a variety of examples and real world work flows. Follow along using the provided work files and explore the multifaceted features of Sonar with Sam as your guide. Both first-time Sonar users who are trying to figure out basic tasks and experienced veterans who are looking to explore the latest features will find just what they are looking for in this VTC course. Create your own original works with Cakewalk SONAR!- Learn the tools and techniques of Cakewalk SONAR- Know how to enhance audio files with Cakewalk SONAR- Discover the secrets of producing a quality audio files- Learn the ropes of creating your own master piece with this course This course is SkillsFuture Credit Eligible.

    Read more...

  • Google Sheets

    Google Sheets

    SGD $49.60

    Course Description

    Google Spreadsheets is rapidly overtaking Microsoft Excel in the workplace. Engage with this exciting new product and become a Google Sheets Master with this course. Google Sheets replicates many of Excel’s functions but has gone one step further. Expect to find charts, graphs, pivot tables, functions and formulas, but you’ll also discover what makes Google Sheets unique, like file sharing, revision history, web based scripts, macros, and much more. It’s not your typical spreadsheet. Keep up with the latest trend on how documents are made.  - Know about all of the functions in Google Sheets - Learn how you can apply Google Sheets into your work  - Learn about the different functions of Google Sheets - Know how Google Sheets can used in your projects 

    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.