In the series of MS 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.
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.
Product code: EN-Exc10-CS3