Reference

Reference

All the languages list in Excel

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

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 Effect – Using Excel to create great things

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

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


Careerist

Join our QA complete training program and save up to 40%!

Careerist

 

Affiliate stuff – Move up and excel with Excel