Excel Power Pivot Introduction - How to Use Power Pivot
Computergaga
@computergagaAbout
Welcome to my channel where you can expect videos on Excel tips and formulas to help you in your day to day work. Videos on using the latest Excel features, formulas, advanced Excel tips, VBA and Power BI. If you have a question, please ask. I try to reply to as many comments as I can. My apologies if I do not respond. It is very difficult to respond to everybody. Who am I? My name is Alan, I'm a Microsoft MVP and I have been training people how to get the most from Excel for over 20 years. I am the author of two Excel books "Advanced Excel Success" and "Advanced Excel Formulas". I love working with data and helping people improve their Excel skills and save time. I live in a town called Ipswich in the UK and I'm a father to two wonderful kids.
Latest Posts
Video Description
This video is an introduction to Power Pivot in Excel. It will explain what Power Pivot is, why and when to use it and walk through a complete example. Download the files used in the video - http://bit.ly/35e1FaQ Below are the timings for the video; 00:00 - Introduction 00:23 - Why use Power Pivot? 04:32 - Installing Power Pivot 06:00 - Importing Data into Power Pivot 11:39 - Modeling the Data 20:40 - Why use DAX? 23:06 - Writing DAX Measures 35:07 - Creating PivotTables and Slicers from our Model This only serves as an introduction to Power Pivot to get started. There is plenty more to explore with Power Query, modelling and writing DAX. There are further videos in the related playlists on this channel to learn more. Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/2JvnnRv Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2t3netw Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2viGg3J Connect with us! LinkedIn ► https://www.linkedin.com/company/18737946/ Instagram ► https://www.instagram.com/computergaga1/ Twitter ► http://www.twitter.com/computergaga1
You May Also Like
Upgrade Your Gaming Setup Now
AI-recommended products based on this video
Beelink SER3 Mini Desktop PC with AMD Ryzen 3 3200U 2C/4T, 16GB DDR4 500GB PCIE3.0 X4 SSD, Dual Display Output, WiFi6/BT5.2 W-11 Pro Mini Gaming Computer
Beelink SER3 Mini PC, AMD Ryzen 3 3200U(14nm, 2C/4T) up to 3.5GHz, Mini Gaming Computer 16GB DDR4 RAM 500GB PCIE3.0 X4 SSD, Micro PC 4K@60Hz Dual Display, Mini Computer WiFi6/BT5.2/HTPC/W-11 Pro
Beelink SER3 Mini PC, AMD Ryzen 3 3200U(up to 3.5GHz) 2C/4T, Mini Computer 16GB DDR4 RAM 500GB SSD, Mini Desktop Computer 4K@60Hz Dual HDMI Display WiFi6/BT5.2/WOL/HTPC/W-11 Pro
MSI PRO MP251W E2 24.5-inch IPS 1920 x 1080 (FHD) Gaming Office Monitor, 120Hz, Adaptive-Synch, HDR Ready, HDMI, VGA Port, Display Port,VESA Mountable, Tilt, Speaker, 4-Side Slim Bezel,1ms, White
MSI PRO MP271A E2 27-inch IPS 1920 x 1080 (FHD) Gaming Office Monitor, 120Hz, Free-Sync, HDMI, DisplayPort, VGA Port, VESA Mountable, Tilt, Speaker, 4-Side Slim Bezel 1ms, Black
MSI PRO B650-S WiFi ProSeries Motherboard (Supports AMD Ryzen 7000 Series Processors, AM5, DDR5, PCIe 4.0, M.2 Slots, SATA 6Gb/s, USB 3.2 Gen 2, HDMI/DP, Wi-Fi 6E, 2.5Gbps LAN, ATX)
MSI Pro MP341CQ, 34" Monitor, 3440 x 1440(UWQHD) VA, 100Hz, TUV Certified Eyesight Protection, 4ms, Displayport, HDMI, Tilt
Corsair Vengeance LPX 32GB (2 X 16GB) DDR4 3200 (PC4-25600) C16 1.35V Desktop Memory - Black
Beelink Mini PC, Intel 12th Gen Alder Lake- N100(up to 3.4GHz), 16GB DDR4 RAM 500GB M.2 SSD, Mini S12 Desktop Computers, USB3.2/WiFi 5/BT4.2 for Home/Office
Beelink Mini S13 Mini PC,Intel 13th Twin Lake N150(Upgraded N100, 4C/4T),Mini Computer 16GB RAM 500GB M.2 SSD, W-11 Pro Gigabit Ethernet, 4K UHD, WiFi6, BT5.2 Home/Business Mini Desktop Computer
OUMAX N150 Dual LAN Mini PC, Intel 13th Gen Twin Lake N150 (Up to 3.6GHz), 16GB DDR4 500GB M.2 SSD, Mini Computer Support 4K Dual HDMI, WiFi5/BT5.0/USB3.2, Built-in 45W Power Supply Office Desktop PC
EVGA GeForce GTX 1660 Ti XC Ultra Gaming, 6GB GDDR6, HDB Fan Graphics Card 06G-P4-1267-KR
Corsair RM1000e Fully Modular Low-Noise ATX Power Supply - Dual EPS12V Connectors - 105°C-Rated Capacitors - 80 Plus Gold Efficiency - Modern Standby Support - Black
Corsair RM1200x Shift Fully Modular ATX Power Supply - Modular Side Interface - ATX 3.1 & PCIe 5.1 Compliant - Zero RPM Fan Mode - 105°C-Rated Capacitors - 80 Plus Gold Efficiency - Black, 1200W
Corsair RM1200e (2023) Fully Modular Low-Noise ATX Power Supply with 12V-2x6 Cable – ATX 3.1 & PCIe 5.1 Compliant, Cybenetics Platinum Efficiency, 105°C-Rated Capacitors, Modern Standby Mode – Black
Corsair HX1200i (2025) Fully Modular Ultra-Low Noise ATX Power Supply with 12V-2x6 Cable – ATX 3.1 & PCIe 5.1 Compliant, Cybenetics Platinum Efficiency, Fluid Dynamic Bearing Fan – Black
Corsair CP-9020140-UK HX1200 1200 W 80+ Platinum Fully Modular Power Supply Unit - Black
Logitech G203 Wired Gaming Mouse, 8,000 DPI, Rainbow Optical Effect LIGHTSYNC RGB, 6 Programmable Buttons, On-Board Memory, Screen Mapping, PC/Mac Computer and Laptop Compatible - Black
Redragon M612 Predator RGB Gaming Mouse, 8000 DPI Wired Optical Mouse with 11 Programmable Buttons & 5 Backlit Modes, Software Supports DIY Keybinds Rapid Fire Button
acer Enduro T1 ET108-11A-80PZ Rugged Tablet, 8.0" WXGA IPS Touch, MediaTek MT8385 Octa-Core Processor, 4GB LPDDR4, 64GB eMMC, WiFi-5, Front 2MP Webcam, Rear 5MP Webcam, Handstrap, Android 9 Pie
Acer PM161Q Bbmiuux 15.6" Full HD (1920 x 1080) Widescreen Portable IPS Display | AMD FreeSync Technology | 4ms (G to G) | 2 Speakers | USB Type-C Cable and Mini HDMI Cable
NEW POW 65W 18V-20V Universal Ultrathin AC Adapter Laptop Charger Power Supply for HP Lenovo Dell Asus Acer IBM Toshiba Samsung Sony Fujitsu Gateway Compatible Models Cord (15 Tips,Black)
acer Chromebook 315 Laptop | Intel Pentium Silver N6000 | 15.6" Full HD IPS Touch | Intel UHD Graphics | 8GB LPDDR4X | 64GB eMMC | Wi-Fi 6 | DTS Audio | Protective Sleeve | Chrome OS | CB315-4HT-P8PQ
