Kategori
Tekniker
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
How to Clear Excel Cache (Windows and Mac)
Learn how to clear Excel cache on Windows and Mac to solve common problems like lag and sync errors, and follow best practices to keep Excel running smoothly.
Allan Ouko
26 januari 2026
Excel Version History: How to View, Restore, and Recover Your Work
Learn how Excel version history helps you view, restore, and recover previous file versions without losing your current work.
Allan Ouko
23 januari 2026
How to Add Days to a Date in Excel: All Methods Explained
Learn how to add days to a date in Excel using simple arithmetic and functions like DATE(), EDATE(), and WORKDAY(), with practical examples and pitfalls to avoid.
Allan Ouko
22 januari 2026
How to Show Formulas in Excel (Instead of Results)
Learn how to show formulas for a full worksheet, check individual cells, prepare files for review or printing, and avoid common issues.
Laiba Siddiqui
15 januari 2026
Reduce Excel File Size: Effective Methods That Actually Work
Large Excel files slow everything down and make sharing harder than it should be. This guide explains why Excel files grow over time and shows practical, safe ways to reduce file size.
Laiba Siddiqui
10 januari 2026
Excel Power Pivot: A Step-by-Step Guide
Learn how to connect tables, write DAX formulas, and build interactive reports inside Excel.
Laiba Siddiqui
6 januari 2026
SUMPRODUCT() Excel: What You Should Know
A practical guide to using SUMPRODUCT() for conditional, weighted, and matrix-based calculations in Excel
Laiba Siddiqui
6 januari 2026
How to Find Circular References in Excel
Learn what circular references are, why they cause problems, and how to fix them using simple and advanced techniques.
Laiba Siddiqui
5 januari 2026
Excel Solver: Optimize Complex Decisions with Multiple Variables
Learn how to use Excel Solver to solve optimization problems with multiple constraints and decision variables. This guide covers setup, solving, and interpreting results with a practical example.
Khalid Abdelaty
12 december 2025
How to Freeze Multiple Rows in Excel
Learn how to freeze multiple rows in Excel with step-by-step instructions, tips, and troubleshooting to keep your headers visible while scrolling.
Allan Ouko
8 december 2025
Convert Excel to CSV: Four Methods That Work
Learn proven ways to convert Excel to CSV, manually, programmatically, and in bulk, while maintaining data accuracy, encoding, and security.
Jachimma Christian
5 november 2025
Excel Sparklines: A Complete Guide to Mini Data Visualizations
Learn how to create this wonderfully compact and elegant cell-sized visualization in Excel that is perfect for summary trend and data visualization.
Tim Lu
4 november 2025