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

  • Audio Mixing Essentials

    Audio Mixing Essentials

    SGD $54.00

    Course Description

    VTC's Audio Mixing Essentials is an advanced course on the often mysterious art of audio mixing. Instead of showing you how to open an equalizer plug-in in a specific program, this tutorial will show you how to use an equalizer (in any program) in order to improve the sound of your next mix. This course first discusses the mixing process and then uses two mixing examples to demonstrate mixing from start to finish (“This Too Shall Pass” by Mile High Chapter and “Night Train To Cairo” by Scot). The mixing of the second project is done in work files and referenced in the course so that they have no narration in order to place more attention on the audio adjustments being made. This course will give any novice recording engineer the tools, techniques, and knowledge to effectively mix professional sounding projects.Master the mysterious art of audio mixing. - Learn the tools and techniques of audio mixing- Know what to use to produce good audio - Discover the secrets of producing a quality audio - Learn the ropes of creating your own master piece with this course This course is SkillsFuture Credit Eligible.

    Read more...

  • Sony DVD Architect Pro 5

    Sony DVD Architect Pro 5

    SGD $45.00

    Course Description

    Sony DVD Architect Pro 5 is the latest update to the extremely popular professional digital video authoring software. In this VTC course, users will be shown the initial system requirements necessary to run the program smoothly. Author Mark Struthers will then discuss the main functions as he demonstrates several methods for creating different types of projects including Menu-Based Projects and Music & Video Compilations. Important considerations such as Masks, Menus, and Themes are analyzed along the way. To conclude the course, methods of transferring projects to DVD are covered. Swiftly create professional-looking DVDs, even stunning widescreen productions. - Learn what goes into creating a DVD - Be able to create different kind of content in DVD - Learn how to create your own media content using Sony DVD Architect - Learn how to polish your projects before transferring into DVD

    Read more...

  • Math & Statistics: Training Tutorials for SPSS and Graphic Calculators

    Math & Statistics: Training Tutorials for SPSS and Graphic Calculators

    SGD $99.00

    Course Description

    SPSS Statistics is a software package used for statistical analysis. Long produced by SPSS Inc., it was acquired by IBM in 2009. The current versions (2015) are officially named IBM SPSS Statistics. Master Math & Statistics with this bundled course that includes training tutorials on BA II PLUS PROFESSIONAL, SPSS, TI-30XS MultiView calculator, IBM SPSS Statistics, TI-Nspire handheld, TI-Nspire CX handheld and TI-84 Plus C Silver Edition. Atomic Learning has teamed up with Texas Instruments to create tutorials that answer common questions students and teachers may have when learning how to use TI-Nspire™ and TI-Nspire™ CAS math and science learning technology. Be able to understand and utilize your analysis with SPSS. - Improve your business using SPSS analytic functions- Using SPSS, examine and solve a research problem, from hypothesis testing to the power analysis- Using BA II PLUS PROFESSIONAL to take advantage of all the same time-saving financial functions- Learn about TI-Nspire handheld, TI-Nspire CX handheld and TI-84 Plus C Silver Edition graphing calculator

    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.