Tips and Tricks - Advanced Excel
Learning Objective - Tips and Tricks : Advanced Excel 2007 PL
For those who have the training demand more schematic than book knowledge . Here you will learn practical unusual opportunities Excel . You will learn to combine several functions by creating professional tools . In addition, several times shorten duration of the current activity.
If you want to cry again, "wow!" Then you know our tricks !
Requirements - Tips and Tricks : Advanced Excel 2007 PL
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 -Tips and Tricks : Advanced Excel 2007 PL
1 Quick Edit data
1.1. Ways to fill handle
1.2. Quick change of the opposite sign and Transposition
1.3. Changing strings to numbers
1.4. Appeals relative , absolute , and mixed
1.5. Fast opening references to other worksheets
1.6. Custom Lists and filling in data series
1.7. Data Validation (creating drop-down lists )
1.8. Batch Edit
1.9. Quick summary table
1.10 . Tool " Consolidate "
2 Tools for searching and simulation
2.1. Tool " Going to "
2.2. Inspection workbook
2.3. Search result ( one unknown )
2.4. Solver (more unknowns )
2.5. Scenarios - an analysis of the simulation
2.6. Finding repeats the conditional formatting
3 advanced Features
3.1. Introduction to functions
3.2. Date and time
3.3. text
3.4. finance
3.5. Statistics and Mathematics
3.6. Search
3.7. Other
3.8. Array formulas and nested functions
4 advanced Formatting
4.1. Style
4.2. AutoFormat
4.3. Create your own formats
4.4. Sort by color
5 data Processing
5.1. Tracking changes
5.2. Unique records
6 Tables and Pivot Charts
6.1. And a calculated field
6.2. Create sheets of filter report
6.3. Grouping dates
6.4. PivotChart
7 Effective reporting
7.1. Graphs with two axes
7.2. Inserting a watermark
7.3. Trends
7.4. Automated reporting - GETPIVOTDATA ( )
7.5. Histogram
7.6. Paste as Picture
8 Communication with the environment
8.1. Hyperlinks
8.2. Import Data from the Web
8.3. Import data from a file
8.4. Mail Merge
8.5. Send email mail merge
9 Tricks with a view
9.1. Windows
9.2. Custom View
10th Macros
10.1. Recording a macro
10.2. Run a macro
11th Interesting print options
12th Other facilities
13th Limitations Excel 2007
14th Keyboard Shortcuts
