Excel Pro Tips
Count the Number of Characters in a String with Excel VBA
Learn how to count total, specific, or space-free characters in a string using VBA with simple examples and a custom function.
Read article
Author & Spreadsheet Consultant
Wasim Akram
71 Articles PublishedPublishing since
Wasim Akram holds a BSc in Industrial and Production Engineering and has around four years of hands-on Excel and Google Sheets experience. He specializes in formulas, lookups, PivotTables, dashboards, charts, data cleaning, macros, VBA, and Google Apps Script. He has created 300+ tutorials that helped over 100,000 users solve data problems. He enjoys exploring advanced formulas and building automated templates that simplify daily tasks.
Editorial Review
Articles Published by Wasim Akram
Articles by Wasim Akram are developed under the guidance of ExcelInsider’s core training program and are technically reviewed by Nehad Ulfat, lead spreadsheet consultant, to ensure accuracy and user-centric value.
Excel Pro Tips
How to Convert Minutes to Decimal in Excel (5 Suitable Ways)
Learn how to convert minutes to decimal in Excel using formulas, the CONVERT function, and time functions like HOUR and MINUTE.
Read article
Excel Pro Tips
How to Add Hours Minutes and Seconds in Excel (2 Easy Ways)
Learn how to add hours, minutes, and seconds in Excel using the plus operator, SUM, TEXT, and TIME functions with simple examples.
Read article
![[Fixed] External Data Connections Have Been Disabled in Excel](https://pub-b39c974f4c124a36a2fb517be38076ec.r2.dev/images/2026/08/featured-image-excel-external-data-connections-have-been-disabled-2-da66a249.webp)
Data Analysis with Excel
[Fixed] External Data Connections Have Been Disabled in Excel
Learn how to fix “External Data Connections Have Been Disabled” in Excel by enabling connections, macros, and trusted locations.
Read article
![[Fixed] Data Analysis ToolPak Not Showing in Excel](https://pub-b39c974f4c124a36a2fb517be38076ec.r2.dev/images/2026/08/featured-image-data-analysis-not-showing-in-excel-2-87e7a4ab.webp)
Data Analysis with Excel
[Fixed] Data Analysis ToolPak Not Showing in Excel
Fix Data Analysis ToolPak not showing in Excel with these easy steps: enable the add-in, update Excel, and repair Office.
Read article
Excel Pivot Table
How to Show Excel Pivot Table in Tabular Form (3 Methods)
Learn how to show Excel Pivot Tables in tabular form using the Report Layout feature, Field Settings, and simple VBA code.
Read article
Excel Pivot Table
How to Show Text in Values Area of Excel Pivot Table
Learn how to show text in the Values section of an Excel Pivot Table using the CONCATENATEX function and Format Cells feature.
Read article
Excel Pivot Table
How to Show Columns Side by Side in Excel Pivot Table
Learn how to show columns side by side in Excel Pivot Table using tabular, outline, classic layouts, or a simple VBA code solution.
Read article
Excel Pivot Table
How to Repeat Row Labels in Excel Pivot Table (3 Methods)
Learn how to repeat row labels in Excel Pivot Tables using Report Layout, Field Settings, or VBA for clearer, more organized data views.
Read article
Excel Pivot Table
How to Show Multiple Rows Without Nesting in Excel Pivot Table
Learn how to display multiple rows in an Excel Pivot Table without nesting using Tabular, Outline, and Classic layout options.
Read article
Excel Pivot Table
How to Add Rows to Pivot Table in Excel (3 Suitable Ways)
Learn how to add rows to a Pivot Table in Excel using Change Data Source, table inserts, or OFFSET with COUNTA functions.
Read article
Excel Pivot Table
How to Transpose Pivot Table in Excel (3 Simple Methods)
Learn how to transpose a Pivot Table in Excel using Paste Special, the TRANSPOSE function, or by rearranging PivotTable fields.
Read article