If you record daily sales data in Excel, it may be impossible to explain variances from day to day. Instead, it may make more sense to summarize the data by week to spot trends and explain variations.
Microsoft Excel 2010 can convert a worksheet to a data table to help you quickly analyze your related data in formatted rows and columns. When you need to expand the table layout, apply the Home tab ...