Excel Essential Skills - Rows & Columns and the EVIL Merge and Center

Posted on:  05/26/2023
Excel Essential Skills - Rows & Columns and the EVIL Merge and Center

All users need certain essential Excel skills. Some of the most popular essential skills include autofit, autosum, inserting and deleting rows and columns. Another needed skill is absolute reference.

AutoFill in Excel

AutoFill in Excel

Topics covered in this post

  • Autofit
  • Absolute reference
  • Autosum
  • Manual cell width
  • Merge and Center
  • Inserting and Deleting Rows and Cols
  • Inserting and Deleting Ranges

YouTube Video

AutoSum in Excel

If you need to sum a range of numbers, use AutoSum to quickly add the numbers.

Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you’re done.

AutoSum in Excel

AutoSum in Excel

Recent Excel Articles

Creating a Column Chart using S&P 500 data with Positive and Negative Colors in Excel

Creating a Column Chart using S&P 500 data with Positive and Negative Colors in Excel

Optimizing Excel Formulas with Copilot: A Comprehensive Guide

Optimizing Excel Formulas with Copilot: A Comprehensive Guide

Recent Word Articles

Microsoft Word to Adobe Acrobat with Bookmarks

Microsoft Word to Adobe Acrobat with Bookmarks

Dictate Feature Updates in Word, Outlook, PowerPoint, and OneNote

Dictate Feature Updates in Word, Outlook, PowerPoint, and OneNote

Lifetime access to Teams Course Beginner to Pro with coupon

Online Microsoft Teams Training with Chris Menard

50% off coupon

Just some of the topics covered

  1. Navigation Teams
  2. Using private Chat
  3. Using group Chat
  4. Teams Meetings
    1. Scheduling Meetings
    2. Meeting controls
    3. Roles in a meeting
    4. Sharing resources
    5. PowerPoint in a meeting
    6. Scheduling Team meetings from Outlook
  5. Working with Teams and Channels
    1. Conversations
    2. Files
    3. Wiki and OneNote
  6. Using Outlook and Teams
  7. Using apps in Teams
Chris Menard

Chris Menard is a certified Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. He runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers. Menard also does 2 to 3 public speaking events every year, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the Support Staff Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at https://chrismenardtraining.com/linkedin or watch his videos on YouTube at https://chrismenardtraining.com/youtube.

Categories