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.
If you do not have Microsoft Office installed on your computer we suggest that you download a free demo of Microsoft Office Software from here:
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
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 2010: Introduction
In this course, 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.
List of Lessons:
Introduction to Excel
Data entry and editing
Worksheet navigation and basic settings
Cell range selection
Manipulation with cell ranges
Cell inserting and deleting
Text and cell formatting
Number, Date and Time format
Formatting via style gallery
Working with files and windows
Printing smaller tables
The AutoSum button and formula copying
Custom formula creation
Work with functions
Basic Excel settings
MS Excel 2010: Intermediate
In this course, you will learn advanced techniques for data processing in Excel (formatting, locking, using templates, advanced copying etc.). You will 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.
List of Lessons:
Advanced cell formatting
Conditional and custom formatting
Workbook properties and work with sheets
Sharing workbooks and tracking changes
Comments and workbooks comparing
Copying options, orders and lists
Formula creation and absolute links
Errors and formulas dependencies
The IF, MIN, and COUNT functions
Functions and formulas used for Date and Time data
Functions for working with text
Techniques of work with relation tables
Data validation and sorting
Go To, Find and Replace orders
Printing larger tables
Criteria table and advanced filter
Outlines and totals
Splitting text into columns
Editing pivot tables and charts
Advanced chart editing
MS Excel 2010: 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 macro creation, with the XML format and its use in MS Excel, with protecting and managing permissions for accessing workbooks.
List of Lessons:
Work with range names
Form creation in a sheet
Protection options within workbooks
Conditional calculations using SUMIF and COUNTIF
Working with an array
Calculation criteria in database functions
Using functions for searching in tables
Work with Microsoft Query
Complicated queries in Microsoft Query
What-if analysis and goal seek
Statistical methods and functions
Macros recording and usage
The VBA code view and editing
Webpages, links and e-mail sending
Introduction to XML
Working with data in the XML format
Become fully trained and substantially improve your chances of employment or earn more money!
Feel like you are actually using the software you are being trained about in the added security of our learning environment.
Test yourself and receive a certificate online. Multiple choice or fill in the blanks style questioning helps you remember and learn.
Course Completion Certificate
Microsoft Office Specialist Exam Available
*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.