Find and Replace in Excel

Excel's Find and Replace feature is a quick way of finding specific text and we can replace it with other text. We have to go to Special feature to quickly select all the cells with formkulas, comments, conditional formatting, constants and data validation etc. Find in Excel Follow the steps below to find text in Excel.
1. On the Home tab, in the Editing group, click Find & Select.
2. Click Find

3. The 'Find and Replace' dialog box appears.

3. Type the text you want to find. For example and when you find it
Excel selects the first occurrence.
4. Click 'Find Next'.
5. Click 'Find Next' to select the second occurrence.
6. To get a list of all the occurrences, click 'Find All'.
Replace in Excel
To quickly find specific text and replace it with other text, execute the following steps.
On the Home tab, in the Editing group, click Find & Select.

and you can replace the text you selected in find

How to create Excel Dashboard - Excel Dashboards

Excel Dashboards would be covered in our excel tutorial today. We will create Excel Dashboards and learn the following skills in our excel Tutorial. You will learn the following skills in the course. Excel Dashboard Design Excel Dashboard Templates Excel Dashboard for Beginners Excel Dashboard Tutorial
Excel Dashboard Course Excel Dashboard using Pivot Table Excel Dashboard for Data Entry Excel Dashboard for Inventory Managment Excel Dashboard Training How to design excel dashboard Excel Dashboard Examples Interactive Excel Dashboard How to build KPI dashboard in Excel How to build sales dasboard in excel How to create excel dashboard step by step Excel Dashboard in Urdu Excel Dashboard in Hindi how to create excel dsahboard how to create excel dashboard reports how to create excel dashboard free how to create excel impressive excel dashboard how to create excel dashboard how to create excel sales dashboard

Create a Drop-down List in Excel

To create a drop-down list in Excel, execute the following steps.
1. On the second sheet, type the items you want to appear in the drop-down list.

We can also hide the list appeared and it's sheet so that users can not see it
2. On the first sheet select cell a1
3. Select the data tools group in data tab and select data validation

4. On the allow list box click list and select range of the cells 5. Click in the source box and select the range from second sheet

Function Keys in Excel F1 - F3

F1 - Open Excel Help

F2 - Move the insertion point to the en of the conents of the active cells as below selection

F3 - Displays the Paste Name dialog box. For example, select cell E2 below, type =SUM(, press F3 and select a name.

Create a Macro in Excel Basic Settings

Excel VBA is used to automate the tasks by writing macros. We will try to create a simple macro which would be executed on a command button.
We have to first turn on the developer tab
1. Right click on the ribbon and click customize the ribbon from menu.

2. In Customize the Ribbon, select the main tabs.
3. Check the Developer check box.

4. Click Ok 5. Developer Tab is now available It will help you in below Macros in Excel
Macros in Excel for beginners
Macros in Excel 2016
Macros in Excel 2007
Macros in Excel 365
Macros in Excel tutorial

Macros in Excel

Excel Macro is a record and a tool which can record your excel steps and will play it back multiple times for you. VBA Macros save time as they can automate repetitive tasks. It is a piece of programming code that runs in an excel environment and you don't need to be a coder to program macros.
Macros are helpful for beginners and it can work in all the versions of excel.
We have covered
Macros in Excel
Macros in Excel 2016
Macros in Excel for Beginners

Data Validation in Excel | Excel Data Validation

Data validation is a feature in Excel, it is used to control what a user can enter into a cell.
In our example, we would try to explain it. In data validation, we try to make sure a value is number and can be restricted, date and characters can also be restricted.
Below is a example of data validation in Excel in which we would restrict the cells to enter whole number between 0 to 10.
Create a Rule
We would create a rule for this
Steps For Validation 1. Select Cell B2
2. On the Data tab, in the Data Tools group, click Data Validation.

Go on to the Settings tab:
3. In the Allow list, click Whole number.

4. In the Data list, click between.
5. Enter the Minimum and Maximum values.
Input Message
A Input messages appear when the user selects the cell and tell the user what to enter.

On the Input Message tab:
1. Check 'Show input message when cell is selected'.
2. Enter a title.
3. Enter an input message.
The message would be appeared for the cell and user is restricted to enter only those numbers. In this article we tried to cover the following. Data Validation in Excel
Data validation in excel 2016
Data validation in excel 2019
Data validation in excel 365
Data validation in excel definition
Data validation in excel list

A useful Shortcut Zoom in and Zoom out in Excel

A function that is frequently used in Excel is Zoom in and Zoom out so here is a shortcut using Zoom functions.
Hold down the Ctrl key and use the scroll of your mouse to zoom in and out.
You can also use the zoom bar on the right bottom of the page, but when you know this shortcut you can do it quickly.

Excel Sumifs Function | How to Sumifs Formula in Excel

To sum cells based on multiple criteria we use Excel Sumifs, use the following SUMIFS function (first argument is the range to sum) which is based on one criteia.

In our example, we have selected one city and find the sale of it. We would cover multiple criteria in our next example of excel Sumifs function.

How to Sumifs in Excel has been covered with the following topics in Excel Sumifs. Sumifs Formula Sumifs Syntax Sumifs multiple columns and rows