121 тысяч подписчиков
178 видео
How to create a 4-Quadrant Matrix Chart in Excel
Split a Master Spreadsheet into Multiple Sheets with 1 click - VBA for Beginner
Why My Vlookup Function Does Not Work?
How to Automatically Hide Rows based on Cell Value - Macro for Beginner
Create Chart with Broken Axis and Bars for Scale Difference - Simple Method
Excel Chart - Stacked Waterfall Chart for Annual Expenses Reporting
How to Create Multi-Color Scatter Plot Chart in Excel
Create Chart with Broken Axis and Bars for Scale Difference - Complex Method
How to Create a Bell Curve chart for Performance Rating Distribution
Excel for HR: Salary Structure Floating Bar Chart with Employee Data
Excel for HR: Salary Structure Floating Bar Chart
Excel Troubleshooting : How to Remove Circular Reference
Excel Troubleshooting - 5 Vlookup Errors in Complex Formula and How to Check Step by Step
Clean Data with ChatGPT: Extract Incomplete Employee Records to a New Sheet
Excel Macro - Save multiple files to specific folders by inputting from a popup box
Sum Multiple Sheets with Different Cells - Macro for beginner
Excel Troubleshooting - 5 Index and Match Errors and How to Check
Add, Rename, and Delete Worksheet with VBA - Macro for Beginner
How to Count Colored Cells with Macro in 1 Click
Lock or Protect Cells by Cell Color in 1 Click - VBA for Beginner
How to Automatically Hide Rows based on Formula driven Cell Value
How to Refresh Pivot Table automatically with Macro
How to Automatically Hide Rows based on Criteria for Row Cell Value
Group and Ungroup Pivot Table Rows with Macro
Split Spreadsheet to Multiple Sheets with Hidden Columns - VBA for Beginner
2 Ways to Remove Invalid Data in Vlookup
Group and Ungroup Columns in Specific Sheets with Macro
Group and Ungroup Columns in Unknown Number of Sheets with Macro
How to Protect Your Macro/VBA Codes from Others for Viewing and Editing
[New Case & Troubleshooting!] Split Sheet in Table Format into Multiple Sheets with 1 click - VBA
Excel vs Power Bi: How To Create Double Stacked Column Charts
Group and Ungroup Specific Rows with Macro - One Click!
How to Find the Minimum Positive Number with Array Function
How to Refresh Multiple Pivot Tables automatically with Macro
Create Bar of Pie Visual with Power BI
Clean Data with ChatGPT: Extract Unique Values from Multiple Column Datasets
How to Create Triple Clustered Column Chart with Scatter Points
How to Create Double Clustered Column Chart with Scatter Points
Clean Data with ChatGPT: Create and Refresh Pivot Table with VBA
How to Automatically Hide Rows based on Cell Value with a Button
How to create a Stacked Bars within Bar/Bars Overlapping Chart in Excel
How to Automatically Hide Nonsequential Rows based on Cell Value - Macro for Beginner
How to Automatically Hide Rows based on Cell Value - Formula-driven and Multiple Criteria
How to Fill Customized Cell Color based on Content with Macro
Coding with ChatGPT: Write Your First VBA Code in Excel in 10 Minutes!
Sum Multiple Sheets with Different Column Count - Macro for beginner
Excel vs Power BI: Create Templates for Double Stacked Column Chart
Create Dependent Dropdown List and Use it for Vlookup (Part 2)
3 Most Commonly Used Visualization Features in Power BI: Card, Multirow Card and Treemap Chart
Find Min, Max and Quartile Value Based on Multiple Criteria with Array Function
Clean Data with ChatGPT: Find and Replace Text Value
Conditional Format Cells Automatically When You Change Cell Content
How to Automatically Group Rows based on Cell Value
How to Create Pivot Table for All Worksheets with 1 Click - Part 2
How to Create Pivot Table for All Worksheets with 1 Click - Part 1
How to get Macro/VBA ready for Excel workbook
How to evaluate and visualize an internal equity or pay compression issue?
