Microsoft Excel For Purchasing Professionals
Training
Provided by Online Training Directory
Are you failing to take advantage of Microsoft Excel's powerful techniques for purchasing? Look, even if you are an experienced Excel user, you may not be utilizing the tools that can help you make sound purchasing decisions and deliver top-notch presentations. The highly personal and interactive online course "Microsoft Excel For Purchasing Professionals" will enable you to perform sophisticated purchasing analyses through exercises that are based entirely on the situations that you face in your purchasing work. The student can complete their course of study within anytime frame as long as it does not exceed 60 days from the stamped start date. Reasonable time should be given to digest all relevant course lessons and materials.
Microsoft Excel For Purchasing Professionals Are you failing to take advantage of Microsoft Excel's powerful techniques for purchasing? Look, even if you are an experienced Excel user, you may not be utilizing the tools that can help you make sound purchasing decisions and deliver top-notch presentations. The highly personal and interactive online course "Microsoft Excel For Purchasing Professionals" will enable you to perform sophisticated purchasing analyses through exercises that are based entirely on the situations that you face in your purchasing work. Frequently Asked Questions How long will it take me to complete the course? The amount of time it takes to complete the course is dependent upon the time you are able to spend in study. Each lesson takes approximately 30-60 minutes to complete and the course is comprised of 8 lessons.
Students generally complete the course in 4-8 hoursWill I be able to work at my own pace? Yes. The online format of the instruction method allows you to proceed according to your own pace. Your personal schedule governs your completion time. The material is available on demand online.Are there any required books for the course? No.
The course is completely online and you will also receive a printer-friendly version of the course. This are included at no additional cost to you.Can I assess what I have learned? Yes. Each lesson has a review quiz. From there you will be able to determine if you understood the concepts or if you still need to review the materials further.
You will need to score 70% or higher overall on the quizzes to successfully complete the course.
|
|
||||||||||
Microsoft Excel For Purchasing Professionals
Outcomes
You will learn how to make the many decisions necessary to identify the best potential suppliers, plus?
Assessment
Evaluation of your performance will be based on... Eight (8) Individual lesson quizzes consisting of 5 questions each for a total of 40 questionsYou must earn a 70% (or 28 out of 40 questions correct) or higher in order to successfully pass the course. You must earn a 70% or higher in order to successfully pass this course (28 out of 40 questions correct). Students may retake quizzes an unlimited amount of times during the 60 days they have from the time of purchase.
Course Outline
Contact Hours: 8
You will learn how to make the many decisions necessary to identify the best potential suppliers, plus?
- How to most effectively prioritize requisitions
- How to decide when to use competitive bidding, negotiation, or both
- How to successfully conduct competitive bidding using solicitation tools such as RFP's and RFQ's
- How to use financial and operational analysis to select suppliers with not only the best monetary offer, but also the least risk of failure
- How to determine whether a contract, purchase order, or other method of ordering is best for a certain purchase
- How to use follow up techniques to ensure supplier compliance
- How to close out a transaction with confidence
- How to think like a purchasing manager
- How to prepare for the future of purchasing
Assessment
Evaluation of your performance will be based on... Eight (8) Individual lesson quizzes consisting of 5 questions each for a total of 40 questionsYou must earn a 70% (or 28 out of 40 questions correct) or higher in order to successfully pass the course. You must earn a 70% or higher in order to successfully pass this course (28 out of 40 questions correct). Students may retake quizzes an unlimited amount of times during the 60 days they have from the time of purchase.
Course Outline
- Lesson 1 - Creating, Formatting, and Printing Professional Bid Comparison Sheets (Basic)
- Lesson 2 - Creating, Formatting, and Printing Professional Bid Comparison Sheets (Advanced)
- Lesson 3 - Developing Should Cost Models For Price Evaluation
- Lesson 4 - Creating Weighted Average Supplier Scorecards
- Lesson 5 - Utilizing Sophisticated Decision Support Features
- Lesson 6 - Creating Charts To Compare Bids, Analyze Spend, and Track Supplier Performance (Excel 2003 or Earlier)
- Lesson 6 ? Creating Charts To Compare Bids, Analyze Spend, and Track Supplier Performance (Excel 2007)
- Lesson 7 - Organizing And Analyzing Spend Data
- Lesson 8 - Creating Pivot Tables To Summarize Purchasing Patterns & Developing Target Pricing Models For Negotiation Strategy
Contact Hours: 8
About The Training Provider: Online Training Directory
Online Training Directory - Workforce and Continuing Ed online courses are offered at basic, intermediate and advanced levels. Going beyond basic training provides a deeper and more educationally rewarding learning experience, especially for students who wish to advance careers or initiate new ones. For the general lifelong learner we continue to offer "fun to learn" single, stand-alone courses.
We look forward to...
