Відео

Thank you Ann!!!

you could possibly use an xlookup for #7

Sweeet! Nice BTS peak!

Love that all the kids are helping you get subscribers!! ❤️

I've had this question so many times - thank you for the tip and hope you're having a fabulous trip!

This was really helpful. Thank you so much!

"We're not sponsored"😂

I’m looking forward to getting the books so I can perfect my skills

Another awesome data viz tip! Thanks Ann! 💯

I come from future hahahah but this demo really helps me. thanks! thank God, Microsoft didn't re-format their arrangement in excel format

Excellent Video, clear & precise, plus cleared doubts!

Top Ann!

Thanks for the video! What software did you use to make the maps?

You've got some pretty cute small multiples in your family!

still a useful video 10 years after

Love these bite size tips - thank you!

Dark gray body text - I love that tip!

thx !

ahhhhh like a breath of fresh air :) Great tip for the dark gray color over solid black - thank you for the explanation! 🔥

Hi Ann! I think UA-cam tutorials is a wonderful idea to start up again 🤗 I personally use YT often for tutorials on Microsoft products!

woot woot! 💯

Thanks for sharing on UA-cam. I think it's the way to go!

Can't wait to see more demo videos from you!

UA-cam let’s goooo

Question - Will this function also keep the frozen rows/columns so that when you print a spreadsheet that is multiple pages the frozen rows/columns also show up on your printed pages? Or is the freeze function only for helping you view on your pc monitor?

thank you! I have been wodering how to do this for a while but didn't know what is was called or what menu it was under so I'll be saving this vid in my favorites!

Very supportive of more Ann on UA-cam! At this stage in my career your coverage of less technical how-tos (though I know many still benefit from these) and more the decision making of what to include in a visualization, the best ways to engage your audience, making equitable visualization, etc. are what help me the most. Good luck!

Is it bad that I love... spreadsheets?!

Thanks for the clear and detailed explanation!

Can you show us the right path to learn excel. I'm so confused with all these videos available in the internet

Wawooo, How can I freeze my rows with columns at once? Thanks you very much.

I learned PT just 6 yrs ago.... it took a while but totally worth it.

This is kinder garden level. There are 2 formulas that I use most now, vlookup and sumifs. Pivots are essential.

can you share the dataset? and i dont know if its the video resolution thats affecting the visibility of the video

WOW! Thank you so much! This was super helpful!

❤

I love your videos are very interesting and very explicative 💪

the data is only showing as an image? anywhere to find the actual file?

this is way too late haha but I think you can use index&match for #7

Spellchecking for Neighborhood quiz

I'll have my exam next Monday, thank you for sharing, it was very useful!

i cant download the spreadsheet excel, can you fix the link please, there is only a picture there

xlookup is the formula you're looking for for the number of children question! ;)

=Rounddown function

I do wish you had typed in a way so that we could see what the formulas consisted of, and the way you added data to them.

But it lose the scale per category ya, wonder how to add that one

Could use lookup or lookup for the race ethnicity for the family with 8 kids, hnstly eyeballing might b the best because they tell u it's the only value, but maybe if they say find the race / ethnicity with the largest or smallest number of kids u could use a mix of v or xlookup and max/min to get that or large or small if they ask for the third largest or smallest number of kids

Thanks for sharing. However, I felt the comparison with Word ("It's just blank canvas") does not do right to Word. Word has tons of templates to for specific objectives and formats. Second, thinking of inclusiveness: texts written in Powerpoint are extremely hard to understand by visually impaired colleagues, as the document in powerpoint has no clear structure and order of content. Apple Siri can't figure out Powerpoint texts easily. Third, using powerpoint makes people focused on looks and format, and it takes endless to redo formatting. Much faster and more efficient in Word.

Really Helpful... Thanx for video...

You might not be a master at excel, but you definitely the best Teacher 👍🙏