Excel Blog articles Excel Blog articles
- Office Scripts is now available for Office 365 Enterprise E1 and Office 365 F3 licensesby isabeladominguez on March 18, 2024 at 6:27 pm
- What’s New in Excel (February 2024)by Microsoft Excel on February 27, 2024 at 9:05 pm
- Introducing PivotTables on iPadby GraceOued on February 21, 2024 at 7:14 pm
- What’s New in Excel (January 2024)by Microsoft Excel on February 6, 2024 at 5:49 pm
- 2023 in Reviewby Microsoft Excel on January 2, 2024 at 7:07 pm
- A new way to debug formulas from Excel Labsby jack-williams on December 11, 2023 at 2:00 pm
- What’s New in Excel (November 2023)by Microsoft Excel on November 28, 2023 at 7:20 pm
- New aggregation functions: GROUPBY and PIVOTBYby JoeMcDaid on November 15, 2023 at 12:46 am
- What’s New in Excel (September 2023)by Microsoft Excel on November 9, 2023 at 7:09 pm
- Improve your productivity in Excel for the web with Power Automate!by ravon314 on November 9, 2023 at 7:09 pm
- What’s New in Excel (October 2023)by Microsoft Excel on November 9, 2023 at 7:09 pm
- Announcing Python in Excel: Combining the power of Python and the flexibility of Excel.by Microsoft Excel on November 9, 2023 at 12:26 am
- Introducing New Enhancements to the Web Connector in Excel for Windowsby jokahati on October 29, 2023 at 4:25 pm
- Enhance Your Excel for the Web Experience with New Formula Authoring Features!by Nir_Tal on October 25, 2023 at 4:26 pm
- Optimizing Narrator screen reader announcements in Excel for Windowsby Sharon910 on October 24, 2023 at 3:45 pm
- Introducing Copilot support for Python in Excel: Advanced Data Analysis Using Natural Languageby David Monroy on September 21, 2023 at 3:00 pm
- Introducing the Python Editor from Excel Labsby Chris_Gross on September 18, 2023 at 4:00 pm
- What’s New in Excel (August 2023)by Microsoft Excel on August 31, 2023 at 9:19 pm
- Excel’s Formula Bar Gets a New Lookby Chris_Gross on August 18, 2023 at 3:00 pm
- Stale Value Formattingby JoeMcDaid on August 8, 2023 at 7:36 pm
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
- How to convert test scores to letter grades in Excel?by Chandoo on March 20, 2024 at 11:33 pm
- How to calculate the Gender Pay Gap using Excel Formulas? (Free Calculator Template)by Chandoo on March 19, 2024 at 11:13 pm
- Weighted Average in Excel [Formulas]by Chandoo on March 14, 2024 at 9:22 pm
- How to get non-adjacent columns with FILTER function in Excelby Chandoo on March 12, 2024 at 9:26 pm
- What is XLOOKUP and how to use it in Excel?by Chandoo on March 12, 2024 at 4:10 pm
- Get all BOLD text out Excel Cells Automaticallyby Chandoo on February 26, 2024 at 6:56 am
- How to fix SPILL Error in Excel Tables (3 easy solutions)by Chandoo on February 21, 2024 at 8:52 pm
Contextures Blog Excel tips and tutorials
- Data Validation Selection Popup Tool – Contexturesby 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 Functionby 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 Cellsby 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-Treesby 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 Listby 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”