Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Initial Skills Assessment and Review
- Assessment of participants' Excel proficiency.
- Warm-up activities focusing on functions and navigation.
- Review of key concepts essential for structured datasets.
Budgeting for Purchases and Report Generation
- Developing basic and dynamic budget templates.
- Monitoring costs and purchase quantities.
- Generating purchase summary reports.
Formulas for Inventory and Cost Calculations
- Applying IF, SUMIF, and SUMIFS for logic-based analysis.
- Utilizing VLOOKUP to reference item details.
- Combining formulas to gain cost-per-unit and supplier-level insights.
Handling and Analyzing Large Datasets
- Managing datasets with 5,000+ rows and multiple columns.
- Performing sorting, filtering, and conditional formatting.
- Employing Excel Tables for dynamic range referencing.
Building Purchase Lists and Supplier Reports
- Creating structured input sheets organized by supplier.
- Linking inventory, quantity, and cost fields.
- Summarizing data by category or raw material.
Practical Inventory Tracking Exercise
- Simulating consumption versus purchases (e.g., comparing 1,000 bags of sugar against 900 bags).
- Reconciling usage data with purchase logs.
- Highlighting discrepancies and generating alerts.
Pivot Tables for Reporting and Analysis
- Creating pivot tables categorized by month, item, or supplier.
- Filtering, grouping, and applying custom summarization.
- Building dashboards using slicers and timelines.
Automating Reports with Macros
- Recording and editing basic macros.
- Automating repetitive tasks (e.g., monthly material consolidation).
- Executing macros to refresh data and generate reports.
Summary and Next Steps
Requirements
- A foundational understanding of basic spreadsheet concepts.
- Familiarity with file management and data entry procedures.
- Previous exposure to business operations or inventory processes.
Audience
- Inventory and purchasing personnel.
- Operations or logistics analysts.
- Finance or administrative staff.
14 Hours
Testimonials (2)
the trainer's patience,
Agata Halubicka - Sad Rejonowy w Krosnie Odrzanskim
Course - Microsoft Office Excel - poziom średnio zaawansowany
well-prepared training, interesting topics
