Microsoft Excel
When precision and speed team up
In a world driven by information, being proficient in Microsoft Excel has become a fundamental requirement, regardless of the industry or discipline in which we operate. Excel is not just a spreadsheet program, but a versatile tool that contributes to the professional advancement of those who need to manage, analyze, and visualize data with great precision and obtain top deliverables by efficiently managing the potential of information.
In a world where information drives us, knowledge of Excel is a skill with transformational potential, through which anyone can equip themselves to excel academically, professionally, or personally.
Course objectives
- Efficient data management
- In-depth data analysis
- Solving complex problems
- Visual representation
- Saving time and resources
- Increasing career versatility
Course modules
Beginner level
- Introduction to Excel
- Introduction to cell formatting
- Formulas, functions, and basic operators (SUM, COUNT, IF, etc.)
- Data manipulation: filtering, sorting, copying, moving
- Flash fill; absolute and relative references
- Navigating Excel: worksheets, columns, rows, freeze panes, printing
- Cell formatting: numbers, text, dates, currency
- Conditional formatting
- Tables
- Data protection
Medium level
- Cell formatting: numbers, text, dates, currency
- Table formatting
- Conditional formatting
- Data validation and protection
- Data filtering and sorting
- Text to columns
- Remove duplicates
- Flash fill
- Charts and sparklines
- Basic formulas and functions SUM, SUBTOTAL, COUNT, COUNTA
- Logical functions: IF, IFS, SUM IF, COUNT IF, SUMIF
- Text functions: UPPER, LOWER, PROPER, LEFT/RIGHT, MID, LEN, CONCAT, TEXTSPLIT
- Date and time functions: TODAY, NOW, DATE
- Search function: FILTER, XLOOKUP
- Pivot tables and pivot charts
- Useful shortcuts and efficiency tips
- Types of errors
Advanced level
- Searching with XLOOKUP
- Advanced nesting of functions
- Power Pivot for data transformation and preparation
- Data analysis: what-if analysis & solver
- Useful shortcuts
- Advanced mathematical and statistical functions: MOD, INT, RANK, PERCENTILE
- Advanced search and referencing functions: CHOOSE, OFFSET, INDIRECT
- Editing and creating macros
Florina Băbău
HR Manager Ascent GroupFlorina is a graduate of the Faculty of Economic Sciences at the West University of Timisoara and has numerous certifications in the field of management and human resources. At the professional level, Florina has over 15 years professional experience as human resources manager, project manager, implementation and process improvements, projects with European funds, organization of motivational events, assessment and personnel development, for both multinational and Romanian companies.
Since 2019 Florina became HR Manager within Ascent Group, coordinating the group's human resources activities and projects at national level. Last but not least, Florina is also an experienced trainer in soft skills and team building programs.
