Turned off all error checking because it had been too daunting to take the time and trouble to learn about all those little green triangles, with all the different error categories. Worked along with this very clear and quick video. Learned a great deal. AND, additionally could finally feel relaxed about the 47MB Excel file that I'm currently using. Thank you!
Thanks @finiteloops8610 See if you have an Optimize button in Review tab. It will help you reduce file size and improve performance. Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ua-cam.com/video/rtDlORLmjlE/v-deo.html Excel Green Marks - Error Checking - Best Practices - ua-cam.com/video/XeLtlzd9lRY/v-deo.html Excel Best Practices - Part 1 of 3 - Data Management - ua-cam.com/video/rr_1ha6g6lc/v-deo.html Excel Best Practices - Part 2 of 3 - Formulas - ua-cam.com/video/kz_zAvMINAk/v-deo.html Excel Best Practices - Part 3 of 3 - Analytics - ua-cam.com/video/JNR5yx_Pg4A/v-deo.html 10 Excel Settings You Must CHANGE! - ua-cam.com/video/vXrrXdKyJFk/v-deo.html Automatic data clean up with Excel Flash Fill - ua-cam.com/video/N3p_x_lXT_c/v-deo.html Instant Excel Audit, Comparison and Analysis - Inquire - ua-cam.com/video/cDdvUZxOUis/v-deo.html Six powerful Excel Navigation Shortcuts - ua-cam.com/video/bR-yMbGPq50/v-deo.html Handle millions of rows in Excel - Slow to fast - ua-cam.com/video/93h7rRsLF7Y/v-deo.html Convert crosstab to tabular - Unpivot - Excel Power Query - ua-cam.com/video/mTtOtZH-nNM/v-deo.html Cheers. Doc
Thanks @azwarmzafar. Check out my "Office 365 Masterclass" All of the 27 apps covered. ua-cam.com/video/kVC_YcL5ObU/v-deo.html It shows which app to use when and how. Practical and authoritative guidance. Doc.
Waao global error checking is really a time saver. Many times we download bank statement and needs to convert all the figures into numbers but the sheet has soo many merged cells so all gets selected. Will try this today and see how it works. The rest are also superb. Thanks for sharing.
There is a benefit behind every feature. Once you understand that, sky is the limit. It is not about tips and tricks or basic / advanced or a quick fix. Watch this video to learn - How to Learn - ua-cam.com/video/RsSJDVNC-Eo/v-deo.html
Turned off all error checking because it had been too daunting to take the time and trouble to learn about all those little green triangles, with all the different error categories. Worked along with this very clear and quick video. Learned a great deal. AND, additionally could finally feel relaxed about the 47MB Excel file that I'm currently using. Thank you!
Thanks @finiteloops8610
See if you have an Optimize button in Review tab.
It will help you reduce file size and improve performance.
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - ua-cam.com/video/rtDlORLmjlE/v-deo.html
Excel Green Marks - Error Checking - Best Practices - ua-cam.com/video/XeLtlzd9lRY/v-deo.html
Excel Best Practices - Part 1 of 3 - Data Management - ua-cam.com/video/rr_1ha6g6lc/v-deo.html
Excel Best Practices - Part 2 of 3 - Formulas - ua-cam.com/video/kz_zAvMINAk/v-deo.html
Excel Best Practices - Part 3 of 3 - Analytics - ua-cam.com/video/JNR5yx_Pg4A/v-deo.html
10 Excel Settings You Must CHANGE! - ua-cam.com/video/vXrrXdKyJFk/v-deo.html
Automatic data clean up with Excel Flash Fill - ua-cam.com/video/N3p_x_lXT_c/v-deo.html
Instant Excel Audit, Comparison and Analysis - Inquire - ua-cam.com/video/cDdvUZxOUis/v-deo.html
Six powerful Excel Navigation Shortcuts - ua-cam.com/video/bR-yMbGPq50/v-deo.html
Handle millions of rows in Excel - Slow to fast - ua-cam.com/video/93h7rRsLF7Y/v-deo.html
Convert crosstab to tabular - Unpivot - Excel Power Query - ua-cam.com/video/mTtOtZH-nNM/v-deo.html
Cheers.
Doc
Thanks a lot, fantastic one as usual!
Thanks @azwarmzafar.
Check out my "Office 365 Masterclass"
All of the 27 apps covered.
ua-cam.com/video/kVC_YcL5ObU/v-deo.html
It shows which app to use when and how. Practical and authoritative guidance.
Doc.
Waao global error checking is really a time saver. Many times we download bank statement and needs to convert all the figures into numbers but the sheet has soo many merged cells so all gets selected. Will try this today and see how it works. The rest are also superb. Thanks for sharing.
There is a benefit behind every feature.
Once you understand that, sky is the limit.
It is not about tips and tricks or basic / advanced or a quick fix.
Watch this video to learn - How to Learn - ua-cam.com/video/RsSJDVNC-Eo/v-deo.html