Python, C, C++, C#, PowerShell, Android, Visual C++, Java ...
We have discussed rounding the numbers using CEILING and FLOOR functions through my previous Article “Microsoft Excel – CEILING and FLOOR functions“. Excel provides another set of functions; provides a similar kind of functionality to round the numbers. Through this article, we are going to discuss these functions. ROUND, ROUNDUP and ROUNDDOWN functions in Excel […]
As part of Excel functions discussions, we are going to discuss two functions through this Article; which are CEILING and FLOOR functions. The CEILING function This function returns the rounded-up number which is nearest to the specified multiple of significance. It is important to understand that, the return number is based on the specified significance; […]
We have discussed in our Previous Article on how to extract partial text in Excel using LEFT, LEFTB and RIGHT, RIGHTB functions. In this Article, we will discuss another set of Text Functions in Microsoft Excel for the same purpose; to extract partial text from the given text. MID and MIDB functions MID and MIDB […]
First line indentation in the Paragraphs tells it is a new paragraph and gives more readability. By default Microsoft Word doesn’t indent the first line in the Paragraphs. You can do the indentation two ways. One is applicable to the current document and other way is applicable to all the Word documents by default. We will […]
Microsoft Excel provides T and TEXT functions to display the text and format the numeric value, respectively. We will discuss about these functions in this Article. The T function This function is used to return the text from the given value. Truly speaking, this doesn’t convert the value to the text; instead it returns the […]
Microsoft Word provides a handful of features to make our lives easy; to prepare and manage Word documents. One of the features is supporting Equations to add into the Word documents. In this article, we will discuss how to insert an Equation in a Word document. This article applies to Microsoft Word 2013 Step 1. […]
In this Article, we will discuss about another set of useful Text Functions Microsoft Excel provides to search the text in the given text. The EXACT formula This function is used to compare two given text values and returns TRUE if both the values are match. The comparison is case-sensitive. That means, “Apple” and “apple” […]
We can add beautiful designs to our Visio pages to provide rich appearance. Visio provides an easy interface to do this. We will discuss adding borders and titles (or headers and footer) to Visio pages through this Article. Step 1. Open Visio document in Visio Application. Adding Header or Footer Step 2. Select DESIGN tab […]
Microsoft Visio provides an easy user interface to manage the Visio Pages. It allows to create, delete, rename, duplicate and order the pages. We will look into the options to manage the Visio Pages through this Article. Visio allows to navigate between the Visio pages through the tabs. To open a particular Visio page, click […]
Another set of Text functions SEARCH and SEARCHB in Microsoft Excel are useful to find the text within the given text. These functions returns the index value where it finds the text in the given text. These functions are non case-sensitive. That means, these considers the text “APPLE” and “apple” as same. SEARCH formula This […]
