Skip to main content

Consolidate eight weeks of sales

100%
SUM

A consolidation table puts the same measure from several weeks side by side. A row total should cover every week, from the first value in column B through the eighth in column I.

The source workbook used eight separate worksheets. This browser exercise presents the same weekly values together in one grid, because the current practice engine works with one sheet at a time. The SUM skill is the same.

In B11, total every weekly figure in B2:I9.

The grid for this exercise needs a free profile.

Everything above is yours to read either way. 19 exercises stay open with no profile at all.

Adapted from Excel Beginners Practice Lab by Muhammad Auwal Abdulaziz (MIT).