The color slider The color slider is a successful experiement in Excel 2003. Also, it works great in higher versions of Excel. So, all you have to do is, move the sliders from left or right. After that, the color of the cell changes. Individually, each slider represents a RGB value. One for red, another […]
Column chart on two separate axes for Excel A column chart on two separate axes allows you to scale one side differently from the other. Requirements Microsoft Excel 2007 or higher or compatible. Download Chart library Excel Effects home Charts As you may know, charts help you show data and information to your audience in […]
Column chart with average line for Excel The column chart with average line is a very common chart in many companies. It is a combination chart, just with an average line, going straight across the series. Requirements Microsoft Excel 2007 or higher or compatible. Download Chart library Excel Effects home Charts As you may know, […]
Column chart with scatter line chart for Excel The column chart with scatter line chart for Excel is also known as a combination chart. Requirements Microsoft Excel 2007 or higher or compatible. Download Chart library Excel Effects home Charts As you may know, charts help you show data and information to your audience in a […]
Column row highlighter The column row highlighter is another experiment that works great. It is an Excel tool with no macros. Basically, we like to call that sheet programming. Do not get us wrong, we love code. However, it is a good challenge to try to do things in Excel without coding. So, the way […]
How to create a bar chart in Excel This quick tip shows you how to create a bar chart in Excel. The short video Below is the short video on creating a bar chart in Excel. Now, you may need to maximize the video, to get the full effect of this quick tip. Education home […]
How to create a column chart in Excel This quick tip shows you how to create a column chart in Excel. The short video Below is the short video on creating a column chart in Excel. Now, you may need to maximize the video, to get the full effect of this quick tip. Education home […]
This lesson shows you how to create a game board in Excel. Before we start the frontend part of the project, take a look at the requirements below. Requirements A personal computer, running the Windows operating system with a two button mouse Excel 2007 or higher. We are using Excel 2204 for Office 365. However, […]
Developer ribbon in Excel The developer ribbon (or devbar) in Excel allows you to create code, add more features, insert controls, and work with data. We use the devbar to create dashboards. Overall, these tools help us improve the user experience. How to show developer ribbon in Excel Now, you may not see the devbar […]
Requirements: To use the dynamic yearly calendar, you need Microsoft Excel 2007 or higher or compatible. Download The dynamic yearly calendar The dynamic yearly calendar is an Excel tool that allows you to select a year from 1900 to 2400. When we first developed this tool, everything was going great. However, it did not work […]
This quick lesson shows you how to edit a basic 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. Before we start, you need a macro to edit. We will […]
The EFFECT worksheet function for Excel returns the effective annual interest rate. EFFECT worksheet function Below is the syntax of the EFFECT function. Syntax =EFFECT(Nominal_rate, Npery) Arguments Here are the arguments of the EFFECT function. Argument Description Nominal_rate The nominal interest rate. Npery The number of compounding periods per year. Examples Example 1 Note: For […]
