E-commerce, Quick Commerce & Logistics Fundamentals

Execute pickup assignment and preparation by finalizing date, time, and location; shortlist vendors by availability; record weight and volume; map a cost-efficient route via route optimization.

Define middle mile logistics as the movement of material from origin to destination processing centers, including CN retrieval, barcode scanning, loading, and securing cargo with nets and seals.

Last mile logistics is the final step delivering from a branch or pc to the end customer, involving delivery requests, vendor assignment, and pin code based planning.

Learn what incentives are, including financial, non-financial, and material types, and analyze order-based, earnings-based, and direct incentives, along with motivation, behavior modification, and retention.

learn how first-in first-out and last-in first-out storage systems manage inventory flow, valuation, profitability, and tax implications using chairs as examples.

Learn the core inventory control techniques—JIT, EOQ, ABC analysis, safety stock, ROP, FIFO, and LIFO—and their benefits and drawbacks for cost control and stockouts.

Learn the just-in-time inventory approach, a demand-driven system that minimizes waste and costs. It emphasizes supplier collaboration, continuous improvement, and flexible production to boost efficiency.

Explore ABC analysis of inventory, categorizing items into A, B, and C by annual consumption value, with data collection, ranking, and cumulative value, plus benefits and best practices.

Calculate picking manpower using IPO, PPI, and utilization, compute picking time per order, and determine required manpower for daily orders.

Explore Microsoft Excel’s grid-based interface, mastering data entry, formulas, data analysis with pivot tables and charts, plus sorting, filtering, macros, collaboration, and security.

Identify Excel toolbars including the ribbon, quick access toolbar, and formula toolbar, and customize the quick access toolbar by adding, removing, and rearranging commands and tools like the name box.

Analyze the structure of Excel formulas, including equals sign, functions, operators, and operands, through examples. Master the order of operations (PEMDAS) and the role of parentheses.

Explore data management in Excel, focusing on organization, cleaning, validation, analysis, and visualization. Learn to use tables, sorting, duplicates removal, data validation, formulas, pivot tables, and charts to derive insights.

Master advanced Excel formulas like VLOOKUP, IF, NestedIF, SUMIF, COUNTIF, AVERAGEIF, SUMPRODUCT, and CONCATENATE to manipulate, analyze, and summarize complex data efficiently.

Learn how the if and ifs functions produce outputs based on conditions, using a login per rider example to show yes/no results and multi-condition logic.

Explore nested if to handle multiple logical tests and categorize values into three ranges from less than or equal to 5 to greater than 8.

Explore how countif counts occurrences that meet a condition and how sumif sums values that meet a condition, using store ids and orders as examples.

Identify the basic components of a chart, including chart area, axes, axis titles, chart title, legend, grid lines, data labels, and a data table, to improve readability of data.

Create combo charts to compare two metrics, such as orders and OPH, using primary and secondary axes. Learn to assign each series to the axis and swap them as needed.

Master pivot tables to analyze weight dispatched from Delhi and Bangalore warehouses across Jan, Feb, and March, using origin and month fields, with destination filters to focus on Mumbai routes.

Create a pivot table and use field items and sets to add a calculated field that divides login hours by number of riders to show average login hours per rider.