Wow. I only use excel at a very basic level but I am going to download the file and play around to see if ai can figure this all out

Amazing excel skills you got Mynda. I am a beginner and have a question. How can you create a report/query for some specific Description item in the transactions table. For example, How much I spent on Amazon or a certain 'Store' for 2024 or any previous years. I know you can manually add it for each month but want to see it simplified. Thanks.

Thank you Mynda for the tips

I have two columns like numerical value columns is n and due date column is p Now if in due date column perticular rows due date is passed so in numerical columns perticular rows amount ignoring ,I want to take sum of whole numerical value columns at the end of numerical columns,so please let me know perfect formula for this , further i want to inform you that I have checked numerical value columns in numbers and due date column is in Excels format like mm/dd/yyyy So please guide me step by step asap for perfect formula for this asap

Title is misleading. It's Excel WEB or online. It's available for some years. It's not new.

Just discovered this yesterday. It was a life saver!

In conditional formatting, my excel version for mac without the button of “all cells showing “sum of income/expense” values for “subcategory “ , so how can I set it by formula? Or other ways?

One Excel task that often seems to stump them is using complex array formulas, especially with functions like INDEX and MATCH combined, or working with XLOOKUP and VLOOKUP when dealing with multiple criteria.

You made this so easy. Thank you. I tried a simple check book register. It worked at first but when I added data and then refreshed the slicers disappeared. Any thoughts?

This is paid app

Doesn't seem safe to put your information on a software connected to a cloud

thank you, you wise and beautiful lady

You are very skillful and your design makes sense. Boom! Subscribed. Thanks for this very nice video!

good to know.....I love my desktop only because 90% clients don't want or use the online version basically fear of exposed to cloud aka security, It's their preface. But always love your insight. thank you

my escel doesnt look like this at all. im using mac is that why chart tools dont look the same? or is there a setting i can change

Great tip! Thank You. P.S. You look preety in longer hair 👩 Don't cut ✂

❤❤❤

Thank you

Thanks for amazing video. Freeze Pane is not working for me. Is there any setting required as above line of row1 when left click no blue bar is available for dragging? On Hovering on row1 it is showing + sign not cursor hand movement, any idea or suggestions?

Love the video! I stumble on reporting how cash withdrawals from the bank account can be tracked and categorized. How would you deal with record keeping for cash purchases?

When something is free, you are the product

thank you for sharing, as always your free content is appreciated for us that need it.

Something that is often overlooked is how difficult is to work with graphs in the Web version. Something needs a lot of improvements before it gets close to the desktop version.

Thank you

Do appreciate your videos tho 🙏

Literally amazing! You make it seem so easy.

Is this is a cloud App?

Great vidéo ! thanks it's very intresting for excell and also to follow incomes and expense. A questio about this, my incomes (salary) come on my account A and i transfert a 50% of my salary to a commun acount that i ve with my wife. How do you manage that?

Thank you for this great tip!

Dayum, your Excel skills are remarkable. I need a beginner refresher course to level up to intermediate and advance.

I didn’t get you. Wasn’t online version of Excel available before?

Another way of getting Excel (and other great stuff from Microsoft) is to either become a Microsoft Partner or to start working for an existing Microsoft Partner. There is a number of ways to become a Partner, but if you intend to make money from selling IT solutions based on Microsoft technology , it shouldn't be too difficult to achieve. If you are already doing this (have a customer for whom you are managing server(s), client PC's, database(s), Microsoft 365 accounts, you may already be eligible to become a partner.

Thanks Mynda. It's a good solution for the average user who doesn't need every feature of desktop Excel and/or doesn't want to spend the money for a 365 subscription. We use Microsoft 365 Family and in my opinion it is an excellent deal and worth every penny.

Informative video

This will require internet connection anytime you want to use excel

How do you adjust the period from calendar year to tax year ie. April to March or ideally by tax year (in UK that's 6th April to 5th April). Thanks

Wow wonderful ! I really appreciated. I become addicted to you videos sometimes I display it many times. I tried to do the same thing for the top worst but it doesn't work for me

Downloaded template. Updated categories, imported my transactions, got pivot chart errors. Followed video to create pivot charts and they show all the original transactions even after uploading my own.

Wow!!!😮

Thank you for this wonderful and insightful learning video! I wanted to seek your advice on a couple of points: How can I add a column to the dashboard that displays the total investment for each stock? What would be the best formula to calculate it? Additionally, how can I incorporate bonuses, stock splits, and dividends into the dataset and display them effectively in the dashboard? Looking forward to your suggestions. Thanks again for the great content!

Can we edit a line? Using like a reference number

I wonder if there's a way to turn this dashboard into a "live" wallpaper on Windows.

Thank You so much for such a clear explanation! You cleared up my confusion about what transformation to perform on the sample query and final query. Got my work done in minutes! I also subscribed :)

13:45 - you can update your reports with 1 click.... well, except for those manual numbers you entered for your KPI. Surely would be better to use a linked value.

Your Excel videos are excellent, as well as challenging! Personally, I don't bother tracking reinvested dividends, because the stock price will go down by the dividend amount, so it evens out.

Thank you for the lesson. I have been looking at a way to do this very thing for my personal and church use. I think you mentioned it can be created for google sheets so will be able to work.