How to Use Highest & Lowest Functions in Excel 2013 Although it is quite easy to locate highest or lowest numbers in small spreadsheets, it becomes useful to learn how to use highest & lowest functions in Excel 2013 if you are dealing with spreadsheets containing a large amount of data. Luckily, Excel 2013 is […]
How to Insert a Screenshot in Excel 2013 If you are an avid user of Excel 2013, you have probably run into situations where you need to insert screenshots into your workbook. Unfortunately, most people don’t know that Excel 2013 comes with a purpose-built feature that makes it much easier to add screenshots to your […]
How to Add Trendlines to a Chart in Excel 2013 Trendlines are a great way to analyze data contained in a chart. If you learn how to add trendlines to a chart in Excel 2013, you will not have to worry about having to read complicated charts or extensive raw data. You can get a […]
How to Create a List of Random Numbers in Excel 2013 You never know when you will need a list of random numbers in life, which is why it can’t hurt to learn how to create a list of random numbers in Excel 2013. Whether you just want to create a list of random numbers […]
How to Create Lookup Formulae with Multiple Criteria in Excel 2013 If you often find yourself dealing with large spreadsheets, learning how to create lookup formulae with multiple criteria in Excel 2013 will save you a lot of time. Once you learn how to create lookup formulae with multiple criteria in Excel 2013, you will […]
How to Use HLOOKUP Function in Excel 2013 This Tutorial will walk you through how to use HLOOKUP Function in Excel 2013. This powerful tool makes searching specific details in a spreadsheet easier than ever before. Many people shy away from learning how to use HLOOKUP function in Excel 2013 because they fear it is […]
How to Use VLOOKUP Function in Excel 2013 You might know how to use the Find feature in Excel 2013, but it is not always effective when you want to find very specific information from large tables. Learning how to use VLOOK UP Function in Excel 2013 would be particularly beneficial in such an instance, […]
How to Freeze Panes in Excel 2013 Working with large amounts of data can be overwhelming. If you constantly have to compare data on two extreme sides of a large spreadsheet, you don’t need to worry about constantly scrolling from one side to another if you learn how to freeze panes in Excel 2013. More […]
How to Compare Worksheets in Excel 2013 Comparing spreadsheets with a lot of data can be confusing if one does not know how to compare worksheets in Excel 2013. This innovative feature lets you place multiple worksheets side-by-side so that you can compare and analyze them with unprecedented ease. This means you don’t have to […]
How to use the Scale-to-Fit Printing Option in Excel 2013 Those of you who have tried to print an Excel spreadsheet before probably already realize the benefits of learning how to use the scale-to-fit printing option in Excel 2013. Due to the nature of spreadsheets, it can be tricky getting those last few rows and […]