Insights in Excel - Data Analysis game changer by Chris Menard
23.8 هزار بار بازدید -
6 سال پیش
-
What if I told you
What if I told you in Excel 2016 for Office 365, you can click on one cell and with two more clicks, have data analysis you would never dream of having? It’s here! Microsoft has updated Excel 2016 for Office 365 with Insights for Excel.
Steps to see Insights in Excel:
1. Simply click a cell in a data range
2. Click the Insights button on the Insert tab. Insight Services will analyze your data and return interesting visuals about it in a task pane on the right-hand side of your screen.
Menard tip: Make your data range a table first using CTRL + T.
Chris Menard is a Microsoft Office Master Instructor in Excel, Word, PowerPoint, and Outlook. Chris provides instructor-led training in Excel and other office applications in Atlanta, Georgia. Menard's client list includes Georgia-Pacific, Mizuno USA, Coca-Cola Company in Atlanta, the Georgia Society of CPAs (GSCPA), Gwinnett Medical Center, and many other clients.
Chris's website is http://chrismenardtraining.com
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
Steps to see Insights in Excel:
1. Simply click a cell in a data range
2. Click the Insights button on the Insert tab. Insight Services will analyze your data and return interesting visuals about it in a task pane on the right-hand side of your screen.
Menard tip: Make your data range a table first using CTRL + T.
Chris Menard is a Microsoft Office Master Instructor in Excel, Word, PowerPoint, and Outlook. Chris provides instructor-led training in Excel and other office applications in Atlanta, Georgia. Menard's client list includes Georgia-Pacific, Mizuno USA, Coca-Cola Company in Atlanta, the Georgia Society of CPAs (GSCPA), Gwinnett Medical Center, and many other clients.
Chris's website is http://chrismenardtraining.com
And make sure you subscribe to my channel!
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
6 سال پیش
در تاریخ 1396/12/14 منتشر شده
است.
23,801
بـار بازدید شده