In this video I show a powerful and very simple and easy to use function in Microsoft Excel which is the ability to create automated and sortable Tables. I also show a glimpse of Pivot Tables and show how you can summarize a Table with a Pivot Table and Pivot Chart. I use Excel 2007 in this tutorial but it should be very similar to Excel 2010 and most of the features are available in Excel 2003.
Download the notes in my video: https://1drv.ms/x/s!As32ynv0LoaIib5TGFAjnB_637joMQ?e=Xl00Ab
Related Videos:
Microsoft Excel: Graphing too many data points - Simple Solution: http://youtu.be/jKwFDR5X1ZY
Adding Secondary Vertical and Horizontal Axes in Microsoft Excel: http://youtu.be/fhPyaWzIQVk
Converting Text to a Table using "Fixed Width Text to Columns" in Microsoft Excel: http://youtu.be/wOpcnsMHb6Y
Remove Trendline from the Legend in Microsoft Excel: http://youtu.be/njp-zx_5Dq0
Trendline Slope and Intercept Formulas in Microsoft Excel: http://youtu.be/DTDY9RL35b8
ISERROR and ISERR Functions in Microsoft Excel: http://youtu.be/MrZLtpsLktM
Transparent Images in Microsoft Excel + Useful Tip: http://youtu.be/uKjtsQZ5Ow0
Convert Time to number, seconds, hours and minutes in Microsoft Excel 2007: http://youtu.be/fwMKbXI98tI
Converting Numbers to Fractions in Microsoft Excel 2007: http://youtu.be/YgJBK0QjIec
Drop Down Lists with Microsoft Excel 2007: http://youtu.be/e7Sbcn-y9j4
Numbered Headings and Automated Table of Contents - Office Word 2007: http://youtu.be/e00xCQ0MClg
Microsoft Excel Tips: -22 = +4 and NOT -4!!!: http://youtu.be/9QC3ZboI3wo
Skip Blanks when Graphing in Microsoft Excel: http://youtu.be/HcCJVUd7a5Q
Automate Formulas using INDIRECT() Function in Excel: http://youtu.be/9WiBtrNq9yU
Microsoft Excel: Data Bars within Cells: http://youtu.be/EjvAhSLmJgw .
SUBSCRIBE via EMAIL: https://mes.fm/subscribe
DONATE! ʕ •ᴥ•ʔ https://mes.fm/donate
Like, Subscribe, Favorite, and Comment Below!
Follow us on:
MES Truth: https://mes.fm/truth
Official Website: https://MES.fm
Hive: https://peakd.com/@mes
MORE Links: https://linktr.ee/matheasy
Email me: contact@mes.fm
Free Calculators: https://mes.fm/calculators
BMI Calculator: https://bmicalculator.mes.fm
Grade Calculator: https://gradecalculator.mes.fm
Mortgage Calculator: https://mortgagecalculator.mes.fm
Percentage Calculator: https://percentagecalculator.mes.fm
Free Online Tools: https://mes.fm/tools
iPhone and Android Apps: https://mes.fm/mobile-apps
▶️ 3Speak