Thanks @ambkumar Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-rtDlORLmjlE.html Excel Green Marks - Error Checking - Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-XeLtlzd9lRY.html Excel Best Practices - Part 1 of 3 - Data Management - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-rr_1ha6g6lc.html Excel Best Practices - Part 2 of 3 - Formulas - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kz_zAvMINAk.html Excel Best Practices - Part 3 of 3 - Analytics - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-JNR5yx_Pg4A.html 10 Excel Settings You Must CHANGE! - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vXrrXdKyJFk.html Automatic data clean up with Excel Flash Fill - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-N3p_x_lXT_c.html Instant Excel Audit, Comparison and Analysis - Inquire - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-cDdvUZxOUis.html Six powerful Excel Navigation Shortcuts - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bR-yMbGPq50.html Handle millions of rows in Excel - Slow to fast - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-93h7rRsLF7Y.html Convert crosstab to tabular - Unpivot - Excel Power Query - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-mTtOtZH-nNM.html Cheers. Doc
Thanks @dr.shwetabairagi2892 Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-rtDlORLmjlE.html Excel Green Marks - Error Checking - Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-XeLtlzd9lRY.html Excel Best Practices - Part 1 of 3 - Data Management - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-rr_1ha6g6lc.html Excel Best Practices - Part 2 of 3 - Formulas - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kz_zAvMINAk.html Excel Best Practices - Part 3 of 3 - Analytics - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-JNR5yx_Pg4A.html 10 Excel Settings You Must CHANGE! - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vXrrXdKyJFk.html Automatic data clean up with Excel Flash Fill - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-N3p_x_lXT_c.html Instant Excel Audit, Comparison and Analysis - Inquire - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-cDdvUZxOUis.html Six powerful Excel Navigation Shortcuts - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bR-yMbGPq50.html Handle millions of rows in Excel - Slow to fast - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-93h7rRsLF7Y.html Convert crosstab to tabular - Unpivot - Excel Power Query - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-mTtOtZH-nNM.html Cheers. Doc
Thanks @brendamg7298 Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-rtDlORLmjlE.html Excel Green Marks - Error Checking - Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-XeLtlzd9lRY.html Excel Best Practices - Part 1 of 3 - Data Management - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-rr_1ha6g6lc.html Excel Best Practices - Part 2 of 3 - Formulas - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kz_zAvMINAk.html Excel Best Practices - Part 3 of 3 - Analytics - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-JNR5yx_Pg4A.html 10 Excel Settings You Must CHANGE! - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vXrrXdKyJFk.html Automatic data clean up with Excel Flash Fill - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-N3p_x_lXT_c.html Instant Excel Audit, Comparison and Analysis - Inquire - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-cDdvUZxOUis.html Six powerful Excel Navigation Shortcuts - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bR-yMbGPq50.html Handle millions of rows in Excel - Slow to fast - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-93h7rRsLF7Y.html Convert crosstab to tabular - Unpivot - Excel Power Query - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-mTtOtZH-nNM.html Cheers. Doc
Thanks Sisira Wijesinghe. Check out my other best practices videos as well. Efficient Tasks Management - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vLFpWVfUfQ8.html Microsoft Teams - 15 Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-W8Ufx_znKxI.html Smart and Effective Email - 5 powerful ways - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-6NEFSMqHgQE.html Outlook Calendar Best Practices : Part 1 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-GzsQnecjAQo.html and Part 2 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-padKH8ys5Cs.html OneNote - Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-m-4AY1cMi8s.html Microsoft 365 Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kVC_YcL5ObU.html Word Tables Best Practices - The ultimate guide - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ueKCHxNUOkA.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 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-rtDlORLmjlE.html Excel Green Marks - Error Checking - Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-XeLtlzd9lRY.html Excel Best Practices - Part 1 of 3 - Data Management - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-rr_1ha6g6lc.html Excel Best Practices - Part 2 of 3 - Formulas - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kz_zAvMINAk.html Excel Best Practices - Part 3 of 3 - Analytics - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-JNR5yx_Pg4A.html 10 Excel Settings You Must CHANGE! - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vXrrXdKyJFk.html Automatic data clean up with Excel Flash Fill - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-N3p_x_lXT_c.html Instant Excel Audit, Comparison and Analysis - Inquire - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-cDdvUZxOUis.html Six powerful Excel Navigation Shortcuts - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bR-yMbGPq50.html Handle millions of rows in Excel - Slow to fast - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-93h7rRsLF7Y.html Convert crosstab to tabular - Unpivot - Excel Power Query - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-mTtOtZH-nNM.html Cheers. Doc
Thanks gowri sankar rao. Watch Word Top 10 settings as well: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-_8r7vNrqh34.html Check out my other best practices videos as well. Efficient Tasks Management - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vLFpWVfUfQ8.html Microsoft Teams - 15 Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-W8Ufx_znKxI.html Smart and Effective Email - 5 powerful ways - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-6NEFSMqHgQE.html Outlook Calendar Best Practices : Part 1 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-GzsQnecjAQo.html and Part 2 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-padKH8ys5Cs.html OneNote - Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-m-4AY1cMi8s.html Microsoft 365 Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kVC_YcL5ObU.html Word Tables Best Practices - The ultimate guide - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-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... ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ZEvAa-JWK6M.html Check out my other best practices videos as well. Task Management Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-DJcxPtu-rcg.html Efficient Tasks Management using the New Planner 2024 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kgxqzDirw1o.html Microsoft Teams Meetings - 16 Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-l3Bvq-I0hy4.html Microsoft Teams - 15 Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-W8Ufx_znKxI.html OneDrive Best Practices Part 1 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-D7ZrfphW4vo.html Part 2 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-nFx6YQxc-b4.html Smart and Effective Email - 5 powerful ways - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-6NEFSMqHgQE.html Outlook Calendar Best Practices : Part 1 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-GzsQnecjAQo.html and Part 2 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-padKH8ys5Cs.html OneNote - Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-m-4AY1cMi8s.html Microsoft 365 Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kVC_YcL5ObU.html Cheers. Doc.
Thanks Carlos Baide. Check out my other best practices videos as well. Efficient Tasks Management - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vLFpWVfUfQ8.html Microsoft Teams - 15 Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-W8Ufx_znKxI.html Smart and Effective Email - 5 powerful ways - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-6NEFSMqHgQE.html Outlook Calendar Best Practices : Part 1 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-GzsQnecjAQo.html and Part 2 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-padKH8ys5Cs.html OneNote - Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-m-4AY1cMi8s.html Microsoft 365 Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kVC_YcL5ObU.html Word Tables Best Practices - The ultimate guide - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ueKCHxNUOkA.html Cheers. Doc.
Thanks @Muzammil-689 Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-rtDlORLmjlE.html Excel Green Marks - Error Checking - Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-XeLtlzd9lRY.html Excel Best Practices - Part 1 of 3 - Data Management - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-rr_1ha6g6lc.html Excel Best Practices - Part 2 of 3 - Formulas - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kz_zAvMINAk.html Excel Best Practices - Part 3 of 3 - Analytics - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-JNR5yx_Pg4A.html 10 Excel Settings You Must CHANGE! - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vXrrXdKyJFk.html Automatic data clean up with Excel Flash Fill - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-N3p_x_lXT_c.html Instant Excel Audit, Comparison and Analysis - Inquire - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-cDdvUZxOUis.html Six powerful Excel Navigation Shortcuts - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bR-yMbGPq50.html Handle millions of rows in Excel - Slow to fast - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-93h7rRsLF7Y.html Convert crosstab to tabular - Unpivot - Excel Power Query - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-mTtOtZH-nNM.html Cheers. Doc
Thanks INDERJEET4321 for the feedback. You may also like these Word related videos: Word top 10 settings - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-_8r7vNrqh34.html Word Tables - 8 ways to create: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-X-G8bZVCGBk.html Word Tables - 13 problems solved: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-y5IblpvN_Jg.html Word Styles - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-7f_aOgsvKA0.html Handing long, complex word documents - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-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 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-rtDlORLmjlE.html Excel Green Marks - Error Checking - Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-XeLtlzd9lRY.html Excel Best Practices - Part 1 of 3 - Data Management - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-rr_1ha6g6lc.html Excel Best Practices - Part 2 of 3 - Formulas - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kz_zAvMINAk.html Excel Best Practices - Part 3 of 3 - Analytics - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-JNR5yx_Pg4A.html 10 Excel Settings You Must CHANGE! - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vXrrXdKyJFk.html Automatic data clean up with Excel Flash Fill - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-N3p_x_lXT_c.html Instant Excel Audit, Comparison and Analysis - Inquire - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-cDdvUZxOUis.html Six powerful Excel Navigation Shortcuts - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bR-yMbGPq50.html Handle millions of rows in Excel - Slow to fast - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-93h7rRsLF7Y.html Convert crosstab to tabular - Unpivot - Excel Power Query - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-mTtOtZH-nNM.html Cheers. Doc
Thanks @motarikmalek6040 Now you know. Just explore, apply and learn. Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-rtDlORLmjlE.html Excel Green Marks - Error Checking - Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-XeLtlzd9lRY.html Excel Best Practices - Part 1 of 3 - Data Management - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-rr_1ha6g6lc.html Excel Best Practices - Part 2 of 3 - Formulas - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kz_zAvMINAk.html Excel Best Practices - Part 3 of 3 - Analytics - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-JNR5yx_Pg4A.html 10 Excel Settings You Must CHANGE! - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vXrrXdKyJFk.html Automatic data clean up with Excel Flash Fill - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-N3p_x_lXT_c.html Instant Excel Audit, Comparison and Analysis - Inquire - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-cDdvUZxOUis.html Six powerful Excel Navigation Shortcuts - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bR-yMbGPq50.html Handle millions of rows in Excel - Slow to fast - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-93h7rRsLF7Y.html Convert crosstab to tabular - Unpivot - Excel Power Query - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-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.
