5 Excel Secrets You'll Be Embarrassed You Didn't Know

Поділитися
Вставка
  • Опубліковано 1 лют 2025

КОМЕНТАРІ • 240

  • @ExcelCampus
    @ExcelCampus  8 місяців тому +15

    Secret #5 seems to be the most popular. Question for you... Are there any time consuming Excel tasks that you'd like to automate with a macro?
    Leave a comment and let us know. 👇🏼
    I'm working on another video on the macro recorder and want to include examples that would be helpful for you. So, your idea or question could be featured in the video.

    • @florenciaray5954
      @florenciaray5954 7 місяців тому +1

      Make a macro about how to keep the header row fixed on a sheet even if we are scrolling down so that we don't have to go all the way up to check the headers again and again while entering data. Because if we do so there surely is a chance of making mistakes. (I'm a beginner and came across this problem while doing a simple task)

    • @stephanebarret2517
      @stephanebarret2517 6 місяців тому

      @@florenciaray5954 Hi Florence,
      you really don't need a macro for that.
      Put your data into a table (an actual Excel one) and when you scroll down the column letters will be replaced by your table headers!
      Magic 😁
      (and you can see that at minute 9:20 of the video checking day 5 is present in the table created with Power Query)

    • @c17nav
      @c17nav 6 місяців тому

      How about a merge cell macro that mimics Word's merge cell capability, which does not discard data that is not in the upper left cell? And a counterpart macro that splits data across cells?

    • @c17nav
      @c17nav 6 місяців тому

      @@florenciaray5954 Welcome to the Excel world. The program has the built-in Freeze Panes capability that creates header rows and columns. Access Freeze Panes on the View tab.

    • @lareh5501
      @lareh5501 6 місяців тому

      @@florenciaray5954 Probably easier than a macro for that is to use one of Excel's "Freeze Panes" options (i.e. freeze top row OR freeze 1st column OR freeze whatever's directly above & to the left of the currently selected cell.
      From the ribbon, go to View tab and right click on the "Freeze Panes" option, then select the "Add to Quick Access Toolbar" option.
      FWIW, I like to show my Quick Access options BELOW the ribbon, that way more icons can appear without running into the file name AND they're available regardless of what ribbon tab is selected.

  • @ryan19899
    @ryan19899 8 місяців тому +85

    Crtl Shift End instead of down arrow was new for me. Thanks Jon!

    • @ExcelCampus
      @ExcelCampus  8 місяців тому +1

      You're welcome. 😀

    • @corvinns
      @corvinns 8 місяців тому +1

      Same here. But meanwhile I like the table approach more: Ctrl+A, Ctrl+T, then shift+space for rows and Ctrl+space for table column

    • @davescellphone5376
      @davescellphone5376 5 місяців тому

      Same

    • @techtricksgh
      @techtricksgh 5 місяців тому

      Really, then you have learnt a new trick

    • @uchechukwuawoke
      @uchechukwuawoke Місяць тому

      Same here

  • @rexbk
    @rexbk 8 місяців тому +16

    Ctrl+Shift+End is a new thing for me. Thanks

  • @philhersh
    @philhersh 5 місяців тому +4

    Awesome! Double clicking on the fill handle was something I learned from your video. Super useful.

  • @JanBolhuis
    @JanBolhuis 8 місяців тому +11

    Thank you for this one. Although I know a lot of shortcuts, I always find it interesting to watch these kind of videos. For just 17 minutes, I learned one new shortcut/trick - Ctrl Shift End - in case of blanks. An amzing one. Thank you. It will save me more than 17 minutes in the future :)

    • @ExcelCampus
      @ExcelCampus  8 місяців тому +1

      Thanks so much, Jan! It will take about 40 uses of the shortcut for you to recoup your time. That's assuming you use it on an average of 10,000 rows that take 26 seconds to select. 17 / (26/60) = 39.23
      Lot's of assumptions in that equation, but I love to geek out on this stuff. I'd love to know how many thousands of times I've used that shortcut alone.
      And I think it's awesome that you thought about the time you will save in the future. So good! 🙂

  • @dianebucciero7728
    @dianebucciero7728 5 місяців тому +6

    The power query to combine files contained in a folder ...... I found this feature on the web a couple days ago, so still new to me, your video just cleared up a sticking point and added more detail. SO simple and will save me so much time and frustration! I will be watching more of your tutorials! Thank you.

    • @ExcelCampus
      @ExcelCampus  5 місяців тому +1

      Glad to hear that, Diane! 😀

  • @DavidWinchell
    @DavidWinchell 5 місяців тому +1

    I sure wish I had found you much earlier, but I'm glad to have found you now. Thanks!!😀

  • @jturner4640
    @jturner4640 Місяць тому

    You've done a phenomenal job of explaining every component of the formulas and explaining exactly what you're doing. This was super helpful! I think a LOT of Excel teachers have their own information bias and forget to explain some things.

  • @ADTR0816
    @ADTR0816 3 місяці тому +1

    Learning Analytics and these videos you post have been instrumental.
    Thanks!

  • @JudahPeters-m6h
    @JudahPeters-m6h 5 місяців тому +3

    Great excel tutorials. I have learnt a lot. The most important was the macro. This will save me a lot of time and make my work super easy. Thank you so much Jon.

    • @ExcelCampus
      @ExcelCampus  5 місяців тому

      Glad it was helpful! 😀

  • @geezerfitz
    @geezerfitz 2 місяці тому

    This is the first video I’ve seen of yours. OUTSTANDING!

  • @JHatLpool
    @JHatLpool 8 місяців тому +4

    Really nice demonstrations and descriptions here. MS Excel is so powerful now.

  • @johnfox9780
    @johnfox9780 5 місяців тому +2

    As always Jon........AWESOME!
    You always speak and describe things so well and at just the right pace for me.
    There's never any time wasting or 'padding' with you, that's why you're always my go to for excel.
    Thank you so much for sharing.
    Regards
    John
    (Inverurie, Scotland)

    • @ExcelCampus
      @ExcelCampus  5 місяців тому

      Wow, thank you for your feedback! 😀

  • @kellyboyd295
    @kellyboyd295 2 місяці тому

    Thanks Jon! I've been scared of PowerQuery - but you made it sound super easy! I'll definitely be looking into it more.

  • @KathleenRyan-y8q
    @KathleenRyan-y8q 3 місяці тому

    All of these videos were extremely helpful - Thank you

  • @JohnAdair-k7j
    @JohnAdair-k7j 8 місяців тому +13

    When I have a select enough rows that I can no longer see my formula, then my favorite way to keep that range selected and "scroll" back up to the formula is while that to just hit Ctrl + Backspace. It's fabulous!

    • @gagreeneeee
      @gagreeneeee 2 місяці тому +1

      if you go to File, Options, Advanced, and Untick Allow editing in Cells, then you will always edit your formulas in the formula bar at the top of the sheet.

    • @cindyfillion9192
      @cindyfillion9192 Місяць тому +1

      I have asked this very question in comments on other videos and at Microsoft's own help forum and nobody could answer... until now!! Bless you.

    • @JohnAdair-k7j
      @JohnAdair-k7j Місяць тому

      @@cindyfillion9192 I learned it from Leila Gharani. 😇

  • @amithbsbs629
    @amithbsbs629 5 місяців тому +2

    Shift control end is new for me when there are multiple blanks in column and used to do manually. Now i am pro after watching

  • @LindieKotze
    @LindieKotze 4 місяці тому

    Very helpful! Compliments on how you present. So easy to follow. Appreciate the effort you put in

    • @ExcelCampus
      @ExcelCampus  4 місяці тому

      Thanks Lindie! I’m happy to hear it helped and appreciate the nice feedback. 🙂

  • @elenoanaivalu5060
    @elenoanaivalu5060 Місяць тому

    I've just learnt all of this now! wow! thanks for this!

  • @Alignmovewell
    @Alignmovewell 27 днів тому

    very helpful and thank you!!!

  • @jmacdono
    @jmacdono 8 місяців тому +2

    I am so glad I found your channel Jon. This is great and useful information!

    • @ExcelCampus
      @ExcelCampus  8 місяців тому

      I'm glad that you find it helpful. 😀

  • @Puja-d2i
    @Puja-d2i 8 місяців тому

    I have joined your channel today and this was the first video I watch it's amazing. If I go through all the videos I might become a pro

    • @ExcelCampus
      @ExcelCampus  8 місяців тому

      Awesome! Thank you for your feedback. 😀

  • @aminamaradesa9778
    @aminamaradesa9778 6 місяців тому

    excellent video, very useful tips ( esp power query and macros) and very well explained.

    • @ExcelCampus
      @ExcelCampus  6 місяців тому +1

      Many thanks for your feedback! 😀

  • @mgrnmgrn
    @mgrnmgrn 8 місяців тому

    Mr.Jon continue your great work to the community.Nice video to save the time.

    • @ExcelCampus
      @ExcelCampus  8 місяців тому

      Thank you, will do! 😀

  • @Adam_K_W
    @Adam_K_W 8 місяців тому +3

    Great work as always Jon. At my company, personal macro workbooks have been banned/locked out by IT Security. So far, a workaround is to convert that same workbook to an Excel Add-in and then set it to load on start up. I've got my own personal ribbon with icons linked to the functions in that Add-In and also custom icons on the Excel shortcut dropdown list so i can get to them either way. If you put together a video on the Add-In approach for personal macros, I'm sure it would be popular.

  • @randyn629
    @randyn629 6 місяців тому

    Thank you for the video. Always enjoy your videos, you have a great teaching manner.

    • @ExcelCampus
      @ExcelCampus  6 місяців тому

      I appreciate your feedback. 😀

  • @fsimonpietri
    @fsimonpietri 8 місяців тому

    Excellent tips and tools. Straight forward explanation.

  • @ashfoster1045
    @ashfoster1045 8 місяців тому +1

    Great video, will be sharing this at work! Someone will make use of it 😊

    • @ExcelCampus
      @ExcelCampus  8 місяців тому +1

      I'm so happy to hear that and thanks so much for sharing! 🙏

  • @ragulmarley4900
    @ragulmarley4900 5 місяців тому

    Am new subscriber this one really awesome i learned new things especially ctrl+shift+end without knowing that i waste time now u saved everything :) do more video we support u kudos!!🥳

    • @ExcelCampus
      @ExcelCampus  5 місяців тому

      Thank you for your feedback! 😀

  • @skjones91199
    @skjones91199 6 місяців тому

    Great stuff! A guy on Reddit was asking about combining files today, and I was able to link this video! Thanks again!

    • @ExcelCampus
      @ExcelCampus  6 місяців тому

      Glad it was helpful! 😀

  • @gardenlighting-barrysluite7505
    @gardenlighting-barrysluite7505 8 місяців тому

    Awesome tips. Thanks heaps Jon. I’m so glad I found your channel, it was actually through Primal Video that I discovered your amazing channel and tutorials.

    • @ExcelCampus
      @ExcelCampus  8 місяців тому

      Awesome! Thank you for your feedback! 😀

  • @johnmccormick2883
    @johnmccormick2883 8 місяців тому

    Great video… thanks for sharing!
    I was already onto most of the tips but the macro bar at the end looks helpful and I’ll check out your video on that!
    Cheers 🍺🍺

    • @ExcelCampus
      @ExcelCampus  8 місяців тому

      Thanks for the nice feedback John! I'm happy to hear you'll be learning more about macros. One of my favorite Excel topics. 🙂

    • @mscotty11
      @mscotty11 7 місяців тому

      I created buttons on my Quick Access Toolbar and assigned them to the most common macros I use. I didn't know we could make our own ribbon item though!

  • @catchagoat
    @catchagoat 8 місяців тому +1

    As usual a very well structured video. I learnt a few new ways to do thing faster, especially the Macro.

    • @ExcelCampus
      @ExcelCampus  8 місяців тому

      🙌 I'm happy to hear you learned some new things. Thanks for letting us know.

  • @miguelmachin1870
    @miguelmachin1870 8 місяців тому

    Thank you for your efforts, explained in great detail yet easy enough for a novice excel user. Great Job.

    • @ExcelCampus
      @ExcelCampus  8 місяців тому

      Thank you for your feedback! 😀

  • @florenciaray5954
    @florenciaray5954 7 місяців тому

    Thank you.... These shortcuts are going to be really helpful in future

  • @mgangat
    @mgangat 8 місяців тому +1

    Thanks Jon for the informative video. This is excellent. My favourites are Power query and pivot tables that are time savers. Will learn power query in depth to make my life easier. Thanks again.

    • @ExcelCampus
      @ExcelCampus  8 місяців тому

      Awesome! I'm happy to hear you're interested in learning Power Query. It's an amazing tool for data cleanup tasks.

  • @dianneclower4911
    @dianneclower4911 2 місяці тому

    I love your efficient videos! Helpful

  • @EJRyder
    @EJRyder 6 місяців тому +2

    I use a very similar header row macro for my work that includes the filename (=CELL("filename",A2) when it is printed out so that I can find the file using the printed output. It is useful to have a blank row below the header if you use arrays with CurrentRegion.

  • @power-reconcile
    @power-reconcile 17 днів тому

    Amazing tutorial, thanks!

  • @Leggg
    @Leggg 5 місяців тому

    Jon, a fabulously informative video with clear explanations. Many thanks. Sadly I think that I shall have to get a more up to date Office suite in order to be able to use the new functionality!

  • @BrianCarey-e9l
    @BrianCarey-e9l 6 місяців тому

    I appreciate you sharing your knowledge and skills. The videos were informative and simple to understand. I will use all 5 "secrets" to improve productivity. I like that you demonstrate the shortcut keys as you teach. Also, Xlookup was new to me.

  • @kgotlaetsilemodieginyane7491
    @kgotlaetsilemodieginyane7491 7 місяців тому

    Wow Jon... what a good short leaning video... I am ur new subscriber right away.

  • @yyusof78
    @yyusof78 8 місяців тому +1

    Marvelous, very value added info

    • @ExcelCampus
      @ExcelCampus  8 місяців тому

      Thanks so much! I'm happy to hear it. 😀

  • @TheWholeGrainBread_Real
    @TheWholeGrainBread_Real 8 місяців тому

    Ive watched a few of these videos and they are really helpful. I really appreciate the info you present!

    • @ExcelCampus
      @ExcelCampus  8 місяців тому

      Thanks for your support. We really appreciate it. 🙏

  • @DallasMartin-s9w
    @DallasMartin-s9w 5 місяців тому

    Thanks for these techniques

    • @ExcelCampus
      @ExcelCampus  5 місяців тому

      You are so welcome! 😀

  • @Tom-kr2ek
    @Tom-kr2ek 8 місяців тому

    As always Jon appreciate your sharing your knowledge of excel your videos are always clear and easy to understand the sheet title layout was extremely helpful, I added an input box to mine so I could fill the title in as I created the sheets works perfectly thank you.

    • @ExcelCampus
      @ExcelCampus  8 місяців тому

      I love that idea, Tom!! 🙌 Save a step in the process. The section on macros seems to be the most popular and I'll do some follow up videos on additional ways to use the macro recorder and modify the macros, including your tip on the input box. It' the InputBox function for anyone reading that wants to learn more.

  • @robinlinneman1808
    @robinlinneman1808 8 місяців тому

    I am going to benefit the most from Secret #5! Thank you!

    • @ExcelCampus
      @ExcelCampus  8 місяців тому

      That's good to know. 😀

  • @franksarbu
    @franksarbu 2 місяці тому

    Thank you!

  • @joukenienhuis6888
    @joukenienhuis6888 8 місяців тому

    Thanks for the clear explanation of these often used functions! I knew them, but i think it is always good to keep reading it if you do not use Excel that much. I do have a question about PowerQuery. What if there already is file and you have to add the data of other files to it without creating a new sheet?

  • @veronicagonzales3114
    @veronicagonzales3114 5 місяців тому +2

    for my current job, i am most interested in Combing Files. I need to watch it again. thank U

  • @loriwangler3667
    @loriwangler3667 8 місяців тому +1

    Thanks, Jon! All so helpful, but I think I'll be using the macro function most.

  • @josealvesferreira1683
    @josealvesferreira1683 7 місяців тому

    Very good, congratulations!

  • @CarolynNguyen-sd9pr
    @CarolynNguyen-sd9pr 8 місяців тому +1

    Great excell tips, very helpful! Thank you, Jon! =)

    • @ExcelCampus
      @ExcelCampus  8 місяців тому

      Glad it was helpful! 😀

  • @BlackThor15
    @BlackThor15 7 місяців тому

    Awesome video, thanks for sharing! Do you have any that shows how to use a vlookup formula to compare 2 different dates in 2 separate spreadsheets and then to present the difference in days between one and the other? Thank you! 👍👍

  • @IvanCortinas_ES
    @IvanCortinas_ES 8 місяців тому +1

    Yeah, excellent tips to increase productivity. Thank you Jon!!!

    • @ExcelCampus
      @ExcelCampus  8 місяців тому

      Thanks so much Ivan! 🙌

  • @hw7channel571
    @hw7channel571 8 місяців тому

    Great work sir🎉

  • @JasonJPerry
    @JasonJPerry 3 місяці тому

    I really enjoyed the Macros but your explanation was great for all of your tips. I am a huge fan of keyboard shortcuts. Do you have a shortcut to automatically increase the column width to fit the data? I am currently using crtl+a and then alt+h+o+i, but I have to do this every time I need to review the data provided and updated from an outside source. I am currently unable to ask them to change their default column width so I am looking to possibly use VBA/macros to automate this step. I am interested to see if you've come across this challenge or if the aforementioned shortcuts are the fastest way to complete the action. Thank you again for teaching and sharing your knowledge, I really appreciate it.

  • @francosilvestri123
    @francosilvestri123 8 місяців тому +1

    Thank you for the great video and hints. Do you save several macros in the same Module or each macro in a separate Module?

    • @ExcelCampus
      @ExcelCampus  8 місяців тому +1

      Great question, Franco! I tend to put several macros in the same module. In my personal macro workbook, I group the macros based on their functionality (or what they do). For example, I have a module named mUnhideSheets that contains several macros for hiding and unhiding sheets. You can see an example in this video. ua-cam.com/video/cckNqUEALbQ/v-deo.html
      This organization allows me to find them a bit easier than putting all macros in one module. It also allows me to move a module to a different workbook if I want to use those macros in a specific project.
      I think there are pros and cons no matter which way you choose to organize your macros. And it's important to find a method that works best for you.
      One thing to note is that you can use Ctrl+F to find macros in the current procedure, module, or project. So if you don't want to organize them, search is another way to quickly find them.
      I hope that helps. Thanks again and have a nice weekend! 🙂

    • @francosilvestri123
      @francosilvestri123 8 місяців тому

      @@ExcelCampus Thank you! I will follow your advice to better organize my macros! I didn't know about Ctrl+F. I will definitively use it in the future. Have a nice weekend too!

  • @HandelMcHandel
    @HandelMcHandel 8 місяців тому +2

    5 for the price of one - one day only! Thanks Jon!

    • @ExcelCampus
      @ExcelCampus  8 місяців тому

      LOL! Tell your friends! 🏃

  • @sallyho146
    @sallyho146 6 місяців тому

    Thank you. Which video that shows how to add my micro tab?

  • @lucianoriquet8552
    @lucianoriquet8552 6 місяців тому

    Very good. Nice job!

  • @KaziMaruf-ik6tk
    @KaziMaruf-ik6tk 5 місяців тому

    Rial life practical job is it. Thanks for sharing

  • @mb-jk6wl
    @mb-jk6wl Місяць тому

    I'm not sure how to follow along. Are there supposed to be some folders in addition to the file that has a tab called Leads? Do the folders contain CSV files? Where are they? thank you so much! And thank you, also for the wonderful vids!

  • @sumardjo
    @sumardjo 7 місяців тому

    Thanks about your knowledge
    and special thanks for sample file
    I can follow video step by step
    thanks very much

  • @controlsgirl
    @controlsgirl 8 місяців тому

    the recording macro might have been the most helpful for me but mainly because i already kknew the others. overall great video

    • @ExcelCampus
      @ExcelCampus  8 місяців тому

      Thanks for the feedback! And I'm happy to hear you enjoyed the section on macros. We'll do more videos on that topic in the future.

  • @prischang3315
    @prischang3315 8 місяців тому

    Thank you so much, excellent and helpful.

    • @ExcelCampus
      @ExcelCampus  8 місяців тому

      Glad to hear it was helpful! 😊

  • @bobbirowlett6728
    @bobbirowlett6728 4 місяці тому

    I have never created a macro in Excel, Access yes, but not Excel. Very interesting. You have expanded my knowledge on every point of your tutorial. I will use the quick keys for selecting ranges a lot. For the XLOOKUP function, is there value for naming headers and data in the formula? I know you most did absolute references. I really enjoyed this video. VERY HELPFUL!

  • @garypheasey
    @garypheasey 7 місяців тому

    Hi Jon. Just found your channel today and subscribed. Great tips. May I ask - what screen recorder do you use? You appear to fly through the steps and are able to annotate very fast. I'd love to learn VBA, is there a course you would recommend? Thanks!

  • @chrism9037
    @chrism9037 8 місяців тому

    Excellent tips, thanks Jon!

    • @ExcelCampus
      @ExcelCampus  8 місяців тому

      Thanks Chris! I appreciate it! 🙌

  • @mkhan-35
    @mkhan-35 6 місяців тому

    Thanks my friend.

  • @SergioJrVarquez
    @SergioJrVarquez 4 місяці тому

    very helpful!

  • @yulfaemellya5142
    @yulfaemellya5142 7 місяців тому

    Great video. Thanks a lots

  • @laurawahlbom5936
    @laurawahlbom5936 3 місяці тому

    Ty Jon! Can you run a second macro after the first? Have a situation at work, where I run a macro that creates 4 sheets, and then I create six other sheets in same workbook. Can I create/run a second macro on whole to give same formatting?

  • @WorryFreeLogistics
    @WorryFreeLogistics Місяць тому

    Great video

  • @lmh4186
    @lmh4186 3 місяці тому

    Love this.

  • @jasminetoro1244
    @jasminetoro1244 6 місяців тому

    I want to understand more on the xlookup formula and the thought process to how the formula works. Example why =xlookup(C6?

  • @carriewenholz9126
    @carriewenholz9126 4 місяці тому

    Could you create a style for the SheetTitle macro? I never use the preset styles as they were never quite what I wanted.

  • @lazyreviewssupport9811
    @lazyreviewssupport9811 8 місяців тому +2

    Thanks for your newsletter bringing me here 😅

    • @ExcelCampus
      @ExcelCampus  8 місяців тому +1

      Thanks for being a subscriber! We appreciate your support. 🙏
      For anyone else reading this, there is a link in the description to join our free weekly Excel Pro Tips Newsletter.

  • @williamkirkwood2070
    @williamkirkwood2070 6 місяців тому

    Really helpful!

  • @johntucker2566
    @johntucker2566 6 місяців тому

    I didn't know you could hit F4 to make references absolute. That's so handy. Thanks!

  • @ronaldoliver1700
    @ronaldoliver1700 6 місяців тому

    Thank you

  • @cimbrow
    @cimbrow 6 місяців тому

    very easy and clear

  • @c17nav
    @c17nav 6 місяців тому +2

    Creating a macro to insert and identically format a top row on multiple sheets is probably not necessary for most spreadsheet users. A different approach is to group a contiguous set of sheets by holding the Shift key, selecting the first sheet's tab and the last sheet's tab. All grouped sheet tabs will indicate that they are in active use. On an active sheet, insert the new first row and apply the desired formatting to the row. Entered text, etc. will be repeated on all grouped sheets.
    Note that an operation on a grouped sheet might be repeated on all sheets of the group if the operation is valid for all grouped sheets.

  • @jodiwood2924
    @jodiwood2924 7 місяців тому

    Oh my goodness. Power query was the best for me. Thank you so much.
    On another note, every August we have a huge business meeting (approximately 800 in attendance) that I have to download all the data from the online registration and create name tags (among other things). I usually download all the info into a csv, then create a 'label' in Word, add the fields, .. you get where I'm going. Is there a quicker easier way? Any help would be appreciated. Thank you.

  • @dinahany233
    @dinahany233 7 місяців тому

    thanks for informative tricks

  • @Enzo_The_Magnificent
    @Enzo_The_Magnificent Місяць тому +2

    2:30 "If you feel that you already know all these techniques, this will be a good reminder to teach them to your co-workers."
    This is the most important message ever. Too many IT workers like to keep techniques to themselves. It makes them feel better than others. Excel will just laugh at people with that attitude. There is always something new to find in Excel so share what you know.

  • @keithM7
    @keithM7 5 місяців тому +21

    Thanks for the shortcuts, Jon! They’ll be really helpful at work. I’m having trouble with Excel though-it’s asking for a product key. Does anyone have any idea where I can get one?

    • @Ann_779
      @Ann_779 5 місяців тому +1

      Hey Keith! I got my Excel product key from BNH Software and was able to use it without any problems!

    • @MarkUSAfreedom
      @MarkUSAfreedom 5 місяців тому +1

      @@Ann_779 Hey Ann, I have a question. Does this key work for all the Office programs, or just for Excel?

    • @Ann_779
      @Ann_779 5 місяців тому +1

      @@MarkUSAfreedom Hello Mark! It's only for Excel. You can find the product keys for the other programs on the same website. Hope it helps!

    • @keithM7
      @keithM7 5 місяців тому +1

      Thank you, Ann!! It worked perfectly, and now I can use Excel without any problem!

    • @Ann_779
      @Ann_779 5 місяців тому

      @@keithM7 You're welcome! I'm happy to help

  • @NawazSyed-kt3oy
    @NawazSyed-kt3oy 7 місяців тому

    Thanks Jon You're Amazing 👍

  • @Xman-lg7qg
    @Xman-lg7qg 4 місяці тому

    need a bit more about power query- how do i get more videos on this topic- btw my favorite

  • @SS-oz3eu
    @SS-oz3eu 8 місяців тому +1

    Some really helpful tips 👍

  • @CraigIreland-q9l
    @CraigIreland-q9l 4 місяці тому

    Jon do you have a keyboard shortcut sheet for Mac

  • @bettyjohnson1625
    @bettyjohnson1625 6 місяців тому

    Is there a way to select a group of cells in a column, then tab to the next column and have the same amount of grouped cells selected? For example selecting cells A1 thru A12 and tab over to have just B1 thru B12 selected?

  • @ronalddcunha6136
    @ronalddcunha6136 8 місяців тому

    Hi Jon,
    Thank you for the keyboard shortcut tips. Just a doubt to clarify. When I enter CTRL+SHIFT+End instead of going to end of the Column, the Print Preview Page Pops out. Please could you help me how to resolve this.

    • @ExcelCampus
      @ExcelCampus  8 місяців тому

      Hi Ronald, I'm not sure what is causing this. Are you using a laptop? Are you on Windows or Mac?

  • @less_thanONEmin
    @less_thanONEmin 4 місяці тому

    oh my , i was searching for a day and this is the best video

  • @polyvg
    @polyvg 5 місяців тому

    In my very first proper spreadsheet (using Lotus 1-2-3 on MS-DOS), not just trying to learn how to use them, I used lookups.
    It was only a modest size - but took over twenty minutes to recalculate. Needless to say, auto-recalc was impossible.
    Things have changed.

    • @gizmovids
      @gizmovids 4 місяці тому +1

      Same! Lotus 1-2-3 as a summer intern in data processing. Had a fancy word processor with a "gold key" too!
      It's been a minute...

  • @PaulEBrownbill
    @PaulEBrownbill 8 місяців тому +2

    Thanks Jon, these tips are really good, especially about recording macros. Paul

    • @ExcelCampus
      @ExcelCampus  8 місяців тому

      Thanks Paul! I appreciate it and I'm happy to hear the feedback on macros too.

  • @riseup4473
    @riseup4473 7 місяців тому

    Great stuff. Thank you!!!

  • @laurengibbs8761
    @laurengibbs8761 7 місяців тому

    macros is a great tool to now use thanks

  • @paulfw1961
    @paulfw1961 7 місяців тому

    Good info!

  • @rotethongvanit
    @rotethongvanit 7 місяців тому

    Superb!