Course Outline
Excel Fundamentals
- Gaining insight into the Excel user interface
- Inputting and modifying data
- Applying essential formatting options
Core Spreadsheet Capabilities
- Managing rows, columns, and multiple worksheets
- Executing basic formulas and calculations
- Utilising copy, fill, and auto-complete features
Fundamentals of Data Visualisation
- Constructing standard charts
- Personalising chart components
- Choosing the most appropriate chart type for your data
Intermediate Formulas and Functions
- Implementing logical functions
- Manipulating text and date functions
- Differentiating between absolute and relative cell references
Data Organisation and Analysis
- Sorting and filtering datasets
- Operating with structured tables
- Applying conditional formatting rules
Advanced Excel Features
- Summarising data using PivotTables
- Visualising insights with PivotCharts
- Utilising advanced lookup functions
Automation and Efficiency Tools
- Developing and executing macros
- Capturing repetitive procedures
- Exploring introductory VBA concepts
Professional Reporting Methods
- Structuring worksheets effectively
- Developing reusable templates
- Adhering to best practices for data presentation
Wrap-up and Subsequent Steps
Requirements
- Familiarity with general computer operations
- Experience with standard office productivity applications
- A keen interest in developing spreadsheet competencies
Target Audience
- Corporate professionals
- Administrative personnel
- Individuals requiring spreadsheet expertise for everyday tasks
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customised 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 (2)
Flexibility in the course delivery and the interactive approach. The trainer was open to questions, clarified doubts clearly and also considered participants suggestions during the sessions. The training was well structured and informative.
Soundarya Mohan - Mizuho Bank Europe N.V.
Course - Financial Analysis in Excel
the trainer's patience,