-
5 Useful Excel Tricks to Become an Efficient Analyst
Excel is an excellent tool for performing data cleaning and data preprocessing tasks. These 5 useful Excel tricks will make you efficient at data cleaning.
Ram Dewani 05 Jun, 2020
-
5 Excel Tricks You’ll Love Working with as an Analyst
These 5 useful excel tricks and tips for analysts will make you efficient at performing data cleaning and data processing tasks.
Ram Dewani 08 Oct, 2020
-
5 Handy Excel Tricks for Conditional Formatting Every Analyst Should Know
Conditional formatting is a handy feature in MS Excel. Learn 4 conditional formatting tricks and conditional formulas in excel to become a better analyst.
Ram Dewani 12 Jul, 2020
-
3 Classic Excel Tricks to Become an Efficient Analyst
Here are 3 classic Excel tricks to become an efficient analyst in your daily role. These tricks cover printing options, flashfill and heatmaps in Excel.
Ram Dewani 15 May, 2020
-
10+ Simple Yet Powerful Excel Tricks for Data Analysis
Here are some useful excel tips and tricks. The excel tips for data analysis and data science include tricks on data cleaning functions, keyboard shortcuts
Sunil Ray 28 Apr, 2020
-
What is Analysis of Variance (ANOVA)?
Learn ANOVA basics: concepts, Excel usage, key terms, group variability, One-Way & Two-Way ANOVA, F-Statistic, and MANOVA explained with steps & examples
Gurchetan 01 May, 2025
-
Cheatsheet – Excel Functions & Keyboard Shortcuts
This article provides 2 cheatsheets - Excel functions and keyboard shortcuts. It should serve as ready reference for doing data analysis in Excel
Sunil Ray 24 May, 2018
-
A Beginner’s guide to Shelf Space Optimization using Linear Programming
A beginners guide to shelf space optimization in retail using linear programming, explained with examples using simplex method, python & greedy algorithms.
Guest Blog 22 Oct, 2024
-
What did you miss ? Complete Solution of Mini Hack Excel
This is a solution of mini hack excel which involves solving a business problem using advanced excel, logical and structured thinking to solve
Analytics Vidhya 14 Mar, 2016
-
A Comprehensive Guide to Data Exploration
This tutorial on data exploration comprises missing value imputation, outliers, feature engineering, and variable creation.
Sunil Ray 01 May, 2025
