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 Tips

Road and Flag Chart
Charts and Visualization

Road and Flag infographics chart in Excel

January 28, 2024February 28, 2025 PKComments Off on Road and Flag infographics chart in Excel
Introduction Welcome to our fun and informative corner! Today, we're going to unravel the magic behind creating a dynamic "Road and Flag infographics chart" in Excel. This isn't just a
Read More
Quick Summary using Groupby Function
Excel Tips and Tricks

Quick Summary using new GROUPBY Function in Excel

January 26, 2024October 10, 2026 PKComments Off on Quick Summary using new GROUPBY Function in Excel
Quick Summary using new GROUPBY Function in Excel Excel enthusiasts, brace yourselves! Today, we're diving into the world of efficient data management with Excel's newest feature: the GROUPBY function. Imagine
Read More
GroupBy and PivotBy Function in Excel
Excel Tips and Tricks

Master GROUPBY and PIVOTBY Function in Excel with Real-World Examples

January 22, 2024October 10, 2026 PKComments Off on Master GROUPBY and PIVOTBY Function in Excel with Real-World Examples
Are you ready to unlock the full potential of Excel 365? In this engaging exploration, we delve into the powerful GROUPBY and PIVOTBY functions. These tools are game-changers for anyone
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
Add Leading Zeroes
Excel Tips and Tricks

Excel Magic: Adding Leading Zeros to Invoice Numbers Made Easy

January 16, 2024October 10, 2026 PKComments Off on Excel Magic: Adding Leading Zeros to Invoice Numbers Made Easy
Excel Magic: Adding Leading Zeros to Invoice Numbers Made Easy! Hello, Excel enthusiasts! Are you ready to unlock another Excel secret? Today, we're turning our popular YouTube tutorial, "Quick Excel
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
Charts and Visualization

Dynamic Colorful Progress Bars in Excel cells

January 8, 2024February 28, 2025 PKComments Off on Dynamic Colorful Progress Bars in Excel cells
Introduction Welcome to a game-changing guide on how to revolutionize your Excel spreadsheets! Today, we're diving into the world of dynamic, colorful progress bars in Excel cells. This method is
Read More
Number of Working days in a Month
Excel Tips and Tricks

Amazing Excel Hack to Count Working Days in a Month

January 5, 2024October 10, 2026 PKComments Off on Amazing Excel Hack to Count Working Days in a Month
Struggling to keep tabs on working days each month? Tired of the tedious manual counting? Well, here's some exciting news! We've got a super simple Excel trick that will make
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
Sumif Function with wildcard
Excel Tips and Tricks

Mastering Excel: Extract Unique Locations and Calculate Total Sales

January 3, 2024October 10, 2026 PKComments Off on Mastering Excel: Extract Unique Locations and Calculate Total Sales
Introduction Are you ready to take your understanding of sales data to the next level? Our recent YouTube video, "Extract Unique Locations and Calculate Total Sales" does just that. It's
Read More

Posts pagination

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