Founder & CEO at DLTC.co and Blogger at YouTube.com/ExcelRush. Certified Microsoft Office Specialist in Excel. Trained 2000+ working professionals and management students. Strength is training in Excel’s Advanced features & functions, programming using VBA in Excel, also Power BI & SQL. Multifunctional work experience of 11+ years. Dancer at Heart.
Introduction to DAX Functions DAX stands for Data Analysis eXpressions. It is basically a language that is used to calculate or analyse existing data (similar to Microsoft Excel functions). Sure, you can analyse data as-is by using charts and other such tools, but...
There are many times when we stumble upon Excel Terminology that looks like complete jargon. At other times, there are words that are completely misunderstood or misused when it comes to Excel. This MS Excel Glossary can be used like an Excel Dictionary. This...
Excel Interview Questions and Answers When you are interviewed for a job, there is a high possibility of Microsoft Excel interview questions and answers being asked. To help you prepare, we will cover a few basic Excel interview questions and answers, and even some...
Introduction to Conditional Formatting When someone refers to the Formatting of a cell it means they are referring to the colors, fonts, borders, alignment, etc. of the cell. When a conditional format is applied on a cell it means the formatting of the cell is based...
We all have some of the other time used Charts in Excel, but always struggle with when it comes to growing data. Once the data starts growing, we want to see the effect of the growing data on the chart immediately without having to do any manual settings every time....
Filtering data simply means seeing limited data. The other data that you do not want to see doesn’t get deleted or doesn’t change in anyway, it just gets hidden. Why would you want to filter data? If you have thousands of rows of data, it’s going to be difficult to...
What-if-analysis in Excel is a tool in Excel that helps you run reverse calculations, sensitivity analysis and scenarios comparison. Decision making is a crucial part of any business or job role. When you can take decisions, which are informed based on data, the...
The primary job of a data analyst is to make sense out of raw data. Excel has a number of tools to help with this. In this post, we will focus on useful functions towards this purpose. These functions are categorised into different sections like statistical, logical,...
Data cleaning is utmost important for any kind of data before you can make sense out of it and generate reports. Let’s say you get a ton of data which is extremely inconsistent in spaces, Mumbai is spelled as “Mumbai”, “Mum bai”, “ Mumbai”, “Mumbai ”, “M Mumbai”. All...
What is the use of Data Validation in Excel? It’s an amazing feature to control and restrict data entry being done by the user in multiple different ways. For example, using Data Validation in Excel you can allow entry of data in a particular column called City, by...
50 seats only
By clicking the above button, you agree to our Privacy Policy.
for Detailed Syllabus, 15+ Certifications, Placement Support, Trainers’ Profiles, Course Fees...
By clicking the above button, you agree to our Privacy Policy.
Live online with Certificate of Participation at Rs 1999 FREE
only 50 seats
By clicking the above button, you agree to our Privacy Policy.
