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 Tips

3 tricks to separate number and text from one Excel column into Order Number and Name
Excel Tips and Tricks

3 Tricks to Separate the Number and Text from an Excel Column

September 23, 2026October 10, 2026 PKComments Off on 3 Tricks to Separate the Number and Text from an Excel Column
You open a file and the whole list has been pasted into one single column: an order number, then a customer name, then another order number, then another name —
Read More
Dashboard

Manufacturing Inventory Management KPI Dashboard in Excel

April 8, 2025April 8, 2025 PKComments Off on Manufacturing Inventory Management KPI Dashboard in Excel
Managing inventory in a manufacturing environment can be a complex task. However, when done right, it saves time, reduces costs, and boosts overall efficiency. That’s where a Manufacturing Inventory Management
Read More
Dashboard Templates VBA

Expense Reimbursement Tracker in Excel

January 16, 2025March 26, 2025 PKComments Off on Expense Reimbursement Tracker in Excel
Hey there! If you're like most businesses, managing expense reimbursements can be a bit of a headache. But, good news! An intuitive Excel-based Expense Reimbursement Tracker is here to streamline
Read More
Excel Tips and Tricks

NUMBERVALUE Function in Excel with Examples

January 4, 2025October 10, 2026 PKComments Off on NUMBERVALUE Function in Excel with Examples
If you’ve ever faced issues with number formatting in Excel, especially when working with international number formats, the NUMBERVALUE Function in Excel can be your best friend. In this article,
Read More
Excel Tips and Tricks

TEXTAFTER function in Excel with Examples

December 27, 2024October 10, 2026 PKComments Off on TEXTAFTER function in Excel with Examples
Welcome to your go-to resource for leveraging one of Excel's handy functions: TEXTAFTER. Whether you're a seasoned Excel user or just getting started, this guide will walk you through how
Read More
Excel Tips and Tricks

TYPE Function in Excel with Examples

December 24, 2024October 10, 2026 PKComments Off on TYPE Function in Excel with Examples
Are you curious about what kind of data is hiding in your Excel cells? The TYPE Function in Excel with Examples is here to help! This function allows you to
Read More
Dashboard

Knowledge Management KPI Dashboard in Excel

December 23, 2024March 11, 2025 PKComments Off on Knowledge Management KPI Dashboard in Excel
In today's data-driven environment, effective knowledge management is crucial for any organization seeking to enhance decision-making and improve overall performance. A Knowledge Management KPI Dashboard in Excel serves as a
Read More
Excel Tips and Tricks

How to use FACT Function in Excel with Examples

December 18, 2024October 10, 2026 PKComments Off on How to use FACT Function in Excel with Examples
If you’re delving into Excel's mathematical functions, the FACT function is an interesting one to explore. This post will break down how to use the FACT function, covering all you
Read More
Templates

Subscription Management Checklist Template in Excel

December 15, 2024March 6, 2025 PKComments Off on Subscription Management Checklist Template in Excel
Effective subscription management is essential for businesses aiming to streamline operations and optimize their expenditure on subscription-based services. A well-organized Subscription Management Checklist Template in Excel not only helps in
Read More
Excel Tips and Tricks

SEARCH Function in Excel with Examples

December 9, 2024October 10, 2026 PKComments Off on SEARCH Function in Excel with Examples
Are you ready to learn a new Excel skill that will make working with text so much easier? Today, we’re diving into the SEARCH function in Excel, a great tool
Read More

Posts pagination

1 2 … 15 Next
  • 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