Julian. S
@JulianExcelTips
Excel Trainer & Small time VBA Developer
Twitter will soon start freeing the name space of 1.5 billion accounts
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?re… #MicrosoftAmbassador
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.
watching a newbie use excel
#Excel Hash Sign Operator - What is it + ADVANCED Tricks you won't find in Microsoft's documentation: youtu.be/1ios50O45-M?re…
Need to create a unique list from a list of repeated items? Use UNIQUE function from M365 facebook.com/photo/?fbid=22…
Need to filter COLUMNS instead of ROWS in Excel? Use M365 FILTER function facebook.com/photo/?fbid=21…
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=21…
XLOOKUP the good, the bad & the ugly. Many say good things about this Excel formula but you be the judge facebook.com/photo/?fbid=21…
Need to generate some random values? Maybe for testing purposes or providing some dummy data for consultants. facebook.com/photo/?fbid=21…
Need to create a stacked column chart with lables showing totals? facebook.com/photo/?fbid=20…
If someone with vision issues opens your workbook, the navigation pane will make it easier for them to find the important content.
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
How to use Table Reference instead of cell reference. facebook.com/photo/?fbid=20…
wow... but only for M365 techcommunity.microsoft.com/t5/excel-blog/…
techcommunity.microsoft.com
Announcing LAMBDA Helper Functions
Excel has new LAMBDA functions
Got pesky errors in Excel formulas? #N/A! , #DIV/0! and #VALUE! are the common ones. facebook.com/photo/?fbid=20…
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=20…
How do you handle multiple conditions in Excel? Are you still using nested IF? Check out IFS or SWITCH facebook.com/photo/?fbid=19…
United States الاتجاهات
- 1. Mark Pope 1,447 posts
- 2. Derek Dixon N/A
- 3. Brunson 7,075 posts
- 4. Knicks 13.4K posts
- 5. Jaylen Brown 7,366 posts
- 6. Celtics 14.6K posts
- 7. Kentucky 28.1K posts
- 8. Notre Dame 36.8K posts
- 9. Caleb Wilson N/A
- 10. Duke 28.9K posts
- 11. Miami 96.4K posts
- 12. Jordan Walsh 1,049 posts
- 13. UConn 8,542 posts
- 14. Braylon Mullins N/A
- 15. Van Epps 128K posts
- 16. Bama 23.8K posts
- 17. #kubball 1,171 posts
- 18. #WWENXT 11.5K posts
- 19. Tennessee 215K posts
- 20. Hubert Davis N/A
Something went wrong.
Something went wrong.