Excel functions list Below are the list of Excel functions in alphabetical order. Function name Type and description ABS function Math and trigonometry: Returns the absolute value of a number ACCRINT function Financial: Returns the accrued interest for a security that pays periodic interest ACCRINTM function Financial: Returns the accrued interest for a security that pays interest at […]
Fun with macros So, fun with macros is a set of learning tools that teach you to code and create great stuff in Excel. The basics Although we have a basics section, we do not plan to put our lessons in categories. Instead, when you learn to create code in Excel, you will realize, you […]
The GendPop app (or GP) is a tool that allows you to compare gender-based data. GendPop app – Online version Requirements So, to use GP, all you need is an Internet connection and a browser. Click on the link below to start creating with the GP online app. GendPop online Working with GendPop When you […]
Getting to know all about us. Getting to know us So, we officially started Excel Effects in August 2015 in New York City. At Excel Effects, we develop software, data tools, games, and other creative stuff. In addition, we make tools that make it easier for you to use and analyze data. Moreover, we want […]
The Google courses in this section of Excel Effects are from our affiliates. Google courses Google Sheets Sheets is a free program that allows you to create and edit spreadsheets online. Also, you can save your work online and open it up in almost any location. Moreover, share your work with others, including coworkers, friends, […]
The great sites Below are some great sites where you can get help on topics related to Excel and Excel Effects. Excel Tip Excel Tips ExcelDemy ExcelFunctions.net Exceljet Microsoft Excel Support Mr. Excel SpreadsheetWEB Help us build this list If you know a site that would fit this list, then feel free to contact us […]
Hearts column sheet chart The hearts column sheet chart is a graph that is designed on a worksheet in Excel. Although it is somewhat unique, it is not uncommon. So, just imagine all the stuff you can do with sheet charts. Good stuff! Keep in mind, we include a movable chart within the sheet. This […]
Hearts row sheet chart The hearts row sheet chart is a graph that is designed on a worksheet in Excel. Although it is somewhat unique, it is not uncommon. So, just imagine all the stuff you can do with sheet charts. Good stuff! Keep in mind, we include a movable chart within the sheet. This […]
This tutorial shows you how to create a hello world macro in Excel. For the purpose of this lesson, we go through the steps on a PC running the Windows operating system. In addition, these steps should work perfectly in Excel 2007 or higher. A macro is a set of commands or actions that make […]
Keep the size and position of an object in Excel This quick tip video shows you how to keep the size and position of an object in Excel. So, whenever you resize a column or row in Excel, the object under that position may move or change in size. Depending on what you want to […]
The LEN worksheet function in Excel returns the number of characters in a text string. LEN worksheet function Here is the syntax of the LEN function. Syntax =LEN(reference) Arguments Reference – A text string or cell range. Example(s) Example 1 Example 2 Example 3 Excel functions Reference home Excel Effects home
Line chart with high low bars for Excel Sometimes, you may see a line chart like this on TV, on business channels. Now, the high-low bars may look different. But, it is the same concept. Requirements Microsoft Excel 2007 or higher or compatible Download Chart library Excel Effects home Charts As you may know, charts […]
