Course Outline
Introduction to Excel
- An overview of the Excel interface and its primary features
- Gaining a clear understanding of workbooks, worksheets, and cell references
- Utilizing the Ribbon, Quick Access Toolbar, and contextual menus effectively
Data Entry and Formatting
- Efficiently entering and modifying data
- Customizing the appearance of cells, rows, and columns
- Applying number formats, styles, and themes
- Performing data cleaning and basic validation tasks
Formulas and Functions
- Grasping formula structure and the order of operations
- Leveraging relative, absolute, and mixed references
- Mastering essential functions such as SUM, AVERAGE, COUNT, IF, and others
- Utilizing modern functions including XLOOKUP, IFS, and dynamic arrays
Working with Data Ranges and Tables
- Creating and maintaining Excel tables
- Sorting, filtering, and applying conditional filters
- Utilizing structured references within tables
- Implementing data validation and eliminating duplicate entries
Data Visualization
- Generating various charts and graphs, such as column, line, and pie charts
- Adjusting chart elements to ensure clarity
- Using Sparklines and Conditional Formatting to derive visual insights
- Adhering to best practices for effective data presentation
Introduction to Data Analysis Tools
- Utilizing PivotTables and PivotCharts
- Summarizing and grouping data effectively
- Getting started with the Analysis ToolPak for basic statistical analysis
Collaboration and Productivity Features
- Saving and sharing files through OneDrive and SharePoint
- Co-authoring workbooks and managing comments
- Accessing version history and utilizing recovery options
- Employing time-saving tools like Flash Fill and Quick Analysis
Summary and Next Steps
Requirements
- Fundamental familiarity with computer systems
- No previous experience with Excel is necessary
Target Audience
- Data analysts
- Office professionals
- Individuals seeking to master Excel fundamentals for data management and analysis
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 2600 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (4)
very clear, very good explanation, wishing more teachers would train like this
Mihaela - Phillip Morris
Course - Excel Basics
The practice
Eliza - DEICHMANN SRL
Course - Excel Basics
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.
