Excel - Chandoo Explains Structured Table Reference - Episode 1708
Hellow guys, Welcome to my website, and you are watching Excel - Chandoo Explains Structured Table Reference - Episode 1708. and this vIdeo is uploaded by MrExcel.com at 2013-05-13T08:56:18-07:00. We are pramote this video only for entertainment and educational perpose only. So, I hop you like our website.
Info About This Video
Name |
Excel - Chandoo Explains Structured Table Reference - Episode 1708 |
Video Uploader |
Video From MrExcel.com |
Upload Date |
This Video Uploaded At 13-05-2013 15:56:18 |
Video Discription |
Microsoft Excel Tutorial: Chandoo Explains Structured Table Reference.
Welcome to another episode of the MrExcel podcast! In this episode, we have a special guest, Chandoo, all the way from halfway around the world, to share a time-saving tip with our community. Chandoo will be explaining the benefits of using structured table references in Excel.
Have you ever struggled with constantly updating your formulas, charts, and pivot tables as your data grows? Well, Chandoo has the solution for you - creating tables in Excel. By simply selecting your data and pressing Ctrl+T, Excel will format it as a table and give it a name. Not only does this make your data look visually appealing, but it also allows for easy referencing and automatic updates as new data is added.
But that's not all, tables also have the advantage of being connected to pivot tables. So when your data changes, all you have to do is refresh your pivot table, no need to modify any source data connections. And if you need to create a chart on top of your table, any additions to the table will automatically be reflected in the chart.
But wait, there's more! Tables also have the ability to use structured references instead of traditional cell references. This means you can easily refer to data by its structure, rather than specific cell references. And with the added bonus of automatic formatting and filtering, tables truly are a game-changer in Excel.
If you want to learn more about the benefits of using tables in Excel, be sure to check out mrexcel.com or chandoo.org for more information. And don't forget to tune in to our daily netcasts for more Excel tips and tricks. Thanks for watching and we'll see you next time on the MrExcel podcast!"
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) Chandoo Talks Table References
(00:25) Time-Saving Tip: Creating Tables
(00:41) Setting Up a Table
(01:07) Benefits of Using Tables
(02:00) Naming and Formatting Tables
(03:02) Using Structural References in Formulas
(04:05) Connecting Tables to Charts and Pivot Tables
(05:00) Additional Resources
(05:12) 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:
Advantages of using tables in Excel
Benefits of structured table formatting
Chandoo structured references
Creating tables in Excel
Excel 2003 vs current versions of Excel
Formatting tables in Excel
MrExcel netcast daily updates
MrExcel podcast episode 1708
Using charts with tables in Excel
Using formulas with tables
Using Pivot tables with tables
Using tables for data analysis
Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153529/
On Friday May 10, 2013, Chandoo (http://chandoo.org/) and Rob Collie (http://www.powerpivotpro.com/) - PowerPivotPro - stopped by MrExcel's place for an evening of Microsoft Excel. So, what is on the agenda For Today's Podcast? Chandoo doing his First Guest Appearance on the Learn Excel Podcast and his topic: "The Benefits of Structured Table References". Follow along with Episode #1708 as Chandoo gives us an indepth analysis of Table References and why using Structured Table References are so beneficial.
"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.mrexcel.com/store/index.php?l=product_detail&p=254)
And
"Pivot Table Data Crunching Excel 2013", by Bill Jelen. Use Excel 2013 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours... understand exactly what's going on in your business... take control, and stay in control! Even if you've never created a pivot table before, this book will help you leverage all their amazing flexibility and analytical power. (http://www.mrexcel.com/store/index.php?l=product_detail&p=255)
"The Learn Excel from MrExcel Podcast Series"
Visit us: MrExcel.com for all of your Microsoft Excel Needs! |
Category |
Education |
Tags |
Data Set | Table Reference | Formula | Chandoo | Rob Collie | PowerPivotPro | accounting | Advanced Excel User | Bill Jelen | business | Data | Excel | Excel 2010 | Excel 2013 | Intermediate Excel User | Learn Excel | Learn Excel 2013 | Learn Excel from MrExcel | Microsoft Excel | MrExcel | MrExcel.com | Pivot Table | Power Pivot | Spreadsheet | spreadsheets | technology | tutorial | Workbook | Worksheet | Microsoft Excel (Software) |
More Videos