Manipulating and Formatting Data and Worksheets
Descriere curs:
- Description: Excel 2007 provides a number of improved tools and new features that allow you to visually enhance the appearance of sheets and workbooks. Cells, rows, columns, sheets, and workbooks can be manipulated and customized using various positioning and formatting features. This course explores the processing of copying and moving cells, columns, rows, and sheets, as well as inserting or removing sheets and modifying workbooks. Formatting tables, textual data, and numerical data, as well as conditional formatting, is also covered.
- Target audience: Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel 2007.
- Estimated Duration: 3.5 h
- Lesson Objectives: Copy and Move Data in Excel 2007
• copy or move data in given scenarios
Modify Rows and Columns in Excel 2007
• add, delete, or resize rows and columns in a given scenario
• modify rows and columns to view specific sections of the worksheet
Insert and Modify Worksheets in Excel 2007
• format workbooks in given scenarios
• insert and delete a worksheet
• rename a worksheet and format the tab color
• copy or move worksheets
Working with Data and Workbooks in Excel 2007
Copying and Moving Data and Worksheets
Format Data in Excel 2007
• apply basic data formatting
• format a data range as a table
• change the position of data in a cell in a given scenario
• identify the functions of Alignment commands
Format Data as a Table in Excel 2007
• work with tables in Excel 2007
• format a data range as a table
• modify an Excel table
Format Numbers in Excel 2007
• apply number formats in a given scenario
• identify the number formatting options available in Excel 2007
Conditional Formatting in Excel 2007
• apply basic conditional formatting rules in a given scenario
• recognize situations when conditional formatting is suitable
Formatting Data in Excel 2007
Formatting Data and Workbooks in Excel 2007
Opinii/comentarii despre acest produs
Nu am gasit comentarii despre acest produs.