In this video we talk about how we can design and customize the pivot table in order to have a report of main table in Microsoft Excel
Tag: Learn Excel
Basic of Pivot Table in Excel
Pivot table is one the most useful tools of Microsoft Excel for getting quick and easy report. In this video we talk about how we can create and generate sample report by using pivot table in Excel.
Excel combo chart
When you want to compare two variables by using Excel charts, if those two variable have same measuring index then we can plot them in one charts. However, if those variables has different measurements, like one being money amount and one being quantity, then we need to use combo box which enables us to have two different measurement units in one chart.
Basic of Charts in Microsoft Excel
In this video we talk about how can make a chart in Excel and what are the main properties of charts in Excel. Creating a chart is one of the main tools for data analyzing and Excel simple and beautiful charts are one its most well known advantages of this software
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.
Excel Table advantages for writing formula
In this video we talked about why using Excel tables give us great advantage in writing formulas and makes function handling more convention and efficient
Text and numeric Filtering in Excel
In this video talk about the filter option of Excel and how we can use it efficiently for filtering numeric or text data in Excel. We convert the data area into table for convention filtering, but you should note that if you don’t convert range to table all concepts will be same.
CONCAT and CONCATENATE Function in Excel
The Microsoft Excel CONCAT function allows you to join 2 or more strings together. It was released in Excel 2016 and replaces the CONCATENATE function. The CONCAT function is categorized as a String/Text Function.
In this video we describe how to use this function in different situations.
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
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