Reference

## ABS worksheet function for Excel – Reference

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

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

## Color scheme table for Excel

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

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

## Excel functions

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

## Great sites for Excel Effects

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

## LEN worksheet function for Excel – Reference

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

## MID worksheet function for Excel – Reference

Overall, the MID worksheet function in Excel returns the characters from the middle of a text string, given a starting position and length. MID worksheet function Here is the syntax of the MID function. Syntax =MID(Text, Start_num, Num_chars) Arguments Below are the arguments of the MID function. Argument Description Text A text string from which […]