10 Excel settings you should review before using Excel Again.
👉 Take our Data Analyst Program: https://www.careerprinciples.com/career-track/the-data-analyst-program
🆓 DOWNLOAD the Excel file for this video: https://careerprinciples.myflodesk.com/l5v5x3n970
Excel has hundreds of settings, and if you use Excel regularly, the 10 setting changes I'm about to show you will transform the way you work. Best part is, you only need to change them once, and you can enjoy the benefits forever. The 10 settings we'll review are: 1. Leading zeros and how to stop Excel from removing them automatically. 2. Deactivating the background cell error every time you add an inconsitent formula. 3. Converting data into a table so formula arrays are dynamic. 4. Changing the default table syntax so it's consistent with Excel formulas outside tables. 5. Changing the default worksheet count (default is just one worksheet, but can change to start a new excel file with multiple sheets). 6. How to collapse the top ribbon for a better view of the Excel worksheet. 7. Creating a new custom color theme. 8. Creating custom lists so you don't have to type the same data every time. 9. Enabeling iterative calculations to avoid circularity errors. 10. Adding the focus cell so you can see the cell you have selected better.
LEARN:
🔥Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course
👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
🚀 All our courses: https://www.careerprinciples.com/courses