Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Using the Format Painter | Working with Worksheets and Workbooks
Excel Essentials
course content

Course Content

Excel Essentials

Excel Essentials

1. Introduction to Excel
IntroductionGetting Acquainted with ExcelExcel InterfaceEntering DataChallenge
2. Entering and Formatting Data
Formatting CellsFormatting TextFormatting NumbersChallenge
3. Basic Formulas and Functions
Introduction to Formulas and FunctionsUsing Cell ReferencesUnderstanding RangesCommon FunctionsApplication of INSERT FUNCTIONChallenge
4. Advanced Formulas and Functions
Displaying and Highlighting FormulasIF Logical Test and Relational OperatorsNested IF StatementsCompound Logical Tests with AND, ORUsing Auditing ToolsConditional FormattingChallenge
5. Data Management and Analysis
Sorting DataFiltering Data Using AutoFilterClearing and Reapplying FiltersRules and SearchCreating and Managing TablesTable Styles and Quick Formatting OptionsUsing Table ToolsChallenge
6. Visualizing Data with Charts and Graphs
Types of ChartsCreating a Basic ChartCustomizing Chart ElementsChanging Chart Styles and ColorsAdding and Removing Chart ElementsEditing Data in ChartsAdding Trendlines to ChartsChallenge
7. Working with Worksheets and Workbooks
Add, Delete, Rename, and Rearrange WorksheetsGrouping and Ungrouping WorksheetsUsing the Format PainterInserting and Deleting Columns, Rows, and CellsHiding and Unhiding Columns and RowsSaving WorkbooksOpening and Closing WorkbooksProtecting Workbooks with PasswordsUsing TemplatesChallengeSummary

Using the Format Painter

The Format Painter is one of Excel's hidden gems.

It's perfect for maintaining a consistent look throughout your spreadsheet without manually formatting each cell.

We'll show you how to use the Format Painter effectively, making your workflow smoother and your spreadsheets more polished.

Key Points

  • Select the cell with the desired formatting and click the Format Painter button;
  • Double-click the Format Painter button to lock it for multiple cells;
  • Press Esc to deactivate the Format Painter.

Task

  • Select cell F11. Click the Format Painter button and click H6 to apply the formatting.
  • Double-click the Format Painter button to apply formatting to multiple cells or ranges.
  • Press Esc to deactivate the Format Painter.
  • Click on Section 6 tab and select D6. Click the Format Painter button and click on Section 7 worksheet. Select cells G6 through to G25 to apply formatting.

Task

  • Select cell F11. Click the Format Painter button and click H6 to apply the formatting.
  • Double-click the Format Painter button to apply formatting to multiple cells or ranges.
  • Press Esc to deactivate the Format Painter.
  • Click on Section 6 tab and select D6. Click the Format Painter button and click on Section 7 worksheet. Select cells G6 through to G25 to apply formatting.

Mark tasks as Completed

Everything was clear?

Section 7. Chapter 3

Choose your plan

Using the Format Painter

The Format Painter is one of Excel's hidden gems.

It's perfect for maintaining a consistent look throughout your spreadsheet without manually formatting each cell.

We'll show you how to use the Format Painter effectively, making your workflow smoother and your spreadsheets more polished.

Key Points

  • Select the cell with the desired formatting and click the Format Painter button;
  • Double-click the Format Painter button to lock it for multiple cells;
  • Press Esc to deactivate the Format Painter.

Task

  • Select cell F11. Click the Format Painter button and click H6 to apply the formatting.
  • Double-click the Format Painter button to apply formatting to multiple cells or ranges.
  • Press Esc to deactivate the Format Painter.
  • Click on Section 6 tab and select D6. Click the Format Painter button and click on Section 7 worksheet. Select cells G6 through to G25 to apply formatting.

Task

  • Select cell F11. Click the Format Painter button and click H6 to apply the formatting.
  • Double-click the Format Painter button to apply formatting to multiple cells or ranges.
  • Press Esc to deactivate the Format Painter.
  • Click on Section 6 tab and select D6. Click the Format Painter button and click on Section 7 worksheet. Select cells G6 through to G25 to apply formatting.

Mark tasks as Completed

Everything was clear?

Section 7. Chapter 3

Choose your plan

Using the Format Painter

The Format Painter is one of Excel's hidden gems.

It's perfect for maintaining a consistent look throughout your spreadsheet without manually formatting each cell.

We'll show you how to use the Format Painter effectively, making your workflow smoother and your spreadsheets more polished.

Key Points

  • Select the cell with the desired formatting and click the Format Painter button;
  • Double-click the Format Painter button to lock it for multiple cells;
  • Press Esc to deactivate the Format Painter.

Task

  • Select cell F11. Click the Format Painter button and click H6 to apply the formatting.
  • Double-click the Format Painter button to apply formatting to multiple cells or ranges.
  • Press Esc to deactivate the Format Painter.
  • Click on Section 6 tab and select D6. Click the Format Painter button and click on Section 7 worksheet. Select cells G6 through to G25 to apply formatting.

Task

  • Select cell F11. Click the Format Painter button and click H6 to apply the formatting.
  • Double-click the Format Painter button to apply formatting to multiple cells or ranges.
  • Press Esc to deactivate the Format Painter.
  • Click on Section 6 tab and select D6. Click the Format Painter button and click on Section 7 worksheet. Select cells G6 through to G25 to apply formatting.

Everything was clear?

The Format Painter is one of Excel's hidden gems.

It's perfect for maintaining a consistent look throughout your spreadsheet without manually formatting each cell.

We'll show you how to use the Format Painter effectively, making your workflow smoother and your spreadsheets more polished.

Key Points

  • Select the cell with the desired formatting and click the Format Painter button;
  • Double-click the Format Painter button to lock it for multiple cells;
  • Press Esc to deactivate the Format Painter.

Task

  • Select cell F11. Click the Format Painter button and click H6 to apply the formatting.
  • Double-click the Format Painter button to apply formatting to multiple cells or ranges.
  • Press Esc to deactivate the Format Painter.
  • Click on Section 6 tab and select D6. Click the Format Painter button and click on Section 7 worksheet. Select cells G6 through to G25 to apply formatting.

Section 7. Chapter 3
Switch to desktop for real-world practiceContinue from where you are using one of the options below
We're sorry to hear that something went wrong. What happened?
some-alt