Course Outline
Getting Started with Excel
- Exploring the Excel interface and its primary capabilities
- Grasping workbooks, worksheets, and cell referencing
- Navigating the Ribbon, Quick Access Toolbar, and context-dependent menus
Input and Styling of Data
- Efficiently inputting and modifying data
- Applying styles to cells, rows, and columns
- Implementing numeric formats, design styles, and themes
- Basic data cleansing and validation techniques
Formulas and Functions
- Understanding formula logic and the order of operations
- Applying relative, absolute, and mixed cell references
- Mastering key functions such as SUM, AVERAGE, COUNT, IF, and others
- Leveraging newer functions like XLOOKUP, IFS, and dynamic arrays
Managing Data Ranges and Tables
- Building and maintaining Excel tables
- Sorting, filtering, and applying conditional filters
- Utilizing structured references within tables
- Enforcing data validation and eliminating duplicate entries
Data Presentation
- Constructing charts and graphs (e.g., column, line, pie)
- Refining chart components for better readability
- Employing Sparklines and Conditional Formatting to highlight insights
- Adhering to best practices for clear data communication
Overview of Analytical Tools
- Utilizing PivotTables and PivotCharts
- Aggregating and categorizing datasets
- Introductory use of the Analysis ToolPak for statistical basics
Collaboration and Efficiency Features
- Storing and sharing documents through OneDrive and SharePoint
- Joint workbook editing and comment management
- Accessing version control and restoration options
- Streamlining tasks with Flash Fill, Quick Analysis, and other productivity aids
Wrap-up and Future Learning Paths
Requirements
- A foundational grasp of computer usage
- No previous proficiency in Excel is necessary
Target Audience
- Data analysts
- Administrative and office professionals
- Individuals seeking to master core Excel concepts for data handling and analytics
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 3200 € + 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.
