Course Outline
Edit spreadsheets
- Edit the contents of a cell
- Insert and delete cells
- Copying cells
- Copy and Paste commands
- The fill handle
- Fill command
- Series data and Autofill option
- Copying formulas
- Relative reference and absolute reference
- Appeals mixed
- Moving the cell
- The Office Clipboard
- Recall, repeat and redoing operations
Working with workbooks
- Excel Files
- Spreadsheets workbook
- Windows workbooks
- Save files to disk
- Opening an existing workbook
The use of functions in formulas
- Functions
- Construction features
- The function arguments.
- Enter a Function
- Math and trigonometry function
- Statistical Functions
- Logical Functions
- Search and address
- Information functions
- Date and Time Functions
- Text functions
Format Cells
- Formatting numbers
- Aligning
- Formatting fonts
- Borders
- Shaded cells
- Style
- Conditional formatting
- Format painter
- Psychological column width and row height
- Auto-fit
- AutoFormat
- Remove formatting from cells
Working with Graphic Objects
- Graphical objects
- Drawing Toolbar
- Drawing objects
- Inserting Images
- We work with graphics
- The order set of graphic objects
Creating Charts
- Charts
- Chart wizard
- Relationship data sheet of graph
- Data series and points
- Chart Elements
- Chart types
- Options charts
- Titles
- Axles
- The grid lines
- Legend
- Data labels
- Data table
Printing
- Printing
- Dialog, the Page Setup
- Print preview
- A dialog box, printing
Using lists
- Lists
- Transforming the range of the list
- Application forms
- AutoFilter
- Advanced filters
- Sorting
- Subtotals
- Functions operating on databases
Pivot tables
- Create and modify PivotTables
- Calculated fields and calculated members
Requirements
Knowledge of Windows
Testimonials
I have learnt something, Trainer tried to help us with our queries.
Angelika Czapka, LKQ Polska Sp. z o. o.
I learned new things so that is a good point
Daria - Angelika Czapka, LKQ Polska Sp. z o. o.
many exercises
Julia - Angelika Czapka, LKQ Polska Sp. z o. o.
The applicability of the content
EPFL HBP PCO
The tips for many of the functions that the trainer presented, which we can easily remember and implement in our future work
Emilija Stoilova - EPFL HBP PCO
1. Clear theoretical explanation of concepts and alternatives to problem solving. 2. Practical examples where concepts are, and can be applied. 3. I learnt skills that I can use in my job, which will make some of my work easier 4. It will definitely bring some innovation into some of the reports I prepare for different Committees.
Sindiso Ndlovu - Export Credit insurance corporation
The reminder of the world of statistics :)
Export Credit insurance corporation
Steve was willing to answer every questions and worked diligently to address any individual concerns or technical issues as they arose in the class. He also did a great job of presenting the technical details in a way that made it less intimidating to even the least tech savvy people in the room. Personally, learning about some useful shortcuts in Excel that I didn't know about will certainly improve my overall workflow when using Excel in the future! I am so appreciative of those little details that I was exposed to during the two-day training.
Alan Gonzalez - Queens College, CUNY
The fact he had dif excel and data sheets with exercises for us to do.
Deepakie Singh Sodhi - Queens College, CUNY
The trainer's skills
Katarzyna Zarazka
Dużo ćwiczeń, zwięzła teoria.
Monika
Spokój i tłumaczenie materiału
Paulina
Duża ilość ciekawych przykładów i ćwiczeń, nauka poprzez praktykę, zainteresowanie grupy przez trenerkę, duża umiejętność przekazanie wiedzy
Kasia - Monika Kamińska, The Boston Consulting Group sp. z o.o.
Duża ilość przykładów i zadań.
Monika Kamińska, The Boston Consulting Group sp. z o.o.
Przydatne triki i formuły ułatwiające codzienne używanie excela, wyjaścione w prosty sposób przez trenerkę
Alicja - Monika Kamińska, The Boston Consulting Group sp. z o.o.
Trainer's knowledge and attitude
Ewa - Monika Kamińska, The Boston Consulting Group sp. z o.o.
Pace was enough to every attendand needs
Szymon - Monika Kamińska, The Boston Consulting Group sp. z o.o.
A lot of exercise. Trainer doesn't need to have support for his course. He has a really great knowledge for his subject.
Quentin Demeyere
It was really nice from the trainer that he took a lot of time to answer our questions and helped us improve or gave us hints on how to improve some macros we were already using without fully understanding the code.
David Trieu - CD Projekt SA
short excersises
Mateusz Podsiadlo
Training agenda was well thought out
Przemek Zalasinski
I like the hands on training and seeing us solve for issues on the spot.
Jon Matrille - LocumTenens.com
I really enjoy the training. Huge and practical! knowledge of the trainer combined with his skill to conduct the training made the training time very efficient. The trainer recognized the level of participant's experience in VBA and provided exercises relevant to that experience which made the training very useful.
Barbara Peek - UBS Business Solutions Poland Sp. z o.o.
I was benefit from the trainer knowledge, explanation and tips.
Kornel Tymcio - UBS Business Solutions Poland Sp. z o.o.
I liked the trainer, nice guy with great attitude.
Lukasz Kanior - UBS Business Solutions Poland Sp. z o.o.
I generally enjoyed the knowledge and sense of humor.
Łukasz Rózga - UBS Business Solutions Poland Sp. z o.o.
Fitted training to peoples needs
Robert Solek - UBS Business Solutions Poland Sp. z o.o.
The whole topic is interesting - everything was ok.
Bartosz Wierzewski - UBS B
Examples from different area of VBA programing.
UBS Business Solutions Poland Sp. z o.o.
The instructors knowlege
US Bank
Content and the way it was provided.
Marcin Samborski
There was a good amount of information for the time of training. Also the trainer was very engaged with the group, especially when people were having troubles or asking questions. It was very nice of him to offer help in case of future ideas.
Aleksander Jarecki - Amazon Development Center Poland Sp. z o.o.
The instructor and the way he teach
Mohammad Almalek - Hessa Al Ali, Dubai Government Human Resources Department - DGHR
the subject
Laila - Hessa Al Ali, Dubai Government Human Resources Department - DGHR
Very clear and easy. Excellent trainer.
Hessa Al Ali, Dubai Government Human Resources Department - DGHR
His engage with the trainees & answer their questions.
sharifa alshehi - Hessa Al Ali, Dubai Government Human Resources Department - DGHR
TRINER IS VERY GOOD
KHALID ALMUJAININ - Hessa Al Ali, Dubai Government Human Resources Department - DGHR
practical nature and patience of trainer
Angela de Jong - Hessa Al Ali, Dubai Government Human Resources Department - DGHR
The trainer had in depth knowledge of the course presented.
BMW
The specialist knowledge was amazing! The way that you took that and broke it up, so we could understand was awesome. I think i just have to start with the simple stuff. the Last Subject was a bit high level and I struggled to keep up but will get there :)
Zaskia Stanz - BMW
Detailed examples & training material.
KAREN LOUW - BMW
He was prepared and also give good pointers
Annemarie Van Aardt - BMW
No certain (VBA Environment and Macros). Otherwise, too much information for a Beginner without basic knowledge Coding/Programming
BMW
The content is useful and the trainer gave us information on what to do in the future if we encounter problems and questions
International Trading Fashion & Apparel Supply Limited
Kamil was exceptionally patient and very helpful in figuring out solutions to real needs. He was also very honest about if he didn't know something from the top of his head, which enabled us to quickly jump on in the training and we didn't lose time.
Christine Weiler
Attention to details, solving problem till it's solved.
Trener by zainteresowany tym jakie zagadnienia nas interesuja i w jaki sposób wykorzystujemy Excel w pracy.
Na początku prowadzący zapytał nas o naszą pracę i o to, jak pracujemy z Excelem oraz czego potrzebujemy się nauczyć, co nadało fajny rytm zajęciom. Wielki plus za anielską cierpliwość :)
power query
well structured.