Look Who it Was Random video

Excel - Excel Gemini: The Game-Changing Tool for Data Analysis & Business Intelligence - Episode 975

3,555 views · Published 20 March 2009 · 4:11 · Indexed 8 November 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Excel Gemini: The Game-Changing Tool for Data Analysis & Business Intelligence. (Early code name for Power Pivot)

Welcome back to the MrExcel netcast! I'm Bill Jelen and today we're diving into the world of Excel Gemini. This powerful tool is a game changer for data analysts and business intelligence professionals. But before we get into that, let's talk about the recent Excel project managers' meeting I attended at Microsoft. While I can't reveal any specific details due to a non-disclosure agreement, I can tell you that there are some exciting things in store for Excel 2010 and beyond.

Now, let's get into the problem at hand. You have a massive amount of data and you need to analyze it. That's where Excel Gemini comes in. With this tool, you can easily create pivot tables and filter your data in a more efficient and user-friendly way. No more struggling with the limited options in Excel 2007. And that's not all, Gemini also allows you to combine data from different sheets and sources, making it a must-have for anyone dealing with large datasets.

But don't just take my word for it, check out this public video featuring Donald Farmer, a Microsoft employee, demonstrating the power of Excel Gemini. I've included a link in the description below. In the video, Donald shows how Gemini can handle a 20 million row dataset with ease, something that would have been nearly impossible in previous versions of Excel. And that's not all, he also introduces a new feature called "slicers" which make filtering and sorting your data even easier.

But wait, there's more! At the 1 hour and 27 minute mark, Donald also showcases another exciting feature in Excel Gemini. This time, he combines data from a web page with a large dataset and creates a pivot table in just a few minutes. It's truly amazing to see how seamlessly Gemini handles this task. As someone who has worked with large datasets in the past, I can confidently say that this add-in changes everything.

I was so impressed with Gemini that I begged to be on the first beta testing team. And let me tell you, it did not disappoint. I can't reveal too much, but let's just say that after seeing the demo, I immediately knew I had to have Excel 2010 and the Gemini add-in. So, if you're someone who deals with a lot of data or needs to combine data from different sources, I highly recommend giving Gemini a try.

I wish I could tell you more about what's coming in Excel 2010, but for now, I'll leave you with these two exciting features that are already public knowledge. I hope you found this video helpful and informative. Don't forget to like, comment, and subscribe for more Excel tips and tricks. Thanks for watching and I'll see you in the next netcast from MrExcel.

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Awesome. There is a video on the 'net with Microsoft's Donald Farmer showing off a new add-in called Gemini. This is an amazing product. In Episode 975, I point out where you can get a sneak peak at Excel 2010 pivot tables in the Donald Farmer video.


This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Table of Contents:
(00:00) Introduction to MrExcel netcast
(00:15) Welcome back and introduction to problem
(01:41) Solution to problem using Excel 2010
(02:08) Introduction to new add-in called Gemini
(03:25) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Business intelligence in Excel
Data set
Excel project managers
Gemini add-in
Multiple items selection
NDA (Non-Disclosure Agreement)
Pivot table
Report filter area
Slicer
TinyURL.com/cssvcj


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152275/

More from this channel