Microsoft Copilot AI and Excel
9:38
Putting Data on Excel 3D Maps
22:26
21 күн бұрын
Online Web Version of Excel
7:59
21 күн бұрын
Excel's Xlookup Function
9:19
Ай бұрын
Excel's Expand Function
7:53
Ай бұрын
Comparing AI Tools for Excel
12:37
Images in Excel Charts
12:34
Ай бұрын
Excel's Hyperlink Function
11:40
Excel's Let Function
9:56
Ай бұрын
Excel's Image Function
7:24
Ай бұрын
Пікірлер
@Alaminbro83
@Alaminbro83 17 күн бұрын
Hi bro Are you looking for a professional KZbin thumbnail designer and KZbin video SEO expert?
@user-ms1ip1oe7n
@user-ms1ip1oe7n Ай бұрын
excellent and precise explaination Bob. Keep bringing real world examples like this one. they are far more valuable than any other long video that teaches nothing.
@BobFlisser
@BobFlisser Ай бұрын
Thank you so much!
@bulletz2108
@bulletz2108 Ай бұрын
How can i bring excel file to web version and send back to desktop? Can you specify it please, normally i use desktop but when i want to launch web version i am only running the same desktop ms excel, why's that?
@BobFlisser
@BobFlisser Ай бұрын
When you have the web version running, click the File menu, then choose Open Files from this Device. If you don't see that option, click Open and you should hopefully see it there. To bring a file from the web version back to the desktop, go back to the File menu, choose Save As, then choose Download a Copy. If you don't see any of those options, you might be signed in with a free account, rather than a paid account. With a free account, you have to copy & paste back and forth.
@rickmagley
@rickmagley 5 ай бұрын
Wow. I would issue a challenge to reduce the video length. You could have done that in 30 seconds without all the messing about. But thank you for the info. And it doesn't solve the issue of aligning multiple objects on different layers which is what I needed. But thank you anyway.
@radharcanna
@radharcanna 11 ай бұрын
Two great tips there. Thanks Bob.
@ajevans4802
@ajevans4802 Жыл бұрын
What about doing this type of thing to replace the whole cell?
@BobFlisser
@BobFlisser Жыл бұрын
If I understand you correctly, if the middle 3 numbers in one of the part numbers in the Substitute tab is 555, you want to replace the entire sequence with something new. Here is how I would do it, starting from the first row, then auto filling down: =IF(MID(A4,5,3)="555",REPLACE(A4,1,11,9999),A4) This means "If the middle sequence of A4 is 555, replace the entire cell with 9999. Otherwise, replace the entire contents with itself."
@orcunguneser8923
@orcunguneser8923 Жыл бұрын
that was helpful thanks, but still we have go to the select menu. i cant believe they didnt make something easy like "link layers" in photoshop and when you select any layer from that linked/grouped batch you edit them all together... its the same company! why&how photoshop and illustrator are so different in the same tools and same applications, just unbelieveble...
@CartooningGenius
@CartooningGenius Жыл бұрын
Hi Bob, thank you very much for this video - it nearly solves my problem! When I save a file in Illustrator(With say 12 layers.) When I reopen the file, Illustrator has grouped all these layers into one. I can still open all the individual layers but they are all in one big layer: 'layer 1'? Do you have any idea why it would do this? Thanks in advance for your thoughts.
@mike3999
@mike3999 2 жыл бұрын
I know this is a very old video and I was lead here searching for the answer to the question asked in the comments. The only easyish way I have found to centre objects from multiple layers and keep the layer is... taking note of the artboard size if you dont remember it. Selecting the objects, go to Object > Artboard > Fit to selected art. Now the art is in the middle (without stuffing the layers). Then simply put the original artboard size back in making sure the centre reference point is selected.. Stupid workaround but it works. Only 8 years since this video and it still isnt an option I am pretty sure. Hope it helps someone
@BobFlisser
@BobFlisser 2 жыл бұрын
Hi Mike, thanks for contributing! And I don't think that's a stupid workaround -- I use it sometimes, also.
@jacobpalatino1113
@jacobpalatino1113 2 жыл бұрын
great tip!
@ManuelFallas
@ManuelFallas 3 жыл бұрын
Thanks
@spritualdiary
@spritualdiary 3 жыл бұрын
Hey There Bob, thank you so much for this lesson. It is real helpfull. Its saves a lot of time and nuisance. Big thumbs up for you
@lukeMac
@lukeMac 3 жыл бұрын
3:17 Paste without losing layers 6:07 Group without losing layers
@bostongirl555
@bostongirl555 3 жыл бұрын
Brilliant, you saved me huge headaches today, thank you!
@black_baron_net
@black_baron_net 3 жыл бұрын
☠️BLACK BARON☠️ it works with version iOS 12.3.1 but it fails completely with iOS 14.1. Another creative day for nothing since most apps refuse to install on iOS devices because I MUST UPDATE. Gosh, what a catastrophic messi software politics this has become nowadays.
@astikapandey2007
@astikapandey2007 3 жыл бұрын
Will it work on windows 10 please please please please please please please please please please please please please tell please please
@BobFlisser
@BobFlisser 3 жыл бұрын
Sorry for the delay in responding, and unfortunately, it won't. Microsoft deliberately disabled it.
@eldukish
@eldukish 3 жыл бұрын
CLAP thanks!!
@erickcardeno5021
@erickcardeno5021 4 жыл бұрын
Is it still possible to dual booth windows and chrome OS now?
@BobFlisser
@BobFlisser 3 жыл бұрын
Sorry but no. Microsoft disabled this ability. :(
@Rotaks
@Rotaks 4 жыл бұрын
Selection doesn't work, when I want to align a group of objects in different layers. E.g. if you want to align you streets and names of streets - as a whole - in the middle of work sheet you need to group them.
@daniellee8752
@daniellee8752 4 жыл бұрын
6:08
@sudhanshuchatterjee1824
@sudhanshuchatterjee1824 4 жыл бұрын
i am making a vctor portrait and i accidently put all layers like line art, lips ,eyes etc. under one single layer. I didn't noticed it and also saved the document. Is there still a way to undo it?? please help,I dont want to loose my work
@BobFlisser
@BobFlisser 4 жыл бұрын
Objects in Illustrator don't remember the layers they came from. If you don't have enough undo steps, the best you can do is look for a previously saved version or an automatic backup.
@debnathmriganka2010
@debnathmriganka2010 4 жыл бұрын
Sir, Can you help me. How to align two object as a group in a page. Because i cant goup it becaue it will be crean one layer. but i need same as layer.
@BobFlisser
@BobFlisser 4 жыл бұрын
This is a feature people have been asking for Illustrator for a long time. As you may have discovered, if you ungroup, the objects remain on their new layer. They don't retain the information of what layers they came from. The only thing I can suggest is to display the rulers (Ctrl + R or Command + R), drag some ruler guides onto the page, and align the objects manually.
@joshualyle3699
@joshualyle3699 4 жыл бұрын
i love that old google chrome look now it looks worse
@7266355
@7266355 4 жыл бұрын
I'm running Windows 7, does that mean I can't do this?
@anshuaspirant1370
@anshuaspirant1370 4 жыл бұрын
Really appreciate the technique you've shared, but It could have been explained within 1 minute. See the various scenarios you've wasted your time the most describing are not even worth mentioning as people search for such videos after encountering them in the first place.
@black_baron_net
@black_baron_net 4 жыл бұрын
It never ever really worked since years with all those security and system updates changing constantly.
@BobFlisser
@BobFlisser 4 жыл бұрын
Yeah, sometimes iCloud fights its users.
@black_baron_net
@black_baron_net 4 жыл бұрын
@@BobFlisser ☠️BLACK BARON☠️ The IT subject remains BUGGY and COMPLICATED after every single security OS X update PLUS iOS Update.
@BobFlisser
@BobFlisser 4 жыл бұрын
@@black_baron_net Should work the same on both platforms, though I've had better success on the Mac.
@mikecar52
@mikecar52 4 жыл бұрын
how long before this was wrong?
@tk_com
@tk_com 4 жыл бұрын
Thankyou
@fawazjabareen
@fawazjabareen 4 жыл бұрын
Trash
@prakharpandey4543
@prakharpandey4543 4 жыл бұрын
Bro I installed the cloud ready chrome os in my samsung laptop but wanted to install windows back in my laptop can you help me please..
@BobFlisser
@BobFlisser 4 жыл бұрын
In the 6 years since this video, Microsoft disabled the ability to do this. If you want to reinstall Windows, you'll probably have to reformat your hard drive first. :(
@mauricewalker2254
@mauricewalker2254 4 жыл бұрын
Very informative.
@santospoland
@santospoland 4 жыл бұрын
To reduce this down from 8 minutes to a minute, graphicdesign.stackexchange.com/questions/18438/how-to-preserve-layer-settings-when-copying-between-files In summary, in the Layer Panel menu, choose Paste Remembers Layers. Then when you copy/paste between files, other artboards or the same artboard, the layers will remain intact. Thank you for the video, thumbs up.
@AetherOnYT
@AetherOnYT 5 жыл бұрын
too old
@alieichenholz7545
@alieichenholz7545 5 жыл бұрын
Hi Bob, great video! Unfortunately I didn't know the info before working on my file (for 3 days..) Is there a way to ungroup the copied paths and separate each shape??
@BobFlisser
@BobFlisser 5 жыл бұрын
You mean you pasted all onto one layer without remembering layers turned on? Unfortunately, Illustrator doesn't retain memory of what the source layers used to be. :(
@georgemcfaulds9560
@georgemcfaulds9560 5 жыл бұрын
Bob how did you get the option for chrome os in the setting panel?
@BobFlisser
@BobFlisser 5 жыл бұрын
Well......... it was available in Windows 7. No longer available in Windows 10!
@scottjand
@scottjand 4 жыл бұрын
George McFaulds This will not work on Windows 7 anymore.
@kyleladd9216
@kyleladd9216 5 жыл бұрын
But this only works if you’re viewing your tabled on a Mac from your iPhone or ipad. You can’t use your iPad to view tabs from your phone or visa versa?
@johnathansparks1678
@johnathansparks1678 5 жыл бұрын
How to really install a Chrome O/S from Neverware a Cloud Ready O/S takes 20 min.www.neverware.com/freedownload
@jairesemccoy9779
@jairesemccoy9779 5 жыл бұрын
hey sir can you do a video on windows 10 because it doesnt when i do it
@vinitagupta4760
@vinitagupta4760 6 жыл бұрын
Son if a bitch
@GeorgeLangley
@GeorgeLangley 6 жыл бұрын
Doesn't allow you to to align the selection as a single entity. For instance, select all, group, then align to art board - works but everything goes to one layer. Select all, save as selection, then align to art board - aligns every individual object and you lose the original layout. Illustrator NEEDS to be able to group across layers.
@natepocsi-morrison6214
@natepocsi-morrison6214 4 жыл бұрын
This is the problem I came here hoping to solve.
@John-sd6gv
@John-sd6gv 6 жыл бұрын
25/05/18 UK. None of these settings are now active in Chrome. It's not possible to activate Chrome this way.
@aesheticdanielle7979
@aesheticdanielle7979 6 жыл бұрын
Does this work in 2018?
@rosedawn5674
@rosedawn5674 6 жыл бұрын
any one can install google chrome browser and it is not chrome os so why do u try to make people think your installing chrome os when your not
@timothysolly7863
@timothysolly7863 6 жыл бұрын
Seriously bro, God bless you for the tip at 3:37! Exactly what I needed just now!
@BobFlisser
@BobFlisser 6 жыл бұрын
Glad you found it useful! Always happy to help.
@MrAshisjana
@MrAshisjana 6 жыл бұрын
It doesn't work in Windows 10, i tried but its not working.
@AGLOProductsService-AngelLGarc
@AGLOProductsService-AngelLGarc 6 жыл бұрын
I love this, any way I love Chrome!!
@robertkushner156
@robertkushner156 6 жыл бұрын
I don't get it - could you tell me how you installed Chrome OS on your windows machine? What source did you use?
@axolotlotlotl
@axolotlotlotl 6 жыл бұрын
you don't install Chrome OS you just get the Chrome Browser
@robertkushner156
@robertkushner156 6 жыл бұрын
Thanks. I already have the browser (among others) and that sure is a lot easier! I just wanted to experience the "shelf" task bar below as if I had the actual installation. But, now, I see that all I have to do is click on the Google Apps in that box - pretty much the same thing. Thanks!!
@skywalker8898
@skywalker8898 6 жыл бұрын
does it work on win10 ? thanks
@BobFlisser
@BobFlisser 6 жыл бұрын
Yes, it will.
@axolotlotlotl
@axolotlotlotl 6 жыл бұрын
no
@BobFlisser
@BobFlisser 6 жыл бұрын
Yeah, I couldn't find any way to do it, either.
@soyacui6864
@soyacui6864 5 жыл бұрын
Skywalker889 no it doesn't
@chadtv7049
@chadtv7049 5 жыл бұрын
I tried it didn't work
@Triric
@Triric 6 жыл бұрын
YOU ARE MY LORD AND SAVIOR!!!