You will prepare an Excel 2016 Workbook and related PowerPoint 2016 Document for Apple Inc Company information and statistics such as any of the following:

• Inventory data

• human resource data – employee related (salary, retention, benefits, performance …)

• sales and revenue data

• budget data

• financial analysis and forecasting data

Refer to Company Websites, Financial Reports, SAM Projects, Library or Excel Textbook etc. for examples. Both your documents must be created from scratch.

Requirements:

Consistency across Excel 

• use the same Theme for both documents

• consistent content, organization, positioning and formatting across both documents

o they look clean, professional and uncluttered 

Excel 2016 Workbook:

• include at least two Tables

o on separate sheets presenting different information

o properly formatted, labeled and titled

o a non-default Table Style is applied to each

• include at least two different types of Charts

o on separate sheets presenting different information

o properly formatted, labeled and titled

o a non-default Chart Style is applied to each

• use of proper Cell Styles and Borders

• use of Structured (Named) References where appropriate

• include at least three different AutoFunctions in your tables (Sum, Average, Min, etc.)

• includes at least three, different, hand-written Formulae of at least intermediate complexity in your tables

o formulas should display 

 complex calculations using multiple operations and parentheses and/or

 non-AutoFunction Formulae (If, PMT, FV, Match, CountIf, etc.) 

• make sure that Formulae and other information is properly produced in Series by using the Fill Handle

• use at least three different Number Formats (Accounting, Currency, Dates, etc.) correctly and consistently in your Tables

• use Conditional Formatting at least twice in your Tables