Microsoft Excel Intermediate
The IF Function
IF with AND / OR Functions
Nested IF – including IFS
Date and Time Functions – TODAY, YEAR, MONTH
Data Validation
The Lookup Function: VLOOKUP, HLOOKUP, XLOOKUP
VLOOKUP Function with IFERROR Validation
Subtotal Feature & SUBTOTAL Function – with Outlines
Database Statistical Functions – DAVERAGE, DCOUNT, and DSUM
Advanced Filters
Conditional Formatting
Pivot Tables & Pivot Charts
This course is designed for individuals who:
Want to display data dynamically in Excel worksheets based on specific conditions or criteria.
Seek to visually understand and follow the logical flow of formulas within worksheets, including addressing circular references.
Are responsible for managing and maintaining lists containing a moderate number of items, such as company assets, personnel records, product inventories, or invoices, often numbering up to a few thousand rows.
We can deliver our training sessions in several ways, these being:
- Open public course (Contact us if you can’t see a suitable date listed)
- Closed group
- In person face to face
- Virtual
- One to one coaching
Have two or more people to train? You may consider a closed group course.
Benefits include:
- Cost effective
- Choose a date to suit you
- Customise content and timings
- No minimum delegate
Contact us on [email protected] to discuss specific date and delivery requirements.
How Our Tutor led Courses Are Delivered:
Delegates are given Pre-work
Group courses use your real-world scenarios so learning is immediately relevant and actionable.
Our sessions are participative and highly Interactive by including a variety of activities throughout the delivery including
Real-world case work
Practical exercises
Real Play
Peer learning
Case studies
Simulation
Facilitated discussion and Structured reflection
Leave with Actionable outcomes
Post-session measurements
Participants leave with:
Practical tools
Clear action plans
Greater confidence
Skills they can apply immediately
Course Benefits
- Fully tutor led instruction
- Comprehensive courseware for all delegates
- Certificates of attendance
- Course Guarantee
- Emergency trainer
- Contextualisation and customisation for Closed group courses
- Evaluation Feedback
- Pre & Post Course Activities
- Access to Customer Portal (course bookers) for oversight of past and future training events and attendance details
Key Features
Engaging tutor led event
Comprehensive course materials
Certificates of attendance
Access to Customer Portal (course bookers)
Course Guarantee
From: £295.00 Plus VAT
Can’t see a suitable date? Please request a date here
Payment available via all major credit cards or Invoice. All options available during the online booking process.
