Resources
![How to Freeze Panes in Excel](https://www.goskills.com/blobs/blogs/617/2c53c3e6-9300-4370-b487-d9376b7d9375-thumb.jpg)
11 min
How to Freeze Panes in Excel
Once you learn how to freeze panes in Excel, analyzing giant spreadsheets won't seem so daunting.
![How To Do a Mail Merge in Excel](https://www.goskills.com/blobs/blogs/704/e241526e-b760-42aa-baf6-fcec2371a737-thumb.jpg)
14 min
How To Do a Mail Merge in Excel
A step-by-step guide to mail merge in Microsoft Word using an Excel source list.
![13 Tax Benefits and Deductions for the Self-Employed](https://www.goskills.com/blobs/blogs/637/a9a4b186-2274-43c9-b193-5cf2c54782f1-thumb.jpg)
10 min
13 Tax Benefits and Deductions for the Self-Employed
Reduce your self-employment taxes with these 13 tax benefits and deductions you could be claiming.
![Top 10 Skills Employers Want to See on a Resume in 2024](https://www.goskills.com/blobs/blogs/638/918dac15-e90e-47e7-8f7f-90ac5aba643c-thumb.jpg)
8 min
Top 10 Skills Employers Want to See on a Resume in 2024
Learn how to stand out in a sea of applicants by finding out the top 10 skills employers are looking for on resumes in 2024.
![Excel Challenge 23: How to Break Ties When Ranking](https://www.goskills.com/blobs/blogs/633/8776b9e4-69e7-40d0-b240-5cad969f4e12-thumb.jpg)
2 min
Excel Challenge 23: How to Break Ties When Ranking
Take this Excel challenge! How do you rank the top 5 agents when duplicate scores exist?
![Pivot Table Filter in Excel](https://www.goskills.com/blobs/blogs/609/8fbc7eba-d55c-4261-808d-365a92603fee-thumb.jpg)
10 min
Pivot Table Filter in Excel
Excel pivot table filters help you to display select portions of data at your discretion and zero in on a special segment.
![VLOOKUP With Multiple Criteria or Multiple Results in Excel](https://www.goskills.com/blobs/blogs/629/dbde537e-187f-4073-9aea-ca9dfae20490-thumb.jpg)
12 min
VLOOKUP With Multiple Criteria or Multiple Results in Excel
Learn how to lookup multiple criteria in Excel. Analyze the best options from the FILTER function to XLOOKUP.
![Excel Challenge 22: Create a Dynamic Excel Chart Range](https://www.goskills.com/blobs/blogs/628/ac167272-3664-401b-afaf-2fd3d0defc58-thumb.jpg)
2 min
Excel Challenge 22: Create a Dynamic Excel Chart Range
Can you create a dynamic chart range in Excel? Take our latest Excel challenge to prove it, and check out our solution!
![The Ultimate Guide to Data Analysis in Excel](https://www.goskills.com/blobs/blogs/581/f2bcbd87-d9e9-4974-95a1-70696721aa01-thumb.jpg)
20 min
The Ultimate Guide to Data Analysis in Excel
Excel is all about data! Learn these simple but essential data analysis tools in Excel.
![How to Prevent Quiet Quitting in Your Company](https://www.goskills.com/blobs/blogs/626/0ce2ddb2-17e4-444b-bf08-8e98fa1909b5-thumb.jpg)
9 min
How to Prevent Quiet Quitting in Your Company
Learn what quiet quitting is and why it happens. Then, learn how to prevent it at your company.
![Excel Challenge 21: Unpivoting Data Within a Table](https://www.goskills.com/blobs/blogs/618/60942d11-4b22-430e-a3a1-65ae87036ee0-thumb.jpg)
2 min
Excel Challenge 21: Unpivoting Data Within a Table
Can you decide on the best method for extracting data using multiple criteria from this Excel table? Test your skills with this Excel challenge!
![How to Make a Table in Excel](https://www.goskills.com/blobs/blogs/611/726e5bbb-d1ba-4175-ac20-cc033eec81de-thumb.jpg)
11 min
How to Make a Table in Excel
Want to know how to make a table in Excel? It's a lot more than just data and labels. Learn about Excel's dynamic and ever adapting tables.
![How to Use the Data Analysis Toolpak in Excel](https://www.goskills.com/blobs/blogs/607/e1965783-bca3-473e-8951-65b4830f3654-thumb.jpg)
9 min
How to Use the Data Analysis Toolpak in Excel
The Excel Data Analysis Toolpak is a handy helper that analyzes complex or large data in a heartbeat.
![How to Sort a Pivot Table](https://www.goskills.com/blobs/blogs/610/1d00cfff-9097-419f-9a97-a3e99c11760f-thumb.jpg)
11 min
How to Sort a Pivot Table
Wondering how to sort a pivot table? Learn how to sort in basic and custom orders in no time!
![How to Subtract in Excel](https://www.goskills.com/blobs/blogs/605/6e84acfe-abd4-448c-aa73-0b5d6a766f41-thumb.jpg)
8 min
How to Subtract in Excel
Ever wondered how to subtract in Excel? Knowing this operation can simplify some of the most complex data.
![Excel Challenge 20: Calculate Years Between Two Dates](https://www.goskills.com/blobs/blogs/603/4ec55367-3f28-455f-b3ba-9ae5e63a233a-thumb.png)
2 min
Excel Challenge 20: Calculate Years Between Two Dates
Choose the best Excel date function to calculate the number of years between two dates with this Excel challenge!
![How to Use the Excel SUBSTITUTE Function](https://www.goskills.com/blobs/blogs/589/0bcb6017-9ed0-497f-856e-bb3be5e48649-thumb.jpg)
7 min
How to Use the Excel SUBSTITUTE Function
Check out all the ways you can replace instances of text with the Excel SUBSTITUTE function.
![How to Use Excel Pivot Table Slicers](https://www.goskills.com/blobs/blogs/602/9527f437-1f49-45dd-b024-b05da3d0545f-thumb.jpg)
11 min
How to Use Excel Pivot Table Slicers
Meet pivot table slicers in Excel – the cooler, more efficient cousin to filters. Learn how to display your desired variables in an instant.
![Corporate Gift Ideas to Wow Your Clients and Staff](https://www.goskills.com/blobs/blogs/597/5d1d2969-a0f7-4d6e-a5e9-9e299348fc1b-thumb.jpg)
9 min
Corporate Gift Ideas to Wow Your Clients and Staff
Corporate gifting can improve your working relationships, help retain clients, and even lower the cost of operations. Here are some corporate gift ...
![Excel Challenge 19: Using Advanced Logic to Return Different Results](https://www.goskills.com/blobs/blogs/596/9c498656-5d85-4a9a-bc46-3b354b78dc39-thumb.jpg)
2 min
Excel Challenge 19: Using Advanced Logic to Return Different Results
What Excel functions do you use when multiple combinations could lead to different outcomes? Share it with us by working on our latest Excel challe...