Rd Submission Sheet: Fill & Download for Free

The Orientation Programme of NIFT is fun, frolic and engagements. It is to find your potentials (Potentials include everything ;p) and get ready to shoot! It’s probably one of a kind! It has ice-breaking sessions , interactive sessions and where students (friends for life) are going to discover each other, know what lies ahead. Led by bright (atleast for the one week) faculties, you will find yourself between something good and amazing. That is where your life starts to change because your way of thinking changes, the way you approach things change; moreover your likes and dislikes change! You shall find yourself in altogether a new world, not something that you knew about earlier (in most of the cases! well, who knew about color chart, let alone ‘Gestalt’s laws’ , BTW you will soon learn Gestalt’s law :P)After the first week starts the foundation Programme : The base for everything that holds the future for you! It is all about polishing your skills that will come handy in your professional career. I believe, the foundation course of NIFT is a salient feature and hardly any Institute matches it (Yeh, you read it right, ANY). And for 2 reasons: 1. Compatible for novices (I hardly could draw a human figure and now . . . well someday I shall post!!) 2. You will be the best (atleast one amongst the best!), no matter where you were at the start. Within a year, you will be apt in drawing, visual representation, will exactly know the dyanamics of fashion, how it all started and how the fashion capitals marked their place. You will literally be abe to identify the designers just by mere a look at a particular style by them! (And, you will laugh off when any bollywood star is crowned a diva!) No matter how much you hate learning softwares, you will have to learn all of them A N D that starts now. Just eat and swallow those sessions. First time in your life, you will know that scissors and sharpners are indeed wastes. Cutters and DST will rescue your lives.What holds significance, is that, you will feel fighting yourselves over choices that you will have to make. NIFT will test all of your character and calibre (Mind it, character means your ability to stand to your decision and bravery to stand by what may be most appropriate; calibre means not how much marks you enjoy but how much you have made yourself worth of taking starts), though there will be thousands of chances falling on you to be an escapist - DON’T BE ONE. At NIFT, there shall be days when you will feel the loneliest and there will be days you’ll be a total swag. Don’t let anything deter your mood and temper to serve the best!When I was at NIFT, I made best of friends! I saw them get matured and grow beyond their capabilities. We failed, we cried, we laughed and finally it was a matter of seconds four years escaped on a blink!I just noticed, how much I have written. (Forgot, the question was only regarding orientation week!) Well, one thing you can start from . . . Don’t be anonymous.EDIT 1:I failed to tell exactly how ‘Foundation Days’ go. So, here it is:There is not a foundation week or a month or a semester but a year altogether which is, as I have mentioned previously one of a kind. Talking of Orientation Programme only feels like speaking only about Thupkas out of whole menu of Tibetan Kitchen of McLeodganj. However, I will write recalling July 2010. It was the last week when classes first commenced at NIFT Kangra (hence McLeodganj)Our first class was a casual one and Ashutosh Porus took it, it was regarding material handling. He made us introduce ourselves and so did every teacher/professor in his/her first class. It was fun, we spoke about many things, he joked and it was where we zeroed out on few Salman Khans of the class. The first week saw students mingling with their new classmates - batch mates (all the departments are mixed in the first year) and their hostel/roommates, discovering the beautiful campus and out of campus locations and places to visit. Meanwhile, it was time for goodbyes from parents who came to leave their wards for a beautiful journey with hugs, hopes and tears. By end of the first week, we had a slight grasp of various subjects and respective teachers that were going to teach us. Mind you, we still could not remember the names of subjects - only the ones classes of which commenced.The second week and Batch C + DFT were party to faculty from Delhi who was to take Fashion Orientation classes and she was amazing. Our batch still remembers her and owes her a lot - I do. It was a rigorous one week, we had to make FO diaries and it was fun and lo, at the end of 2′nd week we were done and dusted with the first assignment of the semester and closure was put to one subject. Facebook accounts of people who did not have one were opened (I am speaking of 2010, these days yet to be born has one and that is more ridiculous than cutting papers with scissors.) school friends and neighbors were added, (family members were yet to arrive on scene), Profile Pictures of Lilies, Roses, David Beckham, Zidane (who forgets the legendary head butt of the FIFA 2006? Sad but legendary and hence, kids, note it was Beckham vs Zidane before Ronaldo/Messi) gave it tough to recognize friends with a very common name. But, NIFTians being NIFTians, all equipped with DSLRs (from libraries/seniors) and sometimes webcams (we are creative)or if you had Nokia E12s and Samsung Corbys and Blackberrys had our DP ready.The end of 2′nd week was for the official ice-breaking trip. We and the senior batch were taken to Switzerland of India - Khajjiar. The week saw many couples hatched out of brewing romantic weather, freedom and a bit of love and benefits. It was a good trip - just that we spent more time on the bus than sightseeing. I, who came from deserts never minded that.The start of 3′rd week and all the batches were into assignment and classes, my favorite was IWAC and DIET, though I liked V and R, the workload was too much. Making straight lines, scores on them on newspaper sheets and waste papers only to come up with final ones on bond sheets/ final line drawings. There was no ragging but introductions and it was nice, we were the second batch of the campus and hence there were only 300 students in total - everyone could remember names of every other person, the teachers knew us all. It was homely.The end of the fifth week and we had a fresher party - parties at the campus are absolute madness - dance and laugh. The first round of breakups come soon after and then there are official twos. The workload gets going tough - you are after assignments but most of the time, as mid sem approaches the assignments are after you. Foundation is the toughest phase in college life.While all your friends in engineering, commerce or even medicine chill out and claim to study just before exams, you work off your limits almost every day. The semester DOES NOT HAVE vacations until Diwali/Navratri and while you are at home you receive love and attention from your parents and that is something you never knew existed at such levels. Still, you miss college and can’t wait to go back. The day you arrive back to college in late October/early November to 3′rd Week of December, with hardly a month to go for Semester end, you have seen it all - sleepless nights, assignments that suck all your energy - but not your enthusiasm, submission and the very FIRST JURY.To us, in Kangra, the winter came as we left for Semester break in December with thick fog over Dhauladhars only to come back in January first week to find heavy snow-clad peaks which speak - O Boy! What a Joy.…to be continued.

Excel is the top software for calculating the massive amount of numeric data. In this Information age, excel makes sense for calculating large amounts of data simple. Excel is a part of Microsoft office. Over the years there is much software designed to manipulate, analyze, and visualize data. But Microsoft Excel still remains the most efficient tool if the person has to make sense out of data. In this blog, we have accumulated all the vital information about excel top 10 formula.Also, we add some additional information, such as importance and tips for the beginner. Many beginners waste time by typing formula manually. Just learn this 10 formula and you will be able to work with your excel sheet efficiently.A lot to know a lot to discuss, let’s get started.Most Used Excel top 10 formula:Excel offers 500+ functions but for a regular person or for a corporate person all the functions are not useful. Definitely every function has used for a specific case. But we are left with 10 functions that truly matters to everyone regardless of which profession you are.1. Count, Sum, Average:-These are some of the most useful commands in excel. Everyone who sees a spreadsheet knows while working this visual information person need these command very often and these are some of the basic mathematics formulas.These basic formulas are so important that they made at the top of this excel top 10 formula list.COUNTING OF CELL(Count, Counta).Count:This command is useful when the user wants to count the number of cells that contain numeric values.{image}Command keyword:Count(2,3) =This command will give the number of values in the brackets. For example, in Count(2,3) there are only two values. This command only works with numbers. This command will only work for numeric values.Count(B1, B2, B3…) =This command will give the number of the cells having a numeric value from selected cells specified in the bracket. It will not count the empty cells. This command only works with numbers.Count(B1: B8) =This command will provide the number of values in the range of cells starting from B1, B2, B3…till B8. For example in “Count(B1: B8)” the computer will count the number of cells that contain any value it will not count empty cells.COUNTA(B1: B10) =This command is useful when a user wants to count the number of non-empty cells in a range. This command works with numeric as well as alphabetical or any character. Besides, this command can also be used in these formats for examples such as Counta(B1, B2,…) or Counta(B1: B10) and Counta(2,4,6).Submission of the cells(SUM).This command performs an addition between selected cells or a range of cells. this command is only for numerical values. this command can be used in any format for example SUM(2,3) or SUM(B1, A5) and SUM(B2: B9).SUM(2,3): Sum of numbers specified in the bracket.SUM(A1, B2, C5…): Addition between selected cells only.SUM(C1: C9): Addition in the range of cells.Average:- As its name suggests it provides us with the average of the input numbers. It only calculates an average of the numerical value.2. IF statementThis command is used for conditional output. Using this user can take any output from the computer according to the requirement.Command keyword= IF(logical, output if logic is true, output if logic is false).Let’s suppose an example that a company took a target to increase its turnover in a year then the management can follow strict rules in order to meet the target. They can monitor themselves through an excel sheet using a command like IF(turnover>100cr. Turnover achieved, Turnover not achieved).Then by the end of the year/session, the excel sheet will remind output about the turnover achieved or turnover not achieved.If command very important role and many functions can be performed through it. The importance is so huge that it made on the 2ndposition of our excel top 10 formula.3. SUMIF, COUNTIF, AVERAGEIF.These commands are useful for the user when you want to put a condition on some of the basic commands like adding the data if the condition is fulfilled. Count the data if the condition gets fulfilled, Take an average of the data if the condition is true.{image}Command Keyword: SUMIF(Range, Criteria, {Sum_range}),COUNTIF(Range, Criteria),AVERAGEIF(Range, criteria)Furthermore, these conditional commands are very useful so 3rdPosition in our excel top 10 formulas.4. VLOOKUP & HLOOKUPAs the name of this command it allows users to lookup for a value in an array. In VLOOKUP ‘V’ stands for vertical lookup. Similarly, in HLOOKUP H stands for horizontal. Basically in these commands we lookup for the values in an array.Command Keyword:- VLOOKUP(lookup value, table array, column index number, range lookup).And HLOOKUP((lookup value, table array, row index number, range lookup ).So these are formulas that will provide you flexibility in the excel sheet. This command made it on the 4th position on our list of excel top 10 formula.5. ConcatenateThis command is used to combine the characters of two different cells. This is applicable when we have to combine first name, last name and combining addresses from a huge datasheet.{image, gif}Command Keyword: CONCATENATE(text1, text2, text3…).6. MAX and MINAs the name suggests, the main function of both the commands is to search for the maximum value in a huge table, and the minimum value in a huge table.{image,gif}Command Keyword: ‘MAX(select range)’ and ‘MIN(select range)’.7. ANDThis is one very useful function. The user can use this function to check if any condition is true or false. There could more than one condition.{image,gif}Command Keyword: AND(logic 1, logic 2,…).For example,AND(A1=”GOOD”,C3>5) output would be TRUE if A1 is GOOD and the value of C3 is greater than 5.8. PROPERThis command is useful when you have huge data which is oddly formatted. if a cell has “tiMe iS moNeY” clearly the sentence needs formatting. so the user can use the proper command, for example, =PROPER(cell_number) and it would output a well-formatted sentence in the cell.Command keyword: PROPER(cell no1., cell no2…), or PROPER(cel no1: cell no10).9.Conditional formattingThis command is useful if the user wants to format things with the condition. for example- let’s suppose we have a table or huge data. And in our example figure we students marks and we want to see how many students got less than 50%.Step 1Select the cell range.Step 2Select the conditional formatingStep 3Select the condition greater than or less than in our example we need less than.Step 4: Put the values in the pop-up then click ok.Now the table is highlighting the marks below 50%.10. UPPER, LOWER, TRIM.These commands are useful when the user has huge data that is not well structured and well-formatted. All of these commands define its function. The lower feature has used to convert all the characters in small letters within a cell. The upper feature will convert all the characters in Capital letters within a cell. Trim will remove all the space within a cell.Command keywords:LOWER(cell_number).UPPER(cell number).TRIM(cell number).Conclusion.These are all the excel top 10 formula that everyone should know in order to boost excel skills. Each of these commands is very basic. If you want to start improving your excel skills, then you must concentrate on these basic excel top 10 formula. Each of these commands gets complex as you want to perform more complicated tasks on the excel. The importance will be more clear once you perform these formula by yourself then you will understand why we added them in the list for excel top 10 formula.Original Source[1][1][1][1]Footnotes[1] Excel Top 10 Formula For The MS Excel Beginners - Statanalytica[1] Excel Top 10 Formula For The MS Excel Beginners - Statanalytica[1] Excel Top 10 Formula For The MS Excel Beginners - Statanalytica[1] Excel Top 10 Formula For The MS Excel Beginners - Statanalytica

Excel is the top software for calculating the massive amount of numeric data. In this Information age, excel makes sense for calculating large amounts of data simple. Excel is a part of Microsoft office. Over the years there is much software designed to manipulate, analyze, and visualize data. But Microsoft Excel still remains the most efficient tool if the person has to make sense out of data. In this blog, we have accumulated all the vital information about excel top 10 formula.Also, we add some additional information, such as importance and tips for the beginner. Many beginners waste time by typing formula manually. Just learn this 10 formula and you will be able to work with your excel sheet efficiently.A lot to know a lot to discuss, let’s get started.Most Used Excel top 10 formulaExcel offers 500+ functions but for a regular person or for a corporate person all the functions are not useful. Definitely every function has used for a specific case. But we are left with 10 functions that truly matters to everyone regardless of which profession you are.1. Count, Sum, Average:-These are some of the most useful commands in excel. Everyone who sees a spreadsheet knows while working this visual information person need these command very often and these are some of the basic mathematics formulas.These basic formulas are so important that they made at the top of this excel top 10 formula list.COUNTING OF CELL(Count, Counta).Count:This command is useful when the user wants to count the number of cells that contain numeric values.Command keyword:Count(2,3) =This command will give the number of values in the brackets. For example, in Count(2,3) there are only two values. This command only works with numbers. This command will only work for numeric values.Count(B1, B2, B3…) =This command will give the number of the cells having a numeric value from selected cells specified in the bracket. It will not count the empty cells. This command only works with numbers.Count(B1: B8) =This command will provide the number of values in the range of cells starting from B1, B2, B3…till B8. For example in “Count(B1: B8)” the computer will count the number of cells that contain any value it will not count empty cells.COUNTA(B1: B10) =This command is useful when a user wants to count the number of non-empty cells in a range. This command works with numeric as well as alphabetical or any character. Besides, this command can also be used in these formats for examples such as Counta(B1, B2,…) or Counta(B1: B10) and Counta(2,4,6).Submission of the cells(SUM).This command performs an addition between selected cells or a range of cells. this command is only for numerical values. this command can be used in any format for example SUM(2,3) or SUM(B1, A5) and SUM(B2: B9).SUM(2,3): Sum of numbers specified in the bracket.SUM(A1, B2, C5…): Addition between selected cells only.SUM(C1: C9): Addition in the range of cells.Average:- As its name suggests it provides us with the average of the input numbers. It only calculates an average of the numerical value.2. IF statementThis command is used for conditional output. Using this user can take any output from the computer according to the requirement.Command keyword= IF(logical, output if logic is true, output if logic is false).Let’s suppose an example that a company took a target to increase its turnover in a year then the management can follow strict rules in order to meet the target. They can monitor themselves through an excel sheet using a command like IF(turnover>100cr. Turnover achieved, Turnover not achieved).Then by the end of the year/session, the excel sheet will remind output about the turnover achieved or turnover not achieved.If command very important role and many functions can be performed through it. The importance is so huge that it made on the 2ndposition of our excel top 10 formula.3. SUMIF, COUNTIF, AVERAGEIF.These commands are useful for the user when you want to put a condition on some of the basic commands like adding the data if the condition is fulfilled. Count the data if the condition gets fulfilled, Take an average of the data if the condition is true.Command Keyword: SUMIF(Range, Criteria, {Sum_range}),COUNTIF(Range, Criteria),AVERAGEIF(Range, criteria)Furthermore, these conditional commands are very useful so 3rdPosition in our excel top 10 formulas.4. VLOOKUP & HLOOKUPAs the name of this command it allows users to lookup for a value in an array. In VLOOKUP ‘V’ stands for vertical lookup. Similarly, in HLOOKUP H stands for horizontal. Basically in these commands we lookup for the values in an array.Command Keyword:- VLOOKUP(lookup value, table array, column index number, range lookup).And HLOOKUP((lookup value, table array, row index number, range lookup ).So these are formulas that will provide you flexibility in the excel sheet. This command made it on the 4th position on our list of excel top 10 formula.5. ConcatenateThis command is used to combine the characters of two different cells. This is applicable when we have to combine first name, last name and combining addresses from a huge datasheet.Command Keyword: CONCATENATE(text1, text2, text3…).6. MAX and MINAs the name suggests, the main function of both the commands is to search for the maximum value in a huge table, and the minimum value in a huge table.Command Keyword: ‘MAX(select range)’ and ‘MIN(select range)’.7. ANDThis is one very useful function. The user can use this function to check if any condition is true or false. There could more than one condition.Command Keyword: AND(logic 1, logic 2,…).For example,AND(A1=”GOOD”,C3>5) output would be TRUE if A1 is GOOD and the value of C3 is greater than 5.8. PROPERThis command is useful when you have huge data which is oddly formatted. if a cell has “tiMe iS moNeY” clearly the sentence needs formatting. so the user can use the proper command, for example, =PROPER(cell_number) and it would output a well-formatted sentence in the cell.Command keyword: PROPER(cell no1., cell no2…), or PROPER(cel no1: cell no10).9.Conditional formattingThis command is useful if the user wants to format things with the condition. for example- let’s suppose we have a table or huge data. And in our example figure we students marks and we want to see how many students got less than 50%.Step 1Select the cell range.Step 2Select the conditional formatingStep 3Select the condition greater than or less than in our example we need less than.Step 4: Put the values in the pop-up then click ok.Now the table is highlighting the marks below 50%.10. UPPER, LOWER, TRIM.These commands are useful when the user has huge data that is not well structured and well-formatted. All of these commands define its function. The lower feature has used to convert all the characters in small letters within a cell. The upper feature will convert all the characters in Capital letters within a cell. Trim will remove all the space within a cell.Command keywords:LOWER(cell_number).UPPER(cell number).TRIM(cell number).Conclusion.These are all the excel top 10 formula that everyone should know in order to boost excel skills. Each of these commands is very basic. If you want to start improving your excel skills, then you must concentrate on these basic excel top 10 formula. Each of these commands gets complex as you want to perform more complicated tasks on the excel. The importance will be more clear once you perform these formula by yourself then you will understand why we added them in the list for excel top 10 formula.Original Source[1][1][1][1]Footnotes[1] Excel Top 10 Formula For The MS Excel Beginners - Statanalytica[1] Excel Top 10 Formula For The MS Excel Beginners - Statanalytica[1] Excel Top 10 Formula For The MS Excel Beginners - Statanalytica[1] Excel Top 10 Formula For The MS Excel Beginners - Statanalytica