Video

Not that I hate the new colors...its bad for document federation, when trying to keep newly made reports matching older formats. Thanks a bunch for the tip!

Does this work in excel 2019 please? Thanks

As you reply me about exacl there are many tools in excel are all good but which is more pupoler nowadays as well as very useful for good salry

Good morning Nazia is again here with you I have one more question I am M.S.c socialogist now I am learning excel which type of job I can found with good salary kindly guide me

You only have 50 free inputs. After that, it's $11 per month.

Great tips. The steps moved fast but very helpful.

Great

So much that can be done in Excel. Thanks for sharing.

Thank you very much ❤

I didn't know about the 'PROPER' function 👍

=INDIRECT("Table3[Products]") Is an alternative to a named range

Most of the features are known. However learn special feature with format paint double click. Thanks

what if one has 3 or more names?

I want to use the index match formula for an excel table that is made up of several columns and rows containing several variables about attendees to a conference.

Hi John is it possible to obtain country flags

Thank you

I want to pull down importrange data in below row in google sheet, but cell reference not change, how i can do it?

Thanks a lots, great video

Great video. Thanks a lots

The copy sheet shortcut is amazing

Sir I'm from India 🇮🇳 🙏🏻 But I am not able to download that Excel file from the link given in your description. How can I download MS Excel File from your description

I found a little workaround to "simulate" the pressed animation for the form. In your recording first record to delete the shadow effect, then comes your main macro, and after that insert the shadow again, then stop recording. It will be just a fraction of a millisecond but thats even enough to get that satisfiyng "pressed" feeling

Exactly what I was looking for. Thanks!

Odly specific but thanks I guess

So cool, thank you Jon!👍

For the tip at the minutes 7:24 can be done with ctrl + f1

Nice. Is there a way to make all the flags the same size?

This was great thanks

This was great thank you

What an amazingly informative video! Thank you. I will use each and every tip here, and i've been working with Excel for years. My favourite is double-clicking the format painter. That will save my sanity

i have more than one tables after getting data from pdf, how can I import all these tables to one excel sheet, because I just know to import data from only one table. Plz help me

You are my hero today.

Good tips (new features?) I didn't know about.

I did it thanks

Can you draw out a course outline in excel for data analytics training?

I don't seem to get the "Sheet number in status bar" option when I right-click on the status bar. Even the lock drawing mode option isn't available in my version. I have excel version 2016.

Cool and useful

This feature is available in Microsoft 365

Great Tips, Thanks!😊

every time i reopen an excel sheet on which i use xlookup, all such cells show #Name? error, how can i resolve this?

Love from India

Great tips, but as an old geezer, I`ll never remember them!

5:53 , I wish I knew how to do this a long time ago.

😮

Good video, thank you 🎉

How much can I earn after excel learning

I have not done indexing now please guide how to get old sort order

Nice tips, I like the lock drawing mode tip!

Hii what is the keyboard shortcut for see all sheets name

Great video! I've found that so many people that have trouble with tables are the seasoned veterans who never learned to use them. When I show tables and pivot tables to new users I find most never need the formulas as much and don't have to learn the old way anyway 😊.