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

By
Published 04-22-2020 09:16 AM 4,727 Views
Microsoft

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

3 Comments
Occasional Visitor

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?

Occasional Visitor

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

Microsoft

@MobileCowcamp Check out this article by one of our Excel MVPs, @Leila Gharani 

%3CLINGO-SUB%20id%3D%22lingo-sub-1329422%22%20slang%3D%22en-US%22%3EExcel%20for%20good%3A%20Learning%20resources%20to%20help%20improve%20your%20Excel%20skills%20for%20the%20future%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1329422%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20week%20we%20share%20with%20you%20a%20set%20of%20learning%20resources%20from%20our%20Excel%20MVP%20%3CA%20href%3D%22https%3A%2F%2Fmvp.microsoft.com%2Fen-us%2FPublicProfile%2F5000748%3FfullName%3DMynda%2520Treacy%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EMynda%20Treacy%3C%2FA%3E%20from%20Australia.%26nbsp%3B%20Mynda%20offers%2C%20%E2%80%9CWe%E2%80%99ve%20pulled%20together%20some%20free%20content%20to%20help%20you%20come%20out%20the%20other%20side%20of%20this%20storm%20with%20stronger%20Excel%20skills%20that%20will%20hold%20you%20in%20good%20stead%20for%20the%20future.%E2%80%9D%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fwww.myonlinetraininghub.com%2Fexcel-project-management-dashboard%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EExcel%20Project%20Management%20Dashboard%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fmyonlinetraininghub.us1.list-manage.com%2Ftrack%2Fclick%3Fu%3D47d3fb3986ef1634c2797a0f4%26amp%3Bid%3De69fbc9b64%26amp%3Be%3Dfbe08d59f6%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EExcel%2C%20Word%20and%20Outlook%20Courses%20for%20Beginners%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fmyonlinetraininghub.us1.list-manage.com%2Ftrack%2Fclick%3Fu%3D47d3fb3986ef1634c2797a0f4%26amp%3Bid%3D0f9395c471%26amp%3Be%3Dfbe08d59f6%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E239%20Excel%20Keyboard%20Shortcuts%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fmyonlinetraininghub.us1.list-manage.com%2Ftrack%2Fclick%3Fu%3D47d3fb3986ef1634c2797a0f4%26amp%3Bid%3D5d4816f03b%26amp%3Be%3Dfbe08d59f6%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EExcel%20%26amp%3B%20Power%20BI%20Webinar%20Replays%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fmyonlinetraininghub.us1.list-manage.com%2Ftrack%2Fclick%3Fu%3D47d3fb3986ef1634c2797a0f4%26amp%3Bid%3Dc40617a5be%26amp%3Be%3Dfbe08d59f6%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EExcel%20Functions%20library%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20more%2C%20see%20Mynda%E2%80%99s%20own%20%3CA%20href%3D%22https%3A%2F%2Fwww.myonlinetraininghub.com%2Fexcel-forum%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Eforum%3C%2FA%3E%20and%20%3CA%20href%3D%22https%3A%2F%2Fmyonlinetraininghub.us1.list-manage.com%2Ftrack%2Fclick%3Fu%3D47d3fb3986ef1634c2797a0f4%26amp%3Bid%3D7d0fc49989%26amp%3Be%3Dfbe08d59f6%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EYouTube%20channel%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHave%20a%20story%20to%20share%20with%20us%3F%20Add%20them%20to%20the%20comments%20below.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECuong%3CBR%20%2F%3EMicrosoft%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1329422%22%20slang%3D%22en-US%22%3E%3CP%3EExcel%26nbsp%3Blearning%20resources%20from%20our%20Excel%20MVP%20%3CA%20href%3D%22https%3A%2F%2Fmvp.microsoft.com%2Fen-us%2FPublicProfile%2F5000748%3FfullName%3DMynda%2520Treacy%22%20rel%3D%22noopener%20noreferrer%22%20target%3D%22_blank%22%3EMynda%20Treacy%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1329422%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBlog%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20good%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1361129%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20for%20good%3A%20Learning%20resources%20to%20help%20improve%20your%20Excel%20skills%20for%20the%20future%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1361129%22%20slang%3D%22en-US%22%3E%3CP%3ETHE%20EXCELL%20THINKS%20THERE'S%2016%20PAGES%20TO%20PRINT%2C%20BUT%20THERE'S%20ONLY%208.%26nbsp%3B%20HOW%20DO%20I%20FIX%20THAT%3F%26nbsp%3B%20TIA.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1376333%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20for%20good%3A%20Learning%20resources%20to%20help%20improve%20your%20Excel%20skills%20for%20the%20future%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1376333%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20Day.%20I%20hope%20this%20is%20the%20correct%20platform%3CBR%20%2F%3EI%20have%20deleted%20a%20DATA%20table%20(Table%205)%20and%20now%20the%20PIVOT%20table%20is%20still%20looking%20for%20the%20DATA%20table%20when%20I%20refresh.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22PietWalt_1-1589022402382.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F190363iD56C2670C5335153%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22PietWalt_1-1589022402382.png%22%20alt%3D%22PietWalt_1-1589022402382.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EHow%20do%20I%20rectify%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1546975%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20for%20good%3A%20Learning%20resources%20to%20help%20improve%20your%20Excel%20skills%20for%20the%20future%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1546975%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20confused!!%20If%20I'm%20not%20in%20the%20right%20place%20for%20this%20question%2C%20please%20let%20me%20know!%3C%2FP%3E%3CP%3EIn%20Excel%3A%20How%20do%20I%20set%20a%20column%20of%20cells%20to%20be%20all%20capitals%3F%3C%2FP%3E%3CP%3EI%20tried%20to%20use%20the%20Upper()%20function%20but%20I%20could%20not%20make%20it%20work.%20It%20works%20if%20you%20put%20it%20in%20a%20unused%20cell%20and%20reference%20the%20cell%20you%20are%20using.%20But%20that%20put%20the%20caps%20letter%20answer%20in%20a%20separate%20cell%20(where%20I%20don't%20want%20it)%20meaning%20I%20have%20to%20use%20two%20(2)%20cells!%3F%20Seems%20rather%20stupid%20and%20clumsy%20to%20me.%3C%2FP%3E%3CP%3EI%20am%20putting%20only%201%20character%20in%20the%20cell.%20Is%20there%20a%20way%20to%20make%20a%20column%20all%20capitals%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1547048%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20for%20good%3A%20Learning%20resources%20to%20help%20improve%20your%20Excel%20skills%20for%20the%20future%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1547048%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20tried%20AutoCorrect%20and%20checked%20the%20boxes%20but%20it%20doesn't%20seem%20to%20work%20either.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1549048%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20for%20good%3A%20Learning%20resources%20to%20help%20improve%20your%20Excel%20skills%20for%20the%20future%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1549048%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F740541%22%20target%3D%22_blank%22%3E%40MobileCowcamp%3C%2FA%3E%26nbsp%3BCheck%20out%20this%20%3CA%20href%3D%22https%3A%2F%2Fwww.xelplus.com%2Fexcel-change-case-of-text%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Earticle%3C%2FA%3E%20by%20one%20of%20our%20Excel%20MVPs%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F34444%22%20target%3D%22_blank%22%3E%40Leila%20Gharani%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Version history
Last update:
‎Apr 22 2020 09:16 AM
Updated by: