Most important Excel feature - Tables

Most important Excel feature - Tables - 18 benefits |

Рет қаралды 4,983

Күн бұрын

In this video, I'm going to show you 18 powerful ways to use Excel tables to save time and improve data accuracy. By using automatic formulas and auto update dependencies, you'll be able to work with your data in a more efficient and accurate way!
#excel #msexcel #exceltips
Download sample file and follow along:
efficiency365....
Contents
00:00 - Intro
00:11 - Formula Auto Update
01:11 - Calculated column auto copy
02:14 - Name the Table
02:42 - Table based formula
03:50 - Auto Copy Formatting
04:21 - Auto Copy Validations
05:58 - Dynamic CountIf
06:51 - Better Vlookup formulas
07:34 - Avoid duplicates in lookup tables
07:58 - Creating tables precisely
09:14 - Select Table Column precisely
10:02 - Easy selection with Ctrl A
10:27 - Easy Navigation
10:50 - No more Freeze Pane
11:12 - Structured formulas
11:50 - Slicers
12:19 - Use Tables for Power Query Import
12:51 - LisObject in VBA
13:32 - Best Practice
ListObject reference VBA:
learn.microsof...
Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster
s.efficiency36...
Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin's Office Masterclass
----------------------------------------------
hi.switchy.io/mms
Online Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - s.efficiency36...
Excel to Power BI - swiy.io/uxlpbi
Learn more from 1000+ blog articles by Dr Nitin Paranjape
Efficiency 365 blog: efficiency365....
LinkedIn : / nitinparanjape
Twitter : / drnitinp
Production
--------------------
Music and Effects: elements.envat...
Created using Adobe Premiere: www.adobe.com/...
AI based captions: videoindexer.ai (Microsoft service)

Пікірлер: 26

@santoshkamala2750 10 ай бұрын

I follow lot of youtubers on Excel. This is my first video from your channel. Without a doubt, you are awesome. It's pretty cleaster and clear. Well narrated. Crispy. Worth watching.

@efficiency365 10 ай бұрын

Thanks @santoshkamala2750 Check out my other best practices videos as well. Efficient Tasks Management - kzfaq.info/get/bejne/rLJ2o7qHy7vKgWw.html Task Apps Comparison: kzfaq.info/get/bejne/jM-Hfayrsra1ips.html Teams Meeting - Agenda, Action Points, Notes - kzfaq.info/get/bejne/oZaka8Kes9GxdKs.html Microsoft Teams - 15 Best Practices - kzfaq.info/get/bejne/jZ6FmduQ39SvqH0.html OneDrive Best Practices Part 1 - kzfaq.info/get/bejne/ep2Kpcmhzb2YpqM.html Part 2 - kzfaq.info/get/bejne/pKyoabyC3cmRkmg.html Smart and Effective Email - 5 powerful ways - kzfaq.info/get/bejne/bLR1ebZ-1q7LgXk.html Outlook Calendar Best Practices : Part 1 - kzfaq.info/get/bejne/feCjhNGWyNClgaM.html and Part 2 - kzfaq.info/get/bejne/pseUfqtp3tmZc6c.html OneNote - Best Practices - kzfaq.info/get/bejne/o5NkdLxiyLPNaKc.html Microsoft 365 Best Practices - kzfaq.info/get/bejne/obxzkryUsZuzkok.html Cheers. Doc.

@jkumar8590 6 ай бұрын

Viewers should also watch his video - 11 commandments on good data. This is extraordinary. His master class on pivot table @ ₹299 is master piece. No parallel course to this course on earth. Repeat watching of his videos will result in new and newer things and deeper insights. All his videos are magical.

@harjitthakur2519 10 ай бұрын

It's too easy to do it.. I appreciate it.

@efficiency365 10 ай бұрын

Thanks @harjitthakur2519 Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - kzfaq.info/get/bejne/qNp0n7KDsdPOnHk.html Excel Green Marks - Error Checking - Best Practices - kzfaq.info/get/bejne/jst8p8-ryZ_Qgo0.html Excel Best Practices - Part 1 of 3 - Data Management - kzfaq.info/get/bejne/qNiPZMuSm82anJc.html Excel Best Practices - Part 2 of 3 - Formulas - kzfaq.info/get/bejne/oeCPraSnsq-ycZ8.html Excel Best Practices - Part 3 of 3 - Analytics - kzfaq.info/get/bejne/gLSCaNypxLbLZHU.html 10 Excel Settings You Must CHANGE! - kzfaq.info/get/bejne/rL6ipbuVsN-udp8.html Automatic data clean up with Excel Flash Fill - kzfaq.info/get/bejne/hJmgktuQ0b64j5c.html Instant Excel Audit, Comparison and Analysis - Inquire - kzfaq.info/get/bejne/maqUqbiL3bW5mac.html Six powerful Excel Navigation Shortcuts - kzfaq.info/get/bejne/mLhdrLCTrLbVZWQ.html Handle millions of rows in Excel - Slow to fast - kzfaq.info/get/bejne/b5mYatWD2LKqZ40.html Convert crosstab to tabular - Unpivot - Excel Power Query - kzfaq.info/get/bejne/o7qkgteLrZPSfoE.html Cheers. Doc

@jeevanmarg 9 ай бұрын

One of the best and most informative video about Excel Tables. Subscribed. Can't wait to see more tips and tricks. Thank you.

@efficiency365 9 ай бұрын

Thanks @jeevanmarg Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - kzfaq.info/get/bejne/qNp0n7KDsdPOnHk.html Excel Green Marks - Error Checking - Best Practices - kzfaq.info/get/bejne/jst8p8-ryZ_Qgo0.html Excel Best Practices - Part 1 of 3 - Data Management - kzfaq.info/get/bejne/qNiPZMuSm82anJc.html Excel Best Practices - Part 2 of 3 - Formulas - kzfaq.info/get/bejne/oeCPraSnsq-ycZ8.html Excel Best Practices - Part 3 of 3 - Analytics - kzfaq.info/get/bejne/gLSCaNypxLbLZHU.html 10 Excel Settings You Must CHANGE! - kzfaq.info/get/bejne/rL6ipbuVsN-udp8.html Automatic data clean up with Excel Flash Fill - kzfaq.info/get/bejne/hJmgktuQ0b64j5c.html Instant Excel Audit, Comparison and Analysis - Inquire - kzfaq.info/get/bejne/maqUqbiL3bW5mac.html Six powerful Excel Navigation Shortcuts - kzfaq.info/get/bejne/mLhdrLCTrLbVZWQ.html Handle millions of rows in Excel - Slow to fast - kzfaq.info/get/bejne/b5mYatWD2LKqZ40.html Convert crosstab to tabular - Unpivot - Excel Power Query - kzfaq.info/get/bejne/o7qkgteLrZPSfoE.html Cheers. Doc

@maneeshpanditrao2555 11 ай бұрын

Thanks a lot... I even didn't know table has so many benefits I will use these techniques in my daily work

@efficiency365 10 ай бұрын

Yes. Tables are amazing. These should be the Standard Operating Procedure for the world.

@azwarmzafar 10 ай бұрын

Another fantastic video, many thanks!

@efficiency365 10 ай бұрын

Thanks. More coming soon.

@mamalik1088 11 ай бұрын

Super explained SIR

@efficiency365 11 ай бұрын

Thanks. Wanted to make this for a long time. I did have an old video for this. But it is outdated. I started with 8 benefits. While creating the video, discovered more!

@billblanchette3604 11 ай бұрын

Awesome, I need to do that slicer video very soon. Thanks

@efficiency365 10 ай бұрын

Thanks @billblanchette3604 Check out my other best practices videos as well. Efficient Tasks Management - kzfaq.info/get/bejne/rLJ2o7qHy7vKgWw.html Teams Meeting - Agenda, Action Points, Notes - kzfaq.info/get/bejne/oZaka8Kes9GxdKs.html Microsoft Teams - 15 Best Practices - kzfaq.info/get/bejne/jZ6FmduQ39SvqH0.html OneDrive Best Practices Part 1 - kzfaq.info/get/bejne/ep2Kpcmhzb2YpqM.html Part 2 - kzfaq.info/get/bejne/pKyoabyC3cmRkmg.html Smart and Effective Email - 5 powerful ways - kzfaq.info/get/bejne/bLR1ebZ-1q7LgXk.html Outlook Calendar Best Practices : Part 1 - kzfaq.info/get/bejne/feCjhNGWyNClgaM.html and Part 2 - kzfaq.info/get/bejne/pseUfqtp3tmZc6c.html OneNote - Best Practices - kzfaq.info/get/bejne/o5NkdLxiyLPNaKc.html Microsoft 365 Best Practices - kzfaq.info/get/bejne/obxzkryUsZuzkok.html Cheers. Doc.

@TheFlight87 10 ай бұрын

Very good video as usual, thank you! I noticed you used a vlookup formula in one of your examples, have you tried using the new xlookup? It's much more powerful and solves the problem of column numbers changing and only being able to search values in the first column of the array.

@efficiency365 10 ай бұрын

Of course XLOOKUP is better. Will post a video on XLOOKUP soon. There are other ways to eliminate VLOOKUP - Using Power Query kzfaq.info/get/bejne/pbl7lJppv9zYdaM.html Using Relationships in Data Model: kzfaq.info/get/bejne/f7NdaaSql7u3pGw.html

@dr.haneevinchu182 10 ай бұрын

This was a fantastic and contentful delivery. Sir, I need to collect data physically for a research questionnaire, including qualitative and quantitative data. Please suggest the proper application and features.

@efficiency365 10 ай бұрын

Do you want to convert paper data to Excel? Try Data from Picture. However, it will not work with handwritten data. Let me know more details, then I can provide a more specific answer.

@dr.haneevinchu182 10 ай бұрын

No, I mean to collect qualitative and quantitative data one-to-one from the respondent and enter it in the application for statistical analysis. Sometimes it can be that respondent will find it easier to post the responses.@@efficiency365

@efficiency365 10 ай бұрын

Use MS Forms if it is ONE response per respondent. Use Lists if it is multiple.

@aditidabhadkar8181 10 ай бұрын

Hi, excellent content.. I tried the list validation auto expand, did not work. What did I miss?

@aditidabhadkar8181 10 ай бұрын

It does not work for different sheets. The source of the list validation needs to be in the same sheet as the table.

@efficiency365 10 ай бұрын

Thanks @aditidabhadkar8181 You are right. This will not work across sheets. If you want more structured data entry with comprehensive validations, use Lists. Here is the video - kzfaq.info/get/bejne/acmPqcmEmJ3HnoE.html Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - kzfaq.info/get/bejne/qNp0n7KDsdPOnHk.html Excel Green Marks - Error Checking - Best Practices - kzfaq.info/get/bejne/jst8p8-ryZ_Qgo0.html Excel Best Practices - Part 1 of 3 - Data Management - kzfaq.info/get/bejne/qNiPZMuSm82anJc.html Excel Best Practices - Part 2 of 3 - Formulas - kzfaq.info/get/bejne/oeCPraSnsq-ycZ8.html Excel Best Practices - Part 3 of 3 - Analytics - kzfaq.info/get/bejne/gLSCaNypxLbLZHU.html 10 Excel Settings You Must CHANGE! - kzfaq.info/get/bejne/rL6ipbuVsN-udp8.html Automatic data clean up with Excel Flash Fill - kzfaq.info/get/bejne/hJmgktuQ0b64j5c.html Instant Excel Audit, Comparison and Analysis - Inquire - kzfaq.info/get/bejne/maqUqbiL3bW5mac.html Six powerful Excel Navigation Shortcuts - kzfaq.info/get/bejne/mLhdrLCTrLbVZWQ.html Handle millions of rows in Excel - Slow to fast - kzfaq.info/get/bejne/b5mYatWD2LKqZ40.html Convert crosstab to tabular - Unpivot - Excel Power Query - kzfaq.info/get/bejne/o7qkgteLrZPSfoE.html Cheers. Doc

@anonymouswikileaks2451 9 ай бұрын

Amazing, how comeall mylife using Excell without knowing that info 😢

@efficiency365 9 ай бұрын

😎 @anonymouswikileaks2451 No problem. Retrofit tables in existing files. All good then. Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - kzfaq.info/get/bejne/qNp0n7KDsdPOnHk.html Excel Green Marks - Error Checking - Best Practices - kzfaq.info/get/bejne/jst8p8-ryZ_Qgo0.html Excel Best Practices - Part 1 of 3 - Data Management - kzfaq.info/get/bejne/qNiPZMuSm82anJc.html Excel Best Practices - Part 2 of 3 - Formulas - kzfaq.info/get/bejne/oeCPraSnsq-ycZ8.html Excel Best Practices - Part 3 of 3 - Analytics - kzfaq.info/get/bejne/gLSCaNypxLbLZHU.html 10 Excel Settings You Must CHANGE! - kzfaq.info/get/bejne/rL6ipbuVsN-udp8.html Automatic data clean up with Excel Flash Fill - kzfaq.info/get/bejne/hJmgktuQ0b64j5c.html Instant Excel Audit, Comparison and Analysis - Inquire - kzfaq.info/get/bejne/maqUqbiL3bW5mac.html Six powerful Excel Navigation Shortcuts - kzfaq.info/get/bejne/mLhdrLCTrLbVZWQ.html Handle millions of rows in Excel - Slow to fast - kzfaq.info/get/bejne/b5mYatWD2LKqZ40.html Convert crosstab to tabular - Unpivot - Excel Power Query - kzfaq.info/get/bejne/o7qkgteLrZPSfoE.html Cheers. Doc