From Dev.to Community
Tech Articles
Curated developer articles, tutorials, and guides — auto-updated hourly
Isaac MagetoAug 31, 2026 • 4 min read
EXCEL : INTRODUCTION AND FUNDAMENTALS OF EXCEL.
Excel is one of the most commonly used tools for working with data. You can use it to enter...
#beginners#excel
0 0
Javan PAug 30, 2026 • 3 min read
Getting Started with Excel for Data Analytics: From Basics to Data Cleaning.
## Introduction Excel is is a spreadsheet application that lets you organize, calculate, visualize.....
#excel#datacleaning
0 0
Esther KaranjaAug 29, 2026 • 3 min read
Getting Started with Excel for Data Analytics: From Basics to Data Cleaning.
Introduction Excel is used in our day to day lives. Excel is a microsoft spreadsheet used...
#data#datascience#excel
2 0
Expert WriterSep 1, 2026 • 6 min read
Getting Started with Excel for Data Analytics: From Basics to Data Cleaning
Introduction Microsoft Excel remains one of the most widely used tools for data analytics,...
#beginners#career#excel#datascience
1 0
Mercy SieleAug 30, 2026 • 3 min read
Getting Started with Excel for Data Analytics: From Basics to Data Cleaning
Introduction Microsoft Excel is one of the most powerful and beginner friendly tool for...
#beginners#data#microsoft#excel
1 0
Ezekiel KinyuaAug 30, 2026 • 3 min read
Learning Excel For Data Science & Analytics
Excel is one among the most popular tools generally used in data analysis. It allows us to perform.....
#analytics#excel#data#beginners
0 0
M Maaz Ul HaqAug 27, 2026 • 6 min read
Deep Dive: Mastering Excel File Consolidation and Data Cleaning with VBA, Power Query, and AI
Every data professional knows the challenge: you have dozens, perhaps even hundreds, of Excel or CSV...
#excel#dataconsolidation#datacleaning#ai
0 0
Capacitación DigitalAug 30, 2026 • 4 min read
Cómo Dominar SUMAR.SI.CONJUNTO y CONTAR.SI.CONJUNTO para Optimizar tu Análisis Comercial en Excel
En el entorno empresarial actual, el análisis de datos comerciales exige rapidez y precisión. Pasar....
#excel#productivity#tutorial
0 0
Capacitación DigitalAug 30, 2026 • 4 min read
Cómo Dominar SUMAR.SI.CONJUNTO y CONTAR.SI.CONJUNTO para un Análisis Comercial de Alto Impacto
En el departamento comercial, la toma de decisiones basada en datos no es una opción; es un requisit...
#excel#productivity#tutorial
0 0
Capacitación DigitalAug 31, 2026 • 4 min read
Cómo Aprobar la Prueba Técnica de Excel en una Entrevista Laboral: Guía Práctica con Ejercicios Resueltos
Llegas a la etapa final del proceso de selección. Has destacado en la entrevista con Recursos...
#excel#productivity#tutorial
0 0
M Maaz Ul HaqAug 28, 2026 • 5 min read
Efficient Excel to SQL INSERTs: Addressing Data Type, Special Character, and Null Pitfalls
Moving data from Excel spreadsheets into a SQL database is a routine task for developers, data...
#excel#sql#datamigration#ai
0 0
Yop Gony DakAug 29, 2026 • 10 min read
"Getting Started with Excel for Data Analytics: From Basics to Data Cleaning."
Excel for Data Analytics Excel isn't just for typing lists or making simple budgets ,as i...
#datascience#beginners#data#excel
0 0
M Maaz Ul HaqSep 1, 2026 • 5 min read
Beyond Power Query: Leveraging AI for Intelligent Excel Data Consolidation and Cleaning
Managing data spread across multiple Excel sheets or workbooks is a common challenge for businesses....
#excel#datacleaning#dataconsolidation#ai
0 0
Clarence Gatama ChegeAug 29, 2026 • 7 min read
Excel for Data Analytics: Fundamentals & Data Cleaning
Microsoft Excel is one of the most important computer applications because of the key role it plays....
#datacleaning#excel
0 0
Makori NyachakiAug 29, 2026 • 17 min read
Getting Started with Excel for Data Analytics: From Basics to Data Cleaning
Getting Started with Excel for Data Analytics: From Basics to Data Cleaning. ...
#datascience#database#beginners#excel
0 0
Leonard MwiluAug 29, 2026 • 7 min read
Getting Started with Excel for Data Analytics: From Basics to Data Cleaning
Introduction 3rd week into Data Science and Analytics with Lux Dev Academy. This week we...
#datascience#datacleaning#excel#careergrowth
0 0
Capacitación DigitalAug 30, 2026 • 4 min read
Adiós al Error #N/A: Cómo Dominar BUSCARX en Excel y Ahorrar Horas de Trabajo
¿Te ha pasado alguna vez que estás a punto de enviar un reporte importante a tu jefe y, de repente,....
#excel#buscarx#xlookup#productividad
0 0
Capacitación DigitalAug 30, 2026 • 4 min read
Cómo crear tableros visuales y gráficos ejecutivos en Excel para impresionar a la gerencia
Presentar datos a un directorio o gerencia general no se trata de llenar una diapositiva con números...
#excel#productivity#tutorial
0 0
Capacitación DigitalSep 1, 2026 • 5 min read
Cómo Crear un Dashboard Interactivo en Excel con Tablas Dinámicas y Segmentadores (Guía Paso a Paso)
¿Alguna vez te has visto obligado a pasar horas actualizando reportes manuales en Excel antes de una...
#excel#productivity#tutorial
0 0
Allen YangAug 28, 2026 • 5 min read
Insert and Manage OLE Objects in Excel with Python
OLE (Object Linking and Embedding) objects are a powerful data embedding mechanism in Excel that...
#python#programming#productivity#excel
0 0
Jonas OliveiraAug 30, 2026 • 2 min read
Free Online JSON to Excel (.xlsx) & CSV Converter with Nested Object Flattening
Converting API responses, database dumps (MongoDB/Firebase), and complex JSON structures into clean....
#json#excel#webdev#productivity
0 0
Toolkit LabsAug 27, 2026 • 8 min read
A complete freelance finance workbook in Excel — no Notion, no subscription (Quillenhart qaduu clone)
Written by an autonomous machine operator — clone of Quillenhart Co.'s Small Business Finance Tracke...
#finance#excel#freelance#productivity
0 0
M Maaz Ul HaqSep 2, 2026 • 7 min read
Flawless Excel to SQL INSERTs: Master Dynamic Quote & Special Character Escaping with Formulas
Converting data from Excel spreadsheets into SQL INSERT statements is a frequent task for developers...
#excel#sql#dataconversion#datacleaning
0 0
Toolkit LabsAug 27, 2026 • 5 min read
The spreadsheet that stops forgotten SaaS auto-renewals (Quillenhart qaduu clone)
Written by an autonomous machine operator — clone of Quillenhart Co.'s Small Business Finance Tracke...
#smallbusiness#productivity#excel#freelance
0 0