Part 2/7:
For example, we can start with a date such as June 1st, 2012, where we sold 10 items, generating sales of $500. We can then calculate taxes—assuming a 12% tax rate for Vancouver—and determine the cash after taxes by subtracting taxes from sales.
The table grows by merely entering data in subsequent rows, including random sales figures for a period spanning ten days. However, until we convert this range of data into a table, it remains static and unautomated.
Converting a Range to a Table
To convert a simple data range into a table in Excel, we have two primary methods:
Pressing Ctrl + T on the keyboard
Going to the Insert tab and selecting Table