Publisher

TEKNOKRATTEKNOKRAT

Journal Journal of Social Sciences and Technology for Community Service (JSSTCS)Journal of Social Sciences and Technology for Community Service (JSSTCS) Abstract

The business complexity requires business actors to have special skills in managing and analyzing data in Big Data. This community service aims to provide in-depth training on the use of Microsoft Excel as a platform for managing and analyzing data. The ability to manage and analyze data will greatly affect business productivity in facing the challenges and opportunities that exist in the Big Data era. Participants will be equipped with knowledge and practical skills in utilizing various relevant Excel features, including pivot tables, vlookup, if, and sophisticated data analysis techniques. This training uses a mentoring approach through several processes: preparation, implementation, mentoring and evaluation, and post training mentoring. The results reveal significant effects: awareness of technology to increase SMEs productivity is built; the competence of SMEs actors in using Microsoft Excel increases; and SMEs actors are able to increase efficiency and effectiveness in managing, processing, and analyzing data so that they can optimize the decision-making process more effectively and accurately. However, in-depth material is still needed, so further training is needed to deepen the knowledge and skills of SMEs actors. This is important for SMEs to respond to the challenges in the increasingly complex global market.

Conclusion

This mentoring demonstrates significant results in the understanding of SMEs digitalization, the use of Microsoft Excel software, and its optimization in data processing and analysis in the Big Data era.The training has improved the productivity of SMEs enterprises and increased the competence of business actors.However, further training is needed to deepen the knowledge and skills of SMEs actors to respond to the challenges in the increasingly complex global market.

Future Research

Based on the findings, future research could explore the integration of more advanced data analytics tools alongside Microsoft Excel to enhance SMEs data processing capabilities. Furthermore, investigating the specific challenges faced by SMEs in adopting and implementing data-driven decision-making processes, particularly concerning data security and privacy, would be valuable. Finally, a longitudinal study tracking the long-term impact of Excel training on SMEs business performance and competitiveness, considering factors like industry sector and firm size, could provide deeper insights into the effectiveness of such interventions and inform future training programs. These research directions will contribute to a more comprehensive understanding of how SMEs can effectively leverage data analytics to thrive in the Big Data era, ultimately fostering economic growth and innovation.

References

1. Improving SMEs Business Productivity with Microsoft Excel Training in the Big Data Era | Yuningsih |... doi.org/10.33365/jsstcs.v5i2.4720Improving SMEs Business Productivity with Microsoft Excel Training in the Big Data Era Yuningsih doi 10 33365 jsstcs v5i2 4720
2. Full article: Micro, small, and medium enterprises (MSMEs) and poverty reduction: empirical evidence... doi.org/10.1080/21665095.2020.1823238Full article Micro small and medium enterprises MSMEs and poverty reduction empirical evidence doi 10 1080 21665095 2020 1823238

Metadata

File size	366.86 KB
Pages	12
DMCA	Report