How To Use Maxifs In Excel?

Searching for some easy alternatives to evaluate maximum value from the data under the conditions in Excel?

Stop searching for it, as by using the Excel MAXIFS function you can easily perform this task.

Now the question arises, how to use MAXIFS in Excel …?

Read more

5 Hacks To Extract Images From Excel

5 Hacks To Extract Images From Excel

Today in this tutorial we will discuss different tricks to extract images from Excel. Now you all must be thinking that what’s new in this to learn because it’s so easy to copy an image from the source then paste it into the paint application and save it.

But just think for a while what if you need to extract multiple images from Excel file?

Read more

5 Tricks To Lock Cells In Excel

How To Lock Cells In Excel

Wants to prevent users from changing the data, formatting or formula contained within the cells of an Excel worksheet?

In my previous blog I have already shared some quick tricks to protect Excel workbook from editing. But if you want to restrict user from making changes into any particular cells then those fixes won’t be applicable.

Read more

4 Ways To Create Drop-Down List In Excel

4 Ways To Create Drop-Down List In Excel

Summary:

This blog summarizes the complete detail on how to create drop list in Excel using different tricks. Also learn how to add/remove item from the drop down list or steps to delete the drop-down list.

Read more

How To Create Flowchart In Excel?

How To Create Flowchart In Excel

Does your Excel worksheet densely packed with useful data but you are facing difficulty to interpret it?  Why don’t you use flowcharts to illustrate relationships between all your data points and for giving more clarity to your Excel spreadsheet.

If you don’t know how it is to be done then also you need not to get tensed as this guide will gives you the complete overview on how to create flowchart in Excel.

Before that, let’s grab some basic knowledge about Excel Flowcharts.

Read more

How To Make Excel Table Automatically Expand?

How To Make Excel Table Automatically Expand

When any new data enter in the worksheet then the Excel table automatically expand by default. But sometime the situation may arise where Excel table doesn’t expand for new data. Do you know how you can fix this issue?

If not then don’t go anywhere as our today’s topic is specifically about how to make Excel table automatically expand. Besides this we will discuss how to deal with the problematic situations where Excel table doesn’t expand for new data.

Read more

3 Ways To Create Calendar In Excel

3 Ways To Create Calendar In Excel

Summary:

The tutorial explain you how to create calendar in Excel with complete steps. Apart from this, you will also get to learn about tricks to create calendar from Excel spreadsheet data.

So without wasting any more time, let’s dive into this post….!

Read more

HLOOKUP Vs VLOOKUP: Clear Contrast Between Excel Lookup Functions

HLOOKUP Vs VLOOKUP

Being an Excel user you all must have heard about Excel lookup functions i.e HLookup and VLookup. But don’t know what the basic difference between HLOOKUP and VLOOKUP is? Or where and when to apply these Excel functions.

If not then go through this post to read about the clear contrast of HLOOKUP vs VLOOKUP function.

Knowledge and practical experience of using HLookup and VLookup function are very much important to get optimum results.

Read more

How To Send Specific Worksheet Or Cell As Email Attachment?

Send Specific Worksheet Or Cell As Email Attachment

Sometimes, Excel users need to send specific worksheet or cell as Email attachment to the head of the company or college. For this purpose, you must have the knowledge of sending the worksheet or cell as an Email.

In case, if you don’t have the actual idea then go through this post, you will find several ways to attach worksheets or cells in email.

You will also get to know about the way to attach Excel files in Email.

Read more

12 Ways To Clean Data In Excel Spreadsheet

12 Ways To Clean Data In Excel Spreadsheet

Excel Spreadsheet is used by most of the users to store the data that they retrieve from different sources which may include unwanted data.

So to clean data in Excel spreadsheets becomes necessary as it will not only avoid and fix problems but also make the dataset look attractive and beautiful.

Cleaning data is a way of modifying information using different techniques. You can ensure that your data is usable, correct, and consistent.

Read more