Thank you for sending your enquiry! One of our team member will contact you shortly.
Thank you for sending your booking! One of our team member will contact you shortly.
Course 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
Requirements
Knowledge of Windows and the basics of using Microsoft Excel.
Testimonials
The pace was the perfect fact that we had a group specially selected. We went through all the functionalities of Excel, which I wanted to discover such things that I did not know.
Ewa Czerwińska
Leader's enthusiasm and commitment :)
Credit Agricole Bank Polska S.A
exercises
Credit Agricole Bank Polska S.A
In case of problems, an individual approach; patience.
Credit Agricole Bank Polska S.A
Contact, no barriers to making contact. exercises
Credit Agricole Bank Polska S.A
commitment and direct contact and practical knowledge
Credit Agricole Bank Polska S.A
I generally was benefit from the examples.
Ewelina Palacz
The training was really useful. I liked the most the parts related to the pivot tables, filtering, lockup 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
I was benefit from the possibility to ask various questions and real life solutions to them.
Magdalena Wojtas
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
I generally enjoyed the relevant examples and interesting curriculum.
Alex Gubanov
Excellent trainer. Very adept at modifying the course to fit our time line.
TruGreen
I liked learning new ways to process data in Excel, in an engaging and fun learning environment.
Hunter Smith
I mostly was benefit from the interaction with the class.
TruGreen
Roman was great! He was really entertaining and helpful. He is very knowledgeable and passionate about the subject. He made the class enjoyable, and made you want to learn and ask questions.
TruGreen
Tricks and Tips and also structural items.
Ritesh Gupta
Learned many new tricks and lots of eye-openers. Tamil kept it interesting and was always able to surprise with new things and insights.
APM Terminals B.V.
The trainer was a knowledgeable and approachable person it was good to refresh & extend my excel knowledge.
laura kooijman
The smart tips that are not too complicated but helpful.
APM Terminals B.V.
Tamil was great at handling our idiosyncrasies and responding to specific needs from people at various skill levels.
Brian Pishko
Flexibility in conducting training, matching the scope of training to participants.
Marcin Doleżyk
I was benefit from a lot of exercises.
UBS Business Solutions Poland Sp. z o.o.
I was benefit from the well prepared examples, plenty of opportunity to practice.
Piotr Ogar - UBS Business Solutions Poland Sp. z o.
Well adjusted to the level of trainees.
Ewelina - UBS Business Solutions Poland Sp. z o.o.
I generally enjoyed the exercises.
UBS Business Solutions Poland Sp. z o.o.
The training was complex and with many useful examples.
Anna Mycka - UBS Business Solutions Poland Sp. z o.o.
Everything was shown very well but as I said too fast.
Damian Szuflada - UBS Business Solutions Poland Sp. z o.o.
I generally was benefit from the quality of the material, exercises.
UBS Business Solutions Poland Sp. z o.o.
matching the examples given by the participants
NBP
practical knowledge
Oskar Krzesicki - NBP
reaction to the participants' questions
NBP
Good contact with listeners and willingness to explain until the end of ambiguity
Katarzyna Zięba - NBP
I enjoyed the flexibility of the trainer, many practical examples, good atmosphere during the training.
Aleksandra Bauer - UBS Business Solutions Poland Sp. z o.o.
I really enjoyed the many practice.
Magdalena Chowaniec - UBS Business Solutions Poland Sp. z o.o.
A lot of examples ..
ADM CONSULTING GROUP SPÓŁKA AKCYJNA
The right amount of exercise.
ADM CONSULTING GROUP SPÓŁKA AKCYJNA
That the trainer walked around and devoted time to virtually everyone.
ADM CONSULTING GROUP SPÓŁKA AKCYJNA
Checking exercises by the lecturer on each computer on a regular basis.
ADM CONSULTING GROUP SPÓŁKA AKCYJNA
A lot of transmitted knowledge in an understandable way. A lot of time dedicated to each individual. .
Aneta Świerszcz - „ADM CONSULTING GROUP” SPÓŁKA AKCYJNA
Accessible to the VBA readily explained. .
ADM CONSULTING GROUP SPÓŁKA AKCYJNA
the lectures were interspersed with exercises.
Natalia Jędrasik - NBP
READY AND DIFFERENCE OF AUXILIARY MATERIALS.
NBP
Prepared exercises and a step-by-step guide in which it is difficult to get lost.
NBP
Materials and prepared exercises ..
NBP
range of topics, exercises how to develop them.
NBP
I liked the useful tips, knowledge and flexibility in answering from the trainer's side.
UBS Business Solutions Poland Sp. z o.o.
It was great that we could try to do an exercise by our owns and then we did it together with trainer. Moreover the trainer shown us a few solutions per each exercise.
- UBS Business Solutions Poland Sp. z o.o.
practical ways of using ms excel
- NBP
All training
Katarzyna Litwinska - UBS Business Solutions Poland Sp. z o.o.
Adjusted to my knowledge of Excel, I learned new things. Explained very well. I finally understood how the formulas work. The trainer concentrated on the most useful parts.
Martyna Szczurek - UBS Business Solutions Poland Sp. z o.o.
he managed to adapt to the heteroclit level of the people attending the training.
- UBS Business Solutions Poland Sp. z o.o.
I liked the practical use of the presented formulas, an opportunity to practice and discuss the results after each exercise.
- UBS Business Solutions Poland Sp. z o.o.
I mostly liked the style.
- UBS Business Solutions Poland Sp. z o.o.
I really enjoyed the many practise.
Magdalena Chowaniec - UBS Business Solutions Poland Sp. z o.o.
I liked the overall scope, presentation style and organization.
Marek Dudka - UBS Business Solutions Poland Sp. z o.o.
Trainer was approachable, helpful, ready to answer questions, explain.
- UBS Business Solutions Poland Sp. z o.o.
Trainer's knowledge sharing, sense of humor and sharing innovation tools
Agata Gwozdziewicz - UBS Business Solutions Poland Sp. z o.o.
Training approx. The trainer has adapted to the participants' request for additional discussion of interesting issues.
expondo Polska Sp. z o.o. Sp.k.
Practical exercises
Patrycja - UBS Business Solutions Poland Sp. z o.o.
-
Agata Szafranska - UBS Business Solutions Poland Sp. z o.o.
Marwan is an excellent trainer. Very clear in the explanations.
GroupEAD Europe S.L.
The content was presented in a very progressive way, from easier topics to more complicated, in a really good pace allowing us to follow without any problem. The availability of the instructor to answer questions, repeat or reinforce topics was fantastic.
Oscar Centeno - GroupEAD Europe S.L.
The trainer style
GroupEAD Europe S.L.
How well he explained
GroupEAD Europe S.L.
He has immense knowledge which is very good and was very useful. Examples were very good.
GroupEAD Europe S.L.
I like the clear explanations provided by Marwan. His clarifications are very intuitive, and follow a very logical sequence. Marwan's interaction with us was very positive and re-assuring.
Marwan Hefnawy - GroupEAD Europe S.L.
I like it very much and the knowledge of the trainer was super but in my opinion it was too many subjects to cover in only 2 days.
GroupEAD Europe S.L.
Related Courses
VBA For Access & Excel
21 hours
Excel Advanced with VBA
21 hours
Analysing Financial Data in Excel
14 hours
Excel For Statistical Data Analysis
14 hours
Excel Advanced
14 hours
Excel Data Analysis
14 hours
Financial Analysis in Excel
14 hours