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

SUM function with Dynamic Range
Excel Tips and Tricks

SUM + CHOOSECOLS function for Dynamic Total

February 5, 2024October 10, 2026 PKComments Off on SUM + CHOOSECOLS function for Dynamic Total
Introduction In the fast-paced world of data analysis, efficiency and flexibility are key. That's why in our latest video, "SUM + CHOOSECOLS Function for Dynamic Total" we delve into a
Read More
Comma Separated Emp Name List using Groupby
Excel Tips and Tricks

Comma Separated List Using New Excel Function – GROUPBY

January 30, 2024October 10, 2026 PKComments Off on Comma Separated List Using New Excel Function – GROUPBY
Introduction Excel isn’t just about spreadsheets; it's a powerhouse for solving real-world data dilemmas. We've just dropped a super helpful video on our YouTube channel titled "Comma Separated List Using
Read More
Get Unique Participant List in Excel
Excel Tips and Tricks

Excel Formula to create Unique list form multiple columns in Excel

January 25, 2024October 10, 2026 PKComments Off on Excel Formula to create Unique list form multiple columns in Excel
Unique list form multiple columns in Excel Ever felt overwhelmed by managing lists in Excel, especially when they sprawl across multiple columns? You're definitely not alone! In our fun and
Read More
Expiry Date Calculator in Excel
Excel Tips and Tricks

Expiry Date Calculator in Excel: A Step-by-Step Guide

January 23, 2024October 10, 2026 PKComments Off on Expiry Date Calculator in Excel: A Step-by-Step Guide
Are you struggling to keep track of product expiry dates in your business or personal inventory? Worry no more! In our latest YouTube video titled "Expiry Date Calculator in Excel"
Read More
Excel Tips and Tricks

Excel Magic: Highlight Dates with Dropdowns & Conditional Formatting

January 19, 2024October 10, 2026 PKComments Off on Excel Magic: Highlight Dates with Dropdowns & Conditional Formatting
Excel Magic Unleashed: A Step-by-Step Guide to Highlight Dates with Dropdowns Welcome to a transformative journey into the world of Excel! In our latest video, "Excel Magic: Highlight Dates with
Read More
Quick Create Sheet for Pivot Table Filters
Excel Tips and Tricks

Pivot Table Magic! Create Multiple Pivot Sheets in Seconds

January 12, 2024October 10, 2026 PKComments Off on Pivot Table Magic! Create Multiple Pivot Sheets in Seconds
Welcome to our latest blog post, where we're excited to share a simple yet powerful technique to enhance your Excel skills. Today, we dive into the world of Pivot Tables,
Read More
Arrows & Color Coding with Custom Formatting
Excel Tips and Tricks

Transform Excel Data with Arrows & Color Coding with Custom Formatting

January 4, 2024October 10, 2026 PKComments Off on Transform Excel Data with Arrows & Color Coding with Custom Formatting
Introduction Are you struggling with visualizing budget variances in your Excel sheets? Well, worry no more! Our latest YouTube video, "Transform Excel Data with Arrows & Color Coding with Custom
Read More
Excel Tips and Tricks

Add KG to Your Numbers Instantly with This Simple Trick

January 2, 2024October 10, 2026 PKComments Off on Add KG to Your Numbers Instantly with This Simple Trick
In our latest, easy-to-follow article, we show you how to add KG to your numbers (or any unit!) in no time. Are you tired of your Excel data looking plain
Read More
Subtotal in Excel
Excel Tips and Tricks

Subtotal Magic in Excel – Quick Guide

December 29, 2023October 10, 2026 PKComments Off on Subtotal Magic in Excel – Quick Guide
Welcome to Excel Subtotal Mastery! Hey there! Are you ready to become an Excel wizard? Great, because today, we're diving into the magical world of Excel subtotals. If you loved
Read More
Hide Your Formula in Excel-1
Excel Tips and Tricks

Hide your Excel Formula with this trick

December 28, 2023October 10, 2026 PKComments Off on Hide your Excel Formula with this trick
Introduction Are you looking to keep your Excel formulas confidential? Our latest video, "Hide your Excel Formula with this Trick," has got you covered. In this blog post, we'll expand
Read More

Posts pagination

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