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

Excel Tips and Tricks

Salary Increment Function in Excel with Example

September 15, 2024October 10, 2026 PKComments Off on Salary Increment Function in Excel with Example
In this blog post, we're going to take a super easy approach to help you calculate Salary Increment Function in Excel. Whether you're in HR or just someone who loves
Read More
Excel Tips and Tricks

Finding and Counting Unique values with Example

September 8, 2024October 10, 2026 PKComments Off on Finding and Counting Unique values with Example
Have you ever struggled with figuring out how many unique items are in your data set or counting their occurrences in Excel? If so, you’re in the right place! In
Read More
Excel Tips and Tricks

How to Check Common Names between two list in Excel

September 7, 2024October 10, 2026 PKComments Off on How to Check Common Names between two list in Excel
Do you often find yourself wondering how to quickly identify Check Common Names between two list across different lists in Excel. Whether you’re comparing attendees for different seminars, members in
Read More
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 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
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
AI Powered Features in Excel
Productivity Excel Tips and Tricks

AI in Excel: A Game-Changer for Data Analysis

June 25, 2023October 10, 2026 PKComments Off on AI in Excel: A Game-Changer for Data Analysis
Navigating through the era of big data, it's become clear to businesses worldwide that efficient data analysis tools are essential. This article aims to shed light on AI in Excel
Read More
Dynamic Annual Calendar with Holiday
Templates

Free Dynamic annual calendar with holiday and Control Panel

March 12, 2023October 10, 2026 PKComments Off on Free Dynamic annual calendar with holiday and Control Panel
In the modern era, managing tasks and schedules is a significant challenge. This challenge can be effectively addressed by using a dynamic annual calendar that can track important dates, events,
Read More

Posts pagination

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