Microsoft Excel Intermediate
The IF Function: Learn how to use the IF function to perform conditional calculations in Excel, allowing you to make decisions based on specified criteria.
Nested IF: Dive deeper into conditional logic by mastering nested IF statements, which enable you to create more complex decision trees.
The Lookup Function: Explore the Lookup functions (such as VLOOKUP and HLOOKUP) to search for and retrieve specific data from tables or ranges.
Date and Time Functions: Learn how to work with date and time functions in Excel to perform various date-related calculations and operations.
Advanced Filters: Explore techniques to efficiently filters lists and databases within Excel.
Subtotals & Outlines: Learn how to create subtotals and outlines to summarize and structure data within large datasets.
Database Statistical Functions: Discover statistical functions to analyse and interpret data, including functions like DAVERAGE, DCOUNT, and DSUM.
Data Validation: Use this powerful tool to validate user input within Excel to minimise user error.
Conditional Formatting: Use conditional formatting to create formulas to control cell formatting.
Pivot Tables & Pivot Charts: Delve into pivot tables and pivot charts to efficiently summarise, analyse, and visualise large datasets.
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
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.