Excel - Project Code Name: GeoFlow: Episode 1686

3,951 views · Published 11 April 2013 · 7:12 · Indexed 8 November 2026

Channel: MrExcel.com · 2013 · Education

Watch on YouTube

Microsoft Excel Tutorial: Discover the Power of Project Codename GeoFlow for Excel | Data Visualization and Mapping Made Easy!

Welcome back to the MrExcel podcast! In today's episode, we will be discussing the highly anticipated release of Project Codename GeoFlow for Excel. This powerful tool allows users to map and visualize data in a whole new way. I have been using GeoFlow for a few days now and I am excited to share some of its amazing features with you.

First, let's talk about choosing geographic fields. It is important to note that when mapping addresses, you should always choose "street" instead of "address". This will ensure that your data is mapped correctly. GeoFlow also offers a variety of chart types, including column, bubble, and heat map. I will be focusing on the bubble chart for this demonstration.

One of the new features in GeoFlow is the ability to customize the date decoration. You can choose to show the date in different formats, such as month and year. This makes it easier to analyze data over a specific time period. Additionally, you can now control the thickness of each column in your chart, allowing for more precise visualization of your data.

Another useful feature is the ability to rotate and tip the data. By holding down the Alt key and dragging to the left or right, you can rotate the data to get a different view. This is especially helpful when trying to analyze data from different angles. You can also zoom in and out using the control wheel on your mouse.

Now, let's take a closer look at the data. Our target area for this demonstration is Merritt Island, Florida. By using GeoFlow, we can see the growth and development of this area over the past 50 years. We can also see how the real estate market has fluctuated over time, with a significant increase in home prices during the 2000s.

One of the most interesting findings from this data is the correlation between the development of Merritt Island and the Apollo program. As the program began in the 1960s, we can see a significant increase in the number of homes being built in the area. This is just one example of the valuable insights that can be gained from using GeoFlow.

To use GeoFlow, you will need Excel 2013 Pro Plus. If you have this version, you can download GeoFlow from the URL on the screen. I highly recommend giving it a try and exploring the various features and capabilities it has to offer. Thank you for tuning in to this episode of the MrExcel podcast. We hope you found it informative and we look forward to bringing you more exciting Excel tips and tricks in the future.

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/


Table of Contents:
(00:00) Introduction to Project Codename GeoFlow
(00:20) Gathering real estate data using tricks from previous episodes
(00:35) Improvements and new features in GeoFlow
(01:00) Tips for choosing geographic fields
(01:15) Overview of chart types and categories
(01:36) New date decoration feature
(02:13) Rotating and tipping data
(03:01) Controlling layer thickness and timeline speed
(03:44) Discoveries made using the data
(04:19) Pausing and zooming in on specific time periods
(04:59) Using the satellite image theme
(05:26) Observing the rise in home prices over time
(06:10) 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:
Chart types
Data visualization
Excel 2013 Pro Plus
Excel form
Florida real estate
Mapping data
Merritt Island
MrExcel podcast
Project Codename GeoFlow
Real estate data
Sales data



And for more information on Excel 2013, check out "Microsoft 2013 InDepth" -- by Bill Jelen. Excel 2013 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone working with Excel 2013. Excel expert and MVP Bill Jelen provides specific, tested, proven solutions to the problems Excel users run into every day: the types of challenges other books ignore or oversimplify. Jelen thoroughly covers all facets of working with Excel 2013. http://www.amazon.com/Excel-2013-Dept

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

More from this channel