Content Creator & former Microsoft Product Manager

Kevin Stratvert

Excel

Lern Top Posts Collection Focus

Pro User MyRole

[URL] Worldwide Content Releastionship

<div><div data-sp-canvascontrol="" data-sp-canvasdataversion="1.0" data-sp-controldata="&#123;&quot;position&quot;&#58;&#123;&quot;layoutIndex&quot;&#58;1,&quot;zoneIndex&quot;&#58;1,&quot;sectionIndex&quot;&#58;1,&quot;sectionFactor&quot;&#58;12,&quot;controlIndex&quot;&#58;0&#125;,&quot;controlType&quot;&#58;3,&quot;id&quot;&#58;&quot;eab81b3f-caad-4f60-a812-2194faa10c66&quot;,&quot;webPartId&quot;&#58;&quot;d1d91016-032f-456d-98a4-721247c305e8&quot;,&quot;rteInstanceId&quot;&#58;&quot;19efc1a7-3390-4e42-8e85-1ebc48ae9cff&quot;,&quot;addedFromPersistedData&quot;&#58;true,&quot;reservedHeight&quot;&#58;811,&quot;reservedWidth&quot;&#58;1178&#125;"><div data-sp-webpart="" data-sp-webpartdataversion="1.11" data-sp-webpartdata="&#123;&quot;id&quot;&#58;&quot;d1d91016-032f-456d-98a4-721247c305e8&quot;,&quot;instanceId&quot;&#58;&quot;eab81b3f-caad-4f60-a812-2194faa10c66&quot;,&quot;title&quot;&#58;&quot;Image&quot;,&quot;description&quot;&#58;&quot;Add an image, picture or photo to your page including text overlays and ability to crop and resize images.&quot;,&quot;audiences&quot;&#58;[],&quot;serverProcessedContent&quot;&#58;&#123;&quot;htmlStrings&quot;&#58;&#123;&#125;,&quot;searchablePlainTexts&quot;&#58;&#123;&#125;,&quot;imageSources&quot;&#58;&#123;&quot;imageSource&quot;&#58;&quot;/sites/M365-CDN/SiteAssets/SitePages/Content-21334/3999990582-Excel10.jpg&quot;&#125;,&quot;links&quot;&#58;&#123;&#125;,&quot;customMetadata&quot;&#58;&#123;&quot;imageSource&quot;&#58;&#123;&quot;siteId&quot;&#58;&quot;40ef054e-5ec7-4552-ac92-09bbd4faa5e1&quot;,&quot;webId&quot;&#58;&quot;35f81bac-1b1d-4f8c-a038-0302a1a6ae55&quot;,&quot;listId&quot;&#58;&quot;870ffa3e-eb32-4905-82ab-9e57adb99968&quot;,&quot;uniqueId&quot;&#58;&quot;60b606aa-634b-4530-ac48-9971a6613f05&quot;,&quot;width&quot;&#58;2048,&quot;height&quot;&#58;1365&#125;&#125;&#125;,&quot;dataVersion&quot;&#58;&quot;1.11&quot;,&quot;properties&quot;&#58;&#123;&quot;id&quot;&#58;&quot;e4e84a10-bffb-4d52-aafd-3c9c169dfd43&quot;,&quot;linkUrl&quot;&#58;&quot;&quot;,&quot;isInlineImage&quot;&#58;true,&quot;siteId&quot;&#58;&quot;40ef054e-5ec7-4552-ac92-09bbd4faa5e1&quot;,&quot;webId&quot;&#58;&quot;35f81bac-1b1d-4f8c-a038-0302a1a6ae55&quot;,&quot;listId&quot;&#58;&quot;870ffa3e-eb32-4905-82ab-9e57adb99968&quot;,&quot;uniqueId&quot;&#58;&quot;60b606aa-634b-4530-ac48-9971a6613f05&quot;,&quot;imgHeight&quot;&#58;1365,&quot;imgWidth&quot;&#58;2048,&quot;imageSourceType&quot;&#58;2,&quot;alignment&quot;&#58;&quot;Center&quot;,&quot;fileName&quot;&#58;&quot;Excel10.jpg&quot;,&quot;fixAspectRatio&quot;&#58;false,&quot;altText&quot;&#58;&quot;&quot;&#125;,&quot;containsDynamicDataSource&quot;&#58;false&#125;"><div data-sp-componentid="d1d91016-032f-456d-98a4-721247c305e8"></div><div data-sp-htmlproperties=""><img data-sp-prop-name="imageSource" src="/sites/M365-CDN/SiteAssets/SitePages/Content-21334/3999990582-Excel10.jpg" data-sp-cust-siteId="40ef054e-5ec7-4552-ac92-09bbd4faa5e1" data-sp-cust-webId="35f81bac-1b1d-4f8c-a038-0302a1a6ae55" data-sp-cust-listId="870ffa3e-eb32-4905-82ab-9e57adb99968" data-sp-cust-uniqueId="60b606aa-634b-4530-ac48-9971a6613f05" data-sp-cust-width="2048" data-sp-cust-height="1365" /></div></div></div><div data-sp-canvascontrol="" data-sp-canvasdataversion="1.0" data-sp-controldata="&#123;&quot;controlType&quot;&#58;4,&quot;id&quot;&#58;&quot;19efc1a7-3390-4e42-8e85-1ebc48ae9cff&quot;,&quot;position&quot;&#58;&#123;&quot;layoutIndex&quot;&#58;1,&quot;zoneIndex&quot;&#58;1,&quot;sectionIndex&quot;&#58;1,&quot;sectionFactor&quot;&#58;12,&quot;controlIndex&quot;&#58;1&#125;,&quot;addedFromPersistedData&quot;&#58;true&#125;"><div data-sp-rte=""><b></b><b></b><p>Creating pivot tables from multiple Excel worksheets or workbooks allows for powerful data analysis and summarization. First, you need to prepare your data. Ensure all your data is consistent, has no missing fields, and is in tabular format. From here, navigate to 'Data' in the Excel toolbar and select 'PivotTable'. You will be prompted to choose the data you wish to analyze.<br></p><p>You can either choose to manually select the range of data from each worksheet or use the 'Multiple consolidation ranges' option if you have your data in different workbooks. Once your data is selected, create a new worksheet for your PivotTable report and begin summarizing and analyzing your data.&#160;</p><p>A pivot table enables you to examine your data in different dimensions, calculate totals, averages, and other aggregates, and reveal patterns that might otherwise be difficult to find.</p><div tabindex="-1" data-cke-widget-wrapper="1" data-cke-filter="off" class="cke_widget_wrapper cke_widget_block cke_widget_inlineimage cke_widget_wrapper_webPartInRteInlineImage cke_widget_wrapper_webPartInRteClear cke_widget_wrapper_webPartInRteAlignCenter cke_widget_wrapper_webPartInRte cke_widget_selected cke_widget_focused" data-cke-display-name="div" data-cke-widget-id="0" role="region" aria-label="Inline image in RTE. Use Alt + F11 to go to toolbar. Use Alt + P to open the property pane."><div data-webpart-id="image" class="webPartInRte webPartInRteAlignCenter webPartInRteClear webPartInRteInlineImage cke_widget_element" data-cke-widget-data="%7B%22classes%22%3A%7B%22webPartInRteInlineImage%22%3A1%2C%22webPartInRteClear%22%3A1%2C%22webPartInRteAlignCenter%22%3A1%2C%22webPartInRte%22%3A1%7D%7D" data-cke-widget-upcasted="1" data-cke-widget-keep-attr="0" data-widget="inlineimage" data-instance-id="eab81b3f-caad-4f60-a812-2194faa10c66" title=""></div></div><p><b>TIMESTAMPS</b></p><p><br></p><ul><li>00&#58;00 Introduction</li><li>00&#58;37 Overview of the data</li><li>01&#58;34 Launch Power Query Editor</li><li>02&#58;28 Import data tables</li><li>04&#58;24 Append queries</li><li>05&#58;48 Transform data</li><li>06&#58;23 Make &amp; customize pivot table</li><li>08&#58;43 Relate data tables</li><li>12&#58;00 Wrap up</li></ul><p><br></p><h3><b>Unders</b><b>tanding Microsoft Excel</b></h3><p>Excel is a Microsoft Office product that's primarily used for handling and organizing data. It offers features for mathematical calculations, statistical analysis, chart creation, and pivot tables. A pivot table is a data summarization tool in Excel, enabling users to extract significance from large, detailed data sets.<br></p><p>Excel's pivot tables allow you to select, analyze, and report on data. With a pivot table, you can pull in data from different worksheets or workbooks, organize it, and then summarize it in various ways. Excel can handle complex data operations, offering users an opportunity to turn raw data into actionable insights.</p><p><br></p><h3><b>What M</b><b>ore to Learn about Microsoft Excel</b><br></h3><h4><b>Harnessing the Power </b><b>of Excel Functions and Formulas</b></h4><p>To truly become proficient in Excel, it's necessary to learn about the various functions and formulas Excel offers. Functions and formulas are the backbone of Excel. They allow you to perform complex calculations, automate data entry, and manipulate data in numerous ways.<br></p><p>Excel provides over 400 functions that cater to a wide array of requirements, from simple arithmetic operations to complex statistical analyses. These include functions like SUM, AVERAGE, COUNT, IF, VLOOKUP, and INDEX-MATCH, among others. Understanding how to use these functions can significantly boost your productivity and data analysis capabilities.</p><p><br></p><h4><b>Maste</b><b>ring Excel's Data Visualization Tools</b><br></h4><p>Excel also offers powerful data visualization tools. These tools, which include charts and graphs, can be used to transform raw numbers into visual representations that are easier to understand. Excel provides a variety of chart types, including bar charts, line charts, pie charts, and histograms, each suited to represent data in different ways.<br></p><p>Understanding how to use Excel's data visualization tools can provide you with the ability to quickly communicate complex data trends to others. Learning to use these tools effectively can make your work more engaging and understandable to your audience.</p></div></div><div data-sp-canvascontrol="" data-sp-canvasdataversion="1.0" data-sp-controldata="&#123;&quot;controlType&quot;&#58;0,&quot;pageSettingsSlice&quot;&#58;&#123;&quot;isDefaultDescription&quot;&#58;true,&quot;isDefaultThumbnail&quot;&#58;true,&quot;globalRichTextStylingVersion&quot;&#58;0,&quot;rtePageSettings&quot;&#58;&#123;&quot;contentVersion&quot;&#58;4&#125;,&quot;isEmailReady&quot;&#58;false&#125;&#125;"></div></div>

Make Pivot Table from Multiple Excel Sheets

EN Main Home

Constantly the latest news, events and article about Microsoft 365 and Azure.

HubSite 365 - The network about Microsoft 365 and Azure.

EN Main Events

EN Main Copilot

EN Main Dashboard

EN Main Role Pro Office 365

EN Main Role Citizen Developer

EN Main Role Data Analytics

EN Main Role Azure Datacenter

EN Main My365

EN Main Content

EN Main Search

EN Main News

EN Main Know-How

#More-News

Think your Teams Phone provisioning is “free”? Think again

Power Query: Unlock Column From Examples Like a Pro

The Power of Networking at the European Collaboration Summit

Azure OpenAI Redefines the Future of Homes.com Transformation

You’re (Probably) Not Using These 30+ Microsoft Teams Phone Features

Storage Optimizer PRO is here

Vorstellung des Storage Optimizer für Microsoft 365

Microsoft 365 Copilot Wave 2: Fresh Features You Can’t Miss

Power BI: Step-by-Step Guide to Cleaning Data for Beginners

Microsoft Fabric: Exclusive Insights & FabCon 2025 Uupdates

Power Apps Controls: Modern vs Classic Text & Button Showdown

Migration to and from the Cloud

#Top-News

Microsoft 365 Copilot Wave 2: Spring’s Game-Changing Updates

Excel Tips: Create Engaging Male vs Female Charts Fast

How to Sync - Microsoft Forms to Power BI

Excel Percentage - Easy Hacks & Cheat Sheet

The Benefits Of Multi-Tenant Shared Calling

What is Teams Phone Mobile?

Boost SharePoint User Engagement with Engaging Design Tips

Optimize Projects with Microsoft Planner Premium 2024

Microsoft 365 Community Conference 2025

European Collaboration Summit 2025

European AI&Cloud Summit 2025

European BizApps Summit 2025

EPPC 2025

Commsverse 2025

Events Slider Top 01

Breaking News 01

Footer01

Media of the Month 01

SharePoint Hackathon - SharePoint Agents - Capgemini

D365 Customer Service - Case Management Agent

Microsoft OneDrive: Expert Tips for Workflow Efficiency

Outlook Copilot: Craft Custom Themes Step-by-Step

Power BI User Journeys: Unlock Deeper Insights in Part 1

Power Automate: Self-Invites to Meetings Made Easy

Microsoft Copilot Agents: Governance Tips for Success

SharePoint Online: Top Tips for Streamlined Template Management

Microsoft Defender Secures Your AI Apps Like Never Before

HomeAnnouncementSPContent01

#Shorts

Azure AI Foundry: Boost Security with Content Safety Matches Integration

Power Apps: 3 Cardinal Errors Developers Must Dodge

Microsoft 365 Copilot: Your Ultimate Free Tool to Cut Subscription Costs

Power Apps Table Designer: Key Limitations You Must Know

Microsoft 365 Copilot Notebooks: Transforming Productivity Soon

Microsoft Entra ID Welcomes BYO MFA for Stronger, Flexible Security

Microsoft Defender XDR: Streamline Security Without Dashboard Chaos

CloudApp Insights: See Every App and Site on Your Devices

Power Platform: How to Effectively Monitor Model Activity

Microsoft Defender: Fortify Internal Apps with AI Security

Excel Secrets: Slash Hours Off Your Form Creation Time Fast!

Word Tip: Instant ALL CAPS Shortcut Revealed!

Azure Internet Routing: Unlocking Lightning-Fast Connectivity

Paper MFA: From McDonalds to Art Career Surge

Planner in Teams: Simplify Task & Project Management Effortlessly

[URL] German Content Relationship

[URL] EU Content Relationship

WebSite Community - Web EN

/crm-pages/make-pivot-table-from-multiple-excel-sheets.htm

Everyone

[URL] Luxemburg Content Relationship

[URL] Swiss Content Relationship

IT Manager

Administrator

Developer

Project Manager

Community

Teams App

365HubSite App

Pro Office 365

Citizen Developer

Data Analytics

Azure  DataCenter

Microsoft

Packt

Nubelus UG (haftungsbeschränkt)

NetForce 365

ICT Solutions AG

Rencore

WebSite Community - Web.

WebSite Community - RootSite

Schweiz Community (DE-CH)

Schweiz Community (EN-CH)

WebSite Community - Web DE

Make Pivot Table from Multiple Excel Sheets

In this step-by-step tutorial, you will learn how to create a pivot table from multiple Excel worksheets and workbooks. A pivot table is a powerful tool that le