Microsoft Excel Conditional Formatting Essentials
Microsoft Excel Conditional Formatting Essentials
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 1h 50m | 1.12 GB
Instructor: Quinton Dreyer
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 1h 50m | 1.12 GB
Instructor: Quinton Dreyer
Learn the essentials required to become a master in using Conditional Formatting in Microsoft Excel
What you'll learn
- What is Conditional Formatting in Microsoft Excel
- How to successfully apply Conditional Formatting based on standard rules found in Excel
- How to create custom rules for Conditional Formatting
- How to successfully use formulas as a means of Conditional Formatting
Requirements
- A PC or Laptop/Notebook
- Microsoft Excel - Any version will work, but preferably 2016 and newer
- Basic knowledge of how to use Excel
- For using Functions please look at my "Important Functions in Microsoft Excel Course"
Description
In Microsoft Excel, Conditional Formatting makes it easy to highlight certain values or make specific cells easier to identify. It dynamically changes the appearance of cells or cell ranges based on conditions.
To put it in simple terms, you give Excel rules on when and how to format specific cells, and Excel will apply that formatting to these cells based on the conditions created in your rules.
It is one of the most simple, yet powerful tools in Excel spreadsheets.
This course will teach you the essentials required to use Conditional Formatting successfully. Become a master in Conditional Formatting quickly!
The course is laid out in 2 Sections and 17 Lectures as follows:
Section 1:
- Welcome
- Conditional Formatting and Course Layout
Section 2:
- Format Cells: Based on Set Criteria
- Format Cells: Dynamically based on changing criteria
- Format Cells: Based on Rank Part 1
- Format Cells: Based on Rank Part 2
- Format Cells: Format Duplicate Cells
- Format Cells: Format with Icon sets Part 1
- Format Cells: Format with Icon sets Part 2
- Format Cells: Format with Icon sets Part 3
- Format Cells: Format with Icon sets Part 4
- Format Cells: Format using Data Bars
- Format Cells: Format with Colour Scales
- Format Cells: Format Alternate Rows with formulas
- Format Cells: Based on values from other cells using formula
- Format cells: Based criteria using formulas
- Format Cells: Format entire Rows using formulas
I attached the Excel Workbook used in my lectures as a resource for you to download and practice what was taught.
When finishing this course, you should be able to clearly understand Conditional Formatting in Excel and how to use it to make your spreadsheets so much more powerful.
Who this course is for:
- Anyone wanting to learn the essentials for using Conditional Formatting in Excel
- Anyone who wants to incorporate visual appearance dynamically to their spreadsheets
- Anyone who works with Excel and lots of data
- Excel users curious about this powerful formatting tool in Excel
Microsoft Excel Conditional Formatting Essentials
