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 Pivot Tables
- Creating a Pivot table
- Formatting and modifying a Pivot table
- Analyzing data using Pivot tables
4. Working with macros
- Creating macros
- Absolute and relative recording
- Assign a macro to a button
5. Customizing the Quick Access Toolbar
- Adding new commands to the Quick Access Toolbar
- Other actions from the Quick Access palette
- Command line customization
6. 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
7. Document protection
- Types of protection
- Worksheet protection
- Workbook protection with password
8. Data exchange between Excel and other applications
- Copy and paste
- Copying from Excel to Word
- Inserting object into the worksheet
9. Data Validation Check
- Defining criteria for data validity check
- Types of criteria of data validity
- Creating drop down lists
- Using formulas to check data validity
10. Advanced techniques for working with diagrams
- Selecting and changing the elements in the diagram
- Working with series of data
- Production of template diagrams and diagram tricks
11. Advanced functions in Excel
- Functions for working with text, date and time
- Logical and statistical functions
- Functions for financial calculations
12. Formulas
- Complex counting formulas
- Formulas for conditional addition based on one criteria
- Formulas for conditional addition based on multiple criteria
- Formulas that find values
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?
During the classes, theory is covered and practical tasks are assigned, the solutions to 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.
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
Regular price
120 €
With a discount
108 €
- Start: September 2026
- Model: online
-
Shedule: 3 times per week
- Time: 18:00 – 20:30 h