Skip to main content

Posts

Showing posts from January, 2017

New Article

How to SUM by matching partial text in Excel

What is Conditional Formatting in Excel?

Conditional Formatting is an Excel Tool that allow users to apply custom cell formatting to a selected cell or it can be a selected range based on criteria. The criteria can be set by using hard code value or by using a formula. For example, You have a range A2:A10 which contains numbers between 1 to 9 in each cells. Now it is difficult to look for a number say 8 from this range within seconds. But if you apply a conditional formatting with a condition that, if the number is 8 then it becomes YELLOW as fill color. After applying this you can easily find the number 8 from the range in milliseconds. If you think that, A2:A10 is very short range where only 9 cells need to look and you will find it easily. But think, you have a table, whose range is A2:G10, now how can you find the 8? Conditional Formatting is a way by which an additional formula or a set of additional formula can inject into each cells. What are the types of Conditional Formatting? For data analysis an MIS Exe

Installing and running Excel on Windows Phone

What is Excel Mobile? Excel Mobile is an app for Windows Phone which is developed by Microsoft Corporation. Microsoft Excel Mobile is the best app for reviewing, updating, and creating spreadsheets on Windows phones and tablets (with a screen size of 10.1 inches or smaller). Spreadsheets look great on your phone and tablet: Formulas, charts, tables, and conditional formatting are all there This version of Excel allows user to stay connected with their task through OneDrive, SharePoint and DropBox. Not only that, your dashboard, charts, conditional formatting are same as desktop. You can make quick changes with the touch of your finger. Can drag columns and move worksheets. Also can tap to add data, format charts, and navigate large spreadsheets  Image 1: Excel Mobile for Windows Phone How to install it? Go to Microsoft Store from your Windows Phone and search for Office if you did not install it in previous. Generally Office app found installed in Windows Phon

How to install and run Excel in an Android Phone?

Microsoft Corporation developed an app for Microsoft Excel which allows you to use in Android platform. This app will help you by easily viewing the .xlsx file, editing it, save it and share with others. It also allows you to view and edit your official workbooks which you have got from e-mail. In a short sentence, you can do your official tasks anytime anywhere. How to Install the Excel in Android Phone? To install the Excel Mobile in Android Phone you need to follow the below instructions: Step 1: Go to Google Play Store from your Android Phone and Search for Microsoft Excel .     Step 2: A list will appears. Select the Apps where you will see developer is Microsoft Corporation . Click the Install button like below image:   Image 1: Android Phone Excel Apps After a while it will complete installation automatically and Install button becomes Open . How to run Android Phone Excel? After installing just touch the Microsoft Excel icon from your apps and this will run.