Course Outline
Initial Skills Assessment and Review
- Evaluation of participant Excel proficiency
- Warm-up exercises focusing on functions and navigation
- Review of essential concepts for structured datasets
Budgeting for Purchases and Report Generation
- Creation of basic and dynamic budget templates
- Tracking expenses and purchase quantities
- Generation of purchase summary reports
Formulas for Inventory and Cost Calculations
- Utilizing IF, SUMIF, and SUMIFS functions for logic-based analysis
- Applying VLOOKUP to reference item details
- Combining formulas for cost-per-unit and supplier-level insights
Handling and Analyzing Large Datasets
- Working with datasets containing 5,000+ rows and multiple columns
- Sorting, filtering, and applying conditional formatting
- Using Excel Tables for dynamic range referencing
Building Purchase Lists and Supplier Reports
- Creating structured input sheets by supplier
- Linking inventory, quantity, and cost fields
- Summarizing data by category or raw material
Practical Inventory Tracking Exercise
- Simulating consumption versus purchase (e.g., 1,000 vs. 900 bags of sugar)
- Reconciling usage data with purchase logs
- Highlighting discrepancies and generating alerts
Pivot Tables for Reporting and Analysis
- Creating pivot tables by month, item, or supplier
- Filtering, grouping, and custom summarization techniques
- Building dashboards with slicers and timelines
Automating Reports with Macros
- Recording and editing basic macros for government tasks
- Automating repetitive processes (e.g., monthly material consolidation)
- Running macros for data refresh and report generation
Summary and Next Steps
Requirements
- An understanding of fundamental spreadsheet concepts
- Familiarity with file management and data entry procedures
- Previous exposure to business or inventory management processes
Audience for Government
- Inventory and purchasing staff members
- Operations or logistics analysts
- Finance or administrative personnel
Testimonials (5)
active interaction between trainer and participants
DEEWEELYN DE LUNA - TRACTEBEL RED INC.
Course - Financial Analysis in Excel
well-prepared training, interesting topics
Maciek Boiski - Instytut Energetyki - Panstwowy Instytut Badawczy
Course - Microsoft Office Excel - poziom podstawowy
I was recently struggling with some pivot table issues and the course gave me the knowledge to work with pivot tables quicker, smarter and more efficiently.
Arina Moayed-Dzenisa - Universal-Investment-Gesellschaft mbH Branch Poland Sp. z o. o.
Course - Microsoft Office Excel - poziom średnio zaawansowany
examples and looking for solutions
Monika Lesniewska - Takenaka Europe GmbH Sp. z o.o. Oddzial w Polsce
Course - Excel Data Analysis
The tips for many of the functions that the trainer presented, which we can easily remember and implement in our future work
