With Autofill Excel Shows Its Smarts and Saves You Time

With Autofill Excel Shows Its Smarts and Saves You Time

Autofill is an essential feature that any Excel user must be constantly using as it saves tremendous amount of time when creating spreadsheets. The capabilities of this feature range from simple copy-paste tasks to automatically creating entire tables, or transferring...
Data Validation: Excel Doing the Data Cleaning for You

Data Validation: Excel Doing the Data Cleaning for You

One of the most versatile features of Excel that is data validation can validate user entries based on rules set by you. With this feature, you can impose strict rules on cells where users can’t enter any invalid data, or display warning messages to make your users...
The crux of organizing your data: How to sort in Excel

The crux of organizing your data: How to sort in Excel

Sorting data in Excel is a crucial part of organizing it for analysis or presentation. What if you want to order data in a different way, say “New York” first, and then “California”, and another state?  One size may not always fit all as data can come in various...
How to use DAX Functions in Pivot Tables

How to use DAX Functions in Pivot Tables

Microsoft’s data analysis tools PowerPivot, Power BI Desktop, and SQL Server Analysis Services (SSAS) Tabular models empower Excel users by allowing them better manage and transform their data. Data Analysis Expressions (DAX) is essentially a formula and query...
Utilizing Web Services in Excel Using Formulas

Utilizing Web Services in Excel Using Formulas

Excel is typically where data ends up being collected. User inputs, data exports, and even web services can provide such data. There are various tools and even some built-in Excel features that can help with this sort of operations, but nothing beats a good old...