Manipulating and formatting data and spreadsheets

Excel 2007 offers several new features and improved tools that allow you to improve the appearance of leaves and books. Cells, rows, columns, worksheets and workbooks can be manipulated and customized using different formatting and positioning. This course explores the process of copying and moving cells, columns, rows, and sheets, as well as inserting or removing sheets and modifying books. Also © n includes formatting tables to text and numeric data © rich and conditional formatting.

• Copy or move data in given situations
• Add, delete or change the size ± or rows and columns in a given situation
• Modify rows and columns for specific sections of the sheet Calculation
• Format books in given situations
• Insert and delete a sheet of Calculation
• Rename a sheet and format the color of the label
• Copy or move spreadsheets
• Modify cells and books in a given situation
• Modify spreadsheets for specific data
• Copy and move data and spreadsheets in a given situation
• Basic formatting of data
• Table format to a range of data
• Re position the cell data in a given situation
• Identify the functions of the commands Alignment
• Working with Tables in Excel 2007
• Table format to a range of data
• Modify a table in Excel
• Numa © rich formats apply in a given situation
• Identify the number formatting options available in Excel 2007
• Basic apply conditional formatting rules in a given situation
• Recognize situations in which conditional formatting is appropriate
• Format data and apply conditional formatting in a given situation
• Move data between workbooks and apply formats in a given situation