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: 6 Responses to “MacMost Live: Building a Basic Business Spreadsheet In Mac Numbers”

    Joseph Leahy
    4 months 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 months ago

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

    4 months ago

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

    Scott
    4 months 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

    Michele
    3 weeks ago

    The last step in building the calculation formula does not appear the same when I follow your steps…I get an error message: Your formula contains a syntax error. All steps except the last step (purple, Amount) are shown exactly like yours until I click Amount (D)…It shows: Expenses::Expenses::Amount…and I can’t find how to change it to just Amount.

    3 weeks ago

    Michele: Maybe clear that cell and try again.

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)