Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: aac, 44100 Hz
Language: English | SRT | Size: 988 MB | Duration: 1h 45m

To Use Some functions to Format your data (includes AND, IF, SUM, SUMIF, COUNTIF, VLOOKUP, MATCH and more.

What you'll learn

Highlight Cells Greater/Smaller/Between a certain Value

Data Bars, Color Scales, Icon Sets

.)

Highlight Top/Bottom Values & Above and below Average

Formula base Formating

Productivity

Presenting Information

Requirements

Having Excel installed, any excel version will do

Description

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.

Who this course is for:

People Learning Excel

People who want to learn Excel Conditional Formatting

Advanced users who might need to do a review and go back to the basics on excel conditional formatting

Bners to Intermediate Users who want to develop their excel skills

People learning Microsft Office tools (Word, access etc.) that want to fill their knowledge gap with excel

Highschool, College Students Needing Excel for their Acad Works

Controllers that work with excel, power bi python and so on that will find conditional formatting very useful for developing their controls and alerts to the next level

Working Professionals in general as excel is needed in most professions (Accountants, Controllers, Eeers, Architects, Analysts, Managers, Human Resources Managers, Teachers, Professors etc.)



DOWNLOAD
uploadgig