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

How to use HLOOKUP FORMULA in Excel

September 21, 2024October 10, 2026 PKComments Off on How to use HLOOKUP FORMULA in Excel
Have you ever wondered how to quickly search for data in Excel that’s arranged horizontally? Well, you're in the right place because today, we're diving into the HLOOKUP FORMULA in
Read More
Excel Tips and Tricks

How to use Day Month and Year Function in Excel

September 21, 2024October 10, 2026 PKComments Off on How to use Day Month and Year Function in Excel
Are you curious about how to break down a date into its individual components like day, month, and year in Excel? Well, you're in the right place! In this blog
Read More
Excel Tips and Tricks

XLOOKUP Function in Excel

September 19, 2024October 10, 2026 PKComments Off on XLOOKUP Function in Excel
If you’re someone who works with Excel frequently, you’ve probably heard of the XLOOKUP Function in Excel. It’s a game-changer, especially when it comes to searching for data in large
Read More
Excel Tips and Tricks Power Pivot

Average function in Excel with Example

September 17, 2024October 10, 2026 PKComments Off on Average function in Excel with Example
Are you looking to quickly calculate averages in Excel? If so, you’re in the right place! In this blog post, we’ll break down how to use the AVERAGE function in
Read More
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 Power Pivot

SUMIF Formula in Excel with example

September 12, 2024October 10, 2026 PKComments Off on SUMIF Formula in Excel with example
Have you ever had a list of expenses in Excel and wondered how to quickly sum up certain categories, like "Food" or "Travelling"? Well, the SUMIF Formula in Excel is
Read More
Power Pivot

How to use Geography Option in Excel with Example

September 9, 2024October 10, 2026 PKComments Off on How to use Geography Option in Excel with Example
Have you ever wondered if you could use Excel for more than just numbers? Well, Excel has some pretty cool features that you may not know about, and one of
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

How to use in FILTER Function in Excel with Examples

September 4, 2024October 10, 2026 PKComments Off on How to use in FILTER Function in Excel with Examples
Are you ready to level up your Excel game? Today, we're going to explore one of Excel’s most powerful tools—the FILTER Function in Excel with Examples  This function is a
Read More

Posts pagination

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