Reference

Reference

ASCII character code table – Reference guide

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 […]

Basic Excel operators – How-to snapshot

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 […]

Column row highlighter โ€“ Conditional formatting experiment

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 […]

Data visualization examples

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 – Quick glance

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 […]

EFFECT worksheet function for Excel

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 […]