MacMost Live: Building a Basic Business Spreadsheet In Mac Numbers

Watch as I build a basic business spreadsheet live from scratch. Expenses and income will have their own tables in their own sheets, with a summary sheet that adds up each category. We'll also track items that don't have a category assigned and add a custom filter that will allow this one document to be used for multiple years.

Video transcript available soon.

Here is the file

Comments: 4 Responses to “MacMost Live: Building a Basic Business Spreadsheet In Mac Numbers”

    Joseph Leahy
    4 weeks ago

    Number the first column the same as the row, so you can always get back the original sort order.
    This number can also be written at the top of any invoice or credit note as a reference.

    Gloria Messer
    4 weeks ago

    Can we request that Apple insert a numbered column as the first column, as it is done in Word?

    4 weeks ago

    Gloria: Not sure what you mean. But you can do that yourself easily enough. =ROW() or =ROW()-1

    Scott
    4 weeks ago

    Very nice video, question.  Based on your design I created a Rideshare spreadsheet.  I sometimes drive for Lyft, Uber or other carriers.  I want to find my totals and averages based on carrier I drove for.  The more complicated formula that tests for a match to the filter table and returns true or false returns an error to me.  The error reads…“The formula was replaced by the last calculated value”. I can of course go to the record above and copy, then paste the formula, and it works fine

Leave a New Comment Related to "MacMost Live: Building a Basic Business Spreadsheet In Mac Numbers"

:
:
:
0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)