Category InfoComTech

Information technology has changed business processes, information management, information dissemination, and commerce in recent times. Virtually everything we do has a link with technology.
Learn coding and programming the easy way. The knowledge you need to unmask your creativity and creative ability.

Types of Charts in Excel and Their Uses

types of charts in Excel - stacked area
There are different types of charts in Excel that are used to simplify data analysis and visualization. Microsoft Excel has columns, lines, pie, doughnut, bar, area, scatter, and more charts to choose from. Excel 2016 included other charts types including treemap, sunburst, histogram, box and whisker, waterfall, and funnels.

How to use Vlookup Formula in Excel

vlookup and nested IF function
The Vlookup formula in Excel can be used to extract values in a table of data. It is a useful function that is used to query a data table and extract items or values in an Excel table or range. Vlookup means vertical lookup, and it’s one of the few functions in the Lookup and Reference functions category.

Conditional formatting in Excel: Uses and Applications

what is conditional formatting
Conditional formatting in Excel is an important tool used for effective data analysis. It is a tool that helps you identify and critically visualize cells that have patterns and trends using colors. It is an interesting data analysis tool that identifies cell variations based on true data conditions. When conditions are specified, cells appearances may vary in compliance with the specified conditions. In this tutorial, we discussed what is conditional formatting in Excel and how to use them in your datasets.