Handledningar i Excel

Håll dig uppdaterad med de senaste nyheterna, teknikerna och resurserna för Excel. Våra handledningar är fulla av praktiska genomgångar och användningsfall som hjälper dig att utveckla dina färdigheter.

Andra tekniker:

Utbilda 2 eller fler personer?Testa DataCamp for Business

Index Match Excel: A Better Way to Look Up Data

See how INDEX() and MATCH() are used to look up values within a table or range of cells Compare INDEX() and MATCH() to VLOOKUP().

5 augusti 2025

Excel Drop Down List: Setup, Tips, and Troubleshooting

Master Excel drop-down lists with step-by-step tips for setup, troubleshooting, and advanced techniques like cascading and searchable lists.

1 augusti 2025

Excel TEXT() Function: Format Numbers as Readable Text

Learn how to convert numbers into formatted text in Excel using the TEXT() function. Customize dates, times, percentages, and more with format codes for clear, user-friendly spreadsheets.

31 juli 2025

How to Make a Bar Graph in Excel: A Beginner's Guide

Learn how to create a bar graph in Excel with this beginner-friendly guide. Explore chart types, formatting tips, dynamic features, and troubleshooting techniques.

29 juli 2025

How to Change Date Format in Excel: What You Need to Know

Learn how to create a bar graph in Excel with this beginner-friendly guide. Explore chart types, formatting tips, dynamic features, and troubleshooting techniques.

28 juli 2025

Excel UNIQUE(): The Fastest Way to Filter Duplicates

Discover how to use the Excel UNIQUE() function to instantly remove duplicates and extract distinct values from any list. Learn how to apply it to both rows and columns.

25 juli 2025

Excel TEXTSPLIT(): Split Text into Multiple Cells in Excel

Easily separate text into columns or rows in Excel using the TEXTSPLIT() function.

17 juli 2025

Connecting Tableau With Excel: Turn Spreadsheets into Dynamic Dashboards

Learn how to seamlessly integrate Tableau with Excel to transform static spreadsheets into powerful, interactive dashboards. Boost insights, streamline analysis, and improve your data-driven decisions.

16 juli 2025

How to Find Median in Excel: The Easy Way and the Long Way

Learn how to use Excel’s MEDIAN() function to find the middle value in a dataset. Compare it with AVERAGE(), handle common quirks, and apply it your own work.

16 juli 2025

Python in Excel: Advanced Analysis in Your Excel Spreadsheet

Learn how to use Python in Excel to run advanced analytics, create visuals, and apply machine learning within your existing spreadsheet workflows.

15 juli 2025

EOMONTH(): Calculate End-of-Month Dates in Excel

Calculate the last day of any month with Excel's EOMONTH() function. Use it to streamline financial schedules, reporting periods, and monthly workflows.

15 juli 2025

MMULT() Excel: How to Do Matrix Multiplication in Excel

Unlock matrix multiplication in Excel with the MMULT() function. This guide explains how to use MMULT(), its syntax, and you will learn its applications in data analysis.

14 juli 2025