Desktop | Analyzing and Formatting


Create a workbook that demonstrates the following concepts:

  • Sorting
  • Grouping and Sets
  • Aliasing
  • Totals and Subtotals
  • Aggregation and Disaggregation
  • Drilling.
  • Formatting
  • Default formatting for measures
  • Special formatting for measures
  • How to format dates

Be prepared to describe/demonstrate the differences between groups and sets, two ways to enable subtotals, and aggregation and disaggregation. Bonus for worksheets that show the top 3 products by market and can show a formatted date in the format ‘Tuesday, Jun 21, 2012’ and ‘21/06/2012’ and ‘2012-06-21’.

Recommended Viewing