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.