GoSkills business - Excel challengesGoSkills Business Resourcestag:resources@goskills.com(c) 2016 - 20252025-11-03T07:43:21Zhttps://cdn2.goskills.com/assets/images/logo/logo-icon-white-background.pngGoSkills.comhttps://www.goskills.comtag:resources@goskills.com,2025-11-03:excel-challenge-58Customer Segmentation: One-Formula Excel Challenge | GoSkills2025-11-03T07:43:21Z2025-11-03T07:43:21ZGoSkills.comhttps://www.goskills.comCreate a customer segmentation report in Excel with one formula. Use dynamic arrays to group customers and label them Gold, Silver, or Bronze.tag:resources@goskills.com,2025-10-06:excel-challenge-57Consolidate Data from Multiple Files | GoSkills Excel Challenge 572025-10-06T14:15:39Z2025-10-06T14:15:39ZGoSkills.comhttps://www.goskills.comConsolidating data in Excel from multiple workbooks? Learn how in this scenario-based challenge! Join our group of learners for Excel practice every month.tag:resources@goskills.com,2025-09-08:excel-challenge-56Data Analysis With Conditional Functions | Excel Challenge2025-09-08T14:15:21Z2025-09-08T14:15:21ZGoSkills.comhttps://www.goskills.comPractice conditional formulas in Excel in a real-world scenario with this beginner-friendly challenge from Microsoft MVP Ilgar Zarbaliyev.tag:resources@goskills.com,2025-08-04:excel-challenge-55Analyze Business Sales | Excel Practice Exercise2025-08-04T14:45:21Z2025-08-04T14:45:21ZGoSkills.comhttps://www.goskills.comLearn how to use conditional formulas SUMIF and SUMIFS in Excel to analyze sales performance in this fun Excel challenge.tag:resources@goskills.com,2025-07-07:excel-challenge-54Excel Challenge 54: Clean Up Messy Data With Power Query2025-07-07T14:45:17Z2025-07-07T14:45:17ZGoSkills.comhttps://www.goskills.comUse Power Query to transform messy, unmanageable data into analysis-ready insights with this month's Excel challenge from GoSkills.tag:resources@goskills.com,2025-06-02:excel-challenge-53Excel Dependent Dropdown Lists: Practice & Tutorial2025-06-02T14:45:15Z2025-06-02T14:45:15ZGoSkills.comhttps://www.goskills.comPractice creating dependent dropdown lists in Excel with this fun challenge! Learn how our expert solved it in the easy-to-follow solution tutorial.tag:resources@goskills.com,2025-05-05:Excel-challenge-52Data Analysis With PivotTables | Excel Practice Exercise2025-05-05T14:45:26Z2025-05-05T14:45:26ZGoSkills.comhttps://www.goskills.comUse PivotTables to perform data analysis with this sales performance Excel challenge. tag:resources@goskills.com,2025-04-07:Excel-challenge-51Excel Loan Amortization Exercise | GoSkills Excel Challenge2025-04-07T14:45:33Z2025-04-07T14:45:33ZGoSkills.comhttps://www.goskills.comBuild an interactive Excel tool to track loans and payments! Master finance functions to create your own amortization schedule template.tag:resources@goskills.com,2025-03-03:Excel-challenge-50Break-Even Analysis Using Data Tables | GoSkills Excel Challenge 502025-03-03T15:24:36Z2025-03-03T15:24:36ZGoSkills.comhttps://www.goskills.comMaster break-even analysis in Excel! Use data tables and conditional formatting to identify profit and loss scenarios. Take on this challenge now!tag:resources@goskills.com,2025-02-03:Excel-challenge-49Excel Challenge 49: Create a Dynamic Lookup Tool With Images2025-02-03T15:28:14Z2025-02-03T15:28:14ZGoSkills.comhttps://www.goskills.comBuild a dynamic lookup tool in Excel to retrieve player details—including images! Plus, create an interactive PivotTable with slicers for easy analysis.tag:resources@goskills.com,2025-01-06:Excel-challenge-48Build With Me: Library Management System | Excel Challenge2025-01-06T16:11:12Z2025-01-06T16:11:12ZGoSkills.comhttps://www.goskills.comFlex your Excel formula skills with this library book tracker challenge! Tackle real-world tasks and sharpen your data analysis expertise.tag:resources@goskills.com,2024-11-04:Excel-challenge-46Excel Challenge 46: Inventory Optimization With Excel Solver2024-11-04T15:39:25Z2024-11-04T15:39:25ZGoSkills.comhttps://www.goskills.comIn this Excel practice exercise, optimize inventory levels across stores and warehouses! Using Solver, balance stock levels, meet demand, and minimize costs.tag:resources@goskills.com,2024-10-07:Excel-challenge-45Excel Challenge 45: Create an Interactive Sales Chart2024-10-07T14:45:29Z2024-10-07T14:45:29ZGoSkills.comhttps://www.goskills.comIf you're creating a dashboard in Excel, an interactive chart will most likely be one of the elements. Learn how to create one in this fun scenario!tag:resources@goskills.com,2024-09-09:Excel-challenge-44Excel Challenge 44: Build an Employee Performance Review Sheet2024-09-09T14:46:06Z2024-09-09T14:46:06ZGoSkills.comhttps://www.goskills.comCreate a performance review sheet in Excel with weighted scores, conditional formulas, and a radar chart. Test your skills in GoSkills’ Excel Challenge 44!tag:resources@goskills.com,2024-08-05:Excel-challenge-43Excel Challenge 43: Assign Random Values From a List2024-08-05T14:45:27Z2024-08-05T14:45:27ZGoSkills.comhttps://www.goskills.comTest your skills with this Excel challenge: create random schedules for athletes and display dynamic rosters. Dive in, explore our resources, and get started!tag:resources@goskills.com,2024-07-01:Excel-challenge-42Excel Challenge 42: Prepare an Excel Worksheet for Printing2024-07-01T14:48:31Z2024-07-01T14:48:31ZGoSkills.comhttps://www.goskills.comIn this Excel challenge, reformat and prep a messy sales worksheet for printing. Join our Slack community; you might learn a trick or two!tag:resources@goskills.com,2024-06-03:Excel-challenge-41Excel Challenge 41: Transforming Data With Excel Functions2024-06-03T14:23:10Z2024-06-03T14:23:10ZGoSkills.comhttps://www.goskills.comTake this Excel challenge to convert data in different formats using Excel functions. Which formulas will you use to organize this group of marathon runners?tag:resources@goskills.com,2024-05-06:Excel-challenge-40Excel Challenge 40: Create a Custom Excel Calculator2024-05-06T15:00:42Z2024-05-06T15:00:42ZGoSkills.comhttps://www.goskills.comWould you like to build your own Excel calculator? It might be easier than you think! Take the challenge and see how our community members solved it.tag:resources@goskills.com,2024-04-01:Excel-challenge-39Excel Challenge 39: Generate Unique Random Values | GoSkills2024-04-01T14:31:20Z2024-04-01T14:31:20ZGoSkills.comhttps://www.goskills.comWhat is the best way to generate random values in Excel? Better yet, can you make them unique? Put your skills to the test with this Excel challenge.tag:resources@goskills.com,2024-03-04:Excel-challenge-38Excel Challenge 38: Data Lookup From Multiple Sources2024-03-04T15:50:14Z2024-03-04T15:50:14ZGoSkills.comhttps://www.goskills.comTake this Excel challenge by showing us what to do when XLOOKUP or VLOOKUP alone isn't enough to extract the values you want. tag:resources@goskills.com,2024-02-05:Excel-challenge-37Excel Challenge 37: Keeping Track of Inventory2024-02-05T16:02:43Z2024-02-05T16:02:43ZGoSkills.comhttps://www.goskills.comUse Excel to keep track of inventory with this challenge, guided by Microsoft MVP Deb Ashby. tag:resources@goskills.com,2024-01-08:Excel-challenge-36Excel Challenge 36: Calculate and Maximize Commission With What-If Analysis2024-01-08T16:37:50Z2024-01-08T16:37:50ZGoSkills.comhttps://www.goskills.comCan you apply what-if analysis to a real-world situation? Take this Excel challenge to find out.tag:resources@goskills.com,2023-12-04:Excel-challenge-35Excel Challenge 35: Create an Invoice Tracker2023-12-04T15:55:07Z2023-12-04T15:55:07ZGoSkills.comhttps://www.goskills.comChallenge yourself to create a tracker in Excel that updates automatically when invoices are due soon or overdue.tag:resources@goskills.com,2023-11-06:Excel-challenge-34Excel Challenge 34: Advanced Data Validation2023-11-06T16:00:42Z2023-11-06T16:00:42ZGoSkills.comhttps://www.goskills.comFlex your data validation and worksheet protection skills with this month's Excel challenge.tag:resources@goskills.com,2023-10-02:Excel-challenge-33Use What-If Analysis and PMT Function in Excel | GoSkills Challenge2023-10-02T16:48:38Z2023-10-02T16:48:38ZGoSkills.comhttps://www.goskills.comCan you use Excel to calculate monthly loan payments using a what-if analysis? Do you know of any other methods? Take the challenge and share your solution!tag:resources@goskills.com,2023-09-04:Excel-challenge-32Excel Challenge: Counting Values That Meet Conditions | GoSkills2023-09-04T14:57:46Z2023-09-04T14:57:46ZGoSkills.comhttps://www.goskills.comExplore ways to count values with specific criteria and flex your problem-solving skills with this month's Excel challenge.tag:resources@goskills.com,2023-08-07:Excel-challenge-31Excel Challenge 31 | GoSkills2023-08-07T14:33:47Z2023-08-07T14:33:47ZGoSkills.comhttps://www.goskills.comIn this Excel Challenge you’ll practice Data Analysis skills with Power Query and Pivot Tables. Solve a data challenge that’s based on a real-world scenario.tag:resources@goskills.com,2023-07-03:Excel-challenge-30Excel Challenge 30: Create a Dynamic Chart Using Multiple Criteria2023-07-03T14:55:04Z2023-07-03T14:55:04ZGoSkills.comhttps://www.goskills.comTake this free Excel challenge to test your ability to make dropdown lists and dynamic charts! Learn real-word skills in data management.tag:resources@goskills.com,2023-06-05:Excel-challenge-29Excel Challenge 29: How to Make an Excel Progress Bar | GoSkills2023-06-05T14:42:08Z2023-06-05T14:42:08ZGoSkills.comhttps://www.goskills.comChallenge your ability to create a functional progress bar in Excel with this workout, then check out our expert's solution!tag:resources@goskills.com,2023-05-01:Excel-challenge-28Excel Challenge - Chart with Conditional Formatting | GoSkills 2023-05-01T14:47:18Z2023-05-01T14:47:18ZGoSkills.comhttps://www.goskills.comThis Excel Challenge asks you to create a column chart that applies conditional formatting and other advanced elements. This isn't your everyday Excel chart, so join the fun and check out our solution!tag:resources@goskills.com,2023-04-03:Excel-challenge-27Excel Challenge 27 | GoSkills2023-04-03T14:46:28Z2023-04-03T14:46:28ZGoSkills.comhttps://www.goskills.comTake this Excel challenge to create a database using randomly-selected values from a list!tag:resources@goskills.com,2023-03-06:Excel-challenge-26Excel Challenge 26: VLOOKUP With Duplicates 2023-03-06T18:08:52Z2023-03-06T18:08:52ZGoSkills.comhttps://www.goskills.comIn this Excel challenge, some of the lookup values are duplicated in the source data set. Can you get Excel to find the right one?tag:resources@goskills.com,2023-02-06:Excel-challenge-25Excel Challenge 25: Convert Dates Stored as Text2023-02-06T17:55:06Z2023-02-06T17:55:06ZGoSkills.comhttps://www.goskills.comWhat are your options when dates in Excel are stored as text? Take this Excel challenge for a spin, then check out our solution!tag:resources@goskills.com,2023-01-09:Excel-challenge-24Excel Challenges | GoSkills2023-01-09T18:00:00Z2023-01-09T18:00:00ZGoSkills.comhttps://www.goskills.comCan you leverage the power of combining Excel dynamic array formulas? Take this Excel challenge to return unique values and non-contiguous columns!tag:resources@goskills.com,2022-12-05:Excel-challenge-23Excel Challenge 23: How to Break Ties When Ranking2022-12-05T17:31:42Z2022-12-05T17:31:42ZGoSkills.comhttps://www.goskills.comTake this Excel challenge! How do you rank the top 5 agents when duplicate scores exist?tag:resources@goskills.com,2022-11-07:Excel-challenge-22Excel Challenge 22: Create a Dynamic Excel Chart Range2022-11-07T17:59:22Z2022-11-07T17:59:22ZGoSkills.comhttps://www.goskills.comCan you create a dynamic chart range in Excel? Take our latest Excel challenge to prove it, and check out our solution!tag:resources@goskills.com,2022-10-03:Excel-challenge-21Excel Challenge 21: Unpivoting Data Within a Table2022-10-03T16:59:20Z2022-10-03T16:59:20ZGoSkills.comhttps://www.goskills.comCan you decide on the best method for extracting data using multiple criteria from this Excel table? Test your skills with this Excel challenge!tag:resources@goskills.com,2022-09-05:Excel-challenge-20Excel Challenge 20: Calculate Years Between Two Dates2022-09-05T17:55:48Z2022-09-05T17:55:48ZGoSkills.comhttps://www.goskills.comChoose the best Excel date function to calculate the number of years between two dates with this Excel challenge!tag:resources@goskills.com,2022-08-01:Excel-challenge-19Excel Challenge: Using Advanced Logic in Formulas | GoSkills2022-08-01T16:51:45Z2022-08-01T16:51:45ZGoSkills.comhttps://www.goskills.comWhat Excel functions do you use when multiple combinations could lead to different outcomes? Share it with us by working on our latest Excel challenge!tag:resources@goskills.com,2022-07-04:Excel-challenge-18Excel Challenge 18: Perform a Two-Way Lookup and Approximate Match2022-07-04T16:50:56Z2022-07-04T16:50:56ZGoSkills.comhttps://www.goskills.comHow do you use two lookup values to return a single value in Excel? Join this month's Excel challenge to find out!tag:resources@goskills.com,2022-06-06:Excel-challenge-17Excel Challenge 17: Summarize Data with Interactive PivotTables and Charts2022-06-06T16:59:16Z2022-06-06T16:59:16ZGoSkills.comhttps://www.goskills.comCan you summarize large pieces of data with an informative, interactive chart? Test your skills with this Excel challenge by using PivotTables and Charts.tag:resources@goskills.com,2022-05-02:Excel-challenge-16Excel Challenge 16: Techniques for Manipulating Text2022-05-02T17:06:54Z2022-05-02T17:06:54ZGoSkills.comhttps://www.goskills.comPractice splitting and re-formatting text using time-saving techniques in Excel!tag:resources@goskills.com,2022-04-04:Excel-challenge-15Excel Challenge 15: Track Expenses with Data Visualization2022-04-04T16:57:23Z2022-04-04T16:57:23ZGoSkills.comhttps://www.goskills.comFor this Excel challenge, let's use conditional formatting to make this monthly expense sheet more visually appealing!tag:resources@goskills.com,2022-03-07:Excel-challenge-14Excel Challenge 14: Perform a Lookup From Multiple Sources2022-03-07T15:40:08Z2022-03-07T15:40:08ZGoSkills.comhttps://www.goskills.comTest your Excel skills with this multi-source, sequential lookup challenge!tag:resources@goskills.com,2022-02-01:Excel-challenge-13Excel Challenge 13: Use Partial Match to Find Multiple Criteria2022-02-01T18:00:16Z2022-02-01T18:00:16ZGoSkills.comhttps://www.goskills.comCan you filter in Excel using multiple criteria and wildcards? Test your skills by stepping up to this challenge!tag:resources@goskills.com,2022-01-04:Excel-challenge-12Excel Challenge 12: Methods for Splitting Cell Values2022-01-04T11:53:07Z2022-01-04T11:53:07ZGoSkills.comhttps://www.goskills.comIn this challenge, we are experimenting with different methods of splitting data in Excel. How many methods do you know? Which method is most efficient?tag:resources@goskills.com,2021-11-23:Excel-challenge-11Use Excel Dropdown Lists to Design an Interactive Worksheet2021-11-23T17:46:51Z2021-11-23T17:46:51ZGoSkills.comhttps://www.goskills.comCan you use data validation to minimize or eliminate selection errors? Test your skills with this Excel challenge!tag:resources@goskills.com,2021-09-13:Excel-challenge-10Excel Challenge 10: Automating Repetitive Tasks With Macros2021-09-13T15:00:00Z2021-09-13T15:00:00ZGoSkills.comhttps://www.goskills.comIn this challenge, you get to build your first simple macro in Excel by automating a repetitive report! Can you solve this challenge?tag:resources@goskills.com,2021-08-04:Excel-challenge-9Excel Challenge 9: Making Use of Advanced Sorting Techniques in Excel2021-08-04T06:33:05Z2021-08-04T06:33:05ZGoSkills.comhttps://www.goskills.comThink sorting data in Excel is simple enough? Well, try this challenge and let's see if you still think so.tag:resources@goskills.com,2021-06-23:Excel-challenge-8Excel Challenge 8: Create a Performance Incentive Worksheet2021-06-23T05:31:18Z2021-06-23T05:31:18ZGoSkills.comhttps://www.goskills.comUse the VLOOKUP and IF functions to solve this new Excel challenge that takes you into a contact center. Take the challenge to learn real-world Excel skills.tag:resources@goskills.com,2021-05-25:Excel-challenge-7Excel Challenge 7: Create an Expandable Dropdown List2021-05-25T08:30:38Z2021-05-25T08:30:38ZGoSkills.comhttps://www.goskills.comHelp this book store owner solve this Excel data management challenge using the XLOOKUP function.tag:resources@goskills.com,2021-04-12:Excel-challenge-6Excel Challenge 6: Using Basic Logical Functions2021-04-12T16:56:30Z2021-04-12T16:56:30ZGoSkills.comhttps://www.goskills.comIt’s coming up to the end of the year and there’s a scramble to take vacation days. Can you help your HR department solve this challenge?tag:resources@goskills.com,2021-01-25:Excel-challenge-5Excel Challenge 5: Formula Super Challenge2021-01-25T17:51:28Z2021-01-25T17:51:28ZGoSkills.comhttps://www.goskills.comIt's time for some more fun with Excel! Try solving this Excel formula challenge from Excel MVP Alan Murray (aka. Computergaga). tag:resources@goskills.com,2020-12-14:Excel-challenge-4Excel Challenge 4: Analyze Data With Power Query2020-12-14T17:53:13Z2020-12-14T17:53:13ZGoSkills.comhttps://www.goskills.comReady for some more fun with Power Query in Excel? Try solving this Excel challenge from Excel MVP Alan Murray (aka. Computergaga). tag:resources@goskills.com,2020-11-16:Excel-challenge-3Excel Challenge 3: Power Query and Pivot Tables2020-11-16T17:49:05Z2020-11-16T17:49:05ZGoSkills.comhttps://www.goskills.comUse power query and pivot tables to solve this GoSkills Excel challenge by Alan Murray.tag:resources@goskills.com,2020-10-19:Excel-challenge-2Excel Challenge 2: Clean and Transform Data with Power Query2020-10-19T19:34:47Z2020-10-19T19:34:47ZGoSkills.comhttps://www.goskills.comReady for some fun with Power Query in Excel? Try your hand at solving this Excel challenge from Excel MVP Alan Murray (aka. Computergaga) now!tag:resources@goskills.com,2020-09-15:Excel-challenge-1Excel Challenge 1: Use Raw Data to Create Dynamic Reports2020-09-15T18:59:09Z2020-09-15T18:59:09ZGoSkills.comhttps://www.goskills.comThink you’re pretty good at Microsoft Excel? Prove it by solving this Excel challenge from Excel MVP Alan Murray!