Posts

Showing posts from 2015

How to Use Data Validation in MS Excel

Image
MS Excel has huge number of users over the world and these numbers are increasing day by day because every time it comes with new features. People use the excel sheet to maintain the data in a good manner. Have you ever tried to apply the validation on the cell? If your answer is no, then read this blog to know about validation option in MS Excel.

Suppose, you want to set the validation (restriction) on a cell that, when someone is trying to enter a data which is more than 15 characters or against the validation then, it will throw an error in the screen to warn the user.


Steps to add validation:

Step 1: Click on the Data tab. Unser the Data Tools option, Data Validation option is available.


Step 2: Now select the cell which you want to validate. Click on the Data Validation option. When you will click on this option then, a window will appear on the screen with the different validation option. This window looks like this:

You can see the different validation options in this window: Sett…

Know More about AutoSum option in MS Excel

Image
Today, when I was working with MS Excel then I used the AutoSum option many times to make sum of the numbers. I have noticed one thing about this option which was very interesting. This option is available in two places, first in Home tab and second in Formulas tab. Check the images below:


AutoSum in Home Tab                                          AutoSum in Formulas Tab
Shortcut for AutoSum:

In MS Excel, every formula and function have its own shortcut. You can use ALT+ as the shortcut of AutoSum option. To test this option, write down the numbers in the excel sheet and press ALT+ to make its AutoSum. Now I am describing my experience with this function.

First I have created three columns named: Physics, Chemistry and English. Now I entered some numbers along with the columns.


Test of AutoSum Option
Vertically Up: Excel user may use‘=sum(number1,number2)’ formula or AutoSum option to sum-up the data. When I tried the AutoSum option in vertically up then it gives me the following resul…

Prevent Your Excel File by Automatic Creation of Hyperlinks

Image
A hyperlink is important but in few cases it becomes tedious. Automatic creation of hyperlink is like a speed breaker in the document creation process. It creates with the following prefixes:

http:// ftp://file:www.mailto:news:\\
Suppose, you are working with large the number of excel files and each file consists of thousands of hyperlinks then what will do? I think you will try to remove manually but here, we are talking about thousands of hyperlinks. In this case, try these options:

Apostrophe (‘) at the starting of the cell entry: To understand this option. Let’s take an example. Suppose you are trying to write www.google.com in the cell. When you write it then, it becomes hyperlink automatically. In this case, write an apostrophe (‘) at the beginning of the cell entry.
‘www.google.com 
It won’t become hyperlink. This is the first way to prevention of automatic hyperlink. The second option is more interesting which is given below:

Using autocorrect options: Simply follow these simple …

Header Corruption of PSD File

Image
Adobe Photoshop is the perfect tool to create images and it is used by professionals as well as home users. Photoshop files or the layers sometimes for no apparent reason gets corrupted and refuses to open. As a result of the numerous situations like: sudden power failure, interruption while downloading and virus infection etc; can damage or corrupt the Photoshop files. In this blog, we will discuss the header corruption in .PSD file and solution to overcome from this issue.

Header of any .PSD file contains all the vital information about PSD file such as size, colors, number of layers and other important details. When the header got corrupted of the Photoshop file then the operating system or other tools cannot access that file.

Points to remember: The header can corrupt by the following reasons –

Memory in the bad sectors where the .PSD file is located. This memory works as storage device. system hard drive works as a storage device.Improper termination of the Adobe Photoshop applica…

Important features of MS Excel 2016

Image
MS Excel 2016 is more enhanced with its feature. For windows and OS X, MS office 2016 will release tomorrow (22-Sept-2015). You can easily download its preview from the official site and they are also providing the product key for office 2016 preview. This preview will be available on your system until you uninstall office 2016 preview or office 2016 is released. So get ready to know about few of them like Power-Query and Business Analytics. Read this post to know about them.

Power Query Power query is not a new feature for Excel users but this time it is more integrated and available as an inbuilt feature of MS Excel 2016. This feature is available in Excel 2010 and 2013 as Add-in. In MS Excel 2016, this feature is available in Get & Transform section which provides fast, easy data gathering and shaping capabilities.























Image courtesy: Microsoft
I will discuss some important feature that you can achieve with power query in Excel 2016:
Data Connectivity: This feature is more updated i…

Repair .PSD file in Few Simple Steps

Image
Adobe Photoshop does not need an introduction because it is used by millions of people across the globe and available in the 25 different regional languages including English. This great tool is available in the market from last 25 years and growing day by day.You can read more about of this tool on Wikipedia. It has a very big market of the customer from the different fields but, sometimes you can face the corruption problems in your .PSD files. The sad news is, Adobe does not provide any tool to repair corrupt .PSD files but luckily few data recovery companies (like Stellar data recovery) provide tools to repair these corrupt files. To know about these tools, stay with this blog.

PSD recovery tools are very powerful and able to repair the layers of .PSD files. This kind of software can repair the various file formats and it can be found as free and paid. I have tested many tools before writing this article. I found these tools are good and appropriate for .PSD repair. Take a look o…

Top 5 Solutions to Repair Corrupt PowerPoint File

Image
PowerPoint is a very well know tool that comes as a part of MS Office suite. Often people use it to create presentations for different purposes. Generally, PowerPoint files are larger in size and have a complicated file structure due to which they are prone to corruption. It takes a lot of efforts and hard work to create a PowerPoint presentation in MS PowerPoint, but due to corruption it could be useless.


Like every other computer file, PowerPoint presentations can corrupt or also become inaccessible at any time. When a corrupt PPT file starts sending you error messages while opening, it is an indication of corruption, which could be major or minor. Let's check out some common solutions that you can perform on your corrupt PPT files in order to repair them or to retrieve the content.
Solution 1 You can simply move the corrupt PowerPoint to a different location. This is a very simple and useful way to troubleshoot your corrupt PPT file and remove its problems. You can also do it by …

How to fix BEX error in Word, Excel and PowerPoint

Image
BEX error is a very common, which occurs due to buffer overflow problem. This error comes with many parameters and user gets an error message on the screen “Application_Name has stopped working”. In this blog, I will give you the solution of this problem for MS Word,Excel and PowerPoint. Take a look on the error message:

Above image shows the BEX error for MS Word.

When a user will click on the “View problem details” option then, a detailed error message will be appear on the screen.

In the above image, Problem Event Name is BEX and second parameter is Application Name and so on. You can read more about these parameters from this article https://technet.microsoft.com/en-us/library/cc738483(WS.10).aspx
General solution of the problem
Here I am giving the solution for MS Word but, it is same for Excel and PowerPoint as well. Open MS Word in the safe mode and click on the File option. At the bottom end, user can see the Options as shown in the image below:
Now in the Options category, Us…

MS PowerPoint – How to fix the error "PowerPoint can’t open of file"

Image
Just think of it!! Whole night you spent in creating PPT for next day meeting but, when you try to open the file at office it says “PowerPoint can’t open of file represented by C:\Users…..” so, what will you do? This is only one situation which I have discussed to you. A user can face the many worst conditions with MS PowerPoint error. As a blogger and reader I always give the importance to PowerPoint presentations but I also faced corruption in the .ppt or .pptx files. In this article, I will discuss the solution to recover from PowerPoint corruption.
There are following ways to solve the problem of MS PowerPoint error:
Move the file to another location:
This is the first solution that, I will suggest to all users. Every program has a default location to save its programs. User can also choose the location to save that file. If user is getting this problem repeatedly then move the .PPT/.PPTX file on the different location and reopen it.
Unblock the file:
Every file has block and unblo…

Quick Fixes for Microsoft Excel Has Stopped Working

Image
In the spare time, I love to participate on forum websites and Office related issues are my favorite topicfor discussion. I saw that, many Excel users facing the same error “Microsoft Excel has stopped working” and they feel very helpless so, I decide to write a blog about this problem. In this blog I will give the solutions to overcome from this problem. If this happens with you then stay with me for half an hour!


User gets above error message on the screen during this problem. Try these options to resolve this problem:
Solution 1: Run MS Excel in Safe Mode

This is the first option that, every excel user should try to solve it. Simply press Windows+r to open the command prompt or open from the Run option in the Start Menu. In command prompt user has to type excel.exe /safe to open the MS Excel in the safe mode. Press the Ctrl button and open Excel file is another option to use the safe mode.


Solution 2: Check the Add-ins
Go to the File Menu then click on the Excel Options.Now in Excel…