In Excel, the ABS worksheet function returns the absolute value of a number, a number without its sign. Basically, the absolute value of a number shows a value of zero or higher. For example, the absolute value of -34 is 34. If you analyze it, then you can view the distance of a number from […]
This tool has all the languages you need to create something nice in Excel. All the languages list At first, we thought of this as an experiment. However, it is fully operational. Therefore, you can use it in any fashion you like. Again, it contains all the languages. Also, when you add or remove a […]
Note: This is a quick reference guide about the ASCII table, not a tutorial. The ASCII character code table So, the ASCII character code table is a set of characters that we use in coding. In addition, it is a great way exchange info to others in a coded way. Of course, you should use […]
This quick how-to snapshot shows you basic Excel operators that you use in spreadsheet development and analysis. Please pay attention to the table and not the chart holder. Overview of basic Excel operators So, the main operators to use in spreadsheets are: assignment, addition, subtraction, multiplication, division, power, and concatenation. Keep in mind, we are […]
This quick snapshot shows you how to change chart x-axis number format. Snapshot to change chart x-axis number format Below is the snapshot card showing you how to change millions to thousands, without modifying any data on the spreadsheet. Everything is done on the chart, retaing the data. Excel is the main vehicle for this […]
Color scheme table If we recall, then this table is from the original Excel 2007 color scheme. The standard colors may be different today. So, feel free to download it and update it for your own purposes. The good part about this table is that you get to view the darker and lighter versions of […]
Brief overview of the column row highlighter The column row highlighter is an experiment in conditional formatting. Moreover, we developed it as an Excel tool without macros. Basically, we like to call that sheet programming. Do not get us wrong, we love coding. But, it is a good challenge to try to do things in […]
The CONCAT worksheet function for Excel allows you to combine multiple ranges of text strings. CONCAT is short for concatenate. Overview of CONCAT worksheet function So, the main key word in the purpose of CONCAT is ranges, which means, CONCAT works as an array function. In other words, you can check values one-by-one within a […]
This snapshot how-to shows you how to create formula from math function. Remember, snapshots are just quick snippets or screenshots of a task. How to create formula from math function Below are the step-by-step instructions on turning a basic math function into a workable formula for computing. Feel free to copy this huge image to […]
Our data visualization examples show you different and creative ways you can show information to your audience. Creative data visualization GendPop examples These examples show you how you can use GendPop to creatively display information. With GendPop, you get to save your creative chart as a SVG file. Meaning, you can open it in almost […]
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 […]
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 […]
