Excel Conditional Formatting from Basics to Formulas- SMASH!
Offered By: Udemy
Course Description
Overview
Learn all about Conditional Formatting. From Beginner Level to Formula/Function Based Advanced Exercises
What you'll learn:
What you'll learn:
- Highlight Cells Greater/Smaller/Between a certain Value
- Data Bars, Color Scales, Icon Sets
- To Use Some functions to Format your data (includes AND, IF, SUM, SUMIF, COUNTIF, VLOOKUP, MATCH and more..)
- Highlight Top/Bottom Values & Above and below Average
- Formula base Formating
- Productivity
- Presenting Information
This course is about automatically formatting your Data with Colors, Icons, Bars (and more) using the Conditional Formatting feature of Excel.
The student will learn Conditional Formatting from the very basics to formula use within the tool.Most of the topics on conditional formatting are covered: basic formatting (Equal, Greater than,Smaller than etc.), formatting with text, etc. We also cover Data Bars, Icon Sets and Color Scales. Finally a good portion of the course is dedicated to formula use within the conditional formatting.
Taught by
João Appleton Ribeiro
Related Courses
A Beginner’s Guide to Data Handling and Management in ExcelPackt via FutureLearn Introduction to Financial Accounting: The Accounting Cycle
University of California, Irvine via Coursera ADP Entry-Level Compensation and Benefits Analyst
Coursera Microsoft Excel: Advanced Data Analysis and Visualisation
Cloudswyft via FutureLearn Advanced Data Visualisation and Analysis in Excel
Packt via FutureLearn