Excel Nyheder

    Excel Blog articles Excel Blog articles

    Chandoo.org – Learn Excel, Power BI & Charting Online Fresh Excel Tips, Power BI, Power Pivot, Power Query, Tricks, Charts, Tutorials, Downloads, Dashboards and Visualization Showcase for your Inspiration and Productivity

    Contextures Blog Excel tips and tutorials

    • Excel Text in Multiple Rows – No Merged Cells
      by Debra Dalgleish on February 8, 2024 at 6:02 am

      I add lots of screen shots to my Excel tutorials, so it’s easier to follow the steps. And if I’m explaining a formula, it’s helpful to show that on the worksheet too. However, some Excel formulas can get pretty long, and I found a way to fix that problem! You can see all the solutions … Continue reading “Excel Text in Multiple Rows – No Merged Cells”

    • Excel for the Holidays 2023-Planning-Games-Trees
      by Debra Dalgleish on December 21, 2023 at 6:01 am

      Do you use Excel to help with all of your holiday planning? It’s a great tool for shopping lists, holiday budgets, dinner preparation, and even holiday games! Holiday Dinner Planner Every time we have a holiday dinner, I use my Holiday Dinner Planner to create a timeline for the preparation steps. Just pick your dinner … Continue reading “Excel for the Holidays 2023-Planning-Games-Trees”

    • How to Remove Duplicate Items in Excel List
      by Debra Dalgleish on November 30, 2023 at 6:02 am

      There’s a built-in tool in Microsoft Excel that makes it easy to remove all the duplicate values from a list. You can remove duplicates based on the items in one column, or multiple columns. Video: How to Remove Duplicates in Excel List The video below shows the steps for removing duplicate items from an Excel … Continue reading “How to Remove Duplicate Items in Excel List”

    • How to Sum Filtered Excel Data – AGGREGATE or SUBTOTAL
      by Debra Dalgleish on November 2, 2023 at 4:02 am

      When an Excel list is filtered, how can you show a total sum or count for numbers in the visible rows only? There are two Excel functions for that task — SUBTOTAL (all Excel versions) and AGGREGATE (Excel 2010 and later). See how these functions work, and decide which one to use. Excel SUBTOTAL Function … Continue reading “How to Sum Filtered Excel Data – AGGREGATE or SUBTOTAL”

    • Video: Dependent Combo Boxes – Excel Data Entry
      by Debra Dalgleish on October 19, 2023 at 4:01 am

      Make it easy to enter valid data in an Excel workbook. Choose “Fastener” in one combo box drop down. The next combo box shows a list of fastener parts, with part ID and part name. This video shows how to use this simple data entry tool, and you’ll get a peek behind the scenes, on … Continue reading “Video: Dependent Combo Boxes – Excel Data Entry”