INTRODUCTION TO SQL
The acronym SQL stands for Structured Query Language. SQL is a database management system language that can be used to …
Importance of Data Analytics
Data Analytics-Importance Data analytics could be a broad term that includes a good range of information analysis techniques. Data analytics …
STATISTICAL PARAMETERS
STATISTICAL PARAMETERS IN DATA ANALYTICS The term “parameter” refers to a statistical process that sums or describes one aspect of a …
INDEX MATCH
INDEX MATCH is a lookup function that many considered to be stronger to the tried-and-true VLOOKUP function. While everyone read …
Sorting In excel
Sorting data can prove to be very beneficial when you have a large worksheet and you want to sort the …
Pivot Tables and Slicers in Microsoft Excel
Pivot table helps the user to expand, isolate, sum, and group the particular data in real time. It can show …
Pivot Table Options and Methods
Pivot table options provide you more flexibility in customization of your data. You can set filters and change the formatting …
Pivot Table Conditional Formatting
Pivot table helps the user to expand, isolate, sum, and group the particular data in real time. It can show …
Pivot Charts in Excel
It would be a sheer waste of time to discuss the benefits of visualization tools such as charts in this …
Top New Features In Excel
NEW FUNCTIONS CONCAT This new function is like CONCATENATE, but better. First of all, it’s shorter and easier to type. …
