This session provides you with a mixture of tools that can save hours when analysing and working with data.
• Using pivot tables to summarise large data without a calculation sight
• Avoid manually adjusting hundreds of calculations by fixing cells in calculations
• Learn how the new XLOOKUP function can pull though information across multiple tables and how it relates to the VLOOKUP function
• Use flash fill to use patterns in your data to produce new columns combining or splitting existing information
This course is designed for proficient users of Excel.
Please note this workshop will be focusing on Excel for PC.
All attendees must be registered to the Business Northumberland programme prior to the workshop.
Registered businesses will receive an email with a link inviting them to Microsoft Teams where they will be able to attend the workshop!