About Course:
  • Analyzing data in Excel 2007
  • Excel 2007 offers powerful data analysis tools that allow you to explore large amounts of data and make informed business decisions based on that data. With reports of dynamic table, you can interactively summarize data, which facilitates the analysis and presentation of results. Dynamic graph reports provide a graphical view of the data contained in the reports of dynamic table. Tools Goal Seek and Solver can retrieve required results from formulas by determining the data the formula requires. Also © n can use two other components analysis and if, data tables and scenarios to see how changes in the formulas to results © stas and models predict results cá¡lculo sheet, respectively. In this course advanced data analysis features, such as dynamic table reports and dynamic report, Goal Seek, Solver, scenarios, data tables and OLAP are discussed.
  • Create a dynamic report table
  • Reorganize data in a dynamic table
  • Customize dynamic table reports
  • Modify the appearance of a dynamic report table
  • Create a dynamic graph report
  • Modify a dynamic graph report
  • Perform calculations in dynamic table reports
  • Recognize when to use each type of cá¡lculo
  • Create a dynamic report table
  • Customize a dynamic report table
  • Change summary of a report from dynamic table
  • Create a formula,dynamic graph
  • Search using objective data for analysis
  • Solver used for data analysis
  • Create scenarios for analysis 
  • Use the Scenario Manager to modify settings
  • Create a table of variable data for data analysis
  • Create a table of data from two variables for data analysis
  • Provide values in a series
  • Perform advanced functions
  • Join the advanced functions usage samples
  • Consolidate data from different books using a summary function
  • Use Goal Seek
  • Solver used for analysis and if
  • Create a table of data for analysis and if
  • Using advanced functions and consolidate data

The Cisco Learning Partner Conference in Montreal, Canada, New Horizons was awarded the Worldwide Acceleration and Transformation Partner of the Year Award.

“They are honored to be recognized for the strong partnership that They have had with Learning@Cisco this past year,” said Bryan Ochs, VP of Global Products and Programs. “They look forward to our continued collaboration to further innovate on Cisco learning products that enhance and transform the Cisco student learning experience for our New Horizon clients.”

See all New Horizons Lebanon courses

Contact information not available.

Courses you can instantly connect with...
Working with documents in Word 2003 New Horizons Lebanon Use Tables and Graphics in Word 2007 New Horizons Lebanon Adding images to PowerPoint 2010 presentations New Horizons Lebanon

Is this the right course for you?

Rate our content

Didn't find what you were looking for ?