Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction to Excel
- Overview of Excel interface and key features
- Understanding workbooks, worksheets, and cell references
- Using the Ribbon, Quick Access Toolbar, and contextual menus
Data Entry and Formatting
- Entering and editing data efficiently
- Formatting cells, rows, and columns
- Using number formats, styles, and themes
- Data cleaning and basic validation
Formulas and Functions
- Understanding formula structure and order of operations
- Using relative, absolute, and mixed references
- Essential functions: SUM, AVERAGE, COUNT, IF, and more
- Using modern functions: XLOOKUP, IFS, and dynamic arrays
Working with Data Ranges and Tables
- Creating and managing Excel tables
- Sorting, filtering, and conditional filtering
- Using structured references in tables
- Data validation and removing duplicates
Data Visualization
- Creating charts and graphs (column, line, pie, etc.)
- Formatting chart elements for clarity
- Using Sparklines and Conditional Formatting for visual insights
- Best practices for effective data presentation
Introduction to Data Analysis Tools
- Using PivotTables and PivotCharts
- Summarizing and grouping data
- Introduction to Analysis ToolPak for basic statistics
Collaboration and Productivity Features
- Saving and sharing files via OneDrive and SharePoint
- Co-authoring workbooks and managing comments
- Version history and recovery options
- Using Flash Fill, Quick Analysis, and other time-saving tools
Summary and Next Steps
Requirements
- A basic understanding of computers
- No prior experience with Excel required
Audience
- Data analysts
- Office professionals
- Anyone wishing to learn the fundamentals of Excel for data management and analysis
14 Hours
Testimonials (6)
very clear, very good explanation, wishing more teachers would train like this
Mihaela - Phillip Morris
Course - Excel Basics
Explanations "in everyone's language"; the fact that every time our questions were answered and it was explained to us in at least 2 ways what, how and from where; the relaxed atmosphere and the fact that although there was a lot about mathematics, I didn't feel that; the trainer's experience proven through reasoned explanations, but never demonstrative; the trainer's passion: it is clear that he likes what he does :)
Alex - DEICHMANN SRL
Course - Excel Basics
Machine Translated
The practice
Eliza - DEICHMANN SRL
Course - Excel Basics
Most of all I appreciated the trainer's way of interacting with all the trainees, the willingness to provide any information requested and the interest given to each topic so that it is well understood. The course was very interactive, with lots of information and examples, and also the exercises were very useful for checking and consolidating knowledge.
Alex - DEICHMANN SRL
Course - Excel Basics
Machine Translated
some new functions i did knew before, such as power query; fomat cell -alignment-fill
Bella - fu ma si jing mi duan jian (da lian) you xian gong si
Course - Excel Basics
The guy was really helpful and knowledgeable and i really learned a lot in two days.
