Home
%3CLINGO-SUB%20id%3D%22lingo-sub-229032%22%20slang%3D%22en-US%22%3EExcel%20Table%20Talk%20Episode%206%3A%20Improvements%20to%20Excel%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-229032%22%20slang%3D%22en-US%22%3E%3CP%3E%3C%2FP%3E%3CDIV%20class%3D%22video-embed-center%20video-embed%22%3E%3CIFRAME%20class%3D%22embedly-embed%22%20src%3D%22https%3A%2F%2Fcdn.embedly.com%2Fwidgets%2Fmedia.html%3Fsrc%3Dhttps%253A%252F%252Fwww.youtube.com%252Fembed%252F1tkpwArL_VY%253Ffeature%253Doembed%26amp%3Burl%3Dhttp%253A%252F%252Fwww.youtube.com%252Fwatch%253Fv%253D1tkpwArL_VY%26amp%3Bimage%3Dhttps%253A%252F%252Fi.ytimg.com%252Fvi%252F1tkpwArL_VY%252Fhqdefault.jpg%26amp%3Bkey%3Dfad07bfa4bd747d3bdea27e17b533c0e%26amp%3Btype%3Dtext%252Fhtml%26amp%3Bschema%3Dyoutube%22%20width%3D%22600%22%20height%3D%22337%22%20scrolling%3D%22no%22%20frameborder%3D%220%22%20allow%3D%22autoplay%3B%20fullscreen%22%20allowfullscreen%3D%22true%22%20title%3D%22Video%22%3E%3C%2FIFRAME%3E%3C%2FDIV%3E%3CP%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%20id%3D%22content%22%20class%3D%22style-scope%20ytd-expander%22%3E%0A%3CDIV%20id%3D%22description%22%20class%3D%22style-scope%20ytd-video-secondary-info-renderer%22%3ELearn%20what%E2%80%99s%20new%20in%20Excel%20for%20Mac.%20More%20information%20at%20%3CA%20class%3D%22yt-simple-endpoint%20style-scope%20yt-formatted-string%22%20spellcheck%3D%22false%22%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fredirect%3Fq%3Dhttp%253A%252F%252Fmsft.social%252FM2tvM9%26amp%3Bredir_token%3DbG9OkyRXN_OPiMvpCECxJG1GEJl8MTUzNDQ0NjQ2N0AxNTM0MzYwMDY3%26amp%3Bv%3D1tkpwArL_VY%26amp%3Bevent%3Dvideo_description%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fmsft.social%2FM2tvM9%3C%2FA%3E%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3CDIV%20id%3D%22always-shown%22%20class%3D%22style-scope%20ytd-metadata-row-container-renderer%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-229032%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F39751i8CB49682B77ECC7B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Untitled.png%22%20title%3D%22Untitled.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EThumbnail%20for%20the%20Excel%20for%20Mac%20Table%20Talk%20video%3C%2FSPAN%3E%3C%2FSPAN%3ESteve%20sits%20with%20me%20to%20show%20off%20some%20of%20our%20latest%20improvements%20to%20Excel%20for%20Mac!%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-229032%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-391095%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Table%20Talk%20Episode%206%3A%20Improvements%20to%20Excel%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-391095%22%20slang%3D%22en-US%22%3E%3CP%3EOn%20the%20PC%20side%2C%20multithreading%20is%20optional.%20It%20is%20controlled%20in%20File%20menu%20%26gt%3B%20Options%20command%20%26gt%3B%20Advanced%20option%20%26gt%3B%20Formulas%20section.%26nbsp%3B%20It%20seems%20to%20me%20that%20on%20the%20PC%20it%20defaulted%20to%20single%20threaded.%26nbsp%3B%20Please%20confirm%20that%20multithreading%20is%20default%20in%20Mac.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20favorite%20%22feature%22%20is%20actually%20a%20mixed%20set%20of%20relatively%20new%20features%3A%3C%2FP%3E%3CP%3E%22Get%20%26amp%3B%20Transform%22%20%26gt%3B%20Tables%20%26gt%3B%20PivotTables%20%26gt%3B%20PivotCharts%20%26gt%3B%20Dashboards%3C%2FP%3E%3CP%3EI%20first%20%22found%22%20PivotTables%2C%20that%20lead%20me%20%22backward%22%20to%20Tables%20and%20%22Get%20%26amp%3B%20Transform%22%20and%20%22forward%22%20to%20PivotCharts%20and%20Dashboards.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-879658%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Table%20Talk%20Episode%206%3A%20Improvements%20to%20Excel%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-879658%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F416473%22%20target%3D%22_blank%22%3E%40Simmonrm%3C%2FA%3E%26nbsp%3B%2C%20if%20in%20brief%2C%20all%20new%20functionality%20is%20always%20introduced%20in%20Office365%20and%20could%20never%20appear%20in%20Excel%202019%2C%20if%20only%20in%20Excel%202021%20or%20so.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-993060%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Table%20Talk%20Episode%206%3A%20Improvements%20to%20Excel%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-993060%22%20slang%3D%22en-US%22%3E%3CP%3ETrust%20me%20I%20got%20confused%20when%20I%20Use%20excel%20on%20MAC%2C%20the%20working%20is%20different%20as%20compare%20to%20windows%2C%20function%20keys%20are%20different%20so%20it%20make%20me%20confuse%20all%20the%20time.%26nbsp%3B%3CSPAN%20class%3D%22tags-links%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youlearnexcel.com%2Fcheck-mark%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Echeckmark%20excel%3C%2FA%3E%26nbsp%3Bhas%20different%20working%20style.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1055690%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Table%20Talk%20Episode%206%3A%20Improvements%20to%20Excel%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1055690%22%20slang%3D%22en-US%22%3E%3CP%3EWhy%20is%20working%20with%20tables%2C%20with%20column%20header%20annotation%2C%20inconsistent%20when%20counting%20columns.%3CBR%20%2F%3EWhen%20%22receiving%22%20column-number%20for%20certain%20table%20column%20header%20you%20are%20relative%20to%20sheet-start%2C%20column%20A%2C%20but%20when%20%22using%22%20the%20column-number%20you%20are%20relative%20to%20the%20first%20column%20in%20the%20table%20%3F%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-879592%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Table%20Talk%20Episode%206%3A%20Improvements%20to%20Excel%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-879592%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20difference%20in%20Excel%20capabilities%20between%20Office%20365%20and%20the%20buying%20the%20Office%202019%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

 

Learn what’s new in Excel for Mac. More information at http://msft.social/M2tvM9
5 Comments
Occasional Contributor

On the PC side, multithreading is optional. It is controlled in File menu > Options command > Advanced option > Formulas section.  It seems to me that on the PC it defaulted to single threaded.  Please confirm that multithreading is default in Mac.

 

My favorite "feature" is actually a mixed set of relatively new features:

"Get & Transform" > Tables > PivotTables > PivotCharts > Dashboards

I first "found" PivotTables, that lead me "backward" to Tables and "Get & Transform" and "forward" to PivotCharts and Dashboards.

Occasional Visitor

Is there a difference in Excel capabilities between Office 365 and the buying the Office 2019?

@Simmonrm , if in brief, all new functionality is always introduced in Office365 and could never appear in Excel 2019, if only in Excel 2021 or so.

Occasional Visitor

Trust me I got confused when I Use excel on MAC, the working is different as compare to windows, function keys are different so it make me confuse all the time. checkmark excel has different working style.

 

Occasional Visitor

Why is working with tables, with column header annotation, inconsistent when counting columns.
When "receiving" column-number for certain table column header you are relative to sheet-start, column A, but when "using" the column-number you are relative to the first column in the table ???