• Home
  • Training
    • Finance
      • Managerial Accounting
      • Financial Accounting
      • Tax Accounting
      • Treasury
      • Auditing
    • People & Culture
    • Supply Chain
    • Management
    • Marketing
    • Business Technology
      • Digital Transformation
      • Information Security
      • Cyber Security
      • Data-Science
    • Apply as a facilitator
    • Simflex Business Simulation
    • EC-Council
    • Development Centers
    • Business Intelligence
    دورة سلاسل الإمداد

    دورة سلاسل الإمداد

    Free
    Read More
    CIA | Certified Internal Auditor®

    CIA | Certified Internal Auditor®

    9,000EGP
    Read More
  • Events
  • Blog
  • About Us
  • Testimonials
  • Contact
High Performance AcademyHigh Performance Academy
  • Home
  • Training
    • Finance
      • Managerial Accounting
      • Financial Accounting
      • Tax Accounting
      • Treasury
      • Auditing
    • People & Culture
    • Supply Chain
    • Management
    • Marketing
    • Business Technology
      • Digital Transformation
      • Information Security
      • Cyber Security
      • Data-Science
    • Apply as a facilitator
    • Simflex Business Simulation
    • EC-Council
    • Development Centers
    • Business Intelligence
    دورة سلاسل الإمداد

    دورة سلاسل الإمداد

    Free
    Read More
    CIA | Certified Internal Auditor®

    CIA | Certified Internal Auditor®

    9,000EGP
    Read More
  • Events
  • Blog
  • About Us
  • Testimonials
  • Contact

Supply Chain

  • Home
  • All courses
  • Supply Chain
  • Excel for Supply Chain Executives

Excel for Supply Chain Executives

Virtual | On Class
Supply Chain
4,500EGP
HPA- Excel For Supply Chain
  • Overview

Choose your payment method

Cash or Installments for up to 24 months

pay Cash or Installments
Course Overview

Microsoft Excel is the most commonly used spreadsheet application. Learning how to use Excel is an investment in both your personal and professional life. Excel makes it easy to monitor financial performance, such as business profit or loss, calculate payments on large purchases, plan a budget, or stay organized with checklists and etc…
As an employee, learning how to use Excel efficiently provides value, since most jobs utilize this application. This opens up more opportunities for employment and career advancement.
When employees know how to use Excel, it improves their efficiency in the workplace. Employees who know how to create detailed worksheets, invoices, charts, and complex formulas achieve professional results in a fraction of the time.
This course is designed to let participants explore the structure of the Excel workbook and demonstrates basic to advanced techniques required for working with spreadsheets.

Course Outline

Formulas & formatting

  • Creating formulas
  • formulas in cells
  • Using the Formula Bar
  • Excel basic functions & Automatic calculation
  • Paste Function tool
  • Previewing and printing
  • Page Setup & Page Break Preview
  • Headers and footers
  • Repeating column/row headings
  • Formatting numbers & text
  • Coloring data and cells
  • Wrapping and shrinking text
  • Merging cells
  • Conditional formatting

Data Management

  • Full Screen view
  • Splitting the window
  • Freeze Panes
  • Using range names in formulas
  • Re-defining and deleting range names
  • Creating & using the Chart
  • Editing and Formatting Charts
  • Naming a range of cells & Jumping to a named range

Advanced functions

  • Using IF functions
  • Creating and editing scenarios
  • creating a Scenario Report
  • Using Goal Seek
  • Creating a pivot table & chart
  • Defining the source range
  • Formatting a pivot table
  • Refreshing a pivot table

Supply chain functions by using excel:
Forecasting

  • Forecasting Functions
  • Forecast accuracy tracking
  • Forecast graphs & Plotting

Planning

  • Cascading business plan
  • Demand planning management
  • Distribution plan

Procurement Management

  • Supplier selection tools
  • Supplier evaluation tools
  • Procurement processes
  • Karlajic matrix

Inventory Management

  • Categorize item lists
  • Sub-lists
  • In-Out lists
  • Stock inventory levels
  • Stock control
  • Inventory Levels
  • Safety stock calculations & maintaining
  • Reorder point calculations
  • Lot size & breakeven calculations
  • Economic order quantities (EOQ)
  • Bill of material (BOM)
  • inventory counting
  • Inventory tracking
  • budgeting,
  • Mean absolute deviation calculation (MAD)
What You Will Learn ?

At program completion, participants will be able to:

  • Manage all supply chain processes effectively & quickly
  • Achieve high accuracy for supply chain results.
  • Analyze all data and results of supply chain processes
  • Manage the suppliers and execution process easily
Target Audience
  • Managers, Executives and Professionals who are involved in supply chain management.
  • Professionals seeking in- depth knowledge and understanding of the Excel Supply Chain functions.

Course Features

  • Lectures 0
  • Quizzes 0
  • Duration 24 hours
  • Language ENG/AR
  • Students 0
  • Assessments Yes
  • Overview
4,500EGP
  • Share:

You May Like

LSSGB | Lean Six Sigma Green Belt Read More
Virtual | On Class

LSSGB | Lean Six Sigma Green Belt

0
8,500EGP
دورة سلاسل الإمداد Read More
Virtual | On Class

دورة سلاسل الإمداد

0
Free
مبادئ عملية التصدير وكيفية التخطيط لدخول الأسواق الدولية Read More
Virtual | On Class

مبادئ عملية التصدير وكيفية التخطيط لدخول الأسواق الدولية

2
Free
CEH | Certified Ethical Hacker v12 (Training+Exam) Read More
Virtual | On Class

CEH | Certified Ethical Hacker v12 (Training+Exam)

0
Free
Certified L&D Manager Read More
Virtual | On Class

Certified L&D Manager

0
8,000EGP

Install 6 months with 0% interest

It's pleasure to contact you

SiteLock
CONNECT US

 (+202) 26903875 – 24182790

 01050222191 – 01050222192

 info@hpa.com.eg

Our Location

 8 Mohamed Anies St. Kolyet El Banat, El Mergheny, Heliopolis, Cairo, Egypt

High Performance Academy © 2022
Powered by Technology Dome

Modal title

Message modal