MS Excel Advanced
Excel is one of the most widely used software applications worldwide.
Excel equips you with the knowledge to organize, analyze, and visualize data—essential skills for making fast and accurate business decisions.
Description
This course is designed for students who want to perform precise and efficient calculations, ranging from basic formulas to complex financial analyses.
With MS Excel Advanced, you’ll learn how to structure and present data in a professional and impactful way.
Curriculum
1. Working with cells
-
Copying and moving cells (cell range)
-
Adding a comment to a cell
-
Another ways of insert into cells
2. Formatting of the worksheet
-
Working with styles
-
Document formatting themes
-
Creating and implementing custom number formats
-
Conditional formatting
3. Working with macros
- Creating a Pivot table
- Formatting and modifying a Pivot table
- Analyzing data using Pivot tables
4. Customizing the Quick Access Toolbar
- Adding new commands to the Quick Access Toolbar
- Other actions from the Quick Access palette
- Command line customization
5. Avoiding errors in worksheets
- Finding and correcting errors in formulas
- Using Excel's validation tools
- Search and data replacement
- Spell check of the worksheets
- Automatic error correction - AutoCorrect
Document protection
- Types of protection
- Worksheet protection
- Workbook protection with password
7. Data exchange between Excel and other programs
- Copy and paste
- Copying from Excel to Word
- Inserting object into the worksheet
Data validity check
- Defining criteria for data validity check
- Types of criteria of data validity
- Creating drop down lists
- Using formulas to check data validity
9. Advanced diagram techniques
- Selecting and changing the elements in the diagram
- Working with series of data
- Production of template diagrams and diagram tricks
Advanced functions in Excel
- Functions for working with text, date and time
- Logical and statistical functions
- Functions for financial calculations
Formulas
-
Compex counting formulas
- Formulas for conditional addition based on one criteria
- Formulas for conditional addition based on multiple criteria
-
Formulas for finding values
12. Final Test
- Functions for financial calculations
FAQ
Target Audience
This course is ideal for anyone looking to expand their knowledge of working with tables and performing data analysis.
Is prior knowledge required?
No prior knowledge is required, but a basic understanding of MS Office is recommended.
More information about the trainer
The course is led by experienced instructors with a proven track record, supported by positive feedback from many satisfied clients.
Qinshift Academy instructors hold university degrees in ICT and are ECDL-certified to teach MS Office and MS Excel at both basic and advanced levels.
MS Excel Advanced
120 €
108 €
- Start: October 2025
- Duration: 3 недели
-
Model: Online
-
Shedule: 3 times per week
- Time: 18:00 – 20:30 ч
