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

Excel 3D Reference - easily reference data on another worksheet

Excel 3D Reference - easily reference data on another worksheet

What is the Middle Class and Are You in the Middle Class?

What is the Middle Class and Are You in the Middle Class?

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 Microsoft Certified Trainer (MCT) and is employed full-time as a Trainer for BakerHostetler, one of the nation’s largest law firms. Menard has a YouTube channel with over 900 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 16 million viewers have appreciated. Menard also does public speaking at conferences for CPAs and Administrative Professionals. Connect with Chris on LinkedIn at chrismenardtraining.com/linked or on YouTube at chrismenardtraining.com/youtube

Categories