Julian. S (@JulianExcelTips) profile picture

Excel Trainer & Small time VBA Developer

Malaysia
Joined April 2012
Your horizontal axis in the middle of the chart when you have negative values? You can place it at the bottom. Select your horizontal axis and CTRL+1 to format. Select Lables > Lable position > Select low.
2
In charts, long numbers tend to overlap and it's hard to read. To format a number to millions with 1 decimal place, select your range of numbers > CTRL+1 > Number tab > Custom > Type 0,,.0"M"
4
Splitting your text at the FIRST alphabet using #macros. facebook.com/julian7s/photos…
2
3
Power BI report server need to know. youtu.be/B6OPcxxc7Zk
1
Generating list of power query functions youtu.be/OW2R56_AD_o
2
Using functions to create leading zeroes (totalling 6 characters). In cell B2 enter =TEXT(A2,"000000") but this doesnt work for text. In cell C2 enter =REPT("0",6-LEN(A2))&A2
4
Creating a water mark in #Excel . Check out this you tube video youtube.com/watch?v=Q_vMRi5N…
Using Pivot table to transpose data - check out youtube.com/watch?v=-mzpLg1g…