Excel for the Manufacturing Sector

Learn Excel Tips from MrExcel
Course Created by Bill Jelen
Host of MrExcel.com website. Microsoft MVP in Excel for 10 years. Author of 43 books about Microsoft Excel and a frequent speaker at accounting conferences.

  •   Lifetime access to all lessons!
  •   30 days money back guarantee!
  •   Accessible via iPhone, iPad and Android (soon!)

This course shows how to use Excel to solve a variety of manufacturing-related problems. Topics include: 
Calculating Delivery Dates
Updating prices from a new price list
Calculating suggest prices to meet GP%
Production by category
Dashboard to report production by line
Multi-dimensional charting (line, shift, person)
Record macro to fill down

Course Objectives

  • Create pivot tables
  • Edit recorded macros
  • Create a production dashboard

Who Is This For?

  • Master Schedulers
  • Production Planners
  • Sales and Operations Planning
  • Cost Accountants

Course Outline

Chapter 1: Introduction

  • Lesson 1
    Introduction
    01:10

Chapter 2: Excel Techniques

  • Lesson 2
    Calculate Delivery Dates
    13:49
  • Lesson 3
    Merging Two Price Lists
    07:28
  • Lesson 4
    Calculate Price for a Desir…
    04:46
  • Lesson 5
    Calculate Production by Cat…
    08:08
  • Lesson 6
    Production Per Hour Dashboard
    06:33
  • Lesson 7
    Multi-Dimensional Charts
    07:09
  • Lesson 8
    Recording a Macro to Fill Down
    08:54

Chapter 3: Conclusion

  • Lesson 9
    09Close
    01:42

  •   Lifetime access to all lessons!
  •   30 days money back guarantee!
  •   Accessible via iPhone, iPad and Android (soon!)