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 accurate and quick calculations where the results vary from basic calculations to complex financial analyses.
Advanced MS Excel will allow you to structure and present data impressively.
Program
1. Working with cells
- Copying and moving cells (range of cells)
- Adding a comment to a cell
- Special ways to insert into cells
2. Formatting the worksheet
- Working with styles
- Document formatting topics
- Creating and applying 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
- Complex counting formulas
- Formulas for conditional addition based on one criteria
- Formulas for conditional addition based on multiple criteria
- Formulas that find values
12. Final Test
- Functions for financial calculations
FAQ
Target Audience
Anyone interested in expanding their knowledge of working with spreadsheets and data analysis.
Is prior knowledge required?
No special prior knowledge is required other than the basics of MS Office.
More information about the trainer
Experienced instructors are appointed for the training, whose expertise is evidenced by the positively evaluated methodology from a large number of satisfied clients.
Avenga Academy instructors hold a university degree in the field of ICT and are ECDL certified in the field of conducting MS Office and MS Excel training for basic and advanced levels.
MS Excel Advanced
120 €
108 €
- Start: October 2025
- Duration: 3 weeks
-
Model: Online
-
Shedule: 3 times per week
- Time: 18:00 – 20:30 h