Become an Excel ninja with Excelsamurai – your go-to resource for mastering shortcuts, formulas, Pivot Tables, and VBA. Our concise tutorials and practical examples will help you work smarter, not harder.
Have Fun While Learning Excel!
Whether you’re a beginner looking to learn the basics or a seasoned pro seeking to take your skills to the next level, our comprehensive tutorials, time-saving shortcuts, powerful formulas, and dynamic VBA scripts will help you conquer even the most complex tasks with ease.
From creating stunning visualizations with Pivot Tables to automating repetitive processes, Excelsamurai is your one-stop shop for all things Excel.
-> Excel Formula
Count Between Two Numbers in Excel using Simple Formula!
Learn how to count values between two numbers or dates in Excel using COUNTIFS, COUNTIF, and other easy formulas. Simple, accurate, and beginner-friendly.
How to Use IF Function in Excel with 3 Conditions?
Learn how to use IF function in Excel with 3 conditions using nested IFs and the IFS function. Practical examples and troubleshooting tips included.
How to use XLOOKUP on Filtered Data: A Comprehensive Guide
Learn how to use XLOOKUP with FILTER in Excel for dynamic lookups on filtered data. Improve efficiency with multiple conditions and error handling.
Easy Formula to Calculate Percentage of Total in Excel
Learn how to calculate the percentage of total in Excel with a simple formula. This guide provides step-by-step instructions, examples, and helpful tips.
How to Calculate Percentage Change in Excel: Easy Guide
Learn how to calculate percentage change in Excel with simple methods, clear formulas, and real-world examples. Master data analysis with ease!
-> Excel Shortcuts
Easy Keyboard Shortcut to Cut a Cell Value in Excel
Learn how to cut a cell value in Excel using keyboard shortcuts for Windows and Mac. Boost speed with simple, step-by-step Excel editing tips.
Quick and Easy Excel Shortcut to Reduce Decimal Places
Learn how to quickly reduce decimal places in Excel using a shortcut. This guide covers everything you need for efficient decimal place management.
Easy Excel Shortcut to Expand Cell to Fit Text
Learn how to use Excel shortcuts to automatically expand cells to fit text. Discover efficient methods like AutoFit, Wrap Text, and manual adjustments.
25 Top Excel Shortcuts for Finance Professionals
Boost your financial productivity with 25 essential Excel shortcuts. Master data entry, navigation, and calculations for efficient spreadsheet management.
15 Top Excel Pivot Table Keyboard Shortcuts You Should Know
Boost your Excel productivity with these 15 essential Pivot Table keyboard shortcuts. Learn how to create, refresh, group, and more efficiently.
-> Pivot Table
How to Disconnect Filter Controls from Pivot Table in Excel?
Learn how to disconnect slicers and filter controls from PivotTables in Excel for better data control, independent filtering, and smooth data source changes.
How to Create a PivotTable from Multiple Tables in Excel?
Learn how to create a PivotTable from multiple tables in Excel using relationships or Power Query. Follow this step-by-step guide for seamless data analysis!
How to View Hidden Pivot Table Field List in Excel?
Learn how to quickly view a hidden pivot table field list in Excel. Follow simple steps, tips, and best practices to keep it always visible and accessible.
How to Prevent Pivot Table from Resizing After Refreshing Data?
Prevent pivot table columns from resizing automatically in Excel with these 4 methods. Learn to maintain formatting & layout when refreshing data.
How to Add a Target Line in Excel Pivot Chart: Expert Guide
Learn how to add a target line in an Excel pivot chart to track goals or benchmarks, enhancing your data analysis and visualization effortlessly.
-> Other Excel Guides
How to Remove Duplicates in Excel? (5 Easy Methods)
Learn how to remove duplicates in Excel using built-in tools, formulas, conditional formatting, and Power Query for clean, accurate data.
Excel Conditional Formatting Based on Another Cell Value
Learn how to format cells in Excel based on another cell’s value using conditional formatting with simple formulas and step-by-step examples.
How to Change Date Format in Excel: A Complete Guide
Learn how to change date format in Excel with step-by-step methods, custom formats, and tips to fix common date issues for clear, accurate data.
How to Filter Cells with Comments in Excel: Easy Guide
Learn how to filter cells with comments in Excel using VBA, helper columns, and other simple methods to organize and review annotated data easily.
How to Calculate Running Total in Excel? (4 Easy Methods)
Learn 4 easy ways to calculate running totals in Excel using formulas, Quick Analysis, and SCAN. Step-by-step guide for beginners and pros.
-> Excel VBA
How to Extract All Comments in A Worksheet in Excel?
Learn how to extract all comments in an Excel worksheet using VBA. Step-by-step guide with code to summarize or extract cell-specific comments.
Excel VBA to Rename Files in a Folder (with Buttons!)
Rename multiple files effortlessly using Excel VBA. Learn how to select a folder, list file names, and automate file renaming with a simple VBA script.
How to Remove Duplicates in Excel Using VBA: Easy Guide
Learn how to use Excel VBA to remove duplicates, automate tasks, and enhance data accuracy with our comprehensive guide. Easy-to-follow steps & best practices.
4 Easy Methods to Convert Numbers to Strings in Excel VBA
Learn how to convert numbers to strings in Excel VBA using functions like Str(), Format() & CStr(). Code examples for VBA number to string conversion.
Excel VBA AutoFilter: Automated Data Filtering in Excel
Master Excel VBA AutoFilter: Learn to automate data filtering, boost productivity & create dynamic reports. Unlock advanced Excel techniques for data analysis.