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