Microsoft Excel Skills - Advanced

Please note this training opportunity is exclusive to LeedsBID levy paying businesses only.

This 1 day Advanced Microsoft Excel course is ideal for individuals who are already comfortable with Excel but want to explore advanced features that develop time saving techniques and improve data analysis skills.

This practical session will help you streamline your work, apply best practices to your spreadsheets and gain confidence using Excel’s powerful features.

By the end of this course, participants will be able to:

• Apply data validation to control data entry and create dynamic drop-down lists.
• Use conditional formatting to highlight key trends.
• Work confidently with logical functions such as AND/OR.
• Create and manage nested IF statements for complex decision making.
• Use XLOOKUP to retrieve and match data efficiently.
• Record and edit macros to automate repetitive tasks.
• Apply auditing tools.
• Clean and tidy datasets, including correcting common data entry errors (e.g., incorrect case used).

If you would like more information regarding this course or if you are unsure whether you work for a levy paying business, please contact

Please note that due to the listed status of our building, there is no lift access available – we apologise for any inconvenience this may cause.

Know what’s Happening Next — before everyone else does.

Get App

Host or Publisher The Engine Room @ LeedsBID