%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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%20noopener%20noreferrer%20noopener%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
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