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
Students succeed in their courses by connecting and communicating with an expert until they receive help on their questions
Consult our trusted tutors.