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

    • Debra’s Excel News – June 2024
      by Debra Dalgleish on June 11, 2024 at 11:30 am

      There’s an Excel calendar, Excel lookup functions, and more, in this month’s Excel news. Excel Event Calendar Quick Ribbon Tip Excel Lookup Functions Excel and AI Monthly Photo Excel Event Calendar Long ago, I made an Excel holiday planning calendar that showed a list of events under each date. The calendar worked, but it needed … Continue reading “Debra’s Excel News – June 2024”

    • Which Excel Lookup Functions Do You Use Most Often?
      by Debra Dalgleish on June 6, 2024 at 5:02 am

      I’ve got an Excel  lookup functions question for you, in the quick poll below. And I’ve got some breaking news for you too! Contextures Monthly Newsletter First, here’s my news — I’m starting a monthly Excel newsletter, which I’ll send on the second Tuesday every month. That way, it won’t land in your inbox, while … Continue reading “Which Excel Lookup Functions Do You Use Most Often?”

    • Excel File Auto Backup When Workbook Saved
      by Debra Dalgleish on May 16, 2024 at 5:02 am

      Do you hit the Save button frequently, while you work in Excel? And do you make backup copies of your Excel files, especially before making major changes? Or, do you only think about saving, right after Excel crashes? Save, Save, Save After many painful experiences, I learned to save my work in Excel, every 5 … Continue reading “Excel File Auto Backup When Workbook Saved”

    • Excel Dependent Drop Down Lists – Block Changes
      by Debra Dalgleish on April 25, 2024 at 5:01 am

      One of my favourite Excel features is a data validation drop down list. In just a couple of minutes, you can make a list of items, then make that list appear in a worksheet cell. It’s like magic! The drop down lists make it much easier to enter data, and they help prevent typos, or … Continue reading “Excel Dependent Drop Down Lists – Block Changes”

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