Ehsel 2003 - vashiat trenior razglezhda kliuchovite vyzmozhnosti na Ehsel, kato vi predostavia cialostna trenirovka:
* Osnovni poniatia pri rabotnite listove
* Redaktirane i formatirane na rabotni listove
* Rabota s formuli
* Syzdavane na diagrami i grafiki
* Avtomatizirane na zadachi chrez makrosi
* Rabota s drugi programi i s Internet
* Temi za naprednali
Sydyrzhanie:
Glava 1 Osnovi na Excel Urok 1.1 Startirane na Excel Urok 1.2 Kakvo e novoto v Excel 2003 Urok 1.3 Zapoznavane s ekrana na programata Excel Urok 1.4 Rabota s meniuta Urok 1.5 Izpolzvane na lenti s instrumenti i syzdavane na nova rabotna kniga Urok 1.6 Zadavane na parametri v dialogov prozorec Urok 1.7 Byrzi klavishi i kontekstni meniuta, izvikani s desnia buton na mishkata Urok 1.8 Otvariane na rabotna kniga Urok 1.9 Syhraniavane na rabotna kniga Urok 1.10 Rabota s pokazaleca na kletki Urok 1.11 Navigacia v rabotnia list Urok 1.12 Vyvezhdane na etiketi v raboten list Urok 1.13 Vyvezhdane na stojnosti v raboten list i markirane na oblast ot kletki Urok 1.14 Izchisliavane na sumarna stojnost s AutoSum Urok 1.15 Vyvezhdane na formuli Urok 1.16 Rabota s AutoFill Urok 1.17 Pregled i razpechatvane na raboten list Urok 1.18 Poluchavane na pomosht Urok 1.19 Promiana na Office Assistant i rabota s butona “What’s This” Urok 1.20 Zatvariane na rabotna kniga i izlizane ot Excel Pregled na pyrva glava Glava 2 Redaktirane na raboten list Urok 2.1 Vyvezhdane na dati i rabota s AutoComplete Urok 2.2 Redaktirane, izchistvane i zamestvane na sydyrzhanieto na kletki Urok 2.3 Izriazvane, kopirane, vmykvane i premestvane na kletki Urok 2.4 Premestvane i kopirane na kletki posredstvom vlachene i puskane Urok 2.5 Sybirane i vmykvane na poveche ot edin element Urok 2.6 Zapoznavane i rabota s absoliutni i otnositelni prepratki kym kletki Urok 2.7 Rabota s komandata Paste Special Urok 2.8 Vmykvane i iztrivane na kletki, redove i koloni Urok 2.9 Rabota s Undo, Redo i Repeat Urok 2.10 Proverka na pravopisa v rabotnite listove Urok 2.11 Otkrivane i zamestvane na informaciata Urok 2.12 Rabota s razshirenite opcii za razpechatvane Urok 2.13 Osnovno upravlenie na fajlove Urok 2.14 Vmykvane na komentar kym kletka Urok 2.15 Zapoznavane sys Smart Tags Urok 2.16 Vyzstanoviavane na rabotna kniga Pregled na vtora glava Glava 3 Formatirane na raboten list Urok 3.1 Formatirane na shriftove chrez lentata s instrumenti Formatting Urok 3.2 Formatirane na stojnosti Urok 3.3 Nastrojka na visochinata na red i shirochinata na kolona Urok 3.4 Podravniavane na sydyrzhanieto v kletki Urok 3.5 Dobaviane na ramka kym kletki Urok 3.6 Prilagane na cvetove i sharki kym kletki Urok 3.7 Rabota s Format Painter Urok 3.8 Rabota s AutoFormat Urok 3.9 Syzdavane na potrebitelski chislov format Urok 3.10 Syzdavane, prilagane i promiana na stil Urok 3.11 Formatirane na kletki posredstvom uslovno formatirane Urok 3.12 Slivane na kletki, rotacia na tekst i rabota s AutoFit Urok 3.13 Otkrivane i zamestvane na formatirane Pregled na treta glava Glava 4 Syzdavane i upotreba na diagrami Urok 4.1 Syzdavane na diagrama Urok 4.2 Premestvane i orazmeriavane na diagrama Urok 4.3 Formatirane i redaktirane na obekti ot diagrama Urok 4.4 Promiana na izhodnite danni za edna diagrama Urok 4.5 Promiana na tipa na diagrama i rabota s krygova diagrama Urok 4.6 Dobaviane na zaglavia, linii ot mrezha i tablici s danni Urok 4.7 Formatirane na serii danni i osite na diagrama Urok 4.8 Dobaviane na anotacia kym diagrama Urok 4.9 Rabota s 3-D diagrami Urok 4.10 Izbor i syhraniavane na potrebitelska diagrama Urok 4.11 Upotreba na zapylvashti efekti Pregled na chetvyrta glava Glava 5 Upravlenie na rabotni knigi Urok 5.1 Preminavane mezhdu razlichni listove ot edna rabotna kniga Urok 5.2 Vmykvane i iztrivane na rabotni listove Urok 5.3 Preimenuvane i premestvane na rabotni listove Urok 5.4 Rabota s niakolko rabotni knigi i prozorci Urok 5.5 Razdeliane i zamraziavane na prozorec Urok 5.6 Prepratki kym vynshni danni Urok 5.7 Syzdavane na goren i dolen kolontitul i nomerirane na stranici Urok 5.8 Zadavane na oblast za razpechatvane i upravlenie na kraia na stranicite Urok 5.9 Nastrojka na poletata i orientacia na stranici Urok 5.10 Dobaviane na zaglavie i linii ot mrezha pri razpechatvane Urok 5.11 Promiana na razmera na hartiata i mashtaba na razpechatvane Urok 5.12 Zashtita na raboten list Urok 5.13 Skrivane na koloni, redove i listove Urok 5.14 Pregled na raboten list i neposredstveno sravnenie na rabotni knigi Urok 5.15 Syhranenie na potrebitelski izgled Urok 5.16 Rabota s shabloni Urok 5.17 Obediniavane na rabotni listove Pregled na peta glava Glava 6 Oshte funkcii i formuli Urok 6.1 Formuli, sydyrzhashti niakolko operatora i oblasti ot kletki Urok 6.2 Rabota s harakteristikata Insert Function Urok 6.3 Syzdavane i upotreba na imenuvani oblasti Urok 6.4 Markirane na nesysedni oblasti i rabota s AutoCalculate Urok 6.5 Rabota s funkciata IF za syzdavane na uslovni formuli Urok 6.6 Rabota s funkciata PMT Urok 6.7 Vizualizacia i razpechatvane na formuli Urok 6.8 Popraviane na greshki vyv formuli Matematicheski funkcii Finansovi funkcii Funkcii za dati i chasove Statisticheski funkcii Funkcii, svyrzani s bazi danni Pregled na shesta glava Glava 7 Rabota sys spisyci Urok 7.1 Syzdavane na spisyk Urok 7.2 Rabota sys spisyci i upotreba na red Total Urok 7.3 Dobaviane na zapisi posredstvom dialogovia prozorec Data Form i chrez reda Insert Urok 7.4 Otkrivane na zapisi Urok 7.5 Iztrivane na zapisi Urok 7.6 Sortirane na spisyk Urok 7.7 Filtrirane na spisyk s AutoFilter Urok 7.8 Syzdavane na potrebitelski avtomatichen filtyr Urok 7.9 Filtrirane na spisyk s pomoshtta na filtyr Urok 7.10 Kopirane na filtrirani zapisi Urok 7.11 Rabota s proverka na validnostta Pregled na sedma glava Glava 8 Avtomatizirane na zadachi s pomoshtta na makrosi Urok 8.1 Zapisvane na makros Urok 8.2 Startirane na makros i prisvoiavane na byrz klavish kym makros Urok 8.3 Dobaviane na makros kym lentata s instrumenti Urok 8.4 Redaktirane koda na makros na Visual Basic Urok 8.5 Vmykvane na kod v syshtestvuvasht makros Urok 8.6 Deklarirane na promenlivi i dobaviane na komentar kym VBA kod Urok 8.7 Poluchavane na potrebitelski vhodni danni Urok 8.8 Izpolzvane na konstrukciata If...Then...Else Pregled na osma glava Glava 9 Rabota s drugi programi Urok 9.1 Vmykvane na raboten list na Excel v dokument na Word Urok 9.2 Promiana na vmyknat raboten list Urok 9.3 Svyrzvane na diagrama na Excel s dokument na Word Urok 9.4 Vmykvane na grafika v raboten list Urok 9.5 Otvariane i syhraniavane na fajlove v razlichni formati Pregled na deveta glava Glava 10 Prilozhenie na Excel v Internet Urok 10.1 Dobaviane i izpolzvane na hipervryzki Urok 10.2 Lenta na hipervryzki i rabota s lentata s instrumenti Web Urok 10.3 Syhraniavane na rabotna kniga kato neinteraktivna ueb stranica Urok 10.4 Syhraniavane na rabotna kniga kato interaktivna ueb stranica Urok 10.5 Importirane i eksportirane na iztochnici na danni Urok 10.6 Opresniavane na izhodni danni i nastrojka na tehnite svojstva Urok 10.7 Syzdavane na nova ueb zaiavka Pregled na deseta glava Glava 11 Analiz na danni i obobshteni tablici Urok 11.1 Syzdavane na obobshtena tablica Urok 11.2 Opredeliane na danni za PivotTable analiz Urok 11.3 Promiana na izchislenieto, izvyrshvano ot PivotTable Urok 11.4 Izbor na dannite, koito se poiaviavat v obobshtenata tablica Urok 11.5 Grupirane na dati v obobshtena tablica Urok 11.6 Aktualizirane na obobshtena tablica Urok 11.7 Formatirane na obobshtena tablica i syzdavane na diagrama ot neia Urok 11.8 Syzdavane na mezhdinni sumi Urok 11.9 Izpolzvane na funkcii, svyrzani s bazi danni Urok 11.10 Izpolzvane na funkcii za tyrsene v spisyk Urok 11.11 Grupirane i strukturirane na raboten list Pregled na edinadeseta glava Glava 12 Analiz “Kakvo – Ako” Urok 12.1 Definirane na scenarij Urok 12.2 Syzdavane na obobshtavasht otchet za scenarij Urok 12.3 Izpolzvane na tablici s edin ili dva vhoda za danni Urok 12.4 Rabota s Goal Seek Urok 12.5 Rabota sys Solver Pregled na dvanadeseta glava Glava 13 Temi za naprednali Urok 13.1 Skrivane, vizualizirane i premestvane na lenti s instrumenti Urok 13.2 Opredeliane na danni za PivotTable analiz Urok 13.3 Izprashtane na faks Urok 13.4 Syzdavane na potrebitelski AutoFill spisyk Urok 13.5 Promiana na opciite na Excel Urok 13.6 Zashtita na rabotna kniga chrez parola Urok 13.7 Svojstva na fajlove i otkrivane na fajlove Urok 13.8 Spodeliane na rabotna kniga i proslediavane na promeni Urok 13.9 Slivane i pregled na spodelena rabotna kniga Urok 13.10 Rabota s Detect and Repair Pregled na trinadeseta glava Indeks
Frequently Asked Questions:
What is BALKANATOLIA.com? BALKANATOLIA.com is a shop for Bulgarian music, films
and books in Bulgarian in Internet. Here you can find
up-to-date information on the new titles and buy the
products you want.
Are you delivering worldwide?
Yes, we are selling both within Bulgaria and abroad.
No matter where you are you can buy the products you
want.
Why are the prices both in USD and BGN?
The prices are in BGN and are converted in USD at the
offical currency rate of the day when the order is shipped
abroad. The price of the products is the same no matter
what currency you see on the screen.
How can you pay for the order?
For Bulgaria the orders are paid by cash on delivery.
Orders abroad can be paid by credit cards (Visa and
MasterCard), Western Union and MoneyGram transfers or
bank transfer. For some countries we support transfer
through postal money order.
Are credit card payments secure?
Credit card payments are processed through PayPal.com
and 2checkout.com to ensure 100 safety in transfers.
Are all the products available in stock?
We offer over 5000 titles books, music and films.
That is why we have in stock only the best selling products
as well as the newest titles from each category. The
rest of the products are ordered on demand but this
in general does not impact on our 48-hour time limit
for shipment.
What is the price for delivery?
The price for delivery depends on the destination and
number of products ordered. For Sofia the price is 1.80
BGN irrespective of the number of products ordered,
for the rest of Bulgaria it is between 1.20 and 3.90
BGN per product depending on the number of products
ordered.
The price for delivery abroad is from 6.80 USD to 9.40
USD per product depending on the number of products
ordered. When you place an order, write down your name
and password and you will see the price for delivery
when the final price is calculated.
How long does delivery take?
Delivery times vary depending on the destination. It
is 2 days for Sofia, and a week for the rest of Bulgaria.
The delivery time outside Bulgaria ranges from 1 to
4 weeks depending on the destination. The orders are
shipped within 2 working days after confirmation of
their payment. If you want express delivery of your
order within 2 or 3 days by DHL or UPS please contact
us for a price quote through email: .
How are the ordered products shipped?
The orders for Sofia are delivered to you by courier.
The orders for Bulgaria are sent through COD by Bulgarian
Posts. The orders abroad are delivered through postal
services with registered mail.
How to order?
To order a product you should be registered in the website
(through the [ Registration
] button from the above menu). Afterwards select the
product you want and click on the add
to cart >> button for the format you prefer:
compact disc, audio cassette, DVD or video CD.
Why are some texts and descriptions in Bulgarian with Latin script?
Products such as books and films are in Bulgarian and are targetted mainly at Bulgarians.
To be able to read the website without a Cyrillic font installed on your computer, the description of these products in the English version of the website is in Latin script.
