Marks PC Solution

  Hey Guys! You should have noticed that I'm writing on MS Excel for last few days! To be honest I'm trying to learn some simple and useful tricks of Excel . And I'm also trying to share my knowledge with you. In this post I've come with such a little trick which maybe very useful if you face such situation. Let's begin . . .    Running Total/ Cumulative Sum It means the summation of numbers in a list and it will be updated each time when a number is added or changes. Look at the image below -    Look at the image. There are two columns with numbers. The first one is simply the number list. But the 2nd one is the summation of the list. Each time a new number is added to the first column the second one shows the summation. How to do this?  It's not a magic. Very simple sum formula is used to perform this task. But there is a little trick. You just need to lock the first cell and then every time it will update the running total list.  Here is my list. S...

  Programs like MS Excel is full of functions. There are many useful functions that we don't use or we don't know about. One of them is CONCATENATE. It means joining or linking. With this function you can join texts from multiple cells. Let's see how . . . Suppose you're working in an Excel Worksheet where you need to combine texts from different cells. I'm gonna show you an example. Let's consider the image below -    What do you see ? I've imputed First Name and Last Name. In Full Name column I've used the formula i.e. CONCATENATE. And in the last column I've added Mr. with the full name.    So how do you use this formula ? Here it is -  =CONCATENATE(A2," ",B2) Observe it carefully. You can add more than 02 cells with this functions. Here I've just used 02 cells. You may think what is this " " for ? You may notice that there is a space between the two i.e. " & ".  If you don't use " " then you...

Photoshop is a nice tool for editing images. But to work better you need some plugins. Plugins are somewhat like add ons as we use with internet browsers. And they make your tasks easier. Today I'm gonna share a must have a plugin for photoshop users who work with images. It's known as - Noiseware Professional. About the Tool Name: Noiseware Professional Type: Plug-in Version: 4.1.1 Size: Less than 1 MB Developer: Imagenomic 100% Free!! What does it do? Noiseware professional is an amazing tool that works with photoshop as plug in. And it's very helpful to remove unwanted noise from images. And it requires very short time and minimum efforts.  Download Noiseware Professional Installing Noiseware Professional After downloading the above file you need to unzip it. You will get a file named Noiseware.8bf in this folder. Copy the file from here. Paste it to to the Plug-ins folder of your photoshop program....

Are you preparing a formal report? Or do you need any cover page sample for any other task? By default, MS Word contains some outstanding cover pages. Each of them will give you different flavor. Today I'm gonna talk about using the default cover pages of MS Word . . .  This Tutorial Applies to -  Word 2007 Word 2010 Word 2013 Word 2016 In every new version, Microsoft Office changes their default templates. Same thing happens to Word cover pages. I mean, the default cover pages are not same in every version of MS Word.  Cover pages included in Word 2016 may not be found in the previous versions of Office. Word 2016 has 16 cover pages. But you can discover more from Office.com . . . Add a Cover Page Run MS Word. Create a new document or open an existing one. Go to the Insert tab. Hit on the Pages > Cover Page > Click on the cover which you like. That's it. Stuffs you Should Know When you add a page numb...