Excel Resources

Latest Articles

387 articles

How to Calculate Subtotal in Excel [Clear & Easy]

Posted by Algirdas Jasaitis

2026-06-01

Learn how to calculate subtotals in Excel in 2023 with WPS Office. Avoid errors and get more insights into your data.

How to Use Regular Expressions (REGEX) in Excel? (3 Examples)

Posted by Algirdas Jasaitis

2026-06-01

Learn how to use REGEX in Excel to perform advanced data analysis. This 2023 guide will show you 3 methods to use REGEX with examples and tips.

How to Use Excel Shortcut to Show Formulas (Step-by-Step Guide)

Posted by Algirdas Jasaitis

2026-06-01

Here is an updated tutorial on 2023: Unlock the power of Excel shortcuts to reveal formulas – step-by-step guide for efficient spreadsheet work!

How to Use Formula Builder in Excel

Posted by Algirdas Jasaitis

2026-06-01

Learn how to access and use Excel's Formula Builder to insert functions and references and make formulas without memorizing syntax.

How To Fix The Scroll Bar In Excel Too Long (Easy&Fast)

Posted by Algirdas Jasaitis

2026-06-01

Learn how to fix the scroll bar in Excel for too long. Restore easy navigation and regain control of your worksheets with our guide.

How to Set Rows as Print Titles in Excel (Easy & Fast)

Posted by Algirdas Jasaitis

2026-06-01

Follow our step-by-step guide to learn how to set print titles in Excel to ensure your essential row labels or headings are consistently displayed.

How To Use Excel Multiple IF Statements (Easy Steps)

Posted by Algirdas Jasaitis

2026-06-01

Learn how to Master Excel's multiple IF statements to simplify formulas efficiently with stepwise instructions and practical examples for accurate calculations.

How to Run T-Test in Excel (Easy & Simple Steps)

Posted by Algirdas Jasaitis

2026-06-01

Learn how to perform a t-test in Excel with straightforward steps. Understand the significance of this statistical tool for comparing means of two groups and making informed decisions.

How To Shift Cells Left in Excel (Step-By-Step Guide)

Posted by Algirdas Jasaitis

2026-06-01

If you have been working in Excel and want to know how to shift cells left in Excel without changing their relative position in a row, read this guide.

How to Make First Letter Capital in Excel (A Completed Guide)

Posted by Algirdas Jasaitis

2026-06-01

Learn step-by-step instructions on how to change lowercase text to uppercase letter, to make your data more professional. Raise your excel spreadsheet skills with this simple guide on how to make first letter capital in excel.

Complete Tutorial of Excel

Master Microsoft Excel with our comprehensive guide. Start with the basics of Excel tutorial, then move on to formulas, functions, PivotTables, and data visualization. Suitable for all skill levels.