If your role involves combining sets of data that span several periods of time, it can be tricky if they are laid out and formatted differently. This is where Excel’s Data Consolidation tools are useful, and in this session, we look at several options for consolidating data by position, by category, by formula and for Microsoft 365 users, by using Power Query.