Conteúdo do Curso

Excel for Beginners

1. Introduction to Excel

Introduction Getting Acquainted with Excel Excel Interface Entering Data Challenge

2. Entering and Formatting Data

Formatting Cells Formatting Text Formatting Numbers Challenge

3. Basic Formulas and Functions

Introduction to Formulas and Functions Using Cell References Understanding Ranges Common Functions Application of INSERT FUNCTION Challenge

4. Advanced Formulas and Functions

Displaying and Highlighting Formulas IF Logical Test and Relational Operators Nested IF Statements Compound Logical Tests with AND, OR Using Auditing Tools Conditional Formatting Challenge

5. Data Management and Analysis

Sorting Data Filtering Data Using AutoFilter Clearing and Reapplying Filters Rules and Search Creating and Managing Tables Table Styles and Quick Formatting Options Using Table Tools Challenge

6. Visualizing Data with Charts and Graphs

Types of Charts Creating a Basic Chart Customizing Chart Elements Changing Chart Styles and Colors Adding and Removing Chart Elements Editing Data in Charts Adding Trendlines to Charts Challenge

7. Working with Worksheets and Workbooks

Add, Delete, Rename, and Rearrange Worksheets Grouping and Ungrouping Worksheets Using the Format Painter Inserting and Deleting Columns, Rows, and Cells Hiding and Unhiding Columns and Rows Saving Workbooks Opening and Closing Workbooks Protecting Workbooks with Passwords Using Templates Challenge Summary

Formatting Cells

Formatting cells in Microsoft Excel is fantastic for making your spreadsheets not only easier to read but also more professional.

In this chapter you'll learn how to adjust the rows and columns, format your cell backgrounds and borders, merge and center your cells as well as align and wrap your cell content to make your data more clear and accessible.

Open the Codefinity Excel workbook and navigate to the Section 2 worksheet to follow along with the video. Feel free to proceed with the previous one or download a new one if necessary:

Now, let's get to work on the key aspects of cell formatting in Excel.

Key Points

Row heights and Column widths can be adjusted by double clicking or dragging the boundaries. Alternatively, right-click the row or column, select Row Height or Column Width, and then enter the measurement you want;
The Borders button, in the Font group on the Home tab, allows you to add borders to a selected range of cells;
Add color to cells by using the Fill Color button, in the Home tab;
Use the Merge & Center button in the Home tab to combine selected cells and center the content;
The Wrap Text button in the Home tab wraps text within a cell to ensure all content is visible without widening the column;
Adjust the vertical and horizontal alignment of cell content using the alignment options in the Home tab.

Tudo estava claro?

Seção 2. Capítulo 1