(3) Consolidation is the process of combining values from several ranges of data either from within the same or different workbooks. It can be used to summarize data from different work sheets into master worksheet and create a report using a variety of calculations. PMT is a financial function that is offered in the financial functions category in Excel.