Marks PC Solution

  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...

  Hello guys! In this post I'm gonna write about some basic functions of Excel i.e. left, right, mid, len & mid+len. Normally they look really simple. But they can be of great use if you know how to combine them with other functions . . .    In this tutorial I'm not gonna discuss about complex use of these functions. I will simply show you the basic use of them. Hopefully next time you will see the advanced use of these functions.    Let's start with the image above. There are mainly 04 formulas i.e. Left, Mid, Right & Len. And the next 02 are combinations of Mid and Len functions.  I've tried to explain every formula in this image. I guess nothing is ambiguous with these 04 functions.  You might be confused with the combinations. In the 1st combination the 02 functions are simply merged.  But in the 2nd combination you should notice that len function is not used. Instead we've used the len column i.e. G2. That is the difference. 1st combi...

    If you work with fraction numbers in Excel then you might be familiar with this problem. While summing up fraction figures in Excel the result may vary from manual calculation. This happens because Excel counts every digits after the decimal point even if they don't appear on the screen!    To fix this problem you can round the fraction numbers as per your requirements. Today I will talk about some simple ways to round the numbers. Hope this will solve your problem and save time as well . . .   Rounding the Numbers First you should know that Excel has 03 formulas to round the numbers -  Round Rounddown Roundup Depending on your necessity you can choose any of them. Let's begin . . .   Now I'm begging your attention to the above image. I've tried to show all the formulas in a single worksheet.  Look at the original numbers and their summation. And then look at the values of rounded numbers and their summations. There are some differences. Now i...

      Back to my site after a long time with a simple excel trick. It's about countif functions of Excel which can count the cells depending on given criteria. Suppose you're analyzing the results of your students or anything else. You need to count the cells which are equal to or greater than or smaller than a specific value. Using countif function you can do so. And today I'm gonna show you how to add multiple countif function . . .       Countif Function Suppose you're counting the cells which are more than 400. Your range is A3 to A12. Then your formula will be -  =COUNTIF(B3:B12,">400") Similarly you can change the formula depending on your requirement. If you wanna find out the cells which are equal to 400 then -  =COUNTIF(B3:B12,"=400") For below 400, you have to type -    =COUNTIF(B3:B12,"<400")     Adding the Multiple Countif Functions - Hopefully you're done with countif function. Now I will show you how to a...

If you're using Excel 2010/ 2013, you can divide your worksheet into individual pages. This exciting feature was unthinkable even on Excel 2003. At first, Microsoft introduced this Page Layout feature in Excel 2007. And it's available in Excel 2010 and 2013 too.  Almost all of you are familiar with the Print Layout view of Microsoft Word. Excel Page Layout view does the same job here. If you enable Page Layout view in a worksheet, you can easily understand your print area with header and footer. And it also makes your printing task easier .  Applies to: Excel 2007 Excel 2010 Excel 2013 Advantages of Page Layout You can view how your printed document will look Check where your page begins and ends View headers and footers of the page Print the worksheet page by page How to Enable Page Layout View You can enable page layout view as below: Open any worksheet or create a new one Go to the View Tab > Workbook Views >...

Sometimes you may need to print same column headers on every page in Microsoft Excel. And to do so, you don't need to manually copy the headers on every page. You can simply set a command from page setup option to print column headers on every page automatically!  In my previous post, I discussed about how to lock or freeze column headers . By freezing rows or columns, you can just show headers at the time of scrolling. But they will be printed on the first page only.  In this tutorial, you will learn - how to print same column headers on every page automatically .  .  . Applies to: MS Excel 2000/ XP MS Excel 2007/ 2010/ 2013 Note: This tutorial has been prepared using Excel 2013. So, few options may differ slightly. Let's start -  Open a previously saved worksheet or create a new one in MS Excel. Go to the Page Setup option from Page Layout Tab (Office XP/ 2000 users should find it under Edit Menu). Go to the Sheet tab...

When you are preparing a large statement or table in Excel, the column headings at the top usually disappear when you scroll down. And this is really troublesome when you need to input data under several headings. Couple of months ago, I faced the same problem. And just 2 days ago, one of my relatives questioned me how to create static/ fixed column header in Microsoft Excel.  Then I explored the topic and found the solution from Excel help and Microsoft Support Page. So, in this post, you are getting another important excel tutorial - How to Lock/ Fix/ Freeze Rows or Columns in excel while scrolling throughout the worksheet. Lock/ Fix/ Freeze Rows or Columns In Excel, the term is known as Freeze Panes . With this option, you can freeze a row or column that you want visible even when scrolling down or right.  Suppose, you preparing a salary sheet that contains hundreds of rows. And you can view only 25/30 rows in a view. When you scroll down, the column h...

Hello Dudes! Hopefully you're alright and also hope you're enjoying my posts. After a long time, I've come with MS Excel Tips. Couple of Months ago, I shared an Excel Sheet with you that includes - Salary Sheet, Result Sheet, Electric Bill etc. Today I've come with another sheet which will help you to learn how to create Column, Bar and Pie Chart in MS Excel.  Actually I was planning to share this tips with you for a long time. But I couldn't understand how to start and what to write. Finally, I've decided to share a sheet with you as example. And I will also try to clarify how to create charts in MS Excel.  Applies to: Office 2007 Office 2010 Office 2013 But I've used Office  2010. So there might be some changes in other versions.  Download Column, Bar & Pie Chart Sheet For your convenience, you can download the above file and have a look before we start. It's just 2 2  KB! Remember, it is an .xlsx ...

If you are a regular user of Microsoft Excel then you might be in danger while typing more than 15 digits in a cell. If you type 1111222233334444 then it will be 1111222233334440. Or if you type 25127680876675435 then it will be  25127680876675400. Simply the digits after 15th place will be changed to zeros! Doesn't it seem peculiar?  Today I will explain when & why this problem occurs and how you can solve it easily.  When the Problem Occurs? The problem occurs when you try to type more than 15 digits in a cell like below:  ####-####-####-#### 1234324545679876 But when you press Enter, the output will be  1234324545679870. Excel changes the last digit to a 0. And why someone needs to type more than 15 digits in a cell? It can't be a currency figure.  Usually when you type a Credit Card/ Debit Card/ BO Account Number you have to type 16 digits. And the calculation of excel doesn't allow you to type more than 15...