Excel Tutorials. Google Sheets Tutorials. Outlook tutorials. Gmail Tutorials. This channel is all about teaching you ways to become way more efficient and work smarter instead of harder.
15 minutes...? I doubt that...I mean for me. I am all set up to create a budget in the morning. Watched it through and let's see if I can do it under an hour. ha.
I cannot find the email receipt. My budget doesn't work correctly. Can you send me the email receipt? I don't know how to give my profile without giving my personal info here.
I've been doing this manually since 2020 and thought "hey, a spreadsheet can do this for me" and I was so excited to find your tutorial! So many other budget styles aren't helpful to me! I love having a running log of all income and expenses so THANK YOU for teaching me how to do this on Google Sheets! This will save me so much time! :)
It is my first time successfully creating a budget template in Excel by listening to instructions in my second language. Thank you so much! I have a question: Is it possible to make the progress bar show a yearly overview rather than a monthly one, while still including daily cost details in the Excel sheet?
This is a great tool to use. If i have multiple income streams and would like to understand when certain funds are put into categories, then the bill gets paid, how can i utilise this chart and graphs to visualise this?
omg I Love this video the best one I have seen when it comes to house budget, I have been running around myself for the past 2 months to find a good guide or template to follow, seriously Thank you!
When I try to edit rules it doesn’t let me. I am on a macbook if that makes a difference? It only lets me change the rule type (data bars, color scale, icon sets, formula, etc.) or the color of the data bar
Great video. 👍🏻 How did you get the data validation list to work? When I was doing the sumifs formula, I was able to get results for most of the categories except one. I received an error saying “value must match one of the listed items”.
In the same fashion @anthonymcdaniel146 ran into, I cannot for the life of me copy the =sum formula, select column G, and then deselect the header and starting balance. It’s prob cause I’m using a Mac version of excel, but my Command key doesn’t deselect the cells. It just highlights them darker and darker and then when I hit enter, a wack-ass auto fill ruins the process. Does anyone have any tips? 🙏ty
For some reason, when I try to do conditional formatting for the chart, it has no option to add a maximum value or min value. It only allows me to edit the cell and the color and the type of rule which I put as (data bar)
Hi. My goal is to find a way to copy a cell and text color to copy the origination of a cell's and text's colors. For example, cell a2 has the word "completed" and the text is bold red with the cell's color purple. When I type "completed" in cell c35, it automatically makes that cell's color purple, and the word becomes bold and red. How can I do that without a script?
This is absolute garbage. Trying to follow step by step and you skip the 'basic stuff' assuming we know it all. Useless. Typical Excel 'expert' rushing through something they expect everyone else to just rush through too. Awful and too fast, way too fast!
And when I do your 'sum ifs' to the letter, it says too few arguments and it is correct when I look at it, you are skipping things out. Not helpful at all. Next channel!
How to input a double criteria, like for example if i wanted to take A B from A1:A50 with A B C D, and i want the criteria to have double input for what the total of A-B in the A1:A50. What are the formula??
This is just what I needed! Thanks. Learning about these powerful tools really helps, but it would also help to hear the basics, like when entering the criteria <0, or >0, the argument needs to be in "", like ">0". Maybe too basic?
Can someone please help me: I’m stuck around 5:25… I can do the running balance for income, but when I enter the formula to do the expenses, the information that is put into J3 is in the format 20/03/1900. I don’t understand what’s going wrong. Does this have something to do with the fact that I’m in Australia and the date format is switched around??? I would seriously so appreciate someone ironing this out for me. I NEED AN EXCEL HERO.