Posted on Leave a comment

Conditional Formatting Fundamental

In this video we introduce an important tool of excel named as conditional formatting which is a very great tool for data analyzing and showing the data in meaningful way. By using this tool, we are able to set different colors or icons for different range of values or based on some predefined conditions, we can change colors or icon of specific cells.

 

 

Posted on Leave a comment

Using filter option and slicer in Excel table

In this video we talk how we can filter data in Excel. Specially, in Excel tables by using slicers options. Slicers are useful tool in excel that enable you filtering data by just clicking at current values in an box. Which can be very helpful when you have lots of data and want to filter them easily

Posted on Leave a comment

Creating New Excel Table Style

In this video, we talk how to using table style and creating one for ourselves. With Table style, we can show data with more properly to other users, specially when you have a lots of data, showing them more efficiently would be one of main concerns of understanding and analyzing data

Posted on Leave a comment

What it means by cleaning data

In this video we talk about how we can clean data. For example, when you gather the data from a database or some other places, then you need to make sure there are structured in good shape (meaning that have a table shape), and if its not, you need to reshape your data into the good structure. Here, we will talk about this good structure and how we can reform data into table format.

Excel data: Data