No time for searching?

508 913 532 Customer service center

marketing@prolearning.pl

Download PDF Download DOC Training form

5 +
= 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


Target

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. 

Requirements

Basic working skills with Microsoft Excel spreadsheets .

Coach

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.

więcej

"Koleje Dolnośląskie S.A. confirms that CI ProLearning performer the course MS6419 – Configuring, Managing and Maintaining Windows Server 2008 servers for our employee between 17-21 June 2013. The course was prepared on the…"

Koleje Dolnośląskie

więcej

"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

więcej
  • Our certifications

Course title:

Duration:
Hours daily:
Days:
Localization:
Date:
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
×