Topics covered include Conditional Formatting wizard, Flash Fill, Name Manager, various functions (string, maths, logical, lookup), pivot tables, slicers and pivot charts to build a BI dashboard.

Having practiced all of these new skills extensively during the course you will be able to hit the ground running on your return to the office and should be able to complete your Excel work far more proficiently.

Learning Outcomes

Apply Fill Tools, Conditional Formatting and Filtering

• Using advanced Fill Series options
• Flash Fill
• Apply advanced conditional formatting and filtering n Creating filters
• Managing conditional formatting rules
• Conditional Formatting with Sorting & Filtering

Working with Data

• Getting External Data
• Restricting Cell Entries to Certain Data Types n Data Validation Tools
• Removing Duplicate Rows from a Worksheet n Sorting Data on a Single & Multiple Criteria n Sorting Data Using Cell Attributes
• Using AutoFilter
• Filtering Data Using Cell Attributes
• Outlining and Subtotaling data
• Removing Duplicates in a Table

Using Formulas

• Apply functions in formulas
• Functions Wizard
• Name Manager, Naming Ranges and Using them in Formulas
• Absolute vs Relative Referencing
• Formula Auditing
• Using nested functions
• Using the IF, AND, and OR functions
• Using the SUMIFS and AVERAGEIFS functions
• Using the VLOOKUP function
• Using the NOW and TODAY functions
• Using text manipulation functions like LEFT, RIGHT, MID, TRIM, CONCATENATE
• Create scenarios
• Using what-if analysis tools n Using the Scenario Manager

Data Analysis & and Manipulation using PivotTables & PivotCharts

• Create and manage PivotTables
• Modifying field selections and options
• Filters in PivotTables
• Creating slicers
• Create and manage PivotCharts
• Manipulating options in existing PivotCharts n Multiple PivotTables on same Sheet
• Applying styles to PivotCharts
• Building a BI Dashboard

Course Dates & Duration

Please note that as per terms and conditions, LEAD Training Services reserves the right to alter course dates, times and venue in exceptional circumstances beyond its control.

A 10-15 minute break will be allowed every hour during which students can also take this opportunity to submit further questions or comments to the trainer.

Entry requirements

A foundation in basic Excel techniques is advised. This course will prepare students for a more advanced course, helping them to learn new tools and functions to make their work in the office more precise and efficient.

Course Delivery Mode

This course will be delivered via live online webinars.  The course trainers will be visible on screen via a professional webinar platform, through which students can follow the trainer presenting live, whilst also using a PowerPoint presentation and sharing other resources as necessary.

Students will be able to interact with the trainer by sending questions or comments through the same webinar platform.

Our student support team will assist all students with simple instructions on how to access the webinar online.  A support line will also be made available to communicate with a student support officer in case of technical difficulties encountered during the live webinar.

Trainer

Sanjay Swamy Prasad

Sanjay is a Senior Insight Analyst at Tipico. He holds a B.Sc. in Artificial Intelligence from the University of Malta and an M.Sc. in Business Analytics from the Manchester Metropolitan University. His experience across the telecommunications and iGaming industries has allowed him to develop strong expertise in analysing data and creating insightful dashboards. His Excel knowledge enables him to efficiently manage complex datasets and produce reports that support strategic decision-making across the business.

Testimonials

• I highly recommend this course to anyone looking to build practical skills in a supportive and well-delivered learning environment.
  J.Muscat, 2025