Introduction Excel formulas are powerful tools that can help you accomplish complex tasks in your spreadsheets. In order to harness the full power of formulas, it's important to understand how each component of a formula works, This article will focus on the $ symbol and explain how it's used to indicate absolute cell references in […]

Introduction In part 1 of this article we learned the basics of using Excel formulas to multiply. In this article we'll build upon this knowledge. We will again site examples and put this method into practice by performing some exercises which will demonstrate the process step by step. Let us understand what is a PRODUCT […]

Introduction We are going to enumerate different methods we can use to multiply using excel formulas, let us site examples on each method to make sure we cover everything about how to use multiplication in excel. Before we go ahead and discuss multiplication let us first understand the different symbol of mathematical operators in Excel. […]

Introduction This tutorial will demonstrate how to use the Excel SUM formula. We have some recommended prerequisites but you can dive straight into the content wherever you feel comfortable. Prerequisites Make sure you have Microsoft Excel installed. Installation will depend on your specific operating system. Open Excel and create a new worksheet. Once you've opened […]

Introduction You may not even realize it, but the numbers you see in your Excel spreadsheet might be text representations of numbers, not numeric values. How do you know if this is the case? It's fairly easy to spot text representations of numbers-- if you try to use these values in formulas and get errors […]

Introduction In Microsoft Excel, a named range refers to a range of cells to which a user has assigned a particular name. The ability to name a range is a handy feature of Excel that is often overlooked. Named ranges can simplify a complex spreadsheet or macro and make your formulas easier to understand. In […]

Introduction If you need to organize and arrange column in a spreadsheet, Microsoft Excel makes it easy to get the job done. Whether you added data to a column by mistake or simply wish to move a column of data to a different location, there are a number of ways you can shift columns in […]

Introduction Excel provides a variety of financial functions that make it easy to generate the reports you need. The Excel PMT function can be used to calculate the periodic payment needed to pay off a loan. This function allows you to determine the amount of the monthly or other periodic payment as long as the […]

Introduction Pie charts offer a simple way to visualize proportions and percentages in your data, with each "pie slice" representing one of those percentages. Microsoft Excel makes it easy to generate pie charts from your spreadsheet data. In this article, we'll walk you through the process of creating an Excel pie chart and saving that […]

Introduction Microsoft Excel provides a variety of functions that can be used to work with dates. Each function performs a simple operation; if you combine multiple functions within one formula, you can tackle more complex tasks. In this article, we'll talk about how to use functions in Excel for date formulas and provide some examples […]