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 […]
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 […]
Firstly, when we start a design or project in Excel, we look at it as a blank canvas. It is such a beautiful thing. Reference guide Education home Excel Effects home
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 […]
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 […]
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 […]
Fun with macros So, fun with macros is a set of learning tools that teach you to code and create great stuff in Excel. The basics Although we have a basics section, we do not plan to put our lessons in categories. Instead, when you learn to create code in Excel, you will realize, you […]
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 […]
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
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 […]
Chart library Area charts Bar charts Bubble charts Column charts Combo charts Donut charts Line charts Math charts Pie charts Scatter charts Sheet charts Special charts
Learn new things or improve on the skills you already have.
