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

Optimizing Excel Formulas with Copilot: A Comprehensive Guide

Optimizing Excel Formulas with Copilot: A Comprehensive Guide
Five Methods for Creating Running Totals in Excel

Five Methods for Creating Running Totals in Excel

Excel is a powerful tool that offers various features to manipulate and analyze data efficiently. One of the useful functionalities it provides is the ability to create running totals, which can be essential for tracking cumulative sums over a period.

Recent Word Articles

Microsoft Word to Adobe Acrobat with Bookmarks

Microsoft Word to Adobe Acrobat with Bookmarks

We don't usually want to email, or share are Word files. Frequently, we make our Word documents PDF files. If you lay out your Word document correctly, it is easy to make bookmarks in the PDF.

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

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

Dictate in Word, Outlook, OneNote, and PowerPoint allows users to use speech-to-text to author content in files.

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