Microsoft Excel 2010: Set of 3 Interactive Courses

Producer: Gopas

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

Overview

In this bundle of all three of our Microsoft Excel 2010 courses you will find all the information that you need to learn to perfectly master the Microsoft Excel application - from basic orientation to the environment of a spreadsheet application and the creation of descriptive charts to the sophisticated utilisation of macros.

The bundle contains:
• Microsoft Excel 2010: Introduction
• Microsoft Excel 2010: Intermediate
• Microsoft Excel 2010: Advanced
The courses in this bundle take the form of tutorials, exercises and quizzes.

Bundle Content
- 55 lessons
- 28 study hours

Please Note: The demo is designed to be representative of this course, and may not be the course itself.

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

Screenshots

Screenshot 1Screenshot 2Screenshot 3

Topics

You will first learn to create tables and to navigate through them and how to fill them with data, to format the talk and text messaging feature and to adapt their overall graphic layout. You will be carrying out calculations based on your own formulas and functions and you will familiarise yourself with the creation and formatting of charts. You will also learn how to filter and sort worksheet records, how to verify data and how to create Pivot Tables. You will then learn how to work with the advanced Microsoft Excel functions for data manipulation and data analysis, by familiarising yourself with financial and database functions, conditional calculation and statistical methods and functions. You will try out a simple task of optimisation which - in accordance with the conditions set - will search for input values that, when combined, will provide the maximum resulting value. You will also familiarise yourself with the creation of macros and with the management of security and permission for access to workbooks.

Objectives

Once you have completed the courses in this bundle you will:
• learn to create tables in the Microsoft Excel program, to enter data in them, to format the data and edit the table format. You will provide calculations through simple functions and formulas and will familiarize yourself with the basics of chart creation and formatting.
• be creating complex formulas and using functions belonging to the date & time and text categories, as well as the logical, financial and database functions. You will learn how to filter lists on a sheet and create pivot tables. You will also practice advanced chart editing.
• learn to work with the advanced Microsoft Excel functions for data manipulation and analysis. You will familiarize yourself with macro creation, with the XML format and its use in MS Excel, with protecting and managing permissions for accessing workbooks.

ASK US A QUESTION...
* required field

ASK US