![Up4Excel](/img/default-banner.jpg)
- Видео 370
- Просмотров 2 400 727
Up4Excel
Великобритания
Добавлен 16 мар 2018
✅ Unlike most other Excel training companies, Up4Excel offers you free Excel practice workbooks so you can work along to the videos. You can download them instantly...no emails, registrations etc....just click the link in the description of any video!
We release videos each week, packed full of ways to save time and impress those around you. Don't miss out and fall behind.....SUBSCRIBE NOW: »» cutt.ly/Up4ExcelSub
💥 Claim your Free Shortcut Keys Cheat Sheet Here: »» www.up4excel.co.uk/shortcuts
👉 Access the Up4Excel Downloads Library: »» ml.up4excel.com/library
📕 Get the Up4Excel Downloads Pack: »» ml.up4excel.com/downloads_pack
We release videos each week, packed full of ways to save time and impress those around you. Don't miss out and fall behind.....SUBSCRIBE NOW: »» cutt.ly/Up4ExcelSub
💥 Claim your Free Shortcut Keys Cheat Sheet Here: »» www.up4excel.co.uk/shortcuts
👉 Access the Up4Excel Downloads Library: »» ml.up4excel.com/library
📕 Get the Up4Excel Downloads Pack: »» ml.up4excel.com/downloads_pack
Excel Paste Special Hacks: Unveiling Pro Shortcuts & Techniques
📗 Download Practice File: »» go.up4excel.com/up4v2106E01FD
🎯 Boost your Excel game with insider tips on mastering Paste Special shortcuts! Supercharge your productivity in minutes and unleash the full power of Excel's Paste Special feature.
In this Microsoft Excel tutorial, I unveil four powerful methods to master Paste Special commands, all through efficient keyboard shortcuts. From saving time to enhancing productivity, I guide you through each technique step-by-step, ensuring you harness the full potential of Excel's Paste Special feature.
Topics covered include:
1. Utilizing keyboard shortcuts for seamless pasting:
Discover how to effortlessly access Paste Special options without ever reac...
🎯 Boost your Excel game with insider tips on mastering Paste Special shortcuts! Supercharge your productivity in minutes and unleash the full power of Excel's Paste Special feature.
In this Microsoft Excel tutorial, I unveil four powerful methods to master Paste Special commands, all through efficient keyboard shortcuts. From saving time to enhancing productivity, I guide you through each technique step-by-step, ensuring you harness the full potential of Excel's Paste Special feature.
Topics covered include:
1. Utilizing keyboard shortcuts for seamless pasting:
Discover how to effortlessly access Paste Special options without ever reac...
Просмотров: 247
Видео
Sort and Filter Secrets: Unleash Excel's Time-Saving Shortcuts
Просмотров 40821 день назад
📗 Download This File: »» go.up4excel.com/up4v2111E01FD 🎯Master Excel Like a Pro: Unlock Time-Saving Keyboard Shortcuts for Efficient Data Sorting and Filtering! Learn how to navigate, filter, and sort your data lightning-fast without touching the mouse, and supercharge your productivity today! In this Excel tutorial, I dive into the world of efficient data sorting and filtering, eliminating the...
Excel Breakthrough: Column Charts Inside Pivot Tables with DAX Sorcery
Просмотров 668Месяц назад
📗 Download This File: »» go.up4excel.com/up4v2406M01FD 🎯Unleash Excel's Untapped Potential: Exclusive Column Charts Inside Pivot Tables with Cutting-Edge DAX Techniques. Elevate Your Data Analysis Game and Gain Unparalleled Insights with This Innovative Approach. Learn how to create a powerful variance column chart effect within a pivot table in this tutorial. Discover how to transform horizont...
Revolutionize Your Excel Reports with Power Pivot and Visual Variances
Просмотров 606Месяц назад
📗 Download Video Workbook: »» go.up4excel.com/up4v2405M01FD 🎯Discover the game-changing potential of Power Pivot as I unveil advanced techniques to revolutionize your Excel reports. Elevate your data analysis skills and transform raw data into dynamic, insightful reports that drive actionable insights. In this tutorial, I'll guide you through creating an intuitive and visually appealing Varianc...
Excel Data Bars Reinvented: Transform Your Visualizations with This Genius Hack!
Просмотров 7582 месяца назад
📗 Download Template: »» go.up4excel.com/up4v2404S02FD Discover the game-changing technique to revolutionize Excel's data bars! Learn how to highlight critical data points and customize visualizations like never before with our simple yet powerful hack. Dive into advanced Excel formatting and elevate your data analysis skills today! 💥 Get Your Shortcuts Cheat Sheet: »» www.up4excel.co.uk/shortcu...
Variance Report Transformation: Simple Excel Visuals for Clearer Insights from Reports
Просмотров 3932 месяца назад
📗 Download Video Workbook: »» go.up4excel.com/up4v2404S01FD Learn powerful techniques to enhance data clarity and drive actionable insights, empowering you to excel in data analysis like never before. Watch now and unlock the full potential of your reports! 💥 33 Fantastic Functions Cheat Sheet: »» ml.up4excel.com/functions01 Are you grappling with unwieldy data sets and struggling to present th...
Excel Wizards Only: Conquering Massive Lists in Dependent Dropdowns
Просмотров 9412 месяца назад
📗 Download Video Workbook: »» go.up4excel.com/up4v2009E02FD Dive into the realm of Excel wizardry as I guide you through the art of conquering massive lists in dependent dropdowns. Uncover advanced techniques, unleash the power of dynamic data management, and elevate your Excel skills to wizard status. In this tutorial, I'll guide you through the process of setting up interactive dropdown lists...
Dependent Dropdowns: Excel's Key to Dynamic Data Visualization
Просмотров 8403 месяца назад
📗 Download Video Workbook: »» go.up4excel.com/up4v2003E02FD Unlock the full potential of Excel with our comprehensive tutorial on Dependent Dropdowns, the cornerstone of dynamic data visualization. Learn how to craft engaging dashboards effortlessly, transforming your Excel reports into powerful tools for analysis and insight. Dive into our step-by-step guide and revolutionize your Excel experi...
Excel's Drop-Down List Debate: Choose Your Champion! Data Validation, Form Controls, or ActiveX
Просмотров 1,3 тыс.3 месяца назад
📗 Download Video Workbook: »» go.up4excel.com/up4v2004E01FD Dive into the heart of Excel's drop-down dilemma! Discover the perfect drop-down solution for your spreadsheets as we compare Data Validation, Form Controls, and ActiveX - unlocking Excel's full potential for efficient data management and dynamic reports. Choose your champion and revolutionize your Excel experience today! Are you tired...
Excel Chart Revolution: One Formula, Zero Macros - Effortless Dropdown Switching!
Просмотров 1,5 тыс.4 месяца назад
📗 Download Template Here: »» go.up4excel.com/up4v2014E01FD Embark on an Excel Chart Revolution in this tutorial! Learn the art of dynamic charting using just one formula and no macros - effortlessly switch between charts with a simple dropdown. Revolutionize your data visualization skills and unlock the true power of Excel in minutes! 💥 33 Fantastic Functions Cheat Sheet: »» ml.up4excel.com/fun...
Automate and Impress: Excel Power Query & Power Pivot Reporting Mastery
Просмотров 5 тыс.4 месяца назад
📗 Download Video Workbook: »» go.up4excel.com/up4v2403M01FD Discover the secrets to effortless Excel reporting mastery with Power Query and Power Pivot. Streamline your workflow, impress your colleagues, and elevate your reporting game! In the previous video, we automated month-end reporting using Power Query. 🎥👀 Watch the PREVIOUS video here: ruclips.net/video/lv7HhViaU3I/видео.html 🎥👀 Also Wa...
Effortless Period-End Reporting: Excel Automation Techniques Revealed!
Просмотров 73 тыс.5 месяцев назад
📗 Download Video Workbook: »» go.up4excel.com/up4v2402M01FD Are you tired of spending hours on monthly reports? Get ready to revolutionize your reporting process and save valuable time with this comprehensive tutorial! No coding required at all. 🎥👀 Watch the NEXT video here: ruclips.net/video/dsM8Y51ElBg/видео.html 🎥👀 Watch the PREVIOUS video here: ruclips.net/video/cBJIwbyvQRE/видео.html In th...
Excel Automation for Month-End Reports: Simplify Your Reporting Process!
Просмотров 3,9 тыс.5 месяцев назад
📗 Download Video Workbook: »» go.up4excel.com/up4v2401M01FD Are you tasked with producing monthly reports that detail actuals, budgets, forecasts, and variances? Look no further! In this comprehensive video, I've got you covered with efficient methods to save you time and effort in your finance reporting. 🎥👀 Watch the next video here: ruclips.net/video/lv7HhViaU3I/видео.html 📊 Streamline Your M...
Excel Secrets Revealed: Transform Your Tables with Automatic Indexing and IDs!
Просмотров 9816 месяцев назад
💥 33 Fantastic Functions Cheat Sheet: »» ml.up4excel.com/functions01 📗 Download Video Workbook: »» cutt.ly/up4v2302M01FD 🎯 Unlock the power of Excel automation! Learn how to effortlessly generate indexes and unique IDs for your tables, revolutionizing your data management experience. Master the art of efficiency and streamline your workflow with our expert tips and tricks. Any good data analyst...
Date Formatting Demystified: Unveiling the Power of Custom Formats
Просмотров 5386 месяцев назад
💥 33 Fantastic Functions Cheat Sheet: »» ml.up4excel.com/functions01 🎯 Transform your Excel skills with our comprehensive guide to date formatting! Learn how to leverage custom formats for clearer insights and efficient data presentation In this Excel tutorial, I'll delve into the intricacies of date manipulation, offering comprehensive insights into formatting and utilizing dates effectively. ...
Excel Date Drama? Solve Month-Day Switch Snags Once and For All!
Просмотров 7157 месяцев назад
Excel Date Drama? Solve Month-Day Switch Snags Once and For All!
Excel Data Mastery: 5 Clever Strategies to Extract Text from Any Cell
Просмотров 4747 месяцев назад
Excel Data Mastery: 5 Clever Strategies to Extract Text from Any Cell
Excel Slicer Hacks: Craft Pivot Table Filters, Formats, and Templates with Ease
Просмотров 5718 месяцев назад
Excel Slicer Hacks: Craft Pivot Table Filters, Formats, and Templates with Ease
Maximize Excel Efficiency: Understanding SUBTOTAL - 109 vs 9
Просмотров 7448 месяцев назад
Maximize Excel Efficiency: Understanding SUBTOTAL - 109 vs 9
🚀 How to Generate Custom IDs for Your Excel Data in Minutes - Easy and Fast Methods 📊
Просмотров 1,1 тыс.8 месяцев назад
🚀 How to Generate Custom IDs for Your Excel Data in Minutes - Easy and Fast Methods 📊
Excel Hacks: Streamline Your Workflow with Automatic Index Columns
Просмотров 1,5 тыс.9 месяцев назад
Excel Hacks: Streamline Your Workflow with Automatic Index Columns
4 Ways Excel Can Split Your Dates into Years Months and Days
Просмотров 8309 месяцев назад
4 Ways Excel Can Split Your Dates into Years Months and Days
Unveiling Excel's Secrets: 9 Functions to Tackle Dirty Dates
Просмотров 53610 месяцев назад
Unveiling Excel's Secrets: 9 Functions to Tackle Dirty Dates
Unleash Excel's Power: From Cluttered Text to Clean Lists in Seconds!
Просмотров 34310 месяцев назад
Unleash Excel's Power: From Cluttered Text to Clean Lists in Seconds!
Say Goodbye to Data Hassles: Excel's Text Extraction Magic
Просмотров 21211 месяцев назад
Say Goodbye to Data Hassles: Excel's Text Extraction Magic
Unlock Excel's Secret Weapon: Extract Names Instantly with Flash Fill
Просмотров 26411 месяцев назад
Unlock Excel's Secret Weapon: Extract Names Instantly with Flash Fill
Tailor Your Pivot Table Look: DIY Report Style Templates
Просмотров 593Год назад
Tailor Your Pivot Table Look: DIY Report Style Templates
Excel Efficiency Unleashed: A Deep Dive into SUMIFS Functionality
Просмотров 375Год назад
Excel Efficiency Unleashed: A Deep Dive into SUMIFS Functionality
Excel Tables: Your Secret Weapon for Pivot Table Precision
Просмотров 421Год назад
Excel Tables: Your Secret Weapon for Pivot Table Precision
Totals Made Easy: Excel Table Automation Secrets
Просмотров 300Год назад
Totals Made Easy: Excel Table Automation Secrets
Thanks a lot!
In your last example, what if there are mix of both date first and month first?
@Up4Excel This is very helpful! Would you have some instruction to get the dropdown list (column B in this video) to work on a completely different tab of the same excel document? Thank you!
Great content! Thank you John
Nice! I've used Excel for well over 30 years and always amazed there's always something I don't know about. BTW, and sorry if I missed it or if it's only in the Beta Insider's edition, but recently [Ctrl][Shift]V was added as a shortcut for paste values. Don't remember where I saw that, but it's a very welcome addition!
hi i can't open teh extension in zip file ..pls advice
Thank you!! That's exactly what I have been looking for
Great to hear that 👍 John
cảm ơn bạn đã chia sẽ
Very useful especially if you want to move away from the beginner phase
Thanks John :) :)
Please someone share link of date column full of null in power query❤
very informative video. thanks for sharing.
2:42 on is exactly what I needed to get these reports done, thank you
Nice one - thanks buddy
Problem with zeros is the data graphs go down to zero and I want it to just show the score for the next score I dont need it going all the way down but skip the 0
Replace your zeros with errors as they don't show on graphs. Google for more info 👍 John
Amazing, Thank you so much John
Glad you like it. Hope it helps you save time 👍 John
It works for list in the same sheet. what if the list is in another sheet
You have to add the sheet name to the reference but you might need to Google the correct format. John
Thanks John.
Thanks for your comments John 👍
Marvelous.
Glad you like it 👍 John
This is great but the difficulty I have is I have data from 51 different sources and they all have different date formats. I can't see a dynamic way to convert the date based on the data. I basically have to create three different templates to choose from
That sounds like a job for power query to me so maybe look into that. It automatically recognises dates in far more formats than the Excel grid too. If that doesn't work I'd imagine a few if functions might get the job done depending on your circumstances. Buy power query is your best bet I'd say 👍 Good luck 👍 John
@@Up4Excel thank you for the suggestion, John! I definitely need to do some exploring and see if I can come up with a solution
Hi I found your videos today and have just been going thru them for the past few hours. Thank you I am learning a lot. I was just wondering is there a solution around conditional formatting?
Glad you're learning a lot and happy you find me. There isn't a solution regarding conditional formatting that I know of and I suspect that if there is one it'll be something completely different to this technique. Conditional formatting sits over the top of other formats applied to cells and is temporary. So even if, for example, you format a cell yellow, conditional formatting can change it to red, and the format of the cell will still show up as yellow in almost any kind of integration I know of, including the one in this video. So sorry, no solution I know of. John
Nice hack!!! :) :) Thanks John
Thanks John, hope you find a use for it 👍John
Good job, nice explined
what a mess this excel pivot formatting is Long live Crystal Reports :-)
Formatting could certainly be a lot more straightforward that's for sure. I'm not a Crystal user so I'll just take your word they should live long 😊 John
How to add Quarterly column. Please guide me.
Power Query is your tool for that...it's an option on every date field 👍
Thanks john super
You're welcome Sampath 👍 John
Great Sir....👍👍👍👍👍
Glad you like it 👍
Sir, this date problem please solve in google sheet
Thanks John. DAX is very powerful. Amazing!!!
It certainly is, this is the tip of the iceberg of course...so more to come 👍John
Very informative video sir thanks
thanks sir, its work
Great to hear, thanks for commenting 👍 John
thank you, this is exactly what I've been looking for. I've managed to implement it for my data, however my macro is bugging out if I'm selecting a date as a drop down. Do you know what I might be missing?
Dates are very sensitive to formatting and other stuff in excel so we often get issues. I did this video that might give you ideas for solutions. Hope it helps ruclips.net/video/cM2PIqcoCkk/видео.html
I have been struggling with retaining pivot table refresh formatting for awhile. Your videos are the first I found that actually get to the root of the issues. Thank you. I became an instant subscriber to your channel.
Thank you very much, glad you found the answers you need 👍 John
Loved your video. But, the music in the background should be softer or none at all. Just my feeling. Thanks for sharing such an amazing technique
Thanks for your feedback on the music. I've noticed it can be very different with or without headphones. I'd be interested in what sort of device you watched on and whether you had headphones so I can gauge volume in the future. Glad you found the technique useful btw 👍 John
@@Up4Excel I had headphones on, and was watching it on my MacBook, but the music should definitely softer, maybe a piano playing laying a slow tempo music instrumental. Love your content. That's a 10 on 10. Am following and waiting to watch more videos. Have a great day.
@@paramveerssachdeva Listening back to this you're right about the volume, this one is definitely much louder than I put it these days....and with headphones on sounds even louder. I'll test all new releases with headphones in future, thanks for the feedback 👍John
Great tips of how to count the numbers when the Sequence tool is of no help. Thanks for that! I was wondering whether there was an easier way than using PowerQuery and afterwards updating… hmm
Thanks and glad you found some useful tips. Not sure about an easier way as such but in this other video I go through some other techniques to create ID values for rows which might give you some ideas ruclips.net/video/RhARYxec5vA/видео.html Good luck 👍 John
@@Up4Excel Thanks for the answer! I will definitely go through the video!
@@erminsehovic2000 Hope you get some good tips from it
Excellent 🎉
Glad you think so Arbaz 👍 John
I am discouraged at work from spending time on "visualizations" for the reports I'm responsible for, but I'm tucking away this truly genius hack (just in case)! 😉
Glad you like it. But a shame you're discouraged as there are some almost instant visuals you can apply that improve reports immediately....like the standard databars take seconds to add ( not as good as these though 😉) John 👍
As always perfect
So glad you think so, I shall try to keep it up 👍 John
You're the best
I'm sure I'm not but I'll take the compliment anyway 😉 Thanks for watching and commenting 👍 John
Exceptional 💫💫💫
Thanks for that, hope you put it to use and impress someone yourself 👍 John
thanks a lot! it helps me rather than to copy all the sheets to new file. So, my question, how my file suddenly change into protected workbook? it happened few times already before.
Glad it helped you 👍 Your workbook should not protect itself without you or someone else doing something. So I don't know what it is doing, very strange. John
Your videos are an absolute lifesaver! It saved me so much time and frustration. I can't thank you enough for sharing such clear and helpful instructions. Your expertise is truly a relief. Keep up the fantastic work!"
Wow, that's a lot of praise so thank you. Removing frustration and saving time is what I aim for 👍 John
Thank you sir! This made a colleague of mine veeeeery happy 😂😂
Glad to help your colleague out 👍 John
❤
Glad to help 👍 John
I have noticed that all of your tutorials are different in that sense that I as a fairly advanced Excel user almost every single time learn something new 👌🙏👌
Great news Alex, glad to hear that and hope it continues 👍 John
Thanks John
Thanks John 👍
Waiting for step 2
It's out on 19th June 2024. Keep an eye out 👍John
well, you can use cell format across selection which will help you to avoid adding extra rows at the top
You could do that but you wouldn't be able to use the same formula across all columns like I did as the centre across selection value only sits in one cell.
Nice, thanks!
No problem! 👍John
much simpler to use filter & unique to filter the original list data, then make it unique. Set it to a cell with autospill, and reference the spill range with the # syntax to use it in your dependent drop down. No macros needed, and it works online too.
Yes, very true thanks, can also put a sort function around it too like =SORT(UNIQUE(FILTER(tblOrders[Product Name],tblOrders[Product Sub-Category]=I6)))...where I6 is the result of the first drop down. I recorded this on Excel 2019 and re-edited it recently to include in my drop down video series. With hindsight, I wouldn't do it like this now, but there are a few useful general tips and obviously good for legacy Excel. Thanks for the comment as anyone with Excel 365 can shortcut this 👍John
@@Up4Excel Yep I realized that after posting my comment. 😕 Your approach is certainly cleaner than many I've seen for handling dependent lists PRE the availability of FILTER!
Yup. Filter made a LOT of my old school expertise obsolete and quaint. Luckily I like to learn!
@@tonypcoyle And a fair few of my older videos the same, but learning something new is the best bit anyway 👍
my issue is that when I select details in the pivot table by double clicking the figures in it, it completely messes up the column widths, even with preserve formatting ticked and autofit unticked
I think you're referring to the drill down feature which opens the source data for that value on a new sheet....you're correct that it doesn't matter what pivot table settings you have it will open with standard column widths despite the data size in the cells. It shouldn't affect the original pivot table column widths though. Unfortunately I don't know of any way to change this feature other than switch it off in the pivot table options.
Thank you, very useful
No problem 👍John