• Excel IF Function – A Guide for Teachers and Beginners

    Today, I will show you how to make a scorecard in Excel and use the IF Function to calculate the scores automatically. We have a list of students who have all completed our test. If the student has scored more than 80 points, we should fill the results column with “Pass”; if they score less…

  • Convert Vertical Data Into Horizontal Data in Excel

    Convert Vertical Data Into Horizontal Data in Excel

    Introduction How do you convert vertical data into horizontal data in Excel? This was a question I was asked this week. A friend of mine was asked to convert an Excel spreadsheet that contained a list of classes and their students from one long column of text to rows of classes and their students. What…