No time for searching?

508 913 532 Customer service center

Download PDF Download DOC Training form

2 +
= 10

A26 – Microsoft Excel – effective use of a spreadsheet – advanced course

1. Working with complex spreadsheets

  • Using complex, built-in functions in Microsoft Excel
  • Tracking relationships between cells and formulas
  • Consolidation of data from many spreadsheets
  • Advanced filter
  • Correctness testing
  • Conditional formatting
  • Data clustering and synospis creating
  • Data and formulas protecting
  • Review mode

2. Tools for supporting data analysis and planning

  • Advanced sorting
  • Indirect sums
  • Report from the table and floating chart
  • Unconventional charts
  • Chosen built-in functions that enable searching for information
  • Using scenarios
  • „Search for the result” tool
  • Searching for the best solution by using Solver
  • Creating and using unconventional forms
  • Forms

3. Manging lists informations

  • Lists creating and maintaining
  • Lists sorting
  • Data filtering
  • Details downloading from the list by using functions

4. Excel coopeation with other programs

  • Importing data from external files
  • Exporting tables and charts to other applications (Word, PowerPoint)
  • MS Query tool
  • Basics of XML use in Excel (2003 and newer versions)
  • Creating enquiries to websites (tabular data downloading)
  • Team working and spreadsheet sharing

5. Introduction to programming in Visual Basic for Applications

  • What is the macro
  • Recording of simple macros
  • Modyfying of simple macros
  • Using of previously prepared macros


Methods of the course performing 

Multimedia lecture, classes, labs


Participants of our courses receive:

  • organized course and trainer
  • tests that check the level of knowledge and skills in order to ensure that course participants have similar level of skills (performed on customer’s demand)
  • didactic materials
  • individual computer post for each of the course participants
  • catering during brakes (coffee, tea, biscuits)
  • lunch (vegetarian or traditional meals – smorgasbord)
  • a CD with a set of exercises after the course completion
  • certificate of the course completion
  • free consultations with the course trainer up to 2 weeks after the course completion
  • tests that check the level of knowledge and skills after the course completion (performed on customer’s demand)

Additional remarks 

The price of the course is established for the course with min. 6 participants.

There is a possibility to organize individual course or classes in small groups, contact us for more details!

We offer discounts for groups bigger than 8 people.   

Associated courses:

(recommended for widening students** knowledge)

  • Office Package
  • Programming courses


If you operate Excel spreadsheets in your everyday work and you want to get to know advanced methods that ease everyday operations, use Excel to complex analysis, and automate specified tasks, this course is for you. During the course you will learn advanced tools, which use guarantee optimizing everyday work with Excel files and more “spare time”. The course has a form of a lecture with special emphasis on practical exercises that illustrate issues discussed during the lecture. 


Basic working skills with Microsoft Excel spreadsheets .


Certified Microsoft Trainer

Last viewed

Customer reviews

"Credit Agricole confirms that CI ProLearning performed for the bank’s employees courses in the scope of websites developing (PHP, MySQL) and Office package between February and December 2013. For each of the courses,…"

Credit Agricole Bank Polska S.A.


"”PRKIK recommends Centrum Innowacji ProLearning as a professional business partner. The training centre organized IT courses in which our employees participated. The course MS 6425-…"

Przedsiębiorstwo Robót Kolejowych i Inżynieryjnych S.A.


"Between 3-4.08.2013 we participated in the course MS Excel – advanced level, which was performed by CI ProLearning. The trainer selected deserves our special recognition. He led the course in professional way, taking care of great atmosphere…"

C.H. Robinson

  • Our certifications

Course title:

Hours daily:
Net price :

Your information

- See terms and conditions

Please fill in the form below in order to sign up for chosen exams.

Code * Name * Date * Time Option

Your information

- See terms and conditions