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

Excel Tips and Tricks

Mastering XLOOKUP: A Comprehensive Guide with 10 Practical Examples

September 3, 2024October 10, 2026 PKComments Off on Mastering XLOOKUP: A Comprehensive Guide with 10 Practical Examples
If you're looking to become an Excel pro, Mastering XLOOKUP function is essential. This powerful tool is not only versatile but also simplifies complex data retrieval tasks that were previously
Read More
Excel Tips and Tricks

How to use EDATE Function in Excel with Example

September 3, 2024October 10, 2026 PKComments Off on How to use EDATE Function in Excel with Example
Are you looking to manage expiration dates for products effortlessly in Excel? The EDATE function is a powerful tool that can help you calculate future or past dates based on
Read More
Excel Tips and Tricks

How to use TOCOL function in Excel

September 2, 2024October 10, 2026 PKComments Off on How to use TOCOL function in Excel
In the world of Excel, there are countless functions designed to make your data management easier and more efficient. One such function is TOCOL, a powerful tool that can help
Read More
Excel Tips and Tricks

How to use XLOOKUP with Multiple Criteria

August 29, 2024October 10, 2026 PKComments Off on How to use XLOOKUP with Multiple Criteria
If you’re working with large datasets in Excel, you’ve probably encountered situations where you need to look up values based on more than one criterion. The XLOOKUP function is a
Read More
Excel Tips and Tricks

Combine Multiple Tables with VSTACK Function

August 29, 2024October 10, 2026 PKComments Off on Combine Multiple Tables with VSTACK Function
Have you ever had multiple tables in Excel that you needed to combine into one? If so, you're in the right place! In this post, we’re going to walk you
Read More
Create Multiple worksheets
VBA

Macro to Create multiple worksheets from selection

August 16, 2024October 10, 2026 PKComments Off on Macro to Create multiple worksheets from selection
Have you ever found yourself in need of an Excel file with multiple worksheets, each customized to fit your needs? If the thought of setting this up seems overwhelming, don’t
Read More
Charts and Visualization

Teams Goal Graph with Football icon in Excel

July 19, 2024October 10, 2026 PKComments Off on Teams Goal Graph with Football icon in Excel
Ever wondered how to make your data presentations stand out? Let's dive into how you can transform raw data into an engaging Teams Goal Graph with Football icon in Excel.
Read More
Credit Rating Meter Chart in Excel
Charts and Visualization

Credit Rating Meter Chart in Excel

June 23, 2024October 10, 2026 PKComments Off on Credit Rating Meter Chart in Excel
In this article, we will create a visually appealing Credit Rating Meter Chart in Excel. You can display a credit score, a Civil score, or any other key performance indicator
Read More
Magic Search and Highlight in Excel
Excel Tips and Tricks Templates

Magic search with highlight in Excel

May 9, 2024February 21, 2025 PKComments Off on Magic search with highlight in Excel
Excel is very useful tool to streamline data handling and reporting. Today, we have created the “Magic Search with Highlight in Excel" template. It is particularly beneficial, allowing users to
Read More
Quick QR code Generator in Excel
Excel Tips and Tricks

Quick QR Code Generator in Excel

February 8, 2024October 10, 2026 PKComments Off on Quick QR Code Generator in Excel
In this article, we will  explain how to create a QR Code Generator in Excel. In the fast-paced digital world we live in, QR codes have seamlessly woven themselves into
Read More

Posts pagination

Previous 1 … 7 8 9 10 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