Target Training - Intermediate Excel 2007 EN

Excel provides capabilities that can be divided into three categories:

•     enter information ,
•     data analysis,
•     presentation of the results .

After completion of the course you will be free to take advantage of new opportunities in all three categories. You will learn how to quickly enter new data , which were later analyzed by the functions and pivot tables . Finally, create a chart and make formatting tables so that the results of the work presented in the most transparent and customer -friendly manner.

The training includes three days of intensive training on practical examples . Instead of weeks to sit on the books that can alienate rather to use Excel than encourage , come to our training .

Requirements - Excel in Finance

We require basic skills in working with MS Excel. If you want to make sure that this training is for you, then download our questionnaire, fill in and send e -mail to : 1-click@1-click.pl . We will advise you in the choice of training.

Place of training

Training is provided in a modern office building Class A - Sienna Center. As a result there is provided a high level of comfort for training.

Address : Warsaw, ul. Sienna 75 - blue entrance to the building , second floor

Dates and Hours

3 days x 6 hours = 18 hours ( 1 hour = hour clock )

from 9:00 to 15:00 at the two coffee breaks and one lunch

Number of participants

from 4 to 8 people ( and individual approach )

Certifications

Each participant receives a training course completion certificates .

Science after training

For the three months training participants receive e-mail with a link to videoporadnika to help them perform.

Price

1 390 PLN (standard price for a three-day training )

The price of the training includes :

•     intensive 3-day training
•     coffee service during breaks
•     two-course lunch every day
•     Professional training materials
•     certificates of completion of training
•     poszkoleniowe support - video guides

How to start ?

Complete the application form: xls (recommended) or pdf and send e -mail to : 1-click@1-click.pl or fax.

The training program - Intermediate Excel 2007 PL

1 Customize commands to suit your needs

    1.1. Customize the Quick Access Toolbar
    1.2. Minimize the ribbon
    1.3. Running commands from the keyboard Ribbons

2 Intermediate data editing

    2.1. Look up values in a worksheet
    2.2. Select the range of cells
    2.3. Naming cell ranges
    2.4. label ranges
    2.5. Style
    2.6. Templates
    2.7. Privacy sheets ( password )

3 Databases

    3.1. AutoFilter
    3.2. Custom AutoFilter
    3.3. Subtotals (indirect )

4 Features

    4.1. Enter a Function
    4.2. SUM ( ) and AutoSum
    4.3. PRODUCT ( )
    4.4. SUMPRODUCT ( )
    4.5. ROUND ( )
    4.6. ABS ( )
    4.7. SQRT ( )
    4.8. PI ()
    4.9. RAND ( )
    4.10. SUMIF ( )
    4.11. AVERAGE ( )
    4.12. MEDIAN ( )
    4.13. MODE ( )
    4.14. MIN () and MAX ()
    4.15. COUNT () and COUNTA ( )
    4.16. IF ()
    4.17. VLOOKUP () and HLOOKUP ( )
    4.18. DATE ( )
    4.19. NOW () and TODAY ()
    4.20 . LEFT ( ) , RIGHT () and MID ( )
    4.21. CONCATENATE ( )

5 pivot Tables

    5.1. Basic information about PivotTables
    5.2. Create a PivotTable report with a list of data
    5.3. Creating and changing the layout of fields in a PivotTable report
    5.4. Changing the format for displaying numbers
    5.5. Selecting data in a PivotTable report
    5.6. Change the layout of a PivotTable
    5.7. Filtering fields
    5.8. sorting
    5.9. Types of calculations of the data field
    5.10. Grouping items
    5.11. Show or hide the details

6 Format Cells

    6.1. Introduction to Formatting
    6.2. Formatting numbers
    6.3. alignment
    6.4. Formatting fonts
    6.5. border
    6.6. Shaded cells
    6.7 . AutoFormat
    6.8. format Painter
    6.9. conditional Formatting
    6.10. Remove formatting

7 Charts

    7.1. charting
    7.2. Modifying charts
    7.3. Change the style of a chart
    7.4. Formatting chart elements
    7.5. Linking chart title or axis of the cell sheet
    7.6. Changing the scale of the vertical axis
    7.7. Changing the scale of the horizontal axis
    7.8. data Labels
    7.9. data Table

8 Quick Edit data

    8.1. Using the fill handle
    8.2. Paste Special Transpose and Multiply
    8.1. Appeals relative , absolute , and mixed
    8.2. References to other sheets
    8.3. Custom Lists and filling in data series
    8.4. Data Validation
    8.5. Batch Edit

9 Keyboard Shortcuts

Description training