Course Outline
Exploring the Excel Environment
- An overview of the user interface and primary capabilities
- Gaining insight into workbooks, worksheets, and cell addressing
- Utilising the Ribbon, Quick Access Toolbar, and context-sensitive menus
Inputting and Styling Data
- Efficiently adding and modifying information
- Styling cells, rows, and columns
- Applying numerical formats, styles, and themes
- Data sanitation and foundational validation techniques
Formulas and Functions
- Comprehending formula syntax and calculation priority
- Applying relative, absolute, and mixed cell references
- Mastering core functions such as SUM, AVERAGE, COUNT, IF, and others
- Incorporating contemporary functions including XLOOKUP, IFS, and dynamic arrays
Managing Data Ranges and Tables
- Building and maintaining Excel tables
- Sorting, filtering, and applying conditional filters
- Leveraging structured references within tables
- Validating data and eliminating duplicate entries
Visualising Data
- Generating charts and graphs (bar, line, pie, etc.)
- Adjusting chart components for enhanced readability
- Employing Sparklines and Conditional Formatting to derive visual insights
- Adopting best practices for effective data presentation
Introduction to Analytical Tools
- Utilising PivotTables and PivotCharts
- Consolidating and categorising data sets
- Familiarising with the Analysis ToolPak for introductory statistical analysis
Collaborative and Efficiency Features
- Storing and distributing documents via OneDrive and SharePoint
- Simultaneous editing of workbooks and managing feedback
- Managing version history and recovery procedures
- Exploiting time-saving utilities such as Flash Fill and Quick Analysis
Conclusions and Future Directions
Requirements
- Familiarity with basic computer operations
- Existing proficiency in Excel is not a prerequisite
Target Audience
- Professionals engaged in data analysis
- Administrative and office staff
- Individuals aiming to master the core principles of Excel for data administration and interpretation
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.
