Course Content

Excel Essentials

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:

Note
You can adjust the zoom level of the Excel workbook by holding down the Ctrl key and scrolling the mouse wheel up or down.

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.

Task

Click on Row 3 & drag the boundary to show the title header in full.
Click on Column B. Double click the boundary on the right to automatically adjust the width.
Select columns C through to I. Right click for menu. Enter 11 in Column Width. Press Enter.
Select cells from C12 to I18. Click the Borders button to add borders to all sides of the cells.
Select cells from C20 to I20. Click the Borders button to add borders to all sides of the cells.
Select cells from B11 to I11. Click the Fill Color button. Choose a color. Repeat with cells B19 to I19 and B12 to B18.
Select cells from B3 to E3. Go to the Alignment group and click the Merge & Center button.
Select cells from C11 to I11. Go to the Alignment group and click the Wrap Text button.
Select cells from C11 to I21. In the Alignment group click Middle Align and then click on Centre align.

Task

Click on Row 3 & drag the boundary to show the title header in full.
Click on Column B. Double click the boundary on the right to automatically adjust the width.
Select columns C through to I. Right click for menu. Enter 11 in Column Width. Press Enter.
Select cells from C12 to I18. Click the Borders button to add borders to all sides of the cells.
Select cells from C20 to I20. Click the Borders button to add borders to all sides of the cells.
Select cells from B11 to I11. Click the Fill Color button. Choose a color. Repeat with cells B19 to I19 and B12 to B18.
Select cells from B3 to E3. Go to the Alignment group and click the Merge & Center button.
Select cells from C11 to I11. Go to the Alignment group and click the Wrap Text button.
Select cells from C11 to I21. In the Alignment group click Middle Align and then click on Centre align.

Mark tasks as Completed

Everything was clear?

Section 2. Chapter 1

Choose your plan

Formatting Cells

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

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:

Note
You can adjust the zoom level of the Excel workbook by holding down the Ctrl key and scrolling the mouse wheel up or down.

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.

Task

Click on Row 3 & drag the boundary to show the title header in full.
Click on Column B. Double click the boundary on the right to automatically adjust the width.
Select columns C through to I. Right click for menu. Enter 11 in Column Width. Press Enter.
Select cells from C12 to I18. Click the Borders button to add borders to all sides of the cells.
Select cells from C20 to I20. Click the Borders button to add borders to all sides of the cells.
Select cells from B11 to I11. Click the Fill Color button. Choose a color. Repeat with cells B19 to I19 and B12 to B18.
Select cells from B3 to E3. Go to the Alignment group and click the Merge & Center button.
Select cells from C11 to I11. Go to the Alignment group and click the Wrap Text button.
Select cells from C11 to I21. In the Alignment group click Middle Align and then click on Centre align.

Task

Click on Row 3 & drag the boundary to show the title header in full.
Click on Column B. Double click the boundary on the right to automatically adjust the width.
Select columns C through to I. Right click for menu. Enter 11 in Column Width. Press Enter.
Select cells from C12 to I18. Click the Borders button to add borders to all sides of the cells.
Select cells from C20 to I20. Click the Borders button to add borders to all sides of the cells.
Select cells from B11 to I11. Click the Fill Color button. Choose a color. Repeat with cells B19 to I19 and B12 to B18.
Select cells from B3 to E3. Go to the Alignment group and click the Merge & Center button.
Select cells from C11 to I11. Go to the Alignment group and click the Wrap Text button.
Select cells from C11 to I21. In the Alignment group click Middle Align and then click on Centre align.

Mark tasks as Completed

Everything was clear?

Section 2. Chapter 1

Choose your plan

Formatting Cells

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

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:

Note
You can adjust the zoom level of the Excel workbook by holding down the Ctrl key and scrolling the mouse wheel up or down.

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.

Task

Click on Row 3 & drag the boundary to show the title header in full.
Click on Column B. Double click the boundary on the right to automatically adjust the width.
Select columns C through to I. Right click for menu. Enter 11 in Column Width. Press Enter.
Select cells from C12 to I18. Click the Borders button to add borders to all sides of the cells.
Select cells from C20 to I20. Click the Borders button to add borders to all sides of the cells.
Select cells from B11 to I11. Click the Fill Color button. Choose a color. Repeat with cells B19 to I19 and B12 to B18.
Select cells from B3 to E3. Go to the Alignment group and click the Merge & Center button.
Select cells from C11 to I11. Go to the Alignment group and click the Wrap Text button.
Select cells from C11 to I21. In the Alignment group click Middle Align and then click on Centre align.

Task

Click on Row 3 & drag the boundary to show the title header in full.
Click on Column B. Double click the boundary on the right to automatically adjust the width.
Select columns C through to I. Right click for menu. Enter 11 in Column Width. Press Enter.
Select cells from C12 to I18. Click the Borders button to add borders to all sides of the cells.
Select cells from C20 to I20. Click the Borders button to add borders to all sides of the cells.
Select cells from B11 to I11. Click the Fill Color button. Choose a color. Repeat with cells B19 to I19 and B12 to B18.
Select cells from B3 to E3. Go to the Alignment group and click the Merge & Center button.
Select cells from C11 to I11. Go to the Alignment group and click the Wrap Text button.
Select cells from C11 to I21. In the Alignment group click Middle Align and then click on Centre align.

Everything was clear?

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

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:

Note
You can adjust the zoom level of the Excel workbook by holding down the Ctrl key and scrolling the mouse wheel up or down.

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.

Task

Click on Row 3 & drag the boundary to show the title header in full.
Click on Column B. Double click the boundary on the right to automatically adjust the width.
Select columns C through to I. Right click for menu. Enter 11 in Column Width. Press Enter.
Select cells from C12 to I18. Click the Borders button to add borders to all sides of the cells.
Select cells from C20 to I20. Click the Borders button to add borders to all sides of the cells.
Select cells from B11 to I11. Click the Fill Color button. Choose a color. Repeat with cells B19 to I19 and B12 to B18.
Select cells from B3 to E3. Go to the Alignment group and click the Merge & Center button.
Select cells from C11 to I11. Go to the Alignment group and click the Wrap Text button.
Select cells from C11 to I21. In the Alignment group click Middle Align and then click on Centre align.

Section 2. Chapter 1

Switch to desktop for real-world practiceContinue from where you are using one of the options below