Julian. S (@JulianExcelTips) profile picture

Julian. S

@JulianExcelTips

Excel Trainer & Small time VBA Developer

 Malaysia
angelfire.com/biz7/julian_s/julian/julians_macros.htm
Joined April 2012
  • Tweets1.2K
  • Following26
  • Followers3K
9Media
Photo by Julian. S (@JulianExcelTips)Photo by Julian. S (@JulianExcelTips)Photo by Julian. S (@JulianExcelTips)Photo by Julian. S (@JulianExcelTips)
Need to create a unique list from a list of repeated items? Use UNIQUE function from M365 facebook.com/photo/?fbid=224…
Excel - EXCEL 365 has some cool functions which is NOT available in...

Excel - EXCEL 365 has some cool functions which is NOT available in...

EXCEL 365 has some cool functions which is NOT available in other versions. It really makes life so much easier for beginners. Let's say I need to...

facebook.com
2
Need to filter COLUMNS instead of ROWS in Excel? Use M365 FILTER function facebook.com/photo/?fbid=219…
Excel - Can I filter my data horizontally? That was one of the...

Excel - Can I filter my data horizontally? That was one of the...

Can I filter my data horizontally? That was one of the questions from my coaching session. Unfortunately directly you can't. However you can try to...

facebook.com
1
Need to generate a series of numbers? There are lots of ways of doing this. However in Excel 365, this is super easy. facebook.com/photo/?fbid=217…
Excel - Need to generate a series of numbers? There are lots of ways...

Excel - Need to generate a series of numbers? There are lots of ways...

Need to generate a series of numbers? There are lots of ways of doing this. However in Excel 365, this is super easy. Older version of Excel, sorry la....

facebook.com
1
XLOOKUP the good, the bad & the ugly. Many say good things about this Excel formula but you be the judge facebook.com/photo/?fbid=217…
Excel - XLOOKUP the good, the bad & the ugly. Many say good things...

Excel - XLOOKUP the good, the bad & the ugly. Many say good things...

XLOOKUP the good, the bad & the ugly. Many say good things about this Excel formula but you be the judge. Scenario, I need to know Diana's staff ID. So...

facebook.com
1
Need to generate some random values? Maybe for testing purposes or providing some dummy data for consultants. facebook.com/photo/?fbid=212…
Excel - Need to generate some random values? Maybe for testing...

Excel - Need to generate some random values? Maybe for testing...

Need to generate some random values? Maybe for testing purposes or providing some dummy data for consultants. Try Excel's random generator. To generate...

facebook.com
1
Need to create a stacked column chart with lables showing totals? facebook.com/photo/?fbid=209…
Excel - Need to create a stacked column chart with totals? You need a...

Excel - Need to create a stacked column chart with totals? You need a...

Need to create a stacked column chart with totals? You need a little magic to pull this off. Here's how. 1. Make sure you have the totals. 2. Insert a...

facebook.com
How to use Table Reference instead of cell reference. facebook.com/photo/?fbid=207…
Excel - How to use Table Reference instead of cell reference. To...

Excel - How to use Table Reference instead of cell reference. To...

How to use Table Reference instead of cell reference. To convert a range of data to an Excel table is easy. Select your range and CTRL + T (a handy key...

facebook.com
1
wow... but only for M365 techcommunity.microsoft.com/…
Announcing LAMBDA Helper Functions

Announcing LAMBDA Helper Functions

Excel has new LAMBDA functions

techcommunity.microsoft.com
1
Got pesky errors in Excel formulas? #N/A! , #DIV/0! and #VALUE! are the common ones. facebook.com/photo/?fbid=201…
Excel - Got pesky errors in Excel formulas? #N/A! , #DIV/0! and...

Excel - Got pesky errors in Excel formulas? #N/A! , #DIV/0! and...

Got pesky errors in Excel formulas? #N/A! , #DIV/0! and #VALUE! are the common ones. How do you get rid of these errors? No doubt leaving the errors...

facebook.com
Do you think "Logically" or "Creatively"? Let's look at a simple scenario where you need to extract the LAST word in a text. facebook.com/photo/?fbid=200…
Excel - Do you think "Logically" or "Creatively"? There are so many...

Excel - Do you think "Logically" or "Creatively"? There are so many...

Do you think "Logically" or "Creatively"? There are so many ways you can use Excel. Some ways are simpler than others. Let's look at a simple scenario...

facebook.com
How do you handle multiple conditions in Excel? Are you still using nested IF? Check out IFS or SWITCH facebook.com/photo/?fbid=199…
Excel - How do you handle multiple conditions in Excel? Are you still...

Excel - How do you handle multiple conditions in Excel? Are you still...

How do you handle multiple conditions in Excel? Are you still using nested IF (the IF within IF)? That's is a lot of brackets and commas in your formula....

facebook.com
1
1
When a chart contains redundant information it is noise. facebook.com/photo/?fbid=193…
Excel - When a chart contains redundant information it is noise....

Excel - When a chart contains redundant information it is noise....

When a chart contains redundant information it is noise. Consider the chart on the left. Let's look at the elements individually. - Legend > Not required...

facebook.com
Need to convert dates in yy-mm-dd format with a formula? When the year is in 2 characters, your formula could FAIL (000416 could be year 1900 or 2000). facebook.com/photo?fbid=1884…
Excel - Need to convert dates in yy-mm-dd format with a formula? When...

Excel - Need to convert dates in yy-mm-dd format with a formula? When...

Need to convert dates in yy-mm-dd format with a formula? When the year is in 2 characters, your formula could FAIL (000416 could be year 1900 or 2000)....

facebook.com
Windows 11 update? cnet.com/news/windows-11-rel…
Some simple text functions to extract information from a text facebook.com/photo?fbid=1851…
Excel - Need information from data? A nice word would be Analytics or...

Excel - Need information from data? A nice word would be Analytics or...

Need information from data? A nice word would be Analytics or Data Mining. Ever selected a training because of the "Title"? I know I have. Let's look a...

facebook.com
Has anyone paid you but they never gave details to which invoices they are paying for? Use Solver facebook.com/photo?fbid=1718…
1
How to extract day, hrs & mins from a text "1 day 23 hrs 59 mins" facebook.com/photo?fbid=1611…
Excel - The system generates duration as shown in column A. You need...

Excel - The system generates duration as shown in column A. You need...

The system generates duration as shown in column A. You need to get Days, Hours & Minutes in separate columns to perform calculations. Most people will...

facebook.com
Which chart should I choose? Which is the best? My answer is, it depends on the story you want to tell. facebook.com/photo?fbid=1598…

Excel - Which chart should I choose? Which is the best? My answer is...

Which chart should I choose? Which is the best? My answer is it depends. It depends on the story you want to tell. Here is a simple guide. If you want...

facebook.com
How do you get rid of invisible characters (which may not be a space) in your Excel data? facebook.com/photo?fbid=1452…
Excel - When you get data from websites or certain systems, there...

Excel - When you get data from websites or certain systems, there...

When you get data from websites or certain systems, there could be invisible characters in your data which may not be a space (using the space bar). How...

facebook.com
There are many ways to make your chart look good. I will just list only 3. facebook.com/photo?fbid=1439…
Excel - There are many ways to make your chart look good. I will just...

Excel - There are many ways to make your chart look good. I will just...

There are many ways to make your chart look good. I will just list only 3. The chart on the left is the default chart you will get in Excel. 1. Give...

facebook.com

No more items