10% OFF Code: TRYIT

All that You Need to Know about Conditional Formatting in Microsoft Excel

Conditional Formatting, in Microsoft Excel, enables you to highlight cells, or range of cells based on certain conditions, to visually explore and analyze data.

The conditional formatting works by changing the appearance of the cells based on the conditions that you specify: only when the conditions are met, then, the cell or cell range is formatted; else, the cells remain as such without formatting. You may use the built-in formatting options in Excel, or create your own conditions. You can apply conditional formatting to a single cell, range of cells (including a named range), Excel Table and Pivot Table

In this course, you will learn about the basics of conditional formatting, the various for conditional formatting options, using Quick Analysis Tool for conditional formatting, building your own conditional formatting rules, and managing the rules. You will be exposed to several real-life situations wherein you can use conditional formatting to visually explore data, to find patterns & trends, and to detect critical issues.

Course Content:

Introduction
Pre-built Conditional Formatting Options
Identify Specific Text, Number or Date (Static)
Identify Specific Text and Number (Dynamic)
Identify Duplicate Values
Format the Duplicate Records
Format Top or Bottom Ranked Values
Format using Above Average / Below Average Values
Format Cells using Data Bars
Format using 2-Color Scale
Format using 3-Color Scale
Format using Icon Sets (Directional Arrows)
Format using Icon Sets (Shapes)
Format using Icon Sets (Ratings)
Apply Conditional Formatting using Quick Analysis
Conditionally Format Pivot Table Reports
Find Cells that have Conditional Formatting
Clear Conditional Formatting
Class Project
Wrapping up
There is a class project, with a number of exercises, that you can complete to reinforce the learning you have had from the various lessons.

Author: Narayanan Veeriah
Duration: 1h 16m
Exer/Code:

Installation:
Unpack that shit, run that shit

Project based course focused on entering the second month of financial transactions and constructing financial statements including a balance sheet and profit and loss report.

In a peaceful retirement village, four unlikely friends meet up once a week to investigate unsolved killings.

There are all kinds of reasons as to why you would get into CG, either as a hobby or as a professional. You could design still artwork, create animations, design video game assets, edit videos with VFX and more. But one area has grown significantly in recent years and that is the art of 3D printing, something that can now be done in your own home if you can get your hands on a 3D printer.

As such, more and more people are interested in learning how to create 3D objects so that they can be printed into real world creations.

In this course we focus on understanding the core principles of creating 3D printable objects, as there are certain things that you can get away with when modelling for scenes and animations, but you wont be able to get away with a bad model for printing.

We cover each of the principles, how to recognise them, and how to deal with them all in this class.

By the end of the class you will be able to create any 3D model you want for printing and be confidant that the final result will be exactly what you expect.

The following principles will be covered in this class:
Dimensions
Manifold Geometry
Intersections
Normals
Remeshing For Lower Topology Counts
Hollowing
Exporting Using The Correct Format
Material Thickness
And More
This is the best place to get started if you have ambitions to create 3D printable objects using Blender.

So lets get started!

Author: Joe Baily
Duration: 1h 9m
Exer/Code:

Installation:
Unpack that shit, run that shit