Key Points

  • You can easily restructure data on a sheet, and move data within and between sheets and workbooks.

  • By using the Data Validation feature, you can restrict the type of data entered in a list sheet by specifying conditions for each column.

  • Using the Conditional Formatting feature, you can apply special font and cell formatting to cell values that meet conditions you specify.

  • You can simplify the process of analyzing data by displaying the data in a chart.

  • You can manage workbook content by adding or removing sheets, copying or moving sheets, or assigning names to sheets to make them easily identifiable.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset