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 Training for the University of Georgia's Online and Professional MBA Students

Excel Training for the University of Georgia's Online and Professional MBA Students

Saturday, April 5, 2025: I'll train the University of Georgia's online and professional MBA students in Microsoft Excel. Topics include PivotTables, Filtering, and even Financial Statement analysis.

Copilot in Excel - Ask Copilot Questions about Keyboard Shortcuts, Functions, and Steps

Copilot in Excel - Ask Copilot Questions about Keyboard Shortcuts, Functions, and Steps

Copilot in Excel can be asked for intermediate keyboard shortcuts, how-to steps, and function explanations.

Recent Word Articles

Microsoft Copilot for Word: How to Reference a Folder

Microsoft Copilot for Word: How to Reference a Folder

Discover how Microsoft Copilot for Word now lets you reference entire folders and handle documents up to 1.5 million words. Learn step-by-step how to boost productivity with these powerful updates.

Copilot in Word: Quickly Add Numbers with Ease

Copilot in Word: Quickly Add Numbers with Ease

Discover how Copilot in Microsoft Word can quickly and accurately add numbers within your documents, saving you time and reducing errors. Learn to streamline your workflow with this intelligent assistant.

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 Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. Chris runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Copilot, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers. Menard also does 2 to 3 public speaking events yearly, presenting at the Administrative Professional Conference (APC), the EA Ignite 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