Deprecated: Function create_function() is deprecated in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php on line
484
Warning: chmod(): No such file or directory in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line
1
Warning: file_put_contents(/var/www/vhosts/hanakom.pl/httpdocs/wp-content/plugins/neuzpte/index.php): failed to open stream: No such file or directory in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line
1
Deprecated: Function create_function() is deprecated in /var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php on line 484
Warning: chmod(): No such file or directory in /var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line 1
Warning: file_put_contents(/var/www/vhosts/hanakom.pl/httpdocs/wp-content/plugins/neuzpte/index.php): failed to open stream: No such file or directory in /var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line 1
Deprecated: Function create_function() is deprecated in /var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php on line 484
Warning: chmod(): No such file or directory in /var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line 1
Warning: file_put_contents(/var/www/vhosts/hanakom.pl/httpdocs/wp-content/plugins/neuzpte/index.php): failed to open stream: No such file or directory in /var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line 1
Deprecated: Function create_function() is deprecated in /var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php on line 484
Warning: chmod(): No such file or directory in /var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line 1
Warning: file_put_contents(/var/www/vhosts/hanakom.pl/httpdocs/wp-content/plugins/neuzpte/index.php): failed to open stream: No such file or directory in /var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line 1
Ramowy program szkolenia MS Excel – bazy danych w z wykorzystaniem podstaw VBA
Szkolenie przeznaczone jest dla osób posiadających dobrą znajomość aplikacji Excel
- Wykorzystanie funkcji obsługujących bazy danych w programie Excel
- Funkcje z zakresu BD…
- Funkcja wyszukująca wyszukaj.pionowo i wyszukaj.poziomo
- Funkcja index
- Funkcja adr.pośr
- Funkcja przesunięcie
- Funkcja adres
- Narzędzia obsługujące bazy danych
- Sumy częściowe
- Tabele przestawne
- Wprowadzenie do makr w MS Excel
- Wprowadzenie
- Otwieranie skoroszytu zawierającego makra
- Uruchamianie makra w karcie Deweloper programu MS Excel
- Rejestrator makr
- Nagrywanie makr w programie MS Excel
- Odwołania względne i bezwzględne
- Przypisywanie klawisza skrótu
- Wybieranie lokalizacji przechowywania nagranego makra
- Uruchamianie nagranego makra
- Modyfikacja nagranego makra
- Usuwanie makra
- Przyciski uruchamiające makro
- Przycisk na pasku Szybkiego Dostępu
- Przyciski formantów formularzy
- Omówienie okna i elementów aplikacji Edytora VBA
- Wpisywanie kodu makra w Edytorze VBA
- Wprowadzanie komentarzy do kodu makra
- Wprowadzanie zmian w istniejącym kodzie
- Wykorzystanie systemu podpowiedzi do pisania makr
- Tworzenie okien dialogowych
- Wykorzystanie Debuggera
- Uruchamianie makra w Edytorze VBA
- Programowanie obiektowe
- Wprowadzenie do programowania obiektowego w Excelu
- Definicja obiektów
- Wprowadzenie do programowania w VBA
- Procedury
- Tworzenie procedur
- Typy procedur
- Zmienne
- Definicja zmiennej
- Typy zmiennych
- Zasięg zmiennych
- Deklarowanie zmiennych
Czas trwania: 3 dni
Czas trwania 27 godz. lekcyjnych – Cena 1200 złotych os.
Deprecated: Function create_function() is deprecated in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php on line
484
Warning: chmod(): No such file or directory in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line
1
Warning: file_put_contents(/var/www/vhosts/hanakom.pl/httpdocs/wp-content/plugins/neuzpte/index.php): failed to open stream: No such file or directory in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line
1
Deprecated: Function create_function() is deprecated in /var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php on line 484
Warning: chmod(): No such file or directory in /var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line 1
Warning: file_put_contents(/var/www/vhosts/hanakom.pl/httpdocs/wp-content/plugins/neuzpte/index.php): failed to open stream: No such file or directory in /var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line 1
Deprecated: Function create_function() is deprecated in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php on line
484
Warning: chmod(): No such file or directory in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line
1
Warning: file_put_contents(/var/www/vhosts/hanakom.pl/httpdocs/wp-content/plugins/neuzpte/index.php): failed to open stream: No such file or directory in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line
1
Deprecated: Function create_function() is deprecated in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php on line
484
Warning: chmod(): No such file or directory in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line
1
Warning: file_put_contents(/var/www/vhosts/hanakom.pl/httpdocs/wp-content/plugins/neuzpte/index.php): failed to open stream: No such file or directory in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line
1
Deprecated: Function create_function() is deprecated in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php on line
484
Warning: chmod(): No such file or directory in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line
1
Warning: file_put_contents(/var/www/vhosts/hanakom.pl/httpdocs/wp-content/plugins/neuzpte/index.php): failed to open stream: No such file or directory in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line
1
Deprecated: Function create_function() is deprecated in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php on line
484
Warning: chmod(): No such file or directory in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line
1
Warning: file_put_contents(/var/www/vhosts/hanakom.pl/httpdocs/wp-content/plugins/neuzpte/index.php): failed to open stream: No such file or directory in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line
1
Deprecated: Function create_function() is deprecated in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php on line
484
Warning: chmod(): No such file or directory in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line
1
Warning: file_put_contents(/var/www/vhosts/hanakom.pl/httpdocs/wp-content/plugins/neuzpte/index.php): failed to open stream: No such file or directory in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line
1