Microsoft Excel – Advanced Course
Two-day course is intended for all common users who have already worked with MS Office Excel application and would like to extend their basic knowledge. The course focuses on the most common and the most useful functions, which are generally used while working with MS Office Excel.
Code
MEXCELP
Course length
2
days
(8:30 – 16:00)
Form
In our classroom or online
Dates
This course is intended for
- The course is intended for all common users who have already worked with MS Office Excel application and would like to extend their basic knowledge.
- Methodology of education
- Tutor’s explanation is accompanied by several practical examples, individual and group exercises on PC
Syllabus
Chapter 1: Advanced formatting
- Keep the source formatting
- Deleting format
- Conditional formatting
- Custom format
Chapter 2: Protecting workbook and worksheet
- Cell protection
- Protect sheet and protect workbook
- Protecting the file by using password, encryption
Chapter 3: Advanced copy and paste options
- Copy and paste options
- Fill series using AutoFill
- Possibilities of cooperation between MS Word and MS Excel
Chapter 4: Applying formulas in Excel
- Principles of creating and using formulas
- Relative and absolute references
- How to quickly find the function, how to revise and edit a formula
Chapter 5: The most used functions
- Logic functions
- Text functions
- Date and time functions
- Math functions
- Conditional calculations
Chapter 6: Analysing and organising data
- Freeze panes, arrange and split windows
- Data validation
- Sorting
- Filtering
- Creating an outline, group and ungroup rows and columns
- Converting text to a table
- Printing large data
Chapter 7: Creating reports and statements using pivot table
- Principles and using of pivot table
- Creating and changing pivot table
- Creating and changing pivot chart
Students will be able to
- Using advanced formulas and functions
- Using formulas with values that match your conditions (functions: countif, sumif)
- Effectively insert the copied values according to given criterias
- Organise, filter and sort large data
- Create reports and statements, aggregate data for the relevant period or category and print them
Course requirements
- Basic level of MS Excel based on MEXCELZ - Microsoft Excel – basic course
- Students are supposed to be confident in using Windows
Hardware
Spacious classrooms are equipped with premium computers with the access to the Internet, the wireless access included.
Literature
The workbook in English language is included.
Prices do not include VAT. OKsystem a.s. reserves the right to change dates and prices of courses.
Similar courses
Take a look at some similar courses from our wide range.
Microsoft Word – Creation of Templates MWORDS
Microsoft Teams for Users MTEAMS
Microsoft Excel – Macros MEXCELM
Need some advice?
Do not hesitate to contact us. We are at your disposal and will be happy to help you.
Why OKškolení?
What are the main advantages of our training centre?
36+ years in business
We have been on the market for more than 36 years and have a wealth of experience in this field.
We are a training center with a rich history and tradition.
Experienced tutors
The basis of any quality education is good and experienced lecturers and this is something that we at OKškolení take particular pride in. Our top lecturers are waiting for you.
Modern classrooms
All classrooms are spacious, air-conditioned, barrier-free and equipped with high-standard computers, with Wi-Fi connection.
Bonus program
Protect your investments into education, loyalty program, advantageous offers, refreshments, grants...
Contact us
Do not hesitate to contact us with any questions you may have.
Do you need to know more about us or would you prefer to contact us using the form?
