Excel Effect – Using Microsoft Excel (or Excel) to create great things. Showing off the Excel effect This page shows you some of the great things that we do in Excel. Moreover, it will inspire you to create Excel effects of your own. Now, these examples will be either in video form or an image. […]
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 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 […]
Link a cell to a shape This quick tip video shows you how to link a cell to a shape in Excel. You know what is funny, sometimes we actually want to use macros to do things. However, you do not necessarily have to use macros to do things. The video So, we have two […]
This quick video tip shows you how to link cells to fancy balls in Excel. Those balls look good! Just imagine what you had to do in the old days to accomplish this task. Link cells to fancy balls So, what we want to do is have a set of balls update when we update […]
