Bob Flisser
Bob Flisser
  • Видео 36
  • Просмотров 109 868
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.
Просмотров: 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
Excel's Sort and Sortby functions
Просмотров 662 года назад
Excel's Sort and Sortby functions
Using Excel's Replace and Substitute functions
Просмотров 152 года назад
Using Excel's Replace and Substitute functions
Excel's Filter function
Просмотров 512 года назад
Excel's Filter function
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 use Excel with Airtable
Просмотров 6 тыс.5 лет назад
How to use Excel with Airtable
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
Intro: avoiding clichés
Просмотров 538 лет назад
Intro: avoiding clichés
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

Комментарии

  • @bulletz2108
    @bulletz2108 7 дней назад

    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 6 дней назад

      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 4 месяца назад

    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.

    • @BobFlisser
      @BobFlisser 3 месяца назад

      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.

  • @radharcanna
    @radharcanna 10 месяцев назад

    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 Год назад

    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 Год назад

      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.

    • @BobFlisser
      @BobFlisser 3 года назад

      😢Wow, thanks for the info.

    • @black_baron_net
      @black_baron_net 3 года назад

      @@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.

  • @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 3 года назад

    Is it still possible to dual booth windows and chrome OS now?

    • @BobFlisser
      @BobFlisser 3 года назад

      Sorry but no. Microsoft disabled this ability. :(

    • @pryt0n180
      @pryt0n180 3 года назад

      @@BobFlisser Chrome nope but pendrive and linux? yes.

  • @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?

    • @BobFlisser
      @BobFlisser 4 года назад

      Correct. Microsoft has removed this ability. 🙁

    • @guostudios4865
      @guostudios4865 4 года назад

      @@BobFlisser what about windows 10? i have a home version

  • @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

    • @BobFlisser
      @BobFlisser 5 лет назад

      Hi Jairese, I don't think this feature is available in Windows 10. 😢

  • @vinitagupta4760
    @vinitagupta4760 5 лет назад

    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.

  • @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?

    • @BobFlisser
      @BobFlisser 6 лет назад

      Unfortunately, no. I've tried it.

  • @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

    • @stalltb
      @stalltb 3 года назад

      shut up kid

  • @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.

    • @airborneleopard1855
      @airborneleopard1855 3 года назад

      its because chrome removed this method in 2015 and windows 10 was created at that time

  • @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

  • @Triric
    @Triric 6 лет назад

    YOU ARE MY LORD AND SAVIOR!!!

  • @Schauk
    @Schauk 6 лет назад

    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.

  • @aniazo8497
    @aniazo8497 6 лет назад

    youre really good

    • @BobFlisser
      @BobFlisser 6 лет назад

      Thank you! Glad you found it useful.

  • @jasonenz4522
    @jasonenz4522 7 лет назад

    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! =)