61 33 25 37 [email protected]

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

    • Data Validation Selection Popup Tool – Contextures
      by Debra Dalgleish on March 7, 2024 at 6:01 am

      With the free Data Validation Select Popup (DVSP) tool from Contextures, you can add popup lists to Excel workbooks. Set the rules you’d like for the pop-up lists — allow single item selection in some columns, and allow multi-selection in other columns. You can even let people add new items to some lists – if … Continue reading “Data Validation Selection Popup Tool – Contextures”

    • Troubleshoot Excel Formulas with ERROR.TYPE Function
      by Debra Dalgleish on February 22, 2024 at 6:00 am

      Did you know that you can use the Excel ERROR.TYPE function to identify specific types of errors on a worksheet? And after the error type is identified, you can use that information to provide help with error troubleshooting. There’s a short video below, that shows an example, and there’s a list of the Excel error … Continue reading “Troubleshoot Excel Formulas with ERROR.TYPE Function”

    • 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”