How do I automatically resize columns to fit text in Excel?

Use AutoFit by double-clicking the right edge of a column header or selecting AutoFit Column Width.

What is the Excel feature that fills months, days, or number sequences automatically?

Use the Fill Handle or the Fill Series command to extend recognized patterns into adjacent cells.

How can I turn rows into columns in Microsoft Excel?

Use the Transpose option when pasting copied data, or use the TRANSPOSE function for linked results.

Free Course Image Microsoft Excel for Beginners

Free online course Microsoft Excel for Beginners

Duration of the online course: 3 hours and 19 minutes

4.5

(19)

Learn Excel fast and organize data with confidence. This free online course builds real workplace skills, from spreadsheets to smart fills and reports.

In this free course, learn about

Excel Fundamentals and Data Entry
Excel Data Analysis and Import Tools
Excel Intermediate Skills

About the free online course

Excel is one of the most practical skills you can add to your toolkit, whether you are applying for your first office job, managing a small business, or trying to make sense of data at work. This free online course helps you go from opening a blank spreadsheet to building clean, readable worksheets you can actually rely on. You will learn how to think in rows and columns, format information clearly, and work efficiently so simple tasks do not take longer than they should.

As you progress, you will gain confidence with the features that make Excel feel powerful instead of overwhelming. You will practice resizing and adjusting columns so your sheets look professional, and you will use smart filling tools that save time by extending patterns such as dates, sequences, and repeated structures. The course also guides you through reorganizing datasets when they are not laid out the right way, making it easier to compare information and prepare it for analysis.

To support real-world decision making, you will explore ways to filter and interact with data so you can focus on what matters. You will also work with modern options that bring outside information into your workbook, including pulling data from the web so your spreadsheet can start with a reliable source rather than manual copy and paste. By the end, you will be ready to handle everyday Excel tasks with more accuracy, build spreadsheets that others can understand, and take a solid step toward office productivity roles that value strong spreadsheet skills.

Course content

Video class: Microsoft Excel Tutorial - Beginners Level 1 32m
Exercise: When working with columns in Microsoft Excel, what function allows you to automatically resize them to fit the content width?
Video class: Microsoft Excel Tutorial - Beginners Level 2 22m
Exercise: What feature in Microsoft Excel allows you to quickly fill a series of related values like days of the week or months into adjacent cells without manually typing each item?
Video class: Microsoft Excel Tutorial - Beginners Level 3 24m
Exercise: Which feature in Excel allows you to change the axis of data, turning rows into columns and vice versa?

Video class: Microsoft Excel Tutorial - Beginners Level 4 25m
Exercise: What is a slicer used for in Microsoft Excel?
Video class: Microsoft Excel Tutorial - Beginners Level 5 20m
Exercise: What feature in Microsoft Excel allows you to pull data directly from a web page into your worksheet?

Video class: Microsoft Excel Intermediate Class: Elevate Your Skills 1h14m
Exercise: What feature in Microsoft Excel can help you automatically fill a range of cells with a series of numbers or text, such as months or days of the week, by recognizing patterns?

Learn aboutExcel

Explore free online Excel courses designed to help you master spreadsheets, formulas, functions, data analysis, charts, PivotTables, and more. Learn at your own pace with beginner to advanced lessons, build practical Microsoft Excel skills for work or study, and earn a certificate upon completion—all at no cost. Start learning today.