Excel - Freeze Panes, Creating an Auto Outline, and AutoSum tip скачать в хорошем качестве

Excel - Freeze Panes, Creating an Auto Outline, and AutoSum tip

Outlining an Excel worksheet is a fabulous way to view your data in groups. For example, you can take January through March and make them Quarter 1. You could take the United States, Mexico, Central America, Greenland, and Canada and group them as North America. With an Outline, you can collapse and expand your data. You will see plus and minus signs when you create an Auto Outline. We will also look at Freezing Panes in Excel in this video. When you freeze panes, your header row is always visible. You can freeze row, columns, and both rows and columns with Freeze Panes Command. Chapters/Bookmarks 0:00 Intro 0:38 Shortcuts for moving around 2:10 Freeze Panes 3:26 AutoSum data with 6:30 Create an Auto Outline #chrismenardtraining #exceltraining #chrismenard #microsoftexcel 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!