14 December, 2020
09 December, 2020
9 Ways To Add Leading Zeros In Excel
Format As Text
There is an option to change the format of a range to text.
Doing this will treat any data you enter as text values, even if they are numbers. This will cause Excel to keep any leading zeros in your numbers.
Change the format from General to Text.
13 November, 2020
30 Excel shortcut keys that make Excel user friendly
03 November, 2020
3 ways to calculate the correlation coefficient in Excel
If you’ve ever learnt some statistics, then you’ve probably come across the correlation coefficient.
But can you calculate this in Excel?
Yes, you can!
Excel can be a great tool for a statistician when you know how to use it.
In this post, I’ll show you 3 ways to calculate the correlation coefficient in Excel.
What Is A Correlation Coeffecient?
The correlation coefficient is also known as the Pearson Correlation Coefficient and it is a measurement of how related two variables are.
The calculation can have a value between 0 and 1.
A value of 0 indicates the two variables are highly unrelated and a value of 1 indicates they are highly related.
For example, you might have data on height (meters) and weight (kilograms) for a sample of people and want to know if these two variables are related.
04 October, 2020
Replicate Excel’s TRIM Function In Power Query
In this post we’re going to learn how to build a custom query function in power query that will replicate Excel’s TRIM function!
If you find you’re always doing the same transformation or calculation, why not turn it into a function? This can simplify the steps in your query and allow you to re-use a solution.
28 September, 2020
6 New Functions In Excel 2019 And Office 365 You Must Learn
Video Tutorial
27 September, 2020
GIVE YOUR STRIPE PAYMENTS DATA SUPER POWERS!
Free Stripe analytics and KPI's like you've never seen in Excel before.DOWNLOADDashboard

Monthly Recurring Revenue (MRR)

Net Revenue

Active Customers

And More...
#evba #etipfree #eama #kingexcel
📤How to Download ebooks: https://www.evba.info/2020/02/instructions-for-downloading-documents.html?m=1
21 September, 2020
11 August, 2020

Excel Number to Words Formula
Excel 2020: Quickly Convert Formulas to Values


For Those Who Prefer Using the Mouse
- Select the data.
- Go to the right edge of the selection box.
- Hold down the right mouse button while you drag the box to the right.
- Keep holding down the right mouse button while you drag the box back to the original location.
- When you release the right mouse button, in the menu that pops up, select Copy Here As Values Only.

For Those Who Prefer Using Keyboard Shortcuts

📤How to Download ebooks: https://www.evba.info/2020/02/instructions-for-downloading-documents.html?m=1
#evba #etipfree #eama #kingexcel
📤How to Download ebooks: https://www.evba.info/2020/02/instructions-for-downloading-documents.html?m=1
08 August, 2020
03 August, 2020
How to create area chart with up / down colors?Area chart with positive / negative colors

How to create area chart with up / down colors?
- Data with positive & negative values.
- optional: A cup of coffee or a cold beverage of your choice.


The last step: Setting two color gradient
- Create 4 gradient stops (most of the default gradient settings have 4 stops)
- Set stop 1 & 2 to positive color (say blue)
- Stop 3 & 4 to negative color (say red)
- Adjust the position of 2 & 3 to the gradient stop calculation you have done earlier.
- Make sure Gradient is linear with 90 degrees

Watch video tutorial: Area chart with positive / negative colors
Download Example File
📤How to Download ebooks: https://www.evba.info/2020/02/instructions-for-downloading-documents.html?m=1
01 August, 2020
Excel 2020: Discover New Functions by Using fx





Once you finish the required arguments, the Function Arguments dialog shows you the answer in two places. I always use this as a sanity check. Does this answer sound like a typical car payment?
=PMT(
with the opening parenthesis and then press Ctrl+A.📤How to Download ebooks: https://www.evba.info/2020/02/instructions-for-downloading-documents.html?m=1
23 July, 2020

Video - Top 10 Excel formulas for IT people
19 July, 2020
Top 10 reasons to learn Excel formulas
📤How to Download ebooks: https://www.evba.info/2020/02/instructions-for-downloading-documents.html?m=1