Organize data and objects in Excel 2010

Course details

Excel 2010 offers many features to organize and manage data, including the sorting and filtering tools that are essential for data analysis are included. By organizational characteristics data, you can sort, filter and group data and make data schemas, allowing focus on its most important parts. The data organized properly using the commands of the Arrange group they can be presented in a logical and easy to understand way. This course explores how to organize data into Excel 2010 using the built-in features. Also © n explains how to organize objects for display in addition how best to use hyperlinks to organize data.

• sort data in more than one column or row
• create a custom filter
• make sketches of the data using the Subtotal, self-schema command or Group
• arrange items on a sheet of cá¡lculo
• recognize how you can organize data to suit a particular design ± or page for printing
• create a hyperlink
• modify hyperlinks
• sort and filter data
• create a schema to group and summarize data
• organize objects on a page
• create a hyperlink on a sheet to a web page cá¡lculo