Courses - Learn Excel Online By Doing

← Back to all Courses

Beautify Your Sheets

ALL DO WATCH PRACTICE UNLOCKED

Formatting Cells

Applying basic text and numeric formats. In this exercise you will learn very simple formatting in the Excel.

Formatting Numbers UNLOCK NOW

Formating cell range which are formatted different type.

Formatting Tricks incl. Special Custom Formats [05:18]

Format Painter - "Uninterrupted Click-ability" [01:58]

Defining Cell Style - for "one-click" universal change [04:01] UNLOCK NOW

Transferring (Merging) Cell Style from one workbook to another [01:17] UNLOCK NOW

Conditional Formatting: Actual vs. Budget Comparison through Arrows [05:47] UNLOCK NOW

Conditional Formatting: w. Drop-down list based Input [03:16] UNLOCK NOW

Conditional Formatting: Data Bars, Color Scales, Icon Sets [02:32] UNLOCK NOW

Conditional Formatting: Blanks, Errors, Values, Duplicates [05:01] UNLOCK NOW

Conditional Formatting: Formula based (Colored rows based in user input) [04:12] UNLOCK NOW

Conditional Formatting: Formula based w. AND() - 2-way input Coloring [05:22] UNLOCK NOW

Conditional Formatting: Formula based w. COUNTIFS() - Highlighting inputs if from restricted list [04:15] UNLOCK NOW

Comments - Shortcuts, Inserting Picture in Comment Box [04:19] UNLOCK NOW

Hyperlinking (Ctrl+K) [03:35] UNLOCK NOW

Level: Beginner
Exercises: 0/15
Steps: 0/31
Points: 5.050
Approx. Time: 1h 10m

Beautify Your Sheets

Make your sheets beautiful using cell, number, date and conditional formatting. Learn the various formatting tricks

Rating Count : 11