Excel’s Conditional Formatting and Multiple Conditions【Excel Skill】

A situation where it’s easy to find the best next actions is called ‘Actionable’. You can make your data analysis actionable very easily with this Conditional Formatting. This article explains the basics of Conditional Formatting, how to use a conditional formula and how to write multiple conditions, step-by-step.

(Duration: 9:33)

 

<< Related Posts >>

(more…)

How to Use Excel Pivot Table 【Screen Demonstration】

This article explains source data formats for a Pivot Table, each section of the Pivot Table’s work screen – the Field List – and demonstrates the elemental steps needed to make a Pivot Table on the Excel screen. You’ll be able to start making your own Pivot Table after reading this article.

(Duration: 7:11)

 

<< Related Posts >>

(more…)

What is Standard Deviation? There are too many Excel functions for Standard Deviation!

This article explains ‘What Standard Deviation is’, ‘Why it’s needed’, and differences between ‘Population’ and ‘Sample’. Also, there are several Standard Deviation Excel functions. You can learn which one you should use.

 

(Duration: 8:52)

 

<< Related Posts >>

(more…)

Excel Absolute and Relative Cell References and Autofill Function【Data Analysis Excel Skill】

You can learn the differences in Absolute and Relative Cell References with case study examples. Mastering Cell References increases your work speed greatly.

 

(Duration: 6:49)

 

<< Related Posts >>

(more…)