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 XLOOKUP Function in Excel with Examples

October 21, 2024October 10, 2026 PKComments Off on How to use XLOOKUP Function in Excel with Examples
Are you looking for an easy and efficient way to retrieve data in Excel? Whether you're managing a small data set or handling large databases, Excel’s XLOOKUP Function in Excel
Read More
Excel Tips and Tricks

DMIN Formula in Excel with Examples

October 19, 2024October 10, 2026 PK0
If you've ever worked with large datasets in Excel and needed to find the minimum value based on certain criteria, you're in the right place! Today, we’re going to explore
Read More
Excel Tips and Tricks

WRAPCOLS Function in Excel with Examples

October 18, 2024October 10, 2026 PKComments Off on WRAPCOLS Function in Excel with Examples
If you've ever wanted to neatly arrange data across multiple columns in Excel without manually copying and pasting, you're in the right place! In this article, we're going to break
Read More
Excel Tips and Tricks

CHOOSEROWS Function in Excel with Examples

October 16, 2024October 10, 2026 PKComments Off on CHOOSEROWS Function in Excel with Examples
Are you ready to unlock the power of Excel formulas with the CHOOSEROWS function? In this post, we’ll walk you through how to use this handy function with real data
Read More
Excel Tips and Tricks

CHOOSE Formula in Excel with Examples

October 14, 2024October 10, 2026 PKComments Off on CHOOSE Formula in Excel with Examples
If you’ve ever worked with Excel, you know how powerful its functions can be. But when it comes to selecting specific values from a list based on an index number,
Read More
Excel Tips and Tricks

How to use INT function in Excel with Examples

October 13, 2024October 10, 2026 PKComments Off on How to use INT function in Excel with Examples
In this blog post, we’ll explore how to use the INT function in Excel, specifically for calculating age using dates. If you’ve ever wondered how to efficiently calculate the age
Read More
Excel Tips and Tricks

Use OFFSET Function in Excel with Examples

October 13, 2024October 10, 2026 PKComments Off on Use OFFSET Function in Excel with Examples
The OFFSET function in Excel is a versatile and powerful tool, especially when you're working with dynamic data ranges. In this blog post, we'll take a deep dive into how
Read More
Excel Tips and Tricks

Use of checkbox in Different Conditions in Excel

October 12, 2024October 10, 2026 PKComments Off on Use of checkbox in Different Conditions in Excel
In Excel, checkbox in Different Conditions are an incredibly versatile tool that can simplify how you manage and track data. In this post, we'll dive into a practical example of
Read More
Excel Tips and Tricks

2-way Lookup Using INDEX + MATCH + MATCH Function in Excel with Examples

October 11, 2024October 10, 2026 PKComments Off on 2-way Lookup Using INDEX + MATCH + MATCH Function in Excel with Examples
Are you looking to up your Excel game by learning advanced lookup techniques? Well, you’re in the right place! In today’s tutorial, I’m going to walk you through 2-way lookup
Read More
Excel Tips and Tricks

Calculate Total Sales Amount without Support Column with Examples

October 10, 2024October 10, 2026 PKComments Off on Calculate Total Sales Amount without Support Column with Examples
Are you tired of creating extra columns just to Calculate Total Sales Amount in Excel? Well, you’re in luck! In this blog post, we'll walk you through how to use
Read More

Posts pagination

Previous 1 … 3 4 5 … 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