![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.
![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.
![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...
![20 Excel Date Functions - Explained!](https://www.goskills.com/blobs/blogs/595/2fe0604e-af06-4e4e-bd20-1720ae66f800-thumb.jpg)
42 min
20 Excel Date Functions - Explained!
There are more than 20 date formulas in Excel to help simplify common operations involving dates. Here is a list of some top Excel date functions.
![Excel Challenge 18: Perform a Two-Way Lookup and Approximate Match](https://www.goskills.com/blobs/blogs/592/c58c5d1d-8776-4571-a2a7-84b1b384691d-thumb.jpg)
2 min
Excel Challenge 18: Perform a Two-Way Lookup and Approximate Match
How do you use two lookup values to return a single value in Excel? Join this month's Excel challenge to find out!
![How to Use the TRIM Function in Excel](https://www.goskills.com/blobs/blogs/593/e22d50e4-44da-4de8-acec-a9afc45bcf95-thumb.jpg)
7 min
How to Use the TRIM Function in Excel
Learn how to clean up data easily using the TRIM function in Excel.
![How to Use VSTACK and HSTACK in Excel](https://www.goskills.com/blobs/blogs/587/3488382d-2e53-46bb-a811-5da67a9b9309-thumb.jpg)
4 min
How to Use VSTACK and HSTACK in Excel
Exciting new Excel functions are here! Learn how VSTACK and HSTACK in Excel make list combinations effortless.
![Excel Challenge 17: Summarize Data with Interactive PivotTables and Charts](https://www.goskills.com/blobs/blogs/582/adb78b11-f79e-457b-ba4a-7c94b6edea62-thumb.jpg)
2 min
Excel Challenge 17: Summarize Data with Interactive PivotTables and Charts
Can you summarize large pieces of data with an informative, interactive chart? Test your skills with this Excel challenge by using PivotTables and ...
![How to use TEXTBEFORE, TEXTAFTER and TEXTSPLIT in Excel](https://www.goskills.com/blobs/blogs/586/4c466394-5d4c-4d98-b504-10d8951a6d5f-thumb.jpg)
13 min
How to use TEXTBEFORE, TEXTAFTER and TEXTSPLIT in Excel
Learn to use TEXTBEFORE, TEXTAFTER, and TEXTSPLIT for easier text handling in Excel.
![Excel Basics - Step by Step Tutorial for Beginners](https://www.goskills.com/blobs/blogs/577/bc2a9812-e678-4b16-b4a7-717a857d08cd-thumb.jpg)
29 min
Excel Basics - Step by Step Tutorial for Beginners
From figuring out the interface to using advanced filters, learn all there is to know when it comes to Excel basics.
![Excel Challenge 16: Techniques for Manipulating Text](https://www.goskills.com/blobs/blogs/576/ba1b1d7c-eb38-4381-90b7-487d9190cd12-thumb.jpg)
2 min
Excel Challenge 16: Techniques for Manipulating Text
Practice splitting and re-formatting text using time-saving techniques in Excel!
![How to Compare Two Columns in Excel](https://www.goskills.com/blobs/blogs/575/2565c95a-94f2-4d96-984d-f31b248b6da3-thumb.jpg)
6 min
How to Compare Two Columns in Excel
Learn how to compare two columns in Excel in a few simple steps.
![How to Move Rows and Columns in Excel](https://www.goskills.com/blobs/blogs/574/1fc5b5de-8acf-4d06-93dc-35968d57c5d8-thumb.jpg)
4 min
How to Move Rows and Columns in Excel
Rearranging data in Excel isn't as complicated as it sounds. Learn how to move columns in Excel (and rows too!) in a few simple steps.