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.
What is the concept of the classes?
The classes cover theory and assign practical tasks, the solutions of which are reviewed and discussed at subsequent meetings. Participants share experiences from the projects they are working on, and together they analyze different approaches, possible solutions, and good professional practices.
More information about the trainer
Larisa Mitic – a graduate mechanical engineer, with over 10 years of experience as an advanced Excel trainer. 500+ satisfied listeners from the business sector, young unemployed people and people from socially vulnerable categories.
MS Excel Advanced
120 €
108 €
- Start: October 2025
-
Model: Online
-
Shedule: 3 times per week
- Time: 18:00 – 20:30 h