Blog Post

Excel Blog
1 MIN READ

Excel for good: Learning resources to help improve your Excel skills for the future

cuong's avatar
cuong
Icon for Microsoft rankMicrosoft
Apr 22, 2020

This week we share with you a set of learning resources from our Excel MVP Mynda Treacy from Australia.  Mynda offers, “We’ve pulled together some free content to help you come out the other side of this storm with stronger Excel skills that will hold you in good stead for the future.”

 

 

For more, see Mynda’s own forum and YouTube channel

 

Have a story to share with us? Add them to the comments below.

 

Cuong
Microsoft

Updated Apr 11, 2023
Version 2.0
blog
excel
Excel for good
cuong's avatar
Icon for Microsoft rankMicrosoft
Joined April 14, 2019
View Profile
Excel Blog
Subscribe to the Excel Blog to get the latest product announcements and updates

4 Comments

  • sanjibdutta's avatar
    sanjibdutta
    Brass Contributor
    Mar 24, 2023

    How good it would be to have a "LET" style function like "MULTIFORMULA" to apply formulas to different cells including the current cell (last formula)? I know many would prefer having separate formula assignment for different cells (quite logical). But using such function wrapped in parameterized Lambda function might be usefull. This kind of work can only be done by VBA macro. But I am not sure if it would introduce any issue...Thanks

  • MobileCowcamp's avatar
    MobileCowcamp
    Copper Contributor
    Jul 27, 2020

    I've tried AutoCorrect and checked the boxes but it doesn't seem to work either.

  • MobileCowcamp's avatar
    MobileCowcamp
    Copper Contributor
    Jul 27, 2020

    I'm confused!! If I'm not in the right place for this question, please let me know!

    In Excel: How do I set a column of cells to be all capitals?

    I tried to use the Upper() function but I could not make it work. It works if you put it in a unused cell and reference the cell you are using. But that put the caps letter answer in a separate cell (where I don't want it) meaning I have to use two (2) cells!? Seems rather stupid and clumsy to me.

    I am putting only 1 character in the cell. Is there a way to make a column all capitals?