Excel Campus is here to help you learn Excel and save you time with your everyday tasks. My name is Jon Acampora and my goal is to help you improve your Excel skills. This channel contains "how-to" tutorial style videos on a wide range of Excel topics including: formulas, pivot tables, macros, VBA, charts, dashboards, Power Query, Power Pivot, Power BI, and much more.
I want to hear from you and learn about what you are struggling with in Excel. Please visit my website and subscribe to my free email newsletter. www.excelcampus.com/newsletter/
And don't forget to subscribe to our KZread channel. Thank you!
Пікірлер
Thank you. Which video that shows how to add my micro tab?
wasting my time your solution not working at all
I like to see the short cuts being used, thanks
Loved this for UIpath!
This is exactly what I was looking for. Thank you so much!
Tx
It is normal to use things without knowing its corret name parts, categories and classes. It is not a good habit. Your video save a lot of effort to let we really have good and efficient communication. Thanks a lot.
Thank you!! tried clicking all sorts.
Great stuff! A guy on Reddit was asking about combining files today, and I was able to link this video! Thanks again!
What output table?
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?
A 25+ year Excel user learned more than 30% of those features today. 🙂 Thanks!
Thank you! This is what I was looking for.
The universe may have started on January 1, 1900 (according to Excel), but it REALLY started on January 1, -4713😃😃😃!!! Of course, the Julian Day Number is not easy to calculate (as well as not very useful in socirty), so it's better to use the built-Excel formulas.
Thank you for the tutorial! Very beneficial and this is what I was looking for.
Definitely sharing this video with my coworkers! Quick feedback: Recommend adding chapters. ;) -Cheers!
Thanks Brandon! I'm happy to hear you'll be sharing it and really appreciate your support. We just added chapters. Thanks so much for the reminder! 🙌
Great video Jon!
Thanks Rafael! 🙂
very easy and clear
i love edging
When i do this and try to use a filter, the 2nd pivot table cell resizes and then ends up hidden behind my slicer. I noticed your slicer still stayed in the same spot even when you hid the other row. what am I doing wrong?
Jon, I am a very intermediate (if not more beginner) Excel/Sheets user who has been troubleshooting an issue for a couple of weeks now, and I feel this video has gotten me 75% of the way to what I need, so thank you very much! My issue is that I am trying to create a running total in a table that starts the sum based on the most recent date. Does that make sense? and if so, do you know a good way to accomplish this? Thank you again for your very helpful video!
Very good. Nice job!
Is it possible to set Excel to autofill a collumn everytime I add a new line?
Click something from status bar that will automatically copied in clipboard and then paste it to the cell....i really was thinking recently if somehow that can be done. And voila!!
Excel is very amazing indeed in data management
2nd way : Awesome Tip :)
If you know excel then you can developed application..kzread.info/dash/bejne/oqZqlc2df9Kadso.html
I just heard power query today and I can't believe the years I wasted working harder with worst results.... This stuff is amazing!
Hi, I'm a student and a beginner user of excel. The only device I have at home is a MacBook. What is the difference of Excel on MacOS compared to Windows?
My excel is probleming when i write this formula they showing error
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.
8:06 Jan Kotas is so going home tomorrow.
Do you know how to rotate the picture once it's in a cell?
I didn’t know you could lock the Format Painter. I will use that a lot. Great tips!
Not working
Not working in 2007 version
It didn't work for me
Double click Format painter, selecting cells by typing cell number. Zoom to fit selection.
Thank you so much been searching for this for some hours now. Solved my issues Thank you again!
Thank you so much🤩
Woa so macros.... I want to make custom macros for.my business for our internal forms and sheets. I need to figure that out!!!
It's kind of ridiculous for such mature software to not have functions to convert or scale basic values according to their type. It really should be possible to use =A2+DAYS(14) the fact is you have know that date values are days since 1900, is just poor design. Thanks for explaining
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.
Man, you are wonderful, thank you so much!... You are a life savior too....
You are most welcome! 😀
@@ExcelCampus 😁😁😁
Assistance Needed with Power Query Error I have a folder named BankStatPDF that contains one Excel file named ConsolBS and two PDF bank statements named BankStatementMay and BankStatementJune. I transformed the BankStatementJune PDF file using Power Query in the ConsolBS worksheet, and it worked perfectly. However, when I changed the source file from BankStatementJune to BankStatementMay, I encountered the following error: Expression.Error: The key didn't match any rows in the table. Details: Key= Id=Table001 Table=[Table] Note: The PDF file BankStatementJune has 9 pages, so it was converted into 7 tables in Power Query. The PDF file BankStatementMay has only 3 pages. The format and bank statement details are the same for both files, and they are from the same bank. The Power Query editor has created 7 query tables of these 9 pages for BankStatementJune. I appended them into a new query named "Statement," so I now have a total of 8 queries. All of these 7 query tables showing the same error except the "Statement" query, which displays: An error occurred in the ‘Table001 (Page 2)’ query. Expression.Error: The key didn't match any rows in the table. Details: Key= Id=Table001 Table=[Table] Please guide me on how to fix this error. Note: The PDF file BankStatementJune is used to transform data in power query that has 9pages so it converted into 7tables. The PDF file BankStatementMay have only 3pages. rest the format and bank statement are same and of one bank. Thank you for your assistance.
I want to understand more on the xlookup formula and the thought process to how the formula works. Example why =xlookup(C6?
How to split panes in Spreadsheet? Does anyone know?
I kept googling "task view short-cut" it leads me to create virtual window.. but 3:13 saves me, and the key word "task view split"... Thank you...
Glad it helped! 😀
What about inconsistent column headers ?? For example- we have a tool from which we can pull data but sometimes we add new columns so let’s say “last name” was column B - but the following download you’ll find it in column C- do you have to manually clean up the spreadsheets before combining??
Thanks
What a fantastic amount of great tips both here and in other videos from other Excel experts - I wish I could remember more of them