How to Use SUMIF in Excel 2013 The SUMIF feature in Excel 2013 is a handy tool that allows users to add up values in a range of cells. However, it is different from the regular AutoSum feature that you are probably familiar with in the sense that you can set up a certain criteria […]
Category: Excel 2013
How to Create a Dropdown List in Excel 2013
How to Create a Dropdown List in Excel 2013 It is useful to learn how to create a dropdown list in Excel 2013 if you regularly engage in data entry and wish to save a whole lot of time. If you constantly have to enter in similar data, how much easier would be it if […]
How to use Cell Comments in Excel 2013
How to use cell comments in Excel 2013 If you learn how to use cell comments in Excel 2013, editing your spreadsheets could become a lot easier. This feature is particularly useful when multiple people are required to work on the same spreadsheet since they can leave their thoughts on it without having to actually […]
How to use Conditional Formatting in Excel 2013
How to use Conditional Formatting in Excel 2013 Conditional formatting is a useful feature that has been inserted into Excel 2013. If you learn how to use conditional formatting in Excel 2013, you will be able to sort out your data with unprecedented ease. This feature allows you to filter out data according to your […]
How to Filter Data in a Table in Excel 2013
How to Filter Data in a Table in Excel 2013 Learning how to filter data in a table in Excel 2013 is extremely useful. If you learn this useful trick, you can sort out and view only that data which is relevant to you at any given time. This is particularly useful when you have […]
How to Record Macros in Excel 2013
How to Record Macros in Excel 2013 Macros are extremely useful for users who perform repetitive tasks in spreadsheets. This guide on how to record macros in Excel 2013 will walk you through the process of setting up your own macro for your spreadsheet. A macro is a small program that records your keystrokes while […]
How to Create a PivotTable in Excel 2013
How to Create a PivotTable in Excel 2013 PivotTables are a great way to summarize your data. Many people shy away from using them because they don’t know how to create a PivotTable in Excel 2013. This step-by-step guide on how to create a PivotTable in Excel 2013 will help you make use of this […]
How to Use Flash Fill in Excel 2013
How to Use Flash Fill in Excel 2013 If you have entered data into a worksheet table column and want to enter the same data into another column, you don’t have to bother typing its contents all over again. Once you learn how to use Flash Fill in Excel 2013, you can, with the help […]