Skills › Data Analytics & Business Intelligence

Excel & Spreadsheets

Perform data analysis with Excel or Google Sheets — formulas, pivot tables, and charts.

0%
Confidence · no data yet
Sign in to track

After this skill you can…

  • Build a dynamic dashboard with pivot tables and slicers
  • Use VLOOKUP, INDEX-MATCH, and array formulas
  • Create automated reports with named ranges and conditional formatting

Watch (10 videos)

How to Modify Rows and Columns in Excel
Coursera · beginner hands-on
→ Insert and delete rows and columns in Excel→ Resize rows and columns for readability→ Hide and unhide rows and columns
Navigating the Microsoft Excel Interface
Coursera · beginner hands-on
→ Navigate the Excel interface→ Use essential tools and features→ Manage workbooks
Excel Tutoring | Excel Tutorial For Beginners | Microsoft Excel Formulas and Functions | Simplilearn
Simplilearn · beginner
→ Create spreadsheets→ Use Excel formulas→ Analyze data
Excel Full Course 2026 | Excel Tutorial For Beginners | Microsoft Excel Course | Simplilearn
Simplilearn · beginner
→ Create spreadsheets→ Manage data→ Perform data analysis
How to use MODE.SNGL Function/Formula in Excel?
Professional's Legacy · intermediate hands-on
→ Apply the MODE.SNGL function to a dataset→ Analyze sales data to find the most frequently occurring value
How to use UPPER Function/Formula in Excel?
Professional's Legacy · intermediate hands-on
→ Use UPPER function in Excel→ Format text in Excel
Excel Lambda Functions: Create Your Own Functions Without VBA or Macros
Mergers & Inquisitions / Breaking Into Wall Street · beginner
→ Use Excel Lambda functions→ Create custom functions without VBA or Macros
Make an Investment Portfolio Tracker in Excel (Stocks, ETFs, Crypto etc.)
Kenji Explains · beginner
→ Use Excel formulas and functions→ Create data visualizations in Excel
How To Set up Print Ranges and Cell Formats in Excel
Michael Nugent · intermediate
→ Create spreadsheets in Excel→ Use Excel formulas and functions
Microsoft Excel Malayalam Tutorial | Introduction to Microsoft Excel | Learn Programming with Entri
Entri Coding മലയാളം · beginner hands-on
→ Create Spreadsheets→ Manage Data→ Perform Basic Analytics

Read (10 articles)

📄
How Excel is Used in Real-World Data Analysis
Dev.to · Gregory Waswa · 2025-06-16
📄
Introduction to MS Excel for data analytics
Dev.to · Kelvin · 2026-01-23
📄
Introduction to MS Excel for Data Analytics
Dev.to · Kipyegon Patrick · 2026-01-25
📄
Introduction to MS Excel for Data Analytics
Dev.to · Austin3560 · 2026-01-25
📄
INTRODUCTION TO MS EXCEL
Dev.to · Victor · 2026-01-27
📄
Introduction to MS Excel for Data Analytics
Dev.to · Erasto Wamuti · 2026-01-26
📄
Excel For Data Analytics: Beginner Friendly Overview.
Dev.to · seme clive · 2026-02-01
📄
How Excel is Used In Real-World Data Analysis
Dev.to · Kevin Ng'ang'a · 2026-03-24
📄
How Excel is Used in Real-World Data Analysis
Dev.to · Kendi · 2026-03-25