Excel: cost your project out so that you can make a profit
Regardless of what you’re selling, it is important that you know how to make it profitable! This doesn’t guarantee it will sell. When you sell the item, you’ll definitely make a profit.
This tutorial shows people how to cost a project out for any type of craft project (jewelry, art, paintings, needlework) so that they will realize what they’re actually making per hour. This video is offered as a supplement to continuing education classes that are being taught where the student needs to learn how much (or how little) they are making. This can be done with a calculator…one needs to have an understanding of logic and math principles to do this.
This means understanding all the costs involved including materials, time, travel time/cost, time to sell. Not all factors are included – you will have to consider marketing costs, hiring of others to sell your item, commissions that may be paid, entry fees to art festivals, and much more. Many artisans do this for the love of their craft and the joy they get from meeting others who appreciate their crafts.
Word: combine several files into one file
Goal: you are applying for a job, they only want ONE file in a PDF format. They have requested a cover letter, resume, list of references, and a sample of your work. Learn how to combine all these files into one document. Make sure you know what folder(s) all the files are in, their names. Insert the file in a subsequent fashion at the bottom of each page.
Many of you know how to do the basics with PowerPoint….done in 2010, this will help those with PowerPoint 2007 and 2013. This video tutorial discusss the slide master, backgrounds, and more.
If you ever have a large spreadsheet (that is a LOT of rows), you can filter the data down to a manageable size so you can work with the pertinent data. This video demonstrates.
If you know the concept of headers and footers in Word, the master pages in InDesign go so much further. It’s more than just adding a page number of a chapter heading. Graphics can be embedded and many different masters can be created. This video from Jeff Witchel says it better than I ever can.
Peachpit publishes many wonderful books on Adobe and many other topics. I own many of them. Some of their best books are their “classroom in a book” series of which I have several. Their website also provides many useful videos and tutorials.
The link I put in here is about the Patch tool which many people are not that familiar with….it has some very useful uses which you’ll discover in this excellent 5 minute video. Matt Kloskowski is the one who created this demo.
This is the video