Hi guys, I am looking for a good YouTube channel to learn excel from intermediate to advance level. Anyone, if you know any such channel please suggest in comments. Thank You😊
I recently bought an Excel course, but the instructors said we'll be doing all the lessons and exercises in Google Sheets because the two programs are supposedly 95% identical.
I'm curious if that's really the case. What do you guys think?
I'm a teacher in the UK and I've built Confident Cells, a site for practising Excel in the browser. You type real formulas into a sheet and it checks your answer, explains common mistakes and gives hints. It covers basics through XLOOKUP, dynamic arrays and PivotTables, plus downloadable workbook projects you upload to get marked.
It launched this week and I'd love some honest feedback from people who actually use Excel. Anything confusing, wrong or missing.
If you'd like to help, comment or DM me and I'll give you a free month of Pro (no card needed). The free lessons work without an account if you just want a look: confidentcells.com
There are also free guides to each function, with a practice sheet to try them in: confidentcells.com/blog
Thanks!
(Apologies if this breaks any rules - feel free to delete!)
I made this fun little game where you have to hit a certain target each quarter. Or you'll get fired. It's a strategy/RNG game where you try to figure out different synergies to be able to hit the target. Don't play if you have anything productive to do!
I have a set of graphs that automatically update to reflect the last 6 weeks of data. These measure performance in terms of success rate, and all have a set target percentage that we want to hit/exceed. Currently the lines are all constant colors, but I would like to have the lines of each graph change color to show if they are meeting target or not for that week of data.
I could see this being presented 2 ways:
- If the value is below target, that entire line segment (last value to current value) turns red. If above, the entire line segment is green.
- Any part of the line that is below the target line turns red.
What is the best way to automate this in Excel 365? Obviously I could just manually change the color of the line segment, but I feel like there has to be a better way. I briefly messed around with gradient lines, but could not find a way to make the cutoffs automatically update as data changed. I also considered creating dummy columns to split the data into 2 series, 1 red and 1 green, but that was not displaying how I wanted, and the lines were not connecting.
Using excel for Mac standalone version, Microsoft 365 subscription, Version 16.115 (26110837) latest version as per the updater. I need to modify the cell style for hyperlinked cells like I used to do the past weeks, but recently the option for that disappeared probably few days ago, just noticed it last night. Right clicking on the cell styles does nothing. Anyone having this problem and how did you fix it? Tried signing in and out of the app, clear application data on the help tab, and restarting laptop. Thanks.
I'm looking for resources containing challenging, application-based practice questions involving queuing systems and service operations on microsoft excel.
I'm particularly interested in longer word problems where you're presented with a real-world scenario (example: a set of customer arrival and service data, and several interconnected questions that require you to analyse and interpret the situation).
Ideally, I'd like practice covering the following areas:
Average arrival and service time
inter-arrival time between consumers
Average waiting time and time spent in the system
Queue length and number of customers in the system
Server utilisation and traffic intensity
How adding or removing servers affects waiting times
Interpreting arrival/service patterns and making operational recommendations, etc
I'm especially looking for multi-part word problems that combine several of these concepts, rather than isolated questions involving direct formula substitution. I'd like to practise interpreting unfamiliar scenarios, deciding which calculations are necessary, and drawing conclusions from the results.
If anyone knows of relevant question banks, textbooks, practice papers, case studies or websites, I'd really appreciate the recommendations!
I'm trying to use multiple excel files to automate a process that my predecessor would have to repetitively copy and paste from other worksheets.
The file i'm sourcing is about 200 kb. It's tiny. But each time I add a step to my query, it redownloads it at my workplace's potato speed internet.
I added Table.StopFolding and Table.Buffer steps and no dice. It still redownloads the thing, so each time I add a step as I work through this problem, it goes and redownloads the excel data like it's an addict.
I tried referencing the query that downloaded the data initially and even then, adding the reference? Better redownload that file. Renaming my reference query? Better redownload the file. I also turned off downloading the preview in the File/Options section, and doing that caused it to again redownload the file, which would be funny except i'm aleady kinda mad at it for ignoring my attempts to store 100 kb of data in memory.
Anyone had any luck with this? Some of my bigger projects can take 10-15 minutes to evaluate because of the length of time required to do these evaluations, and these are relatively simple but deal with much larger data sets.
I manage a risk/hazard register with 1 Master and 49 Sub-Packages, tracking Hazard, Cause, and Control Measures (one-to-many relationships).
The master register contains key details, which are common to all the sub package registers. The Sub package registers contain additional information
Current workflow & configuration pain points:
Bidirectional updates: Changes originate at a sub-package level, update the Master, and then all other 48 sub-packages must assess how the new/updated Hazard, Cause, or Control affects them.
Strikethrough text problem: currently use strikethrough formatting inside cells to indicate removed/amended Hazards, Causes, or Control Measures
Is maintaining a master sheet and 49 separate sub-package sheets the wrong pattern here? Or is there a cleaner Excel pattern for handling this?
The current formula would be A1*A2 where A1 is 20.1 and A2 is 2.09. I need it to give me 42.009 but it gives me 42.000 no matter how many decimals I allow it to display. I have no rounding parameters that I know of.
Why is excel overwriting previous rows without prompting? To troubleshoot, I've gone in and disabled AutoComplete and Flash Fill in Excel options > Advanced > Editing options, but it's still happening. I would expect Undo to only undo the other changed rows, but it undoes everything. I'm using Excel 365 Apps for enterprise Version 2610.
Hello! I am trying to figure out how to add in an interest formula to auto-calculate the interest accrued on a credit card or loan account in order to make the visuals in my sheet be accurate. I have a line for balances and amount paid, but obviously the balance shifts due to interest daily or monthly depending on the account, so I'm wanting to have excel calculate that for me, so I'm not having to adjust the balance, I can just input the amount paid toward the account. TIA!!
I’ve been using excel on my MacBook for a project in uni, but every time I try to edit it’s just stuck loading. I’ve been having to force quit every time because it says my excel is not responding.
Any tips on how I can have excel running smoothly again? I’m not exactly tech savvy so any advice would be helpful!
Firstly, thank you all for all the help you’ve been the last day or two. It makes everything so much easier when I can ask a person instead of googling everything.
Cell G7 has a formula based on the values in cells G4,5,6. Cell G8 needs to round the number in G7. The specific formula I need is: if G4 is 0-1999 then I need the value in G7 to be rounded up to the nearest 100 in G8, if the value in G4 is >=2000 then I need the value in G7 to round up to the nearest 1000 in G8.
I work as a cycle instructor with colleagues, and we all download a simple xlsx spreadsheet with pupil details on at the start of the week. Not the same file, but exactly the same spreadsheet format no matter where everyone is working - just with different contents.
It doesn't display at all well on a phone (too wide and too much info), and the software people aren't willing to do anything about it. So I wondered if I could create something like a macro, to chop out columns we don't need to see, and change justification on boxes that might contain a paragraph of text that makes the sheet a mile wide. And then share that "macro" with everyone else, so they could apply it to the spreadsheet they download.
I can do this for myself, on my own desktop PC, but is there a really simple way, or perhaps some kind of tool or phone app people can get, that would make it so people who are less computer literate than myself (and I'm no excel expert) can easily do the same?
In one row can I do an increasing sequence (1/30) … (30/30) for example in the screen shot? No worries about the 100% on the left side, that is added daily. Normally we type each cell individually so was just seeing if there is a better way
In the last few months I've had green triangles appear with no 'error options' when selected and no 'ignore error' available when I right click. Is this a new feature? I can't find any way to turn these off.
For clarity, I'm very familiar with resolving the usual green flag error. This seems new.
I use certain Excel templates daily for work, but I did not create them and so I'm not sure what the disconnect is.
Part of my job includes downloading a spreadsheet from a website and then copying and pasting the info to one of our Excel templates. Part of this information is a date. In the past, I was able to copy the mm/dd/yyyy date from the source and then paste it onto our template and it would remain mm/dd/yyyy. The source spreadsheet recently changed a little bit, and I was able to configure everything just fine except the date.
Now, when I paste it over, it becomes some random numbers that don't seem related. For example, 11/24/2026 becomes 46350, 12/3/2026 becomes 46359, 1/8/2027 becomes 46395, etc. Those numbers are reflected in the formula bar. I have NO IDEA what's causing this. Further, when I go to type the actual date into the cell, it just comes becomes a bunch of pound signs while the formula bar reflects the date I typed.
I'm usually good at poking around and figuring things out on my own, but I'm stumped. I know this probably has to do with our specific formatting, but can someone possibly point me in the right direction to get this fixed? Any ideas at all?
Edit: Solved, thank you! I widened the column and made sure the cells were formatted as date. Still have no idea why this changed, as everything was fine up until yesterday when the source updated their spreadsheet, but it is what it is!
We all know the neat trick of broadcasting with an IF condition: =IF(SEQUENCE(2),1) stretches the scalar across both rows.
I wanted to use it with Excel’s new nested array support, to get an outer array of size 2 where each element holds an inner array. But it unexpectedly returns #VALUE! errors:
=IF(SEQUENCE(2),{SEQUENCE(,2)})
There is a workaround: the old thunk technique. Wrapping the inner array in a LAMBDA makes it behave as a scalar, so it broadcasts:
=IF(SEQUENCE(2), LAMBDA(SEQUENCE(5)))
The catch is that you then have to evaluate the thunks with an iterator like MAP or REDUCE, so it feels a bit like a loophole. Not sure about it's efficiency either.
I'm currently working as a Document Controller in the construction industry, and I've recently started learning Excel VBA.
My daily work involves handling Inspection Requests (IRs), document logs, tracking revisions, managing pending responses, organizing correspondence, and dealing with large amounts of Excel data.
I'm learning VBA because I want to automate repetitive tasks, improve my Excel skills, and become more efficient at my job.
I have a few questions for experienced VBA developers:
Are there any recognized VBA certifications worth pursuing?
Does VBA certification actually help when applying for jobs, or is practical experience more important?
What real-world VBA projects would you recommend for someone working in Document Control?
Is learning VBA still valuable in 2026, considering Power Query, Power Automate, and Python?
Can strong Excel VBA skills make a difference in a Document Controller's career, especially in the construction industry?
I'd really appreciate hearing about your experiences and recommendations.
If you were starting your career as a Document Controller today, would you invest more time in Advanced Excel, VBA, Power Query, or Python? And why?"
I came across this weird Excel bug (while uploading product data to ChannelAdvisor/Rithum).
Some products wouldn't import their decimal values correctly, even though everything looked fine in Excel. It drove me crazy, but I was determined.
Turns out Excel saves certain numbers in a weird floating-point representation inside the XLSX file, while other (?!) numbers are saved as normal decimals.
You can reproduce..
Paste these into Excel:
0.06
0.07
0.08
0.075
0.095
0.135
0.266
0.28
0.288
Save as .xlsx, rename a copy to .zip, extract it, and open `xl/worksheets/sheet1.xml` in a text editor.
You'll see that 0.06 and 0.08 are saved normally, but 0.07 and the other numbers are saved with long decimal or exponential representations, such as `7.0000000000000007E-2`.
What's weird is that it isn't random. In my tests, 0.06 and 0.08 always save normally, while 0.07 and the others consistently come out differently.
I'm puzzled as to what algorithm produces this inconsistency.
I wonder if this could also affect lookups, comparisons, or even "=" formulas. It definitely causes problems with some parsers (like in my case)
Here's what I've tried:
Changing the number format doesn't help.
Converting to text =TEXT(A1,"0.###") works if your software accepts text values. (=round(A1,3) won't work). You can check the cell type using =ISTEXT(A1) or =ISNUMBER(A1).
Saving as .csv works! (but if you reopen the CSV in Excel and save it back as .xlsx, the problem comes back)
Opening the file in Google Sheets and downloading it back as .xlsx works! The downloaded file is a little bigger, apparently because it has more empty cells, but the numbers are saved normally and remain numeric.
IDK if saving as .xls helps. ChannelAdvisor doesn't accept .xls, so I couldn't know for sure (but roundtrip save to xls and then back to xlsx has the same problem)
I remember seeing the same behaviour years ago. How come this still hasn't been fixed?
Does anyone know why Excel treats certain decimal numbers differently, and whether there's a way to fix this in Excel itself (without converting the values to text)?