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
- Evaluation of participants' Excel skills.
- Warm-up activities involving functions and navigation.
- Review of key concepts 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
- Employing IF, SUMIF, and SUMIFS for logic-based analysis.
- Applying VLOOKUP to reference item details.
- Combining formulas to gain insights into cost-per-unit and supplier performance.
Handling and Analyzing Large Datasets
- Working with datasets of 5,000+ rows and multiple columns.
- Utilizing sorting, filtering, and conditional formatting.
- Leveraging 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 type.
Practical Inventory Tracking Exercise
- Simulating consumption versus purchase scenarios (e.g., comparing 1,000 bags purchased to 900 bags consumed).
- Reconciling usage data with purchase logs.
- Highlighting discrepancies and generating alerts.
Pivot Tables for Reporting and Analysis
- Creating pivot tables based on month, item, or supplier.
- Filtering, grouping, and customizing summaries.
- Building dashboards using slicers and timelines.
Automating Reports with Macros
- Recording and editing basic macros.
- Automating repetitive tasks, such as monthly material consolidation.
- Executing macros for data refresh and report generation.
Summary and Next Steps
Requirements
- Familiarity with basic spreadsheet concepts.
- Experience with file management and data entry.
- Previous exposure to business or inventory processes.
Audience
- Inventory and purchasing staff.
- Operations or logistics analysts.
- Finance or administrative personnel.
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
