Using interactive exercises and software simulations, you’ll quickly become familiarised with the Excel 2010 environment and its documents, functions and features. The course modules are:
MS Excel 2010 Introduction - Learn how 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.
MS Excel 2010: Intermediate - 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 also learn how to filter lists on a sheet, create pivot tables and practice advanced chart editing.
MS Excel 2010: Advanced - 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.