Scenario and Goals

The Contoso, Ltd. company wants to evaluate and analyze its profit margins, focusing on overall percentages and variances. After you complete this example, you should be able to perform the following actions in Excel:

  • Automatically fill in a month series and create your own fill styles

  • Enter formulas

  • Work with tables and style sheets

  • Format cells

  • Add and format graphics and charts

  • Create a PivotTable and PivotChart

Sample Files

Use the Profit margin, Namerows, and Table profit margin worksheets in the Excel_Example.xls or Excel_Example.xlsx sample file. The sample files are found in the Chapter01 folder. For more information about the sample files, see the section titled Using the Sample Files.

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial