Calculate Net 30, Net 45, and Net 60 Payment Dates in Excel
Learn how to automatically calculate Net 30, Net 45, and Net 60 invoice payment due dates in Excel using date formulas, drop-down lists, and lookup tables.
Read more ›Excel & Data Problems
Short answers for Excel formula errors, broken pivots, import issues, and workbooks that freeze or calculate wrong.
Latest
8825 ResourcesHow to Transfer Word Macros and Custom Keyboard Shortcuts to Another PC
Learn how to transfer Word macros and custom keyboard shortcuts to another PC by locating and moving the Normal template in Microsoft Office 365.
Read more ›How to Insert Excel Images into Specific PowerPoint Placeholders Using VBA
Learn how to use VBA to insert Excel images into specific PowerPoint slide positions. Bypass placeholder limitations by inserting shapes and adjusting dimensions.
Read more ›How to Make Excel Option Buttons Work Independently by Row
Learn how to make Excel option buttons work independently by row. Use Group Boxes to isolate radio buttons and allow multiple selections in checklists and forms.
Read more ›How to Split Repeated Names and Associated Values into Separate Excel Rows
Learn how to split repeated names and associated values into separate rows in Excel using Power Query and modern dynamic array functions like FILTER and VSTACK.
Read more ›How to Combine and Split Text in Excel Using Formulas
Learn how to combine city and state values or split two-word names into separate columns in Excel using CONCAT, LEFT, MID, and SEARCH formulas.
Read more ›Fix Excel Symbols Invisible or Displaying Incorrectly
Learn how to fix Alt-code symbols that are invisible or displaying incorrectly in Microsoft Excel. Discover troubleshooting steps like Safe Mode and registry resets.
Read more ›How to Show Cell Values on Excel Chart Data Points
Learn how to display specific spreadsheet cell values on Excel scatter chart points. Discover methods using custom data labels, VBA, and free WPS Office alternatives.
Read more ›How to Plot VBA Arrays Directly in Excel Charts
Learn how to plot VBA arrays directly into an Excel chart without exporting values to a worksheet. Assign in-memory arrays to XValues and Values properties easily.
Read more ›How to Create Excel Summary Tables from Complex Data using Power Query
Learn how to summarize complex data and over 10,000 sales records in Excel using Power Query and PivotTables. Reshape data by unpivoting columns.
Read more ›How to Fix Excel VBA CDO SMTP Error 0x80040217
Learn how to troubleshoot and fix Excel VBA CDO SMTP Error 0x80040217. Discover solutions for Microsoft 365 authentication, SMTP settings, and VBA email scripts.
Read more ›Fix Access Crosstab Query Not Appearing in Excel
Learn why your Microsoft Access crosstab query is missing from the Excel Navigator and how to fix parameterized query issues to successfully import your data.
Read more ›How to Round Numbers in Every Excel Worksheet Using VBA
Learn how to use a VBA macro to efficiently round numeric constants and apply consistent number formatting across all worksheets in your Excel workbook.
Read more ›How to Fix LAMBDA, BYROW, and BYCOL #NAME? Errors in Excel
Learn how to troubleshoot and fix sudden #NAME? errors for Excel functions like LAMBDA, BYROW, and BYCOL when they stop working or disappear from AutoComplete.
Read more ›How to Match Scheduled Time to Employee Timecards with Power Query
Learn how to match scheduled times to employee timecards in Excel using Power Query and DAX. Discover how to handle duplicate records using index columns.
Read more ›How to Fix Excel ActiveX Controls Not Working on External Monitors
Troubleshoot and fix the issue where Excel ActiveX controls and VBA scripts stop responding when moving your workbook to an external monitor.
Read more ›Fix Excel VBA Restarting from Beginning After Breakpoint
Troubleshoot Excel VBA projects that unexpectedly restart from the beginning after resuming from a breakpoint. Learn how to handle Application.Wait and OnTime events.
Read more ›How to Set Excel Series Image Offsets with Microsoft.Office.Interop.Excel
Learn how to resolve issues with setting Excel series image offsets using Microsoft.Office.Interop.Excel in C# and find dedicated COM development resources.
Read more ›Try what you just learned
Download WPS Office free and open Word, Excel, PowerPoint, and PDF files in one lightweight app.