Microsoft Excel Tutorial for Beginners: Lesson 1

[soybean]

Best Practices when working with Microsoft Excel​

1. Save workbooks with backward compatibility in mind. If you are not using the latest features in higher versions of Excel, you should save your files in 2003 *.xls format for backwards compatibility
2. Use description names for columns and worksheets in a workbook
3. Avoid working with complex formulas with many variables. Try to break them down into small managed results that you can use to build on
4. Use built-in functions whenever you can instead of writing your own formulas

​

 

[soybean]

Summary​

• Introduction of MS Excel : Microsoft Excel is a powerful spreadsheet program used to record, manipulate, store numeric data and it can be customized to match your preferences
• The ribbon is used to access various commands in Excel
• The options dialogue window allows you to customize a number of items i.e. the ribbon, formulas, proofing, save, etc.