Advanced Excel 2007

Course details

Objectives :

• Provide the participants the basic skills necessary to use advanced applications in Excel.

Contents :

• Definition program Excel.
• Prepare a working paper.
• Tips & Tricks.
• Absolute values ​​and relative values.
• The introduction of equations and functions using the command Formulas: SUMIF, IF AND, IF AND, OR, IF OR, MATCH, INDEX,, SUM, INT, MOD, AVARAGE IF, IF ERROR.
• The preparation of spreadsheets and the introduction of forms and formats required by 
• CONDITIONAL FORMAT AS A TABLE FORMATTING statement with how to use the equations.
• The establishment of regulations by dynamic pivot tables and analyzed, filtered, show, hide, and edit tables, coordination and created from external data.
• The preparation of the central Pivot tables tables for the purpose of classification of data, numbers and customers and preparing forms, graphs own.
• Preparing pivot tables Pivot tables of the banks in terms of types of deposits, accounts and distribution accounts by branches and customers.
• Use the search and classification vertical figures and data (VLOOKUP) using Excel from a workbook to another workbook, or from a worksheet to another worksheet, integrate it with VLOOKUP with it VALUE - IF- ERROR.
• Use the command LOOKUP, HLOOKUP with clarifying the differences between the LOOKUP and VLOOKUP.
• Goal Seeking - Back Solving in Formulas.
• Withdrawal of tabular data (tables) on the WORD file and transferred to a worksheet in Excel file without using Copy & Paste.
• Excel and VISUAL BASIC APPLICATION (VBA) Altfiqit equations and calculations using Excel macros and VBA (run Almacroat).