Thanks @ambkumar Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ruclips.net/video/rtDlORLmjlE/видео.html Excel Green Marks - Error Checking - Best Practices - ruclips.net/video/XeLtlzd9lRY/видео.html Excel Best Practices - Part 1 of 3 - Data Management - ruclips.net/video/rr_1ha6g6lc/видео.html Excel Best Practices - Part 2 of 3 - Formulas - ruclips.net/video/kz_zAvMINAk/видео.html Excel Best Practices - Part 3 of 3 - Analytics - ruclips.net/video/JNR5yx_Pg4A/видео.html 10 Excel Settings You Must CHANGE! - ruclips.net/video/vXrrXdKyJFk/видео.html Automatic data clean up with Excel Flash Fill - ruclips.net/video/N3p_x_lXT_c/видео.html Instant Excel Audit, Comparison and Analysis - Inquire - ruclips.net/video/cDdvUZxOUis/видео.html Six powerful Excel Navigation Shortcuts - ruclips.net/video/bR-yMbGPq50/видео.html Handle millions of rows in Excel - Slow to fast - ruclips.net/video/93h7rRsLF7Y/видео.html Convert crosstab to tabular - Unpivot - Excel Power Query - ruclips.net/video/mTtOtZH-nNM/видео.html Cheers. Doc
Thanks @brendamg7298 Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ruclips.net/video/rtDlORLmjlE/видео.html Excel Green Marks - Error Checking - Best Practices - ruclips.net/video/XeLtlzd9lRY/видео.html Excel Best Practices - Part 1 of 3 - Data Management - ruclips.net/video/rr_1ha6g6lc/видео.html Excel Best Practices - Part 2 of 3 - Formulas - ruclips.net/video/kz_zAvMINAk/видео.html Excel Best Practices - Part 3 of 3 - Analytics - ruclips.net/video/JNR5yx_Pg4A/видео.html 10 Excel Settings You Must CHANGE! - ruclips.net/video/vXrrXdKyJFk/видео.html Automatic data clean up with Excel Flash Fill - ruclips.net/video/N3p_x_lXT_c/видео.html Instant Excel Audit, Comparison and Analysis - Inquire - ruclips.net/video/cDdvUZxOUis/видео.html Six powerful Excel Navigation Shortcuts - ruclips.net/video/bR-yMbGPq50/видео.html Handle millions of rows in Excel - Slow to fast - ruclips.net/video/93h7rRsLF7Y/видео.html Convert crosstab to tabular - Unpivot - Excel Power Query - ruclips.net/video/mTtOtZH-nNM/видео.html Cheers. Doc
Thanks @dr.shwetabairagi2892 Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ruclips.net/video/rtDlORLmjlE/видео.html Excel Green Marks - Error Checking - Best Practices - ruclips.net/video/XeLtlzd9lRY/видео.html Excel Best Practices - Part 1 of 3 - Data Management - ruclips.net/video/rr_1ha6g6lc/видео.html Excel Best Practices - Part 2 of 3 - Formulas - ruclips.net/video/kz_zAvMINAk/видео.html Excel Best Practices - Part 3 of 3 - Analytics - ruclips.net/video/JNR5yx_Pg4A/видео.html 10 Excel Settings You Must CHANGE! - ruclips.net/video/vXrrXdKyJFk/видео.html Automatic data clean up with Excel Flash Fill - ruclips.net/video/N3p_x_lXT_c/видео.html Instant Excel Audit, Comparison and Analysis - Inquire - ruclips.net/video/cDdvUZxOUis/видео.html Six powerful Excel Navigation Shortcuts - ruclips.net/video/bR-yMbGPq50/видео.html Handle millions of rows in Excel - Slow to fast - ruclips.net/video/93h7rRsLF7Y/видео.html Convert crosstab to tabular - Unpivot - Excel Power Query - ruclips.net/video/mTtOtZH-nNM/видео.html Cheers. Doc
Thanks Sisira Wijesinghe. Check out my other best practices videos as well. Efficient Tasks Management - ruclips.net/video/vLFpWVfUfQ8/видео.html Microsoft Teams - 15 Best Practices - ruclips.net/video/W8Ufx_znKxI/видео.html Smart and Effective Email - 5 powerful ways - ruclips.net/video/6NEFSMqHgQE/видео.html Outlook Calendar Best Practices : Part 1 - ruclips.net/video/GzsQnecjAQo/видео.html and Part 2 - ruclips.net/video/padKH8ys5Cs/видео.html OneNote - Best Practices - ruclips.net/video/m-4AY1cMi8s/видео.html Microsoft 365 Best Practices - ruclips.net/video/kVC_YcL5ObU/видео.html Word Tables Best Practices - The ultimate guide - ruclips.net/video/ueKCHxNUOkA/видео.html Cheers. Doc.
Thanks gowri sankar rao. Watch Word Top 10 settings as well: ruclips.net/video/_8r7vNrqh34/видео.html Check out my other best practices videos as well. Efficient Tasks Management - ruclips.net/video/vLFpWVfUfQ8/видео.html Microsoft Teams - 15 Best Practices - ruclips.net/video/W8Ufx_znKxI/видео.html Smart and Effective Email - 5 powerful ways - ruclips.net/video/6NEFSMqHgQE/видео.html Outlook Calendar Best Practices : Part 1 - ruclips.net/video/GzsQnecjAQo/видео.html and Part 2 - ruclips.net/video/padKH8ys5Cs/видео.html OneNote - Best Practices - ruclips.net/video/m-4AY1cMi8s/видео.html Microsoft 365 Best Practices - ruclips.net/video/kVC_YcL5ObU/видео.html Word Tables Best Practices - The ultimate guide - ruclips.net/video/ueKCHxNUOkA/видео.html Cheers. Doc.
Thanks Carlos Baide. Check out my other best practices videos as well. Efficient Tasks Management - ruclips.net/video/vLFpWVfUfQ8/видео.html Microsoft Teams - 15 Best Practices - ruclips.net/video/W8Ufx_znKxI/видео.html Smart and Effective Email - 5 powerful ways - ruclips.net/video/6NEFSMqHgQE/видео.html Outlook Calendar Best Practices : Part 1 - ruclips.net/video/GzsQnecjAQo/видео.html and Part 2 - ruclips.net/video/padKH8ys5Cs/видео.html OneNote - Best Practices - ruclips.net/video/m-4AY1cMi8s/видео.html Microsoft 365 Best Practices - ruclips.net/video/kVC_YcL5ObU/видео.html Word Tables Best Practices - The ultimate guide - ruclips.net/video/ueKCHxNUOkA/видео.html Cheers. Doc.
Such a useful video! Having backstage appear when I use short cuts has been such a bug bear of mine - removing this is such a relief! I don't appear to have the "Enable Data Analysis Add-Ins:Power Pivot and 3D Maps" option in my Data Options. Is there something I need to do to make this appear, or has it be superceded by something else? UPDATE: I went to Add-Ins > Manage COM Add-Ins and selected MS Power Map for Excel and MS Power Pivot for Excel and now appear to have access.
Thanks @yertletheturtle5843 Yes. Enable the add-ins. Just created a video to explain how to do this... ruclips.net/video/ZEvAa-JWK6M/видео.html Check out my other best practices videos as well. Task Management Best Practices - ruclips.net/video/DJcxPtu-rcg/видео.html Efficient Tasks Management using the New Planner 2024 - ruclips.net/video/kgxqzDirw1o/видео.html Microsoft Teams Meetings - 16 Best Practices - ruclips.net/video/l3Bvq-I0hy4/видео.html Microsoft Teams - 15 Best Practices - ruclips.net/video/W8Ufx_znKxI/видео.html OneDrive Best Practices Part 1 - ruclips.net/video/D7ZrfphW4vo/видео.html Part 2 - ruclips.net/video/nFx6YQxc-b4/видео.html Smart and Effective Email - 5 powerful ways - ruclips.net/video/6NEFSMqHgQE/видео.html Outlook Calendar Best Practices : Part 1 - ruclips.net/video/GzsQnecjAQo/видео.html and Part 2 - ruclips.net/video/padKH8ys5Cs/видео.html OneNote - Best Practices - ruclips.net/video/m-4AY1cMi8s/видео.html Microsoft 365 Best Practices - ruclips.net/video/kVC_YcL5ObU/видео.html Cheers. Doc.
Thanks @Muzammil-689 Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ruclips.net/video/rtDlORLmjlE/видео.html Excel Green Marks - Error Checking - Best Practices - ruclips.net/video/XeLtlzd9lRY/видео.html Excel Best Practices - Part 1 of 3 - Data Management - ruclips.net/video/rr_1ha6g6lc/видео.html Excel Best Practices - Part 2 of 3 - Formulas - ruclips.net/video/kz_zAvMINAk/видео.html Excel Best Practices - Part 3 of 3 - Analytics - ruclips.net/video/JNR5yx_Pg4A/видео.html 10 Excel Settings You Must CHANGE! - ruclips.net/video/vXrrXdKyJFk/видео.html Automatic data clean up with Excel Flash Fill - ruclips.net/video/N3p_x_lXT_c/видео.html Instant Excel Audit, Comparison and Analysis - Inquire - ruclips.net/video/cDdvUZxOUis/видео.html Six powerful Excel Navigation Shortcuts - ruclips.net/video/bR-yMbGPq50/видео.html Handle millions of rows in Excel - Slow to fast - ruclips.net/video/93h7rRsLF7Y/видео.html Convert crosstab to tabular - Unpivot - Excel Power Query - ruclips.net/video/mTtOtZH-nNM/видео.html Cheers. Doc
Thanks @romulusmilea2747 Yes you can use native shortcuts. No problem. I am talking about a generic concept of creating shortcuts for any button which is frequently used and does not have a native shortcut. Wrap text was just an illustrative example. Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ruclips.net/video/rtDlORLmjlE/видео.html Excel Green Marks - Error Checking - Best Practices - ruclips.net/video/XeLtlzd9lRY/видео.html Excel Best Practices - Part 1 of 3 - Data Management - ruclips.net/video/rr_1ha6g6lc/видео.html Excel Best Practices - Part 2 of 3 - Formulas - ruclips.net/video/kz_zAvMINAk/видео.html Excel Best Practices - Part 3 of 3 - Analytics - ruclips.net/video/JNR5yx_Pg4A/видео.html 10 Excel Settings You Must CHANGE! - ruclips.net/video/vXrrXdKyJFk/видео.html Automatic data clean up with Excel Flash Fill - ruclips.net/video/N3p_x_lXT_c/видео.html Instant Excel Audit, Comparison and Analysis - Inquire - ruclips.net/video/cDdvUZxOUis/видео.html Six powerful Excel Navigation Shortcuts - ruclips.net/video/bR-yMbGPq50/видео.html Handle millions of rows in Excel - Slow to fast - ruclips.net/video/93h7rRsLF7Y/видео.html Convert crosstab to tabular - Unpivot - Excel Power Query - ruclips.net/video/mTtOtZH-nNM/видео.html Cheers. Doc
Thanks INDERJEET4321 for the feedback. You may also like these Word related videos: Word top 10 settings - ruclips.net/video/_8r7vNrqh34/видео.html Word Tables - 8 ways to create: ruclips.net/video/X-G8bZVCGBk/видео.html Word Tables - 13 problems solved: ruclips.net/video/y5IblpvN_Jg/видео.html Word Styles - ruclips.net/video/7f_aOgsvKA0/видео.html Handing long, complex word documents - ruclips.net/video/9jrYJHQ7YmQ/видео.html Thanks.
I don't have option of opening files in office desktop apps. I am using MS 2019 which is installed on my laptop by default and also has O365 subscription. But I chose to use MS 2019 as it is lifetime free. Is this option available anywhere in MS 2019.?
You need Office 365 version of Office. Go to Office.com and check if you have the option of Installing Office from there. If not you have O365 which only gives you browser versions of Office.
@@efficiency365 I have O365 in my office, there i changed it but still it's not opening on desktop. Also sir, is there anyway where we can use ctrl+[ in online sheet for going to dependent?. In the desktop version it works smoothly but when working online can't go to a dependent cell,
O365 comes in various editions. Yours will be Business Basic - If you have Business Premium, you will get the latest desktop version. Some features will not come to the 2019, 2021 versions. Excel on web does not have Trace Dependents / Precedents. So the shortcut will not work.
Thanks @homey.channel Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ruclips.net/video/rtDlORLmjlE/видео.html Excel Green Marks - Error Checking - Best Practices - ruclips.net/video/XeLtlzd9lRY/видео.html Excel Best Practices - Part 1 of 3 - Data Management - ruclips.net/video/rr_1ha6g6lc/видео.html Excel Best Practices - Part 2 of 3 - Formulas - ruclips.net/video/kz_zAvMINAk/видео.html Excel Best Practices - Part 3 of 3 - Analytics - ruclips.net/video/JNR5yx_Pg4A/видео.html 10 Excel Settings You Must CHANGE! - ruclips.net/video/vXrrXdKyJFk/видео.html Automatic data clean up with Excel Flash Fill - ruclips.net/video/N3p_x_lXT_c/видео.html Instant Excel Audit, Comparison and Analysis - Inquire - ruclips.net/video/cDdvUZxOUis/видео.html Six powerful Excel Navigation Shortcuts - ruclips.net/video/bR-yMbGPq50/видео.html Handle millions of rows in Excel - Slow to fast - ruclips.net/video/93h7rRsLF7Y/видео.html Convert crosstab to tabular - Unpivot - Excel Power Query - ruclips.net/video/mTtOtZH-nNM/видео.html Cheers. Doc
Wonderful video, in one of my excel facing proflem of formula bar value different from cell value, can you please share your email id to send that excel sheet. Thanks in advance.
Eye opening, especially for those of us who don't know what they don't know. Thank you!
Thanks.
Watch this.. Very transformative.
ruclips.net/video/RJksUyzVyCQ/видео.html
!! Appreciate the wisdom share Nitin !! 💫👏
Thanks @ambkumar
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - ruclips.net/video/rtDlORLmjlE/видео.html
Excel Green Marks - Error Checking - Best Practices - ruclips.net/video/XeLtlzd9lRY/видео.html
Excel Best Practices - Part 1 of 3 - Data Management - ruclips.net/video/rr_1ha6g6lc/видео.html
Excel Best Practices - Part 2 of 3 - Formulas - ruclips.net/video/kz_zAvMINAk/видео.html
Excel Best Practices - Part 3 of 3 - Analytics - ruclips.net/video/JNR5yx_Pg4A/видео.html
10 Excel Settings You Must CHANGE! - ruclips.net/video/vXrrXdKyJFk/видео.html
Automatic data clean up with Excel Flash Fill - ruclips.net/video/N3p_x_lXT_c/видео.html
Instant Excel Audit, Comparison and Analysis - Inquire - ruclips.net/video/cDdvUZxOUis/видео.html
Six powerful Excel Navigation Shortcuts - ruclips.net/video/bR-yMbGPq50/видео.html
Handle millions of rows in Excel - Slow to fast - ruclips.net/video/93h7rRsLF7Y/видео.html
Convert crosstab to tabular - Unpivot - Excel Power Query - ruclips.net/video/mTtOtZH-nNM/видео.html
Cheers.
Doc
Great video! Thanks for sharing your knowledge
Thanks @brendamg7298
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - ruclips.net/video/rtDlORLmjlE/видео.html
Excel Green Marks - Error Checking - Best Practices - ruclips.net/video/XeLtlzd9lRY/видео.html
Excel Best Practices - Part 1 of 3 - Data Management - ruclips.net/video/rr_1ha6g6lc/видео.html
Excel Best Practices - Part 2 of 3 - Formulas - ruclips.net/video/kz_zAvMINAk/видео.html
Excel Best Practices - Part 3 of 3 - Analytics - ruclips.net/video/JNR5yx_Pg4A/видео.html
10 Excel Settings You Must CHANGE! - ruclips.net/video/vXrrXdKyJFk/видео.html
Automatic data clean up with Excel Flash Fill - ruclips.net/video/N3p_x_lXT_c/видео.html
Instant Excel Audit, Comparison and Analysis - Inquire - ruclips.net/video/cDdvUZxOUis/видео.html
Six powerful Excel Navigation Shortcuts - ruclips.net/video/bR-yMbGPq50/видео.html
Handle millions of rows in Excel - Slow to fast - ruclips.net/video/93h7rRsLF7Y/видео.html
Convert crosstab to tabular - Unpivot - Excel Power Query - ruclips.net/video/mTtOtZH-nNM/видео.html
Cheers.
Doc
Thanks for sharing your knowledge
Thanks @dr.shwetabairagi2892
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - ruclips.net/video/rtDlORLmjlE/видео.html
Excel Green Marks - Error Checking - Best Practices - ruclips.net/video/XeLtlzd9lRY/видео.html
Excel Best Practices - Part 1 of 3 - Data Management - ruclips.net/video/rr_1ha6g6lc/видео.html
Excel Best Practices - Part 2 of 3 - Formulas - ruclips.net/video/kz_zAvMINAk/видео.html
Excel Best Practices - Part 3 of 3 - Analytics - ruclips.net/video/JNR5yx_Pg4A/видео.html
10 Excel Settings You Must CHANGE! - ruclips.net/video/vXrrXdKyJFk/видео.html
Automatic data clean up with Excel Flash Fill - ruclips.net/video/N3p_x_lXT_c/видео.html
Instant Excel Audit, Comparison and Analysis - Inquire - ruclips.net/video/cDdvUZxOUis/видео.html
Six powerful Excel Navigation Shortcuts - ruclips.net/video/bR-yMbGPq50/видео.html
Handle millions of rows in Excel - Slow to fast - ruclips.net/video/93h7rRsLF7Y/видео.html
Convert crosstab to tabular - Unpivot - Excel Power Query - ruclips.net/video/mTtOtZH-nNM/видео.html
Cheers.
Doc
Extremely useful Video.
Thank you Doc. you made my carrier! thanks for sharing knowledge.
Thanks Sisira Wijesinghe.
Check out my other best practices videos as well.
Efficient Tasks Management - ruclips.net/video/vLFpWVfUfQ8/видео.html
Microsoft Teams - 15 Best Practices - ruclips.net/video/W8Ufx_znKxI/видео.html
Smart and Effective Email - 5 powerful ways - ruclips.net/video/6NEFSMqHgQE/видео.html
Outlook Calendar Best Practices : Part 1 - ruclips.net/video/GzsQnecjAQo/видео.html and Part 2 - ruclips.net/video/padKH8ys5Cs/видео.html
OneNote - Best Practices - ruclips.net/video/m-4AY1cMi8s/видео.html
Microsoft 365 Best Practices - ruclips.net/video/kVC_YcL5ObU/видео.html
Word Tables Best Practices - The ultimate guide - ruclips.net/video/ueKCHxNUOkA/видео.html
Cheers. Doc.
Loved it. You are rock star sir
Thanks gowri sankar rao.
Watch Word Top 10 settings as well: ruclips.net/video/_8r7vNrqh34/видео.html
Check out my other best practices videos as well.
Efficient Tasks Management - ruclips.net/video/vLFpWVfUfQ8/видео.html
Microsoft Teams - 15 Best Practices - ruclips.net/video/W8Ufx_znKxI/видео.html
Smart and Effective Email - 5 powerful ways - ruclips.net/video/6NEFSMqHgQE/видео.html
Outlook Calendar Best Practices : Part 1 - ruclips.net/video/GzsQnecjAQo/видео.html and Part 2 - ruclips.net/video/padKH8ys5Cs/видео.html
OneNote - Best Practices - ruclips.net/video/m-4AY1cMi8s/видео.html
Microsoft 365 Best Practices - ruclips.net/video/kVC_YcL5ObU/видео.html
Word Tables Best Practices - The ultimate guide - ruclips.net/video/ueKCHxNUOkA/видео.html
Cheers. Doc.
Great video.! Thanks for sharing your knowledge
Thanks Carlos Baide.
Check out my other best practices videos as well.
Efficient Tasks Management - ruclips.net/video/vLFpWVfUfQ8/видео.html
Microsoft Teams - 15 Best Practices - ruclips.net/video/W8Ufx_znKxI/видео.html
Smart and Effective Email - 5 powerful ways - ruclips.net/video/6NEFSMqHgQE/видео.html
Outlook Calendar Best Practices : Part 1 - ruclips.net/video/GzsQnecjAQo/видео.html and Part 2 - ruclips.net/video/padKH8ys5Cs/видео.html
OneNote - Best Practices - ruclips.net/video/m-4AY1cMi8s/видео.html
Microsoft 365 Best Practices - ruclips.net/video/kVC_YcL5ObU/видео.html
Word Tables Best Practices - The ultimate guide - ruclips.net/video/ueKCHxNUOkA/видео.html
Cheers. Doc.
Such a useful video! Having backstage appear when I use short cuts has been such a bug bear of mine - removing this is such a relief! I don't appear to have the "Enable Data Analysis Add-Ins:Power Pivot and 3D Maps" option in my Data Options. Is there something I need to do to make this appear, or has it be superceded by something else?
UPDATE: I went to Add-Ins > Manage COM Add-Ins and selected MS Power Map for Excel and MS Power Pivot for Excel and now appear to have access.
Thanks @yertletheturtle5843
Yes. Enable the add-ins.
Just created a video to explain how to do this...
ruclips.net/video/ZEvAa-JWK6M/видео.html
Check out my other best practices videos as well.
Task Management Best Practices - ruclips.net/video/DJcxPtu-rcg/видео.html
Efficient Tasks Management using the New Planner 2024 - ruclips.net/video/kgxqzDirw1o/видео.html
Microsoft Teams Meetings - 16 Best Practices - ruclips.net/video/l3Bvq-I0hy4/видео.html
Microsoft Teams - 15 Best Practices - ruclips.net/video/W8Ufx_znKxI/видео.html
OneDrive Best Practices Part 1 - ruclips.net/video/D7ZrfphW4vo/видео.html Part 2 - ruclips.net/video/nFx6YQxc-b4/видео.html
Smart and Effective Email - 5 powerful ways - ruclips.net/video/6NEFSMqHgQE/видео.html
Outlook Calendar Best Practices : Part 1 - ruclips.net/video/GzsQnecjAQo/видео.html and Part 2 - ruclips.net/video/padKH8ys5Cs/видео.html
OneNote - Best Practices - ruclips.net/video/m-4AY1cMi8s/видео.html
Microsoft 365 Best Practices - ruclips.net/video/kVC_YcL5ObU/видео.html
Cheers. Doc.
Very Useful
ThANK YOU
Thanks @Muzammil-689
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - ruclips.net/video/rtDlORLmjlE/видео.html
Excel Green Marks - Error Checking - Best Practices - ruclips.net/video/XeLtlzd9lRY/видео.html
Excel Best Practices - Part 1 of 3 - Data Management - ruclips.net/video/rr_1ha6g6lc/видео.html
Excel Best Practices - Part 2 of 3 - Formulas - ruclips.net/video/kz_zAvMINAk/видео.html
Excel Best Practices - Part 3 of 3 - Analytics - ruclips.net/video/JNR5yx_Pg4A/видео.html
10 Excel Settings You Must CHANGE! - ruclips.net/video/vXrrXdKyJFk/видео.html
Automatic data clean up with Excel Flash Fill - ruclips.net/video/N3p_x_lXT_c/видео.html
Instant Excel Audit, Comparison and Analysis - Inquire - ruclips.net/video/cDdvUZxOUis/видео.html
Six powerful Excel Navigation Shortcuts - ruclips.net/video/bR-yMbGPq50/видео.html
Handle millions of rows in Excel - Slow to fast - ruclips.net/video/93h7rRsLF7Y/видео.html
Convert crosstab to tabular - Unpivot - Excel Power Query - ruclips.net/video/mTtOtZH-nNM/видео.html
Cheers.
Doc
Very useful tip...will use in my day-to-day😀 work
Thanks. Have you seen the Word Top 10 Settings video? ruclips.net/video/_8r7vNrqh34/видео.html
Shortcut for Wrap text is Alt + H + W, one can easily remember it associating H + W with HardWare. This shortcut is universal, for English users.
Thanks @romulusmilea2747
Yes you can use native shortcuts. No problem.
I am talking about a generic concept of creating shortcuts for any button which is frequently used and does not have a native shortcut.
Wrap text was just an illustrative example.
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - ruclips.net/video/rtDlORLmjlE/видео.html
Excel Green Marks - Error Checking - Best Practices - ruclips.net/video/XeLtlzd9lRY/видео.html
Excel Best Practices - Part 1 of 3 - Data Management - ruclips.net/video/rr_1ha6g6lc/видео.html
Excel Best Practices - Part 2 of 3 - Formulas - ruclips.net/video/kz_zAvMINAk/видео.html
Excel Best Practices - Part 3 of 3 - Analytics - ruclips.net/video/JNR5yx_Pg4A/видео.html
10 Excel Settings You Must CHANGE! - ruclips.net/video/vXrrXdKyJFk/видео.html
Automatic data clean up with Excel Flash Fill - ruclips.net/video/N3p_x_lXT_c/видео.html
Instant Excel Audit, Comparison and Analysis - Inquire - ruclips.net/video/cDdvUZxOUis/видео.html
Six powerful Excel Navigation Shortcuts - ruclips.net/video/bR-yMbGPq50/видео.html
Handle millions of rows in Excel - Slow to fast - ruclips.net/video/93h7rRsLF7Y/видео.html
Convert crosstab to tabular - Unpivot - Excel Power Query - ruclips.net/video/mTtOtZH-nNM/видео.html
Cheers.
Doc
V. Good tips Dear Dr.
Thanks Vijay.. Let me know any items I missed but you find them as important settings.
As always great video
Thanks INDERJEET4321 for the feedback.
You may also like these Word related videos:
Word top 10 settings - ruclips.net/video/_8r7vNrqh34/видео.html
Word Tables - 8 ways to create: ruclips.net/video/X-G8bZVCGBk/видео.html
Word Tables - 13 problems solved: ruclips.net/video/y5IblpvN_Jg/видео.html
Word Styles - ruclips.net/video/7f_aOgsvKA0/видео.html
Handing long, complex word documents - ruclips.net/video/9jrYJHQ7YmQ/видео.html
Thanks.
I don't have option of opening files in office desktop apps. I am using MS 2019 which is installed on my laptop by default and also has O365 subscription. But I chose to use MS 2019 as it is lifetime free. Is this option available anywhere in MS 2019.?
You need Office 365 version of Office.
Go to Office.com and check if you have the option of Installing Office from there.
If not you have O365 which only gives you browser versions of Office.
@@efficiency365 I have O365 in my office, there i changed it but still it's not opening on desktop. Also sir, is there anyway where we can use ctrl+[ in online sheet for going to dependent?. In the desktop version it works smoothly but when working online can't go to a dependent cell,
O365 comes in various editions. Yours will be Business Basic - If you have Business Premium, you will get the latest desktop version.
Some features will not come to the 2019, 2021 versions.
Excel on web does not have Trace Dependents / Precedents.
So the shortcut will not work.
Hello sir,,how are you
Sir,, pls make a video for note taking ,,i am using office 365
Hi
Already have the video - OneNote best practices: ruclips.net/video/m-4AY1cMi8s/видео.html
Sir I don't have analyse data😢in mine what to do! How to get it
Thanks @homey.channel
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - ruclips.net/video/rtDlORLmjlE/видео.html
Excel Green Marks - Error Checking - Best Practices - ruclips.net/video/XeLtlzd9lRY/видео.html
Excel Best Practices - Part 1 of 3 - Data Management - ruclips.net/video/rr_1ha6g6lc/видео.html
Excel Best Practices - Part 2 of 3 - Formulas - ruclips.net/video/kz_zAvMINAk/видео.html
Excel Best Practices - Part 3 of 3 - Analytics - ruclips.net/video/JNR5yx_Pg4A/видео.html
10 Excel Settings You Must CHANGE! - ruclips.net/video/vXrrXdKyJFk/видео.html
Automatic data clean up with Excel Flash Fill - ruclips.net/video/N3p_x_lXT_c/видео.html
Instant Excel Audit, Comparison and Analysis - Inquire - ruclips.net/video/cDdvUZxOUis/видео.html
Six powerful Excel Navigation Shortcuts - ruclips.net/video/bR-yMbGPq50/видео.html
Handle millions of rows in Excel - Slow to fast - ruclips.net/video/93h7rRsLF7Y/видео.html
Convert crosstab to tabular - Unpivot - Excel Power Query - ruclips.net/video/mTtOtZH-nNM/видео.html
Cheers.
Doc
Formula error with different color and blank cell formula error are useful feature.
Critical thing - that is often ignored.
Wonderful video, in one of my excel facing proflem of formula bar value different from cell value, can you please share your email id to send that excel sheet.
Thanks in advance.
Sure. asknitin@maxoffice.co
@@efficiency365 Given email ID not working, please share working email ID