It can feel overwhelming when starting out with a new idea. The easiest action to take is to build a website, sharing that idea.
STEP 1. BUY A DOMAIN
Before you build your website, you should purchase the domain of which you aim to publish on. That way, when you're ready to launch your idea, you have what you need.
STEP 2. DECIDE ON A WEBSITE BUILDER
It's okay to choose one you don't love because you can always change later. Some advanced builders allow you to export entire sites.
STEP 3. DESIGN
If this part causes you stress, I'd recommend a web designer (I have quite a few in my network).
STEP 4. OPTIMIZE FOR SEO
Your idea is ready to reach thousands. Optimize your site so it scores high on search engine results and gets shared across the web.
STEP 5. INTEGRATE
Loop in your business to your site, such a communication or bookings. Your business is now ready to get to the next level.
If you want more info, check out this guide I wrote.
Great question. Here's an article on what I think is best.
LEADING WEBSITE BUILDERS
In alphabetical order, the leading website builders are:
They're each incredibly straightforward, given their scope. I've made a website on each. Here's what each one looks like:
With minimal experience, you can have a website up in a matter of hours. For most of these sites, it's free to build and even publish (without a custom domain). So get busy and see what you can create.
|Cheapest Functional Option||$144/year
|Website Tool Tester Rating||4.0||4.5||4.5||4||3.8|
|Ease to Use||9/10||8.5/10||8/10||9.5/10||9.5/10|
|Biggest Pros||Visually attractive||Easy to use||Highly Flexible
|Easy to use
|Easy to use|
|Biggest Con||Not Cheap
how to use
As theatre artists and professionals, communicating with important people is a central part of your career. Automating this important task can reduce errors, increase results, and lower stress! Now's the time to stop worrying if you should follow up with that person because you're going to learn how to do it automatically.
Thank you to Yacin Tmimi and Victoria Levchenko for helping put this together!
Dashboards are visually intuitive tools which track, analyze, and display important information. Learn how to create and use such dashboards in Google Sheets to unlock new levels of productivity and accuracy.
Thank you to Sara Jacobi for helping put this together!
Begin by creating a sheet in google docs with some business expenses.
Each expense (row) should have 4 fields: Expense (name), Date, Amount, and Category (label).
2 Type Total Expenses: and Press Enter
We're now going to change some formatting stuff.
4 Select the fill color tool.
5 Click dark blue 2
Select the font color tool.
7 Click white
We're now going to drag this formatting option to some other cells.
Click on the blue square in the corner of the cell.
9 With your mouse, click and drag highlight, then drop it on highlight
10 Click highlight
We have copied the formatting but also the text!
Remove the text.
12 Click highlight
Let's copy this formatting to other cells!
Click on the blue square in the bottom corner of the cell.
14 With your mouse, click and drag highlight, then drop it on highlight
Select all the cells in which you want to clean the text.
Then, press your delete (mac) or backspace (windows) button.
18 Now, calculate the total expenses.
Since C2 is where the expenses amounts begin. And we don't know where the rows end, so writing C will have our function cycle until the rows are empty).
21 Rename F4.
22 Click highlight
23 Type =MIN(B2:B) which will calculate the minimum value in the date column.
24 Type =MAX(B2:B) which will calculate the maximum value in the date column.
To calculate the range, take the difference between the two cells.
Something doesn't look right.
Our answer is in days. That's not helpful.
Divide the answer by 30 to convert to months.
Add parentheses to make the mathematics correct.
29 Click G5
30 Type G5 and Press Enter
That looks better.
But I don't want a crazy decimal. I want a rounded figure.
32 Click on the current formula.
Type ROUND before the current formula so that the statement is as follows:
=ROUND((G4-G3)/30,1) The 1 at the end tells the function to round to one decimal value.
(Found that hard to do? We're gonna do it again in the next steps, so hang tight.)
35 Again, in one clean stroke.
36 Type G5
37 Click G5
38 Type G5
39 Click G5
40 Type G5 and Press Enter
41 Click highlight
42 Click Time Range
43 Type F5 and Press Enter
44 Type Expenses per Month
Total Expenses / Time Range
46 There we go!
47 We don't need these last two. Let's scrape em.
48 Choose the fill cell color tool.
49 Click Reset
50 Click highlight
51 Let's set the font to a special color.
52 Click dark blue 2
53 Type Unique Expenses in your newly formatted font.
54 Type highlight and Press Enter
55 Enter into F9
Sort will arrange the values by alphabetical order. Unique will remove duplicates. Filter will remove blanks (because we're going to specify it to).
Finish the formula by writing:
58 Let's reformat these bad boys.
59 Select the font-color tool.
60 Click dark blue 2
61 Make your font bold?
62 Click highlight
63 Let's fix this guy.
64 Make it italicized?
65 Click highlight
66 Click dark blue 2
67 Click highlight
68 Click white
The formatting is up to you. But this is what works for me, sometimes by trial.
70 Copy the formatting, like we did previously.
71 Type highlight
Remove the text.
Click Unique Expenses:
74 (Select all the text)
75 Replace it with Value
76 Now, let's get the values for each category.
We're going to use an Array Formula which repeats a calculation per row along a column.
In our case, we want to SUM the Value (Amount) of each expense if the Category is equal to the one in our row.
The $ symbol locks the range, instead of allowing it to be dynamic. (We don't want to change our range). The IF statement is testing for rows whose categories are =F9 (Entertaining)
Here's our bad boy.
Feel free to take a moment and add in any $ we missed out on earlier.
This will extend the formula to the remaining rows.
82 Let's convert these figures to dollar amounts.
83 Click Format as currency
85 Let's test the dynamic nature of this sheet.
86 Click 35.75
87 Change it to 35.90
88 Things have changed all around!
89 Change it again? Change it to: 35.60
90 It's interactive!
91 More formatting stuff.
92 Type highlight
93 Click Fill color
94 Click dark magenta 2
95 Click Text color
96 Click white
97 Resize some of the columns.
98 With your mouse, click and drag highlight, then drop it on highlight
99 Change this column too.
100 Click highlight
101 With your mouse, click and drag highlight, then drop it on highlight
102 Click highlight
103 Type Choose a Category:
104 Let's reformat stuff.
105 Choose the font-color tool.
106 Click dark magenta 2
Now we're going to add a dropdown menu.
Do this by clicking Data
108 Click Data validation...
Pay attention to the field named Criteria. We're going to choose a list from a range. Click on the range.
110 Click Select a data range
111 With your mouse, click and drag Select a data range, then drop it on highlight
112 Click highlight
113 Click Range
114 Type F9:F
Looks good? (Yes, it does.)
You now have a dropdown menu that works!
Let's reformat these cells.
Select fill-cell-color tool.
118 Click light magenta 3
119 Select the font-color tool.
120 Click dark magenta 2
122 Nah. Unitalicize...
Maybe yah... Re-italicize! (This is how UX design sometimes is...)
Use your dropdown menu!
125 Let's reformat this cell.
126 Copy cell I2
127 Paste here.
128 Press META + V
Remove the text.
Click Dropdown Section
130 Select all.
131 Leave empty.
132 Type highlight
133 Resize column.
134 With your mouse, click and drag highlight, then drop it on highlight
135 Click highlight
136 With your mouse, click and drag highlight, then drop it on highlight
137 Type Total
That's not specific enough. Let's revise.
Click Total and edit it to be Total $ Expenses
139 Type N Expenses
140 Let's not calculate the Total $ Expenses yet. We'll do something much cooler.
141 Let's format. (Next to our friends in columns F and G)
142 Click Fill color
143 Click dark magenta 2
144 Click highlight
145 Type Array Formulas Below
146 We're going to choose all values from our main body of values which match out selected category in J3.
147 Begin with an ARRAYFORMULA
148 We're going to apply a FILTER to exclude any empty cells
149 Click =ARRAYFORMULA(FILTER(A2
The elements in the filter are explained herein:
FILTER(A2:D,D2:D=J3 translates to:
In all elements between A2 and D, choose only the rows where the value in column D = the value in J3 (Entertainment)
Close up the function.
This is all you need!
Isn't that cool!
Now we need to relabel some columns.
Rename your columns.
Let's fix the formatting.
155 Select your cells.
156 Choose the fill color tool.
157 Click dark magenta 2
158 Click Text color
159 Click white
162 Let's calculate this field.
Instead of calculating from the previous method (cell G9), let's measure the values in the items below.
That looks kosher.
How does that compare the values in blue? It's a match!
Let's calculate the number of expenses in this category.
Type =COUNTIF(I9:I,"<>") This will count all cells that aren't empty.
166 How does this look? (It looks very very good, yes it does)
167 Let's try our tool out on another category!
168 Select Events from your dropdown menu.
169 How does this look?
170 Choose another! Choose Membership
171 How does it look?
172 Let's add another field. Type Cost per Month
This is Total $ Expenses / Time Range (in Months)
175 Let's resize that column.
176 With your mouse, click and drag highlight, then drop it on highlight
177 Click highlight
178 Let's reformat these cells.
179 With your mouse, click and drag highlight, then drop it on highlight
180 Fill color tool.
181 Click light magenta 3
182 Select Text Color tool.
183 Click dark magenta 2
184 Click highlight
185 Choose another Category.
186 Click Equipment
187 Click Fill color
188 Click light magenta 1
189 Click highlight
190 Click white
191 Click highlight
192 Click dark magenta 2
193 Click highlight
194 Click dark blue 2
195 Click Fill color
196 Click magenta
197 Click highlight
198 Click purple
199 Click Fill color
200 Click Custom...
201 Click highlight
202 With your mouse, click and drag highlight, then drop it on highlight
203 Click highlight
204 With your mouse, click and drag highlight, then drop it on highlight
205 Click highlight
206 With your mouse, click and drag highlight, then drop it on highlight
207 Click OK
208 Click highlight
209 Scroll left and click highlight
210 Click Things
211 Click highlight
212 Click highlight
213 Type highlight
214 Press META + A
215 Type A22
216 Type highlight
217 Doubleclick Tickets to the Fyre Festival
218 Type A22
219 Click A22
220 Type A22 and Press Enter
221 Type highlight and Press Enter
222 Click highlight
223 Type highlight
224 Click highlight
225 Click Format as currency
226 Click highlight
227 Scroll right and click highlight
228 Type highlight
229 Click highlight
230 Click Format as currency
231 Click highlight
232 Scroll left and click highlight
233 With your mouse, click and drag highlight, then drop it on highlight
234 Click highlight
235 Click highlight
236 Click highlight
237 That's it. You're done.