EXCEL TRAINING INSTITUTE IN COIMBATORE
Excel Course in Coimbatore
Manage Workbook Options and Settings
1.1. Create Worksheets and Workbooks
▪ Create a workbook
▪ Import data from a delimited text file
▪ Add a worksheet to an existing workbook
▪ Copy and move a worksheet
1.2. Navigate in Worksheets and Workbooks
▪ Search for data within a workbook
▪ Navigate to a named cell, range, or workbook element
▪ Insert and remove hyperlinks
1.3. Format Worksheets and Workbooks
▪ Change worksheet tab color
▪ Rename a worksheet
▪ Change worksheet order
▪ Insert and delete columns or rows
▪ Change workbook themes
▪ Adjust row height and column width
▪ Insert headers and footers
1.4. Customize Options and Views for Worksheets and Workbooks
▪ Hide or unhide worksheets
▪ Hide or unhide columns and rows
▪ Customize the Quick Access toolbar
▪ Modify document properties
▪ Display formulas
1.5. Configure Worksheets and Workbooks for Distribution
▪ Inspect a workbook for hidden properties or personal information
▪ Inspect a workbook for accessibility issues
▪ Inspect a workbook for compatibility issues