Microsoft Excel 2013: Set of 3 Interactive Courses

Producer: Gopas

Duration: 49 hours.
This product is an online product and is a single-user, 1-year licence.

Overview

In this bundle of all three Excel 2013 courses you will familiarise yourself with the tools of the most widely applied spreadsheet program. Via the interactive lessons, you will first get acquainted with the program environment. You will learn how to properly enter values to the cells of future tables and how to set their format. From these input values, you will further derive new data by calculating them through formulas, including the applied functions from various categories. You will learn to manipulate cell ranges and whole worksheets. You will adjust the appearance of created tables by setting the cell properties and by applying cell styles. You will analyse the entered data via charts and conditional formatting. You will learn to set the print properties before printing created tables and charts. You will also learn to sort and filter more extensive data and to calculate their subtotals. You will familiarise yourself with the data validation, the creation of scenarios and with the application of the Solver tool. You will learn to share workbooks and to set various levels of their protection. You will also examine the creation and usage of macros in detail.

The bundle contains:
• Microsoft Excel 2013: Introduction
• Microsoft Excel 2013: Intermediate
• Microsoft Excel 2013: Advanced

The courses in this bundle take the form of tutorials, exercises and quizzes.

Bundle Content
- 98 lessons
- 49 study hours

This product allows the student to print a certificate from the course on successful completion.

The recommended settings to run this course are:
- Any of following internet browsers: Internet Explorer 6.0 or higher, Opera, Mozilla Firefox, Chrome; all with the Adobe Flash plug-in version 8.0 or higher
- 1 GHz CPU; 512 MB RAM; OS Windows 2000, XP, Vista or Windows7
- Display resolution of 1280 x 1024
- Soundcard, speakers or headphones are recommended

Topics

Objectives

Please see datasheets for individual courses for full details of skills to be learnt and course objectives

ASK US A QUESTION...
* required field

ASK US