FEATURES
NEW! Microsoft® Excel 2010 eBook!
With NEW Costing Sheet Lesson!
- 206 fully illustrated pages (Excel® 2010 eBook)
150 fully illustrated pages (Excel® 2002 eBook)
- Easy to follow step by step instructions with screen grabs
- 2 Printable PDF eBooks
- NEW! PDF eBooks now compatible with Adobe Reader on mobile devices (iPhone, iPad, Android)
- 3-page Tech Pack and Line Sheet samples in Excel format
With our eBook you’ll learn to:
- Create apparel industry standard Tech Packs, Fashion Line Sheets and Garment Costing Sheets
- Calculate Size Grading and Costing using Excel formulas
- Format Excel Worksheets and Link Pages
- Insert Sketches and Graphics
- Enter and Format Cell Data
BENEFITS
- Quickly learn how to use Microsoft Excel 2002 (PC) and 2010 (PC) specifically for the Fashion Industry
- Easily learn the features used most commonly in the fashion industry with easy to follow, step-by-step lessons.
- Stay ahead of the competition with must-have fashion career skills
- Become a confident, time-saving asset to fashion employers and sales teams
- Save time and stop size grading manually! Calculate garment size grades automatically with Excel formulas and linked cells
- Create your own apparel tech packs, fashion line sheets, garment costing sheets, and other apparel industry spreadsheets
RECOMMENDED FOR:
- Experienced Fashion Designersresponsible for sample development and request forms
- Fashion Design Studentsor Recent Grads who want a competitive edge in the job market
- Technical Designerswho want to keep up with the ever-changing fashion industry
- Designers/Companiesthat are still using handwritten forms or calculating size grading manually
- Freelance Designerswho want to gain a professional edge as independent contractors
- Sales Reps who need to present Line Sheets to buyers
DESCRIPTION
In this fast-paced apparel industry, knowing how to use Microsoft® Excel is a must for fashion designers and technical designers alike. With the tutorials in our “My Practical Skills: Microsoft Excel for the Fashion Industry” e-book, you will learn everything you need to know to create essential fashion industry worksheets such as spec sheets, grade sheets, fashion line sheets, garment costing sheets & garment production sheets.
Knowing how to use Microsoft Excel is an important skill for any fashion career since it is used in all phases: from design, to production, and even in sales. Apparel designers use Excel to create spec sheets for initial sample requests, technical designers create Excel tech packs and size grades for garment production, and sales teams use fashion line sheets created in Excel to present the current line to apparel buyers. So if you don’t know how to use Microsoft Excel or if your knowledge is limited to just entering data, it’s time to update your skills with our eBook tutorials.
Unfortunately, too many fashion designers don’t know how to use Microsoft Excel to create these important spreadsheets. Most apparel designers just know the basics like how to enter data, resize cells, and change font sizes & colors. As a result, numerous fashion companies are still using outdated means such as filling out tech packs by hand, calculating size grades manually, or using an inadequate program like Adobe Illustrator to produce these fashion spreadsheets!
Our Microsoft Excel eBook tutorials focus on the features used most commonly in the fashion industry, making it easy for you to learn Microsoft Excel. We’ve weeded out the unnecessary, overwhelming features of Excel that you’ll never use, to give you the practical skills needed to easily complete apparel industry projects.
DOWNLOAD INFORMATION
- Contents:2 PDF eBook files and Microsoft Excel sample files
- Size:31.3 MB
- Download Time:2-15 minutes
- Format:Compressed ZIP file
- Uncompress PC: Automatic, double click or download the free Zip Readerif needed
- Uncompress Mac: Automatic, double click or download the free StuffIt Expander if needed
USAGE INSTRUCTIONS
- Use Adobe Reader to read the ebook and follow along with the lessons in Microsoft Excel 2010 or Excel 2002
- Use the Excel sample files as a guide to check your work
SOFTWARE REQUIREMENTS
- Microsoft Excel
- Basic Excel skills
- Adobe Reader for the ebook PDF
TECHNICAL AND BILLING SUPPORT
- If you need help or have any questions, please contact us through the form. We respond within 24 hours, usually much faster.
DOWNLOAD SUPPORT
- After purchase, you will receive two emails: your purchase receipt and your download link from us.
- If you don’t see our download email within minutes, please check your spam (junk mail) folder. If you still can’t find it, let us know.
- Your purchase receipt will include an email and a phone number where we may be reached, depending on our availability in the Eastern US time zone.
Hassle-Free Product Replacement – See our Product Guarantees!
PDF eBook and spec sheet Excel files
$34.95
(122 ratings: please vote!)
Just desire to say your article is as astonishing. The clarity in your post
is simply great and i can assume you’re an expert on this subject.
Fine with your permission allow me to grab your feed to keep up to date with forthcoming post.
Thanks a million and please continue the gratifying work.
Napoli drakt
Hi! I know this is kinda off topic but I was wondering which
blog platform are you using for this website? I’m getting sick and tired of WordPress because I’ve had problems with hackers
and I’m looking at alternatives for another platform. I would be fantastic if you could point me in the direction of a good platform.
Milan Tröja
Hi Lisa, While the ebook was written using Excel in Windows, the functions and foundations for creating tech packs, formulas etc are the same in Excel for Mac, but some of the tools and menus may be located in different places. You should be able to follow along with no problem! :)
Hi Svetlina, 1. Since we are a US company based in NY Garment Industry, our Excel ebook works with inches. However we can provide instructions for converting specs and grading formulas to cm. 2. There is a lesson in this ebook that shows exactly how to format and formulate a costing sheet (you can see a preview image of the costing sheet created in the Previews section of the product page).
Dear Sirs,
we would like to buy “Excel for fashion industry”. We need some additional information:
1. We are from Bulgaria and we are working with centimetres. Is “Excel for fashion indutry” working with centimetres too?
2. Does it give detailed technical succession for calculation of each operation for making of basic, overcoated garments, i.e. for cost price of the goods.
Thank you very much in advance!
I have Excel for Mac 2011. Will this work?
Hi Sumon,
While our Excel eBook was written using Excel in Windows, the functions and foundations for creating tech packs, formulas etc are the same in Excel for Mac, but some of the tools and menus may be located in different places. You should be able to follow along with no problem! :)
I’m Merchandiser . very helpful us. have you MS xl 2007..???
Can you tell me specifically if there are templates that come with the ebook that I can drag and drop/insert my files of drawings into the excel file?
Are they full and complete tech pack templates containing POM, BOM, a Construction section and any other industry Full tech pack requirements? Thanks!
Hi Mrrisha,
1. This ebook teaches you how to use Excel to enter grade rules via formulas- it does not show you how to give fit corrections. However, if you already know how to give fit corrections, you can use the skills learned in this ebook to give corrections (there iare already columns dedicated to fit corrections and comments on the Spec Sheet of the Tech Pack and you can add additional columns as needed).
2. The Microsoft Excel ebook only contains sample spec templates for a few basic Juniors garments. Our Apparel Tech Pack Templates have a larger collection of sample tech packs for a variety of garment styles for Men, Women, and coming soon, Children and Plus Size. Tech Packs for Jackets and Dresses are included in this product, but specific templates for Outerwear and Eveningwear are not included. Complex details are usualy shown as callouts on a garment sketch, not on the spec sheet. The second lesson shows how to create a detail sheet which offers a large space for a detailed sketch to be placed.
3. If you do not currently know how to use Excel to create spec sheets, tech packs, enter formulas, link cells, etc., this ebook will give you a tremendous advantage at work since you’ll have the skills to create any type of spreadsheet you may need.
4. This ebook does not teach how to conduct fittings- this ebook shows how to use Microsoft Excel to create your own spec sheets, tech packs, line sheets, and costing sheets- giving you the skills needed to use Excel to create these and any other type of custom spreadsheet you may need for the fashion industry. Our How to Spec a Garment ebook teaches how to measure garments and record them in a tech pack to send to factories and patternmakers, however, it does not cover how to conduct fittings and give pattern and fit corrections. We recommend the book Ready-to-Wear Apparel Analysis by Patty Brown and Janett Rice (available at Amazon.com) for instruction on generating fit corrections.
well, as a apparels manufecturer i think Your xl and ebook is very important.
This book really seems like something I’ve been looking for.
But before I purchase, I have a few questions :
1) Does it include how to communicate alterations/changes on the Grading sheet (using formulas) , after Model fitting, to the manufacturer’s? Like– how to tighten so much from here & loose from there,etc?
2) Does it include Specs templates of different style of garments & details? Can it be used for any style of garment like : outerwear, eveningwear, or for describing complex details in finishing,etc.?
3) Will it help at my work place as an added advantage?
4) Do you also have a book explaining the actual fitting process & it’s alterations, especially of draped / designer gowns. I have difficulty in expressing those complex details.
Thanks in advance for the response