Excel Advanced Training Course

Course CodeCourse Code

ExcelAdv

Duration Duration

21 hours (usually 3 days including breaks)

Requirements Requirements

Knowledge of Windows and the basics of using Microsoft Excel.

Overview Overview

The course participants will be able to efficiently use primarily data analysis tools such as scenarios and pivot tables, use the features to perform calculations on dates and text-processing functions, and create and adapt to the needs of macros to automate work with spreadsheets.

Course OutlineCourse Outline

Adjustment of the working environment

  • Hotkeys, facilities
  • Create and modify toolbars
  • Options excel (autosave, input, etc.).
  • Options paste special (transpose)
  • Formatting (style, format painter)
  • Tool - go to

Organization of information

  • Management sheets (naming, copying, color change)
  • Assign and manage the names of cells and ranges
  • Protect worksheet and workbook
  • Secure and encrypt files
  • Collaboration and track changes, comments
  • Inspection sheet
  • Create your own templates (charts, worksheets, workbooks)

Data analysis

  • Logic
  • Basic Features
  • Advanced Features
  • Creation of complex / multiple formulas
  • Scenarios
  • Search result
  • Solver
  • Charts
  • Graphics support (shadows, charts, AutoShapes)

Database management (list)

  • Data consolidation
  • Grouping and outlining data
  • Sorting data (over 4 columns)
  • Advanced data filtering
  • Database Functions
  • Subtotal (partial)
  • Tables and Pivot Charts

Cooperation with other applications

  • Get External Data (CSV, TXT)
  • OLE (static and link)
  • Web Queries
  • Publication sheets on site (static and dynamic)
  • Publication PivotTables

Automation of work

  • Conditional Formatting
  • Create your own formats
  • Check the validation

Macros - automation tasks in sheets

  • Registration macros
  • Understanding and modifying the code macros (VBA items)
  • Connecting the interface macros or workbook
  • Create forms on screen or printed

TestimonialsTestimonials

Tempo było idealne - fakt że grupę mieliśmy specjalnie dobraną.
Przeszliśmy przez wszystkie funkcjonalności Excela - to na czym mi zależało, żeby odkryć takie rzeczy których nie znałam.

Ewa Czerwińska - Pirelli/TPI

Excel :)

Credit Agricole Bank Polska S.A

Entuzjazm i zaangażowanie prowadzącego :-)

- Credit Agricole Bank Polska S.A

ćwiczenia

- Credit Agricole Bank Polska S.A

W razie problemów - indywidualne podejście; cierpliwość.

- Credit Agricole Bank Polska S.A

Kontakt, brak barier w nawiązywaniu kontaktu. Ćwiczenia

- Credit Agricole Bank Polska S.A

zaangażowanie i bezpośredniość w kontakcie i wiedzę praktyczną

- Credit Agricole Bank Polska S.A

examples

Ewelina Palacz - UBS Business Solutions Poland Sp. z o.o.

trainer patient and knowledge

Iwona Jawdyk - UBS Business Solutions Poland Sp. z o.o.

The training was really useful. I liked the most the parts related to the pivot tables, filtering, lookup options and data consolidation. I appreciated trainer's excellent knowledge on the subject. His attitude was very good as well. He built open and 'not so formal' atmosphere which helped participants to ask the questions or speak about their daily excel issues. He was fully understandable during the whole training and his way of explaining the topics was direct and adequate.

Katarzyna Chalinska - UBS Business Solutions Poland Sp. z o.o.

Training was well prepared from the beginning. Enthusiasm and great attitude of the trainer helped us successfully deliver the training. Positive feelings! Highly recommended!

Łukasz - UBS Business Solutions Poland Sp. z o.o.

Possibility to ask various questions and real life solutions to them.

Magdalena Wojtas - UBS Business Solutions Poland Sp. z o.o.

Very helpful, made me feel more comfortable using Excel.

TruGreen

I appreciated the amount of effort and energy that Roman put into this. Hours and hours and hours of Excel training will inevitably get boring, but Roman's attention to detail, energy, and thoroughness made me want to keep learning--even at 5 PM on the second, of two, eight hour learning days.

Christian Labenberg - TruGreen

Relevant examples and interesting corriculum

Alex Gubanov - TruGreen

Excellent trainer. Very adept at modifying the course to fit our timeline.

TruGreen

Learning new ways to process data in Excel, in an engaging and fun learning environment.

Hunter Smith - TruGreen

Interaction with the class

TruGreen

The instructor(see Other Remarks below)

TruGreen

Bookings, Prices and EnquiriesBookings, Prices and Enquiries

Guaranteed to run even with a single delegate!
Private Classroom
 
Private Classroom
Participants are from one organisation only. No external participants are allowed. Usually customised to a specific group, course topics are agreed between the client and the trainer.
Private Remote
From 2700PLN
Private Remote
The instructor and the participants are in two different physical locations and communicate via the Internet. More Information

The more delegates, the greater the savings per delegate. Table reflects price per delegate and is used for illustration purposes only, actual prices may differ.

Number of Delegates Private Remote
1 2700PLN
2 1950PLN
3 1700PLN
4 1575PLN
Public Classroom
From 1500PLN
(68)
Public Classroom
Participants from multiple organisations. Topics usually cannot be customised

The more delegates, the greater the savings per delegate. Table reflects price per delegate and is used for illustration purposes only, actual prices may differ.

Number of Delegates Public Classroom
1 1500PLN
2 1350PLN
3 1300PLN
4 1275PLN
Cannot find a suitable date? Choose Your Course Date >>
Too expensive? Suggest your price

Related Categories

Related Courses

Upcoming Courses

VenueCourse DateCourse Price [Remote / Classroom]
Kielce, ul. Warszawska 19Tue, 2018-01-30 09:002700PLN / 1500PLN
Olsztyn, ul. Gietkowska 6aTue, 2018-01-30 09:002700PLN / 1650PLN
Bydgoszcz, ul. Dworcowa 94Tue, 2018-01-30 09:002700PLN / 1650PLN
Wrocław, ul.Ludwika Rydygiera 2a/22Wed, 2018-01-31 09:002700PLN / 1500PLN
Opole, Wladyslawa Reymonta 29Mon, 2018-02-05 09:002700PLN / 2250PLN

Course Discounts

Course Venue Course Date Course Price [Remote / Classroom]
Analiza biznesowa i systemowa z użyciem notacji UML - warsztat praktyczny dla PO w metodyce Scrum Katowice ul. Opolska 22 Wed, 2018-01-17 09:00 7722PLN / 3624PLN
BPMN 2.0 for Business Analysts Katowice ul. Opolska 22 Mon, 2018-01-22 09:00 5940PLN / 3030PLN
Adobe Creative Cloud - Montaż video Katowice ul. Opolska 22 Mon, 2018-01-29 09:00 3861PLN / 2455PLN
DTP (InDesign, Photoshop, Illustrator, Acrobat) Kielce, ul. Warszawska 19 Mon, 2018-01-29 09:00 5940PLN / 2980PLN
Angular 4 - dobre praktyki Katowice ul. Opolska 22 Tue, 2018-01-30 09:00 7920PLN / 3450PLN
Psychology of interpersonal cooperation Wrocław, ul.Ludwika Rydygiera 2a/22 Tue, 2018-01-30 09:00 5148PLN / 1430PLN
PostgreSQL Administration and Development Katowice ul. Opolska 22 Mon, 2018-02-05 09:00 7821PLN / 4007PLN
DTP (InDesign, Photoshop, Illustrator, Acrobat) Opole, Wladyslawa Reymonta 29 Mon, 2018-02-05 09:00 5940PLN / 4230PLN
Międzynarodowe Standardy Rachunkowości i Sprawozdawczości Finansowej (MSR, MSSF) (IAS, IFRS) Poznan, Garbary 100/63 Fri, 2018-02-09 09:00 3950PLN / 1188PLN
Creating and managing Web sites Katowice ul. Opolska 22 Mon, 2018-02-12 09:00 5841PLN / 3048PLN
Javascript Basics Poznan, Garbary 100/63 Tue, 2018-02-13 09:00 4455PLN / 1885PLN
SQL in Microsoft Access Kraków, ul. Rzemieślnicza 1 Thu, 2018-02-15 09:00 10266PLN / 3911PLN
Effective interpersonal communication with elements of assertiveness Gdynia, ul. Ejsmonda 2 Mon, 2018-02-19 09:00 5148PLN / 1530PLN
Visual Basic for Applications (VBA) in Excel - Introduction to programming Katowice ul. Opolska 22 Mon, 2018-03-05 09:00 3564PLN / 2291PLN
Certified Agile Tester Katowice ul. Opolska 22 Mon, 2018-04-02 09:00 8910PLN / 4720PLN
Perfect tester Szczecin, ul. Sienna 9 Wed, 2018-04-04 09:00 5920PLN / 2294PLN
Quality Assurance and Continuous Integration Katowice ul. Opolska 22 Thu, 2018-04-12 09:00 2673PLN / 2037PLN

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients