From the course: Microsoft Office Specialist: Excel Expert (Microsoft 365 Apps) Cert Prep
Join today to access over 25,200 courses taught by industry experts.
Summarize data from multiple ranges by using the Consolidate feature - Microsoft Excel Tutorial
From the course: Microsoft Office Specialist: Excel Expert (Microsoft 365 Apps) Cert Prep
Summarize data from multiple ranges by using the Consolidate feature
- [Instructor] The consolidate feature in Excel pulls data from multiple Excel worksheets into one worksheet. The only caveat is that the data must be structured similarly. I'm going to show you options you can choose from when setting up the consolidation in your workbooks and show you how you can link to the data source. Let's jump into our document. It's the 04_08 Consolidate workbook, and we're also going to work with the 04_08 2022 Sales workbook. We need to pull the information from this workbook into the worksheet called Combined Sales. Within 04_08 Consolidate workbook, we have our 2021 sales. On the Combined Sales worksheet, you'll notice that I have left the column headings and the row headings blank, because I want to show you how you can pull that information in from the worksheets as you consolidate that information. I'll start in B3. On my data tab in the data tools group, I'll go to consolidate. Now…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Contents
-
-
-
-
-
-
Use AND(), OR(), and NOT() in nested functions4m 56s
-
(Locked)
Use IF() and IFS() in nested functions5m 43s
-
(Locked)
Use SWITCH() in nested functions4m 23s
-
(Locked)
Use SUMIF(), AVERAGEIF(), SUMIFS(), and AVERAGEIFS() functions4m 43s
-
(Locked)
Use COUNTIF(), COUNTIFS(), MAXIFS, and MINIFS5m 51s
-
(Locked)
Look up data using XLOOKUP(), VLOOKUP(), HLOOKUP(), INDEX(), and MATCH()7m 19s
-
(Locked)
Use NOW() and TODAY() functions and calculate dates using WEEKDAY() and WORKDAY() functions8m 31s
-
(Locked)
Summarize data from multiple ranges by using the Consolidate feature4m 46s
-
(Locked)
Use What-If Analysis, Goal Seek, and Scenario Manager5m 56s
-
(Locked)
Calculate financial data with NPER() and PMT() functions4m 19s
-
(Locked)
Use the SORTBY() and FILTER() functions4m 30s
-
(Locked)
Troubleshoot formulas8m 16s
-
(Locked)
Challenge: Create advanced formulas30s
-
(Locked)
Solution: Create advanced formulas14m 31s
-
-
-