Product Description
In this courses you will find all the information that you need to learn to perfectly master the Microsoft Excel application.
The course will help you learn from basic orientation to the environment of a spreadsheet application and the creation of descriptive charts to the sophisticated utilisation of macros.
MS Excel 2010 will make you 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.
It will enable you to carry 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.
Once completed with the basics, then you will 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.
If you 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.
The course will enable you to familiarise yourself with the creation of macros and with the management of security and permission for access to workbooks.
Course Study Format
This course is delivered through ONLINE method.
The course is available for you to complete at your convenience over a 12 month period.
IT Training Courseware Support
The entire home study courses include step by step online training and keyword search facilities.
Using show and ask training methods you can access the desired eLearning courseware step by step.
Our technical support team is available for 24 hours a day from Monday to Friday, to help you out regarding any queries related to your online course
Exams
All exam vouchers supplied with our courses must be used within the duration of your course. Exam Vouchers become invalid once the course has expired.
MS Excel 2007: Introduction
In this course you will learn how to create Excel tables, to complete them with data, to format this data and to alter the graphic layout of tables. You will be performing calculations using simple formulas and you will familiarize yourself with the basics of chart creation and formatting.
List of Lessons:
Introduction to Excel
Data inserting and editing
Navigating the spreadsheet and basic settings
Area selection
Area Manipulations
Area inserting and deleting
Text and Cell Appearance Formatting
Number, Date and Time Format
Formatting Using Style Gallery
Files and Windows Handling
Printing Small Tables
Calculations using AutoSum and formula copying
Custom Formula Creation
Using Functions
Chart Creation
Chart Formatting
Spell Checking
Basic Excel Settings
Using the Help
MS Excel 2007: Intermediate
In this course you will learn advanced techniques for data processing (formatting, locking, using templates, advanced copying etc.). You will be creating more complex formulas and using functions belonging to the date and time and text categories and also logical, financial and database functions. You will learn how to filter sheet records and how to create Pivot Tables. You will also practice advanced chart editing.
List of Lessons:
Lock
Advanced cell formatting
Conditional formatting and custom format
Templates
Workbook properties and work with sheets
Sharing and merging workbooks
Comments and comparing workbooks
Copying options, orders and lists
Creating Formulas and Absolute Links
Errors and Dependencies of Formulas
Connected Sheets
The IF, MIN and COUNT functions
Functions and formulas for working with date, time
Functions for working with text
Rounding off
Financial Functions
Relation table techniques
Validation and sorting
Go to, find and replace
Printing large tables
AutoFilter, lists
Criteria tables and advanced filter
Database functions
Outlines and totals
Splitting text into columns
Pivot Table Creation
Editing Pivot Tables and Pivot Chart
Advanced chart editing
MS Excel 2007: Advanced
In this course you will learn to work with the advanced Microsoft Excel functions for data manipulation and analysis. You will familiarize yourself with creating macros, with the XML format and its use in MS Excel, with security and management of permissions for accessing workbooks.
List of Lessons:
Work with Area Names
Creating a Form in a Sheet
Protection Options and Embedded Objects
Conditional Calculations
Conditional Calculations – SUMIF and COUNTIF
Working with an Array
Calculation Criteria in Database Functions
Searching in Tables by Using Functions
Data Import
Working with Microsoft Query
Microsoft Query Program – Complicated Queries
Merging Data
Sheet Scenarios
Solver
What-if Analysis and Goal Seek
Statistical Methods and Functions
Use and Recording of Macros
View and Editing VBA Code
Web Pages, Links and E-mail Sending
File Security
Permission Control
Introduction to XML Format
Working with Data in XML Format
Job Prospects
Become fully trained and substantially improve your chances of employment or earn more money!
Interactive simulations
Feel like you are actually using the software you are being trained about in the added security of our learning environment.
Skills Assessments
Test yourself and receive a certificate online. Multiple choice or fill in the blanks style questioning helps you remember and learn.
Course Completion Certificate
*Please note, unless stated otherwise or included in package, our online courses only offer course completion certificates ( £10 fee) and in all cases official testing (at a charge made by testing centre) is required to gain officially certified recognised qualifications.
Unless otherwise specified, official exams are not included.
