Microsoft has updated a free tool designed to streamline the migration to the latest iteration of Windows client for end users. At the end of the past month, the Redmond company quietly refreshed the Application Compatibility Toolkit version 5.6 “With relatively small fanfare (in other words, with no fanfare that I am aware of) we [...]
[ This is a content summary only. Visit Pctipsbox for full article, links, other content, and more! ]
Let’s say that, you want to solve certain number of equations in the Excel application. Unless and until the Add-in for solving equations is not enabled in the application, you cannot solve equations and a #NAME! Error will be showed in a cell when you try solving equations in that particular cell. In this tutorial, you will be guided on how to enable the Add-in for solving equations in Excel 2010 Application.
1) Click on the “File” tab and then on the ‘Options’ tab.
Figure 1
2) In “Excel Options” window, click on the “Add-ins” tab.
Figure 2
3) Under the “Add-ins” tab, choose ‘Excel Add-ins’ option from the drop down list of the ‘Manage’ box and click on the ‘Go’ button.
Figure 3
4) Now, in the ‘Add-ins’ dialogue box thus opened, select the check box that says “Solver Add-in” and click on the ‘OK’ button.
Figure 4
So this is how you can enable the Add-in for solving equations in Excel 2010 Application.
You can use the ROUNDUP function to round off a number to the required number of decimal places. You can also use EVEN and ODD function formulas to round off a number to its nearest even number or to its nearest odd number respectively. The below mentioned tutorial will guide you on how to use these functions to round up a number.
Consider the sample worksheet shown below that contains some numbers in cells A1 to A5.
Taking the above worksheet as example, we will apply the ROUNUP, EVEN and ODD functions to obtain the desired results.
Figure 1
ROUNDUP Function
The ROUNDUP function takes two arguments. The first argument is the number that you want to round up and the second argument is number of decimal places that you want the number to be rounded up.
In our example, we are rounding up the number in cell A1 to two decimal places. To achieve this type the formula =ROUNDUP(A1,2).
Figure 2
EVEN Function and the ODD Function
The EVEN and the ODD Function, unlike the ROUNDUP function require only one argument. The only argument is nothing but the number that you want to round up to its nearest even number or nearest odd number respectively.
In our example, we are rounding up the number in cell A2 to its nearest even whole number and for achieving this, the formula to be used is =EVEN(A2)
Figure 3
Figure 4
Similarly, we are rounding up the number in cell A3 to its nearest odd whole number and for this the formula to be used is =ODD(A3)
Figure 5
Figure 6
So, this is how you can round up a number to the required number of decimal places, to its nearest even number and to its nearest odd number.
The third and finale concept video in the Microsoft XUI series, “Play”, has now been officially published online by Invivia, the makers of the video. In contrast to the previous “Home” and “Work” videos released over a year ago, it is by far the most bizarre and incoherent of them all.
Although August de los Reyes screened this during his NUI session at TechEd Australia 2010 last week, I thought by looking at it a second time in full fidelity I would have a better understanding of what the hell is going on. That’s not the case.
Fortunately there is an official description that gives some insight into its intended effect.
The XUI series is a poetic exploration of how technology might invisibly integrate into our daily lives.
…
XUI Play, the third video, is a hyper-real portrayal of a dinner party where differing points-of-view make a complex array of conflicting interactions. The physical constraints of dining at a table can hold together conflicting opinions and desires inside of a singular activity. We are using this metaphor of a dinner party as an analog for collaborative computing. This video also investigates the cause and effect of small gestural interactions on an urban scale via the digital cloud. Here, analog devices behave in extraordinary ways with the hidden aid of technology.
Riiiiiight.
In Excel application, you can use a particular table name in a formula to refer to any data present in that table. By default, the excel application would have enabled the usage of table names in formulas. In this tutorial you will be guided on how to disable the usage of table names in formulas in Microsoft Excel 2010 Application. This tip comes in very handy, when you want to ensure more security to a data table by disallowing people to edit the table, copy or delete that table.
1) Click on the “File” tab and then click on ‘Options’ tab.
Figure 1
2) In “Excel Options” window thus opened, click on the ‘Formulas’ tab.
Figure 2
3) Inside the “Formulas” tab, under ‘Working with Formulas’ category, clear the checkbox that says “use table names in formulas”.
Figure 3
4) So, the next time you use any table name in a formula, the excel application will show a warning message saying that, you cannot use this table name in the formula.
5) If you want to enable the usage of table names in formulas, then select the checkbox that says “use Table names in formulas” under the ‘Working with Formulas; category.
Figure 4
6) Finally, if you are done, click on the ‘OK’ button on the Excel Options window.
So, this is how you can disable and enable the usage of table names within the formulas in Excel 2010 Application.
See also How to Disable and Enable the Formula AutoComplete feature in Excel 2010 Application.
Bringing multi-touch technology to the desktop mice might seem trivial but Microsoft Research doesn’t just want to stop at a couple gestures. A group of researchers there have been thinking of new ways to redefine the dated but familiar traditional mice interaction model with new multi-touch-enabled ones.
In their report “Design and Evaluation of Interaction Models for Multi-touch Mice“, they acknowledge that a multi-touch mice has the potential to combine the best of surface computing with the ergonomic benefits of a mice, but existing prototypes and products including the Apple Magic Mouse might not be utilizing the technology to their full potential.
Using the prototype hardware they built, they designed four interaction models around an fascinating thought that not only would the cursor be showed on screen but also multi-touch visualizers that showed the fingers activity on the sensor, including if they were “activated” and how they are positioned. This also allowed the “hand” position of the cursor to be separated from the “finger” interaction controls in a graphical user interface.
Unfortunately their experiments with a dozen participants concluded all of their proposed models were slower than using a multi-touch screen or a three-buttoned mouse, but their findings establishes some groundwork for future research and development in the area.
I’m sure Microsoft Hardware is taking notes.
The below mentioned tutorial will brief you about the common errors that people make while making formulas in the excel application.
1) Open and Close parentheses do not match
You should always ensure that, the open and the close parentheses always match. The excel application will show the parentheses in colors when you make a formula. In a formula, there should be an equal number of matching open and close parentheses.
2) Colon symbol may not be used to indicate a range of cells
When you indicate a range of cells in a formula, ensure that you have indicated the range using a colon symbol. For example, if you are using the cell range A1 to A5, indicate this range in the formula as A1:A5.
3) Required arguments may not be entered properly
Ensure that all the required arguments for a formula are entered correctly and also ensure that you do not enter too many arguments inside a function.
4) More than 64 functions may be nested
Though, this is a rare occurrence, ensure that you have nested not more than 64 functions inside a formula.
5) Other Worksheets names may be enclosed in the formula incorrectly
When you enclose cells or values that are contained in another Worksheet or workbook and, if that worksheet’s name starts with a non alphabetical character, then ensure that you have enclosed that worksheet’s name within a single Quotation (‘) mark.
6) A path to External Workbooks may be entered incorrectly
You should always ensure that, the External reference to a workbook includes the name of the workbook and the right path.
7) Numbers that include formatting may be entered
You should ensure that the numbers that you enter should be free of any kind of formatting. For example, if you want to enter the number as $200, ensure you enter the number only as 200 and not $200.
Avoid division by Zero.
So, these are the Common Errors that might occur when making formulas in Excel application.
See also How to make a formula using Nested functions in Excel 2010 application
I come across this extremely useful Firefox plug-in (i.e. Greasemonkey) to enable the customized user java script for any website. You can write your own java script (if you know how) or you can browse all the available user Java scripts from www.userscripts.org.
I’m going to use the “Download YouTube Video as MP4″ user jaya script as an example here to show how we can install “user script” into the GreaseMonkey Firefox plug-in.
Steps to Install User Script
Now, you can go to any YouTube page and you will see the “Download” button as follow. You can either download the “FLV” or “MP4″ format. After that, you can use VLC – My Best Video Player to watch the video.
Notes: You can also remove or made changes to all the installed user script by going to the “Tools->Greasemonkey->Manage User Scripts…”.
P/S: Have fun and I hope you did find this “GreaseMonkey” Firefox plug-in useful. Please be careful of not simply install any user scripts but only those well-known & reliable one. If you can read the reviews of the script to figure that out…
In the last post we guided you on how to assign names to cells or range of cells in an Excel worksheet. In this post, you will be guided on how to delete or change those defined names of cells in an Excel Worksheet.
1) Click on the ‘Formulas’ tab and then under the Formulas tab, in the ‘Defined Names’ category, click on the ‘Name Manger’ icon.
Figure 1
2) Now, in the ‘Name Manager’ dialogue box thus opened, select the name that you want delete and then click on the ‘Delete’ tab. If you want to delete more than one name at a time, then select the names by holding down the Ctrl key and then click on the ‘Delete’ tab.
Figure 2
3) In case, if you want to change the name that you have assigned for a cell, then select the name from the list and click on the ‘Edit’ tab.
Figure 3
4) Now, in the ‘Edit name’ dialogue box thus opened, enter the new name that you want in the ‘name’ box and click on ‘OK’ button.
Figure 4
5) Finally click on the ‘Close’ button in the ‘Name Manager’ dialogue box.
So, this is how you can use the Name Manager feature to change or delete the name that you have assigned for the cells in an Excel Worksheet.
When you type a formula in any cell of an Excel worksheet, the excel application, by default will show the result of that formula in that particular cell. For example, if you type the formula “=SUM(A1,A2)” for adding two numbers present in cells A1 and A2, the result obtained by adding the numbers will be showed in the cell. In the following tutorial, we will guide people how to make the Excel application show the formula itself instead of its calculated result.
Here is an illustration to show you how the excel application displays the result of a formula when you type one inside a cell. We have used the formula to obtain the SUM of two numbers in cells A2 and A3 and the result in cell A4. Here is the formula that we have used: – “=SUM(A2,A3)” exclude the enclosing double quotes when typing the formula.
Figure 1
To make Excel Application show the formula instead of result, carry on the following steps
1) Click on the “File” tab and then click on ‘Options’ tab.
Figure 2
2) In the “Excel Options” window thus opened, click on ‘Advanced’ tab.
Figure 3
3) Under the ‘Advanced’ tab, in ‘Show Options for this Worksheet’ category, select the check box that says ‘Show formulas in cells instead of their calculated results’.
Figure 4
4) Finally click on the ‘OK’ button.
5) Now if you observe your worksheet, you can see that, the calculated result will be replaced by the formula that you used to show the result in the cell.
Figure 5
So, this is how you can make the Excel 2010 Application show the Formulas instead of their calculated results in the cells of the Worksheet.