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)
How much data can you load into #PowerBI ? blog.crossjoin.co.uk/2022/11…
4
26
60
Julian. S retweeted
Elon Musk (@elonmusk) profile picture
Elon Musk
@elonmusk9 Dec 2022
Twitter will soon start freeing the name space of 1.5 billion accounts
13,114
27,236
7,253
343,510
Import data from a picture to #Excel. Works with pictures from a file, or the clipboard, and loads it to the spreadsheet. youtu.be/f94JJLVbZhU?rel=0 #MicrosoftAmbassador
Image from MyOnlineTrainingHub (@OnlineTrainingH)
5
12
Many people underestimate Microsoft's PDF tools. Edge is a free, lightweight, and secure PDF reader with great annotation/highlight/text tools; Word is a fantastic PDF editor, that can fix things Acrobat can't in documents you may receive; And the built-in PDF writer works well.
2
9
29
watching a newbie use excel
27
204
47
1,519
#Excel Hash Sign Operator - What is it + ADVANCED Tricks you won't find in Microsoft's documentation: youtu.be/1ios50O45-M?rel=0
Image from MyOnlineTrainingHub (@OnlineTrainingH)
2
4
7 reasons DAX is not easy are now in video. Enjoy #dax! youtu.be/xCs6-w2A3Rs
Image from Marco Russo (@marcorus)
5
25
5
117
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
Julian. S retweeted
Bill Jelen (@MrExcel) profile picture
Bill Jelen@MrExcel29 Jul 2021
If someone with vision issues opens your workbook, the navigation pane will make it easier for them to find the important content.
Microsoft Excel (@msexcel) profile pictureMicrosoft Excel
@msexcel29 Jul 2021
We want #Excel to be delightful and easy to use—for everyone! With the new navigation pane, users will be able to find content more efficiently, navigate between different worksheets and objects faster, and more. Get the details: msft.it/6016nWodu
3
10
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
Julian. S retweeted
Tom Urtis (@TomUrtis) profile picture
Tom Urtis@TomUrtis25 Jul 2021
Showing how to stop seeing those annoying menu floaties! #AskTomUrtis
Image from Tom Urtis (@TomUrtis)
5
16
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...

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
Load more