![Bob Flisser](/img/default-banner.jpg)
- Видео 36
- Просмотров 109 868
Bob Flisser
США
Добавлен 2 окт 2011
Video author for lynda.com, Pluralsight, Skillsoft, Tuts+ and Udemy. Web developer, science geek, Whovian, dragon boat racer and kayaker.
Blog: www.flisser.com
Blog: www.flisser.com
Excel's What-If Analysis Tools
Online course: Excel 365 for Busy People
www.udemy.com/excel90min
Corporate training for Excel and other Microsoft and Adobe applications:
ComputerTraining.Live
Between the Sheets, Episode 52: Excel's What-If Analysis Tools
Excel is great not just for recording numbers that happened in the past like sales and expenses you already made, but also for figuring out the future. You might need to decide which car to buy or where you get the best deal on printing or how many people to hire. All these decisions have variables you need to figure out and see how they interact. That’s what Excel’s what-if tools are for.
www.udemy.com/excel90min
Corporate training for Excel and other Microsoft and Adobe applications:
ComputerTraining.Live
Between the Sheets, Episode 52: Excel's What-If Analysis Tools
Excel is great not just for recording numbers that happened in the past like sales and expenses you already made, but also for figuring out the future. You might need to decide which car to buy or where you get the best deal on printing or how many people to hire. All these decisions have variables you need to figure out and see how they interact. That’s what Excel’s what-if tools are for.
Просмотров: 1
Видео
Photoshop AI vs. Midjourney: Which Should You Use?
Просмотров 70День назад
Online course: Become a Photoshop Expert in a Day by Mastering Layers www.udemy.com/photoshop-layers Online course: Excel 365 for Busy People www.udemy.com/excel90min Corporate training for Photoshop and other Adobe applications and for Excel and Microsoft Office: www.ComputerTraining.Live Midjourney is one of the best AI image generators, and Adobe is introducing AI image generation into Photo...
Excel's Scan Function
Просмотров 175День назад
Online course: Excel 365 for Busy People www.udemy.com/excel90min Corporate training for Excel and other Microsoft and Adobe applications: ComputerTraining.Live Between the Sheets, Episode 53: Excel's New Scan Function Creating a running total is a common task but it can get complicated. So Microsoft is introducing a function to streamline it: the Scan function for both the Windows and Mac vers...
Inserting Checkboxes in an Excel Worksheet
Просмотров 13День назад
Online course: Excel 365 for Busy People www.udemy.com/excel90min Corporate training for Excel and other Microsoft and Adobe applications: ComputerTraining.Live Between the Sheets, Episode 54: If you ever wanted to insert a checkbox in an Excel worksheet, you know it wasn’t easy or straightforward. But now it is! The Windows edition of Excel 365 now has a checkbox object you can insert just lik...
Automatic Calculations in Excel
Просмотров 105День назад
Online course: Excel 365 for Busy People www.udemy.com/excel90min Corporate training for Excel and other Microsoft and Adobe applications: ComputerTraining.Live Between the Sheets, Episode 55: Another excellent feature Microsoft added to Excel is automatic calculations! It doesn’t mean you don’t have to write any formulas anymore, but it can figure out some of them for you, and not only simple ...
Groupby & Pivotby Excel Functions
Просмотров 94День назад
Online course: Excel 365 for Busy People www.udemy.com/excel90min Corporate training for Excel and other Microsoft and Adobe applications: ComputerTraining.Live Between the Sheets, Episode 56: You will now be able to create Excel pivot tables with a function! That means they will be dynamic, more portable and more flexible. The functions are called Groupby and Pivotby, and they are very similar...
ChatGPT vs Google Bard in Excel
Просмотров 8День назад
Comparing ChatGPT vs Google Bard in Excel Online course: Excel 365 for Busy People www.udemy.com/excel90min Corporate training for Excel and other Microsoft and Adobe applications: ComputerTraining.Live Between the Sheets, Episode 56: More AI tests! We test ChatGPT 4 and Google Bard to see if they can solve one easy and one difficult Excel problem.
Creating Excel Pivot Tables from Multiple Tables
Просмотров 140День назад
Online course: Excel 365 for Busy People www.udemy.com/excel90min Corporate training for Excel and other Microsoft and Adobe applications: ComputerTraining.Live Between the Sheets, Episode 57: In the Windows editions of Excel, you can create Pivot Tables from multiple tables as the source. They can be in the same workbook or in separate workbooks. In this episode, you’ll learn how to do it.
Creating Bubble Charts in Excel
Просмотров 10День назад
Online course: Excel 365 for Busy People www.udemy.com/excel90min Corporate training for Excel and other Microsoft and Adobe applications: ComputerTraining.Live Between the Sheets, Episode 58: Bubble charts let you sneak three dimensions of data onto a page. In addition to the chart having standard X and Y values, each piece of data is a bubble or circle. Higher values produce larger bubbles an...
Present value in Excel
Просмотров 2314 дней назад
Online course: Excel 365 for Busy People www.udemy.com/excel90min Corporate training for Excel and other Microsoft and Adobe applications: ComputerTraining.Live Between the Sheets, Episode 59: Calculating present value tells you what it’s worth today to receive a dollar at a specific time in the future. That’s because money has a time value. In this video, we look at two related functions: Pres...
Desert island shortcuts for Excel
Просмотров 1414 дней назад
Online course: Excel 365 for Busy People www.udemy.com/excel90min Corporate training for Excel and other Microsoft and Adobe applications: ComputerTraining.Live Between the Sheets, Episode 60: If I were stranded on a desert island and could have only 9 Excel shortcuts with me, these are the ones I would want.
Use Excel's Cell function to return metadata about your worksheet
Просмотров 4614 дней назад
Online course: Excel 365 for Busy People www.udemy.com/excel90min Corporate training for Excel and other Microsoft and Adobe applications: ComputerTraining.Live Between the Sheets, episode 61: Cell function Excel’s Cell function returns metadata about your worksheet or individual cells. Use it to collect information like cell formatting, file name and location and other particulars.
Regular Expressions functions in Excel
Просмотров 4414 дней назад
Online course: Excel 365 for Busy People www.udemy.com/excel90min Corporate training for Excel and other Microsoft and Adobe applications: ComputerTraining.Live Microsoft is now beta testing three functions to use regular expressions to identify, extract and replace text based on regular expressions. These can make easier and fine-tuned work of searching and replacing than current functions can...
How to make Excel column headers repeat. #shorts #shorts
Просмотров 19Месяц назад
Turn #Excel column or row headers into titles so they show up on every page. #shorts #short
Adobe Illustrator artificial intelligence feature: Generative Recolor
Просмотров 18811 месяцев назад
Adobe Illustrator artificial intelligence feature: Generative Recolor
Sneak peek: Artificial intelligence tools in Photoshop 2023
Просмотров 76Год назад
Sneak peek: Artificial intelligence tools in Photoshop 2023
How to query a worksheet using Excel's Xlookup function
Просмотров 572 года назад
How to query a worksheet using Excel's Xlookup function
Using Excel's Replace and Substitute functions
Просмотров 152 года назад
Using Excel's Replace and Substitute functions
Club Crew 2021 National Championships: opening ceremony to awaken the dragon
Просмотров 1332 года назад
Club Crew 2021 National Championships: opening ceremony to awaken the dragon
How to use the Select Object tool in Adobe Photoshop
Просмотров 674 года назад
How to use the Select Object tool in Adobe Photoshop
Dragon boat races -- test of Adobe Premiere Rush
Просмотров 785 лет назад
Dragon boat races test of Adobe Premiere Rush
How to replace or substitute data in Excel
Просмотров 1,7 тыс.5 лет назад
How to replace or substitute data in Excel
How to Use Built-In Mobile UI Screens in Adobe XD
Просмотров 1 тыс.8 лет назад
How to Use Built-In Mobile UI Screens in Adobe XD
How to use the IF function in Excel 2016
Просмотров 8 тыс.8 лет назад
How to use the IF function in Excel 2016
How to keep Adobe Illustrator from combining layers when you group or paste
Просмотров 32 тыс.9 лет назад
How to keep Adobe Illustrator from combining layers when you group or paste
How to run Chrome OS inside Windows
Просмотров 44 тыс.10 лет назад
How to run Chrome OS inside Windows
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?
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.
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.
Yes I agree, I went off too much on a tangent on this one! To answer your question, use the Align panel and click the icon that looks like a dotted box or proxy. That will align objects to the artboard and you can click the alignment tools. Or you can select a bunch of objects, then Option + click (or Alt + click) one object to be the key object. That aligns the other objects to it.
Two great tips there. Thanks Bob.
What about doing this type of thing to replace the whole cell?
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."
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...
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.
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
Hi Mike, thanks for contributing! And I don't think that's a stupid workaround -- I use it sometimes, also.
great tip!
Thanks
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
3:17 Paste without losing layers 6:07 Group without losing layers
Brilliant, you saved me huge headaches today, thank you!
Glad to be of help!
☠️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.
😢Wow, thanks for the info.
@@BobFlisser iOS 13.7 was a good version. 14.3 failed. I wished I could install a signed iOS version 13.7 from ipsw.me on my iPhone and iPad.
Will it work on windows 10 please please please please please please please please please please please please please tell please please
Sorry for the delay in responding, and unfortunately, it won't. Microsoft deliberately disabled it.
CLAP thanks!!
Is it still possible to dual booth windows and chrome OS now?
Sorry but no. Microsoft disabled this ability. :(
@@BobFlisser Chrome nope but pendrive and linux? yes.
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.
6:08
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
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.
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.
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.
i love that old google chrome look now it looks worse
I'm running Windows 7, does that mean I can't do this?
Correct. Microsoft has removed this ability. 🙁
@@BobFlisser what about windows 10? i have a home version
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.
It never ever really worked since years with all those security and system updates changing constantly.
Yeah, sometimes iCloud fights its users.
@@BobFlisser ☠️BLACK BARON☠️ The IT subject remains BUGGY and COMPLICATED after every single security OS X update PLUS iOS Update.
@@black_baron_net Should work the same on both platforms, though I've had better success on the Mac.
how long before this was wrong?
Thankyou
Trash
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..
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. :(
Very informative.
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.
too old
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??
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. :(
Bob how did you get the option for chrome os in the setting panel?
Well......... it was available in Windows 7. No longer available in Windows 10!
George McFaulds This will not work on Windows 7 anymore.
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?
How to really install a Chrome O/S from Neverware a Cloud Ready O/S takes 20 min.www.neverware.com/freedownload
hey sir can you do a video on windows 10 because it doesnt when i do it
Hi Jairese, I don't think this feature is available in Windows 10. 😢
Son if a bitch
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.
This is the problem I came here hoping to solve.
25/05/18 UK. None of these settings are now active in Chrome. It's not possible to activate Chrome this way.
Does this work in 2018?
Unfortunately, no. I've tried it.
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
shut up kid
Seriously bro, God bless you for the tip at 3:37! Exactly what I needed just now!
Glad you found it useful! Always happy to help.
It doesn't work in Windows 10, i tried but its not working.
its because chrome removed this method in 2015 and windows 10 was created at that time
I love this, any way I love Chrome!!
I don't get it - could you tell me how you installed Chrome OS on your windows machine? What source did you use?
you don't install Chrome OS you just get the Chrome Browser
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!!
does it work on win10 ? thanks
Yes, it will.
no
Yeah, I couldn't find any way to do it, either.
Skywalker889 no it doesn't
I tried it didn't work
YOU ARE MY LORD AND SAVIOR!!!
LOL, glad this helped!
You can also select the layers and go to layers panel menu, and choose collect in new layer. But it also won't solve the problem of aligning objects.
youre really good
Thank you! Glad you found it useful.
if you sent this to me as one layer and i wanted to separate grouped parts to a new layer, how would i do that? im a screen printer i have some artwork that is 2 colors, i was able to group the text and open a new layer...i just don't know how to add the selected grouped text into layer 2. please help!!! thanks! =)