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

  • Corel Painter X3: Create Digital Art Pieces

    Corel Painter X3: Create Digital Art Pieces

    SGD $58.00

    Course Description

    Painter X3 is Corel's latest update to their powerful and popular natural media emulator which is used by professional creative artists in a wide variety of genres and styles. This VTC 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 yet easy-to-follow style, this course is packed with professional workflow tips and tricks that it will help you to master Painter in no time. Dive into Corel Painter and unleash your artistic flare!- Learn about the tools and techniques available in Corel Painter X3 - Know about the different types of tools and techniques used in Corel Painter X3- Discover the capability of Corel Painter X3 to create dynamic creative content - Be able to produce content that can rival physical painting This 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...

  • Cubase 8

    Cubase 8

    SGD $45.00

    Course Description

    Steinberg's Cubase Elements 8 is their entry level, professional digital audio workstation. It contains all the aspiring musician and mix engineer requires to get started with audio and midi recording compositions. This VTC course covers installation issues and preference setting before moving on to connecting the program to a relevant soundcard. As the course progresses, functions such as creating busses and the implementation of the inspector are looked at prior to focusing on building a project.Learn how to work with audio files with Cubase 8. - Know how Cubase 8 handles audio files- Learn how to edit your own audio files with Cubase 8- Discover the potential of Cubase 8 with your audio files- Master audio editing with all the right tools and techniques in Cubase 8

    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.