Data Tab…Consolidate [Data Tools]…Select FX…Add Ranges…Select Options…DONE!
Today’s Excel Q&A by Philip Gamey, shows you how to use Excel’s Consolidate tool to unite several reports.
Watch the video below:
There are 2 ways to add sub and grand totals in reports, one requires more, and here’s the other
This Excel Q&A by Philip Gamey teaches you how to use CTRL+”FEW CLICKS” and ALT+= to save the day.
Watch the YouTube below on Making TOTALS fun!