What is ‘Find and Replace’? Often, when we are working upon a worksheet, it is possible that we make errors. Find and Replace is an easy method by which one can find these cells and replace them with the desired values. Why use ‘Find and Replace’? Find and Replace saves a lot of time and …
Find and Replace in MS Excel – Free Excel Tutorials Read More »
What is Formatting? Formatting, in MS Excel, is to change the data’s type such that it can suit the needs of the user. The numbers entered can be formatted according to the following available options Number Currency Accounting Short Date Long Date Time Percentage Fraction Scientific Text Why Use Number Formatting? Formatting should be used …
Formatting Numbers in MS Excel- Free Excel Tutorials Read More »
After we are done with an Excel sheet, there maybe a need for highlighting cells that are important. In this article, we will look at how we can do this. Greater Than Less Than Between Equal to Text that Contains Date occurring Duplicate Values Highlighting cells-Greater Than This option can be used if we want …
Equations and Symbols Equations and symbols are basic necessities for mathematical and scientific calculations. Sometimes there is a need to insert complex mathematical equations used to compute various values and insert symbols that are not commonly used. In this module we will talk about inserting Equations Symbols Where to Find These Options? The options Equations …
Inserting Mathematical Equations and Symbols in Excel Read More »
A user can change the zoom in Microsoft Excel according to his or her needs. There are three options available: Zoom 100% Zoom to Selection We will look each one in detail. Zoom in Excel This is the option that allows one to select various zoom percentages. To do this, click on ‘Zoom’ option from …
Changing the Zoom in Microsoft Excel – Free Excel Tutorials Read More »