Objectives Set a validation rule to enter data in a Introduction to Excel worksheet Definition of a Spreadsheet Import data Advantages of a Spreadsheet Apply number formats Components of Excel Window Apply a condition for formatting Create a new workbook Create names for ranges of cells Opening, creating, and saving a workbook Apply the names in formulas Enter and Edit data in a worksheet Locate the required data Edit and format cells, rows and columns Sort data Format numbers and apply style Filter data Link data in the worksheet Calculate subtotals Refer to cells in a formula Audit a worksheet Importing and exporting data Secure the contents of a workbook Creating a web page Create a macro Placing interactive data on the web Execute a macro View different sections of a worksheet Change the print settings of a workbook Insert a picture Print a workbook Preview and print workbook/sheet Perform what-if analysis Creating and modifying graphics (charts) Create dynamic tables and charts to Set a validation rule to enter data in a worksheet analyze data Publish dynamic tables and charts in an interactive Web page Page 141
Objectives Introduction to Excel Definition of a Spreadsheet Advantages of a Spreadsheet Components of Excel Window Create a new workbook Opening, creating, and saving a workbook Enter and Edit data in a worksheet Edit and format cells, rows and columns Format numbers and apply style Link data in the worksheet Refer to cells in a formula Importing and exporting data Creating a web page Placing interactive data on the web View different sections of a worksheet Insert a picture Preview and print workbook/sheet Creating and modifying graphics (charts) Set a validation rule to enter data in a worksheet Set a validation rule to enter data in a worksheet Import data Apply number formats Apply a condition for formatting Create names for ranges of cells Apply the names in formulas Locate the required data Sort data Filter data Calculate subtotals Audit a worksheet Secure the contents of a workbook Create a macro Execute a macro Change the print settings of a workbook Print a workbook Perform what-if analysis Create dynamic tables and charts to analyze data Publish dynamic tables and charts in an interactive Web page Page 141
Advance_Digital_Appreciation.docx