New: NextGenTemplates Academy - video courses on Excel formulas with AI and Pivot Tables & dashboards. Early-bird: 20% off with code EARLYBIRD20 - first 20 orders only. See the courses →
  • Learn Excel (Free Course)
    • 1. Shortcut Keys
    • 2. Fill & Flash Fill
    • 3. Find & Replace
    • 4. Sort & Filter
    • 5. Formulas & Functions
    • 6. Data Validation
    • 7. Conditional Formatting
    • 8. Basic Charts
    • 9. Advanced Charts
    • 10. Pivot Tables
    • 11. Excel Dashboards
    • 12. VBA Course
    • 13. Excel Formulas with AI
  • Templates
  • Tutorials
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
    • Excel Dashboards
    • Power Pivot & DAX
  • Power BI
  • Template Store
    • Ready to Use Templates
  • Courses
  • Academy
    • Excel + AI Mastery: 100 Formulas
    • Excel Pivot Tables & Dashboards
  • About Us
  • Contact Us

PK: An Excel Expert

Transforming Data into Decisions

Tag: Excel Tutorial

Stylish Stacked Column Chart with Integrated Totals
Charts and Visualization

Effective Stacked Column Chart with Integrated Totals

May 14, 2023October 10, 2026 PKComments Off on Effective Stacked Column Chart with Integrated Totals
Excel is an essential tool in the corporate world, and its charting capabilities are among its most powerful features. Among these, the Stacked Column Chart stands out for its effectiveness
Read More
Fill Series in Excel
Excel Tips and Tricks

Fill Series in Excel

November 13, 2022October 10, 2026 PKComments Off on Fill Series in Excel
Microsoft Excel is a powerful tool that helps users organize and analyze data efficiently. One of the many useful features in Excel is the Fill Series option, which enables users
Read More
Count Sub-strings in an Excel Cell with a User Defined Function
VBA

Count Sub-strings in an Excel Cell with a User Defined Function

September 10, 2018October 9, 2026 PK0
Need to count sub-strings in an Excel cell? It happens all the time: a cell holds comma-separated ticket numbers, a semicolon-separated list of email IDs or a string of codes
Read More
Text Join Formula for All Excel Versions: TEXTJOIN UDF in VBA
VBA

Text Join Formula for All Excel Versions: TEXTJOIN UDF in VBA

May 23, 2018October 9, 2026 PK0
This text join formula for all Excel versions gives you TEXTJOIN-style results even if your Excel does not have the TEXTJOIN function. TEXTJOIN joins a whole range of cells into
Read More

Posts pagination

Previous 1 … 9 10
  • Learn Excel (Free Course)
    • 1. Shortcut Keys
    • 2. Fill & Flash Fill
    • 3. Find & Replace
    • 4. Sort & Filter
    • 5. Formulas & Functions
    • 6. Data Validation
    • 7. Conditional Formatting
    • 8. Basic Charts
    • 9. Advanced Charts
    • 10. Pivot Tables
    • 11. Excel Dashboards
    • 12. VBA Course
    • 13. Excel Formulas with AI
  • Templates
  • Tutorials
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
    • Excel Dashboards
    • Power Pivot & DAX
  • Power BI
  • Template Store
    • Ready to Use Templates
  • Courses
  • Academy
    • Excel + AI Mastery: 100 Formulas
    • Excel Pivot Tables & Dashboards
  • About Us
  • Contact Us
Copyright © 2023 PK-AnExcelExpert.com - Privacy Policy