After helping his side to secure a 1-1 draw at the Santiago Bernabeu in the first leg, the Red Devils star is in no doubt that the Old Trafford crowd will create an incredible atmosphere.
"The big European nights at home are always special occasions and, when Madrid come to town, it will be extra-special," he told the official Uefa website.
|MANCHESTER UNITED LATEST
|12/1||Manchester United are 12/1 with William Hill to beat Real Madrid 1-0 at Old Trafford
"At this stage of the competition, when two teams like this come together, sometimes it can be very tight and games can be won and lost on little details," Carrick explained.
"Of course we will play our game and try to score goals but sometimes that's not possible, especially in games like this. I am sure Madrid are thinking the same thing."
The game marks Cristiano Ronaldo's first return to Old Trafford since leaving to join Madrid in a world-record transfer deal back in 2009 and Carrick is expecting a warm reception for the Portuguese, insisting: "Everyone respects what he did at the club and how good he was."
With this year's final set to take place at Wembley, some have suggested that this will offer the Red Devils the opportunity to lay to rest the demons of their 2011 final defeat to Barcelona at the same venue.
However, the England international is wary of focusing on retribution too early, observing: "In terms of putting that right, we can't, because the game is gone. We've got something else to achieve now and we'll try our utmost to do that.
"Obviously, being at Wembley, it's an added incentive but we're not looking too far ahead. We are well aware of the tie that is immediately in front of us."