https://www.goskills.com/Resources/Business GoSkills Business Resources en-us (c) 2016 - 2025 Mon, 03 Nov 2025 07:43:21 Z https://cdn2.goskills.com/assets/images/logo/logo-icon-white-background.png https://www.goskills.com/Resources/Business tag:resources@goskills.com tag:resources@goskills.com,2025-11-03:excel-challenge-58 https://www.goskills.com/Resources/excel-challenge-58 Excel challenges Create a customer segmentation report in Excel with one formula. Use dynamic arrays to group customers and label them Gold, Silver, or Bronze. Mon, 03 Nov 2025 07:43:21 Z 2025-11-03T07:43:21Z tag:resources@goskills.com,2025-10-06:excel-challenge-57 https://www.goskills.com/Resources/excel-challenge-57 Excel challenges Consolidating data in Excel from multiple workbooks? Learn how in this scenario-based challenge! Join our group of learners for Excel practice every month. Mon, 06 Oct 2025 14:15:39 Z 2025-10-06T14:15:39Z tag:resources@goskills.com,2025-09-08:excel-challenge-56 https://www.goskills.com/Resources/excel-challenge-56 Excel challenges Practice conditional formulas in Excel in a real-world scenario with this beginner-friendly challenge from Microsoft MVP Ilgar Zarbaliyev. Mon, 08 Sep 2025 14:15:21 Z 2025-09-08T14:15:21Z tag:resources@goskills.com,2025-08-04:excel-challenge-55 https://www.goskills.com/Resources/excel-challenge-55 Excel challenges Learn how to use conditional formulas SUMIF and SUMIFS in Excel to analyze sales performance in this fun Excel challenge. Mon, 04 Aug 2025 14:45:21 Z 2025-08-04T14:45:21Z tag:resources@goskills.com,2025-07-07:excel-challenge-54 https://www.goskills.com/Resources/excel-challenge-54 Excel challenges Use Power Query to transform messy, unmanageable data into analysis-ready insights with this month's Excel challenge from GoSkills. Mon, 07 Jul 2025 14:45:17 Z 2025-07-07T14:45:17Z tag:resources@goskills.com,2025-06-02:excel-challenge-53 https://www.goskills.com/Resources/excel-challenge-53 Excel challenges Practice creating dependent dropdown lists in Excel with this fun challenge! Learn how our expert solved it in the easy-to-follow solution tutorial. Mon, 02 Jun 2025 14:45:15 Z 2025-06-02T14:45:15Z tag:resources@goskills.com,2025-05-05:Excel-challenge-52 https://www.goskills.com/Resources/Excel-challenge-52 Excel challenges Use PivotTables to perform data analysis with this sales performance Excel challenge. Mon, 05 May 2025 14:45:26 Z 2025-05-05T14:45:26Z tag:resources@goskills.com,2025-04-07:Excel-challenge-51 https://www.goskills.com/Resources/Excel-challenge-51 Excel challenges Build an interactive Excel tool to track loans and payments! Master finance functions to create your own amortization schedule template. Mon, 07 Apr 2025 14:45:33 Z 2025-04-07T14:45:33Z tag:resources@goskills.com,2025-03-03:Excel-challenge-50 https://www.goskills.com/Resources/Excel-challenge-50 Excel challenges Master break-even analysis in Excel! Use data tables and conditional formatting to identify profit and loss scenarios. Take on this challenge now! Mon, 03 Mar 2025 15:24:36 Z 2025-03-03T15:24:36Z tag:resources@goskills.com,2025-02-03:Excel-challenge-49 https://www.goskills.com/Resources/Excel-challenge-49 Excel challenges Build a dynamic lookup tool in Excel to retrieve player details—including images! Plus, create an interactive PivotTable with slicers for easy analysis. Mon, 03 Feb 2025 15:28:14 Z 2025-02-03T15:28:14Z tag:resources@goskills.com,2025-01-06:Excel-challenge-48 https://www.goskills.com/Resources/Excel-challenge-48 Excel challenges Flex your Excel formula skills with this library book tracker challenge! Tackle real-world tasks and sharpen your data analysis expertise. Mon, 06 Jan 2025 16:11:12 Z 2025-01-06T16:11:12Z tag:resources@goskills.com,2024-11-04:Excel-challenge-46 https://www.goskills.com/Resources/Excel-challenge-46 Excel challenges In this Excel practice exercise, optimize inventory levels across stores and warehouses! Using Solver, balance stock levels, meet demand, and minimize costs. Mon, 04 Nov 2024 15:39:25 Z 2024-11-04T15:39:25Z tag:resources@goskills.com,2024-10-07:Excel-challenge-45 https://www.goskills.com/Resources/Excel-challenge-45 Excel challenges If 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! Mon, 07 Oct 2024 14:45:29 Z 2024-10-07T14:45:29Z tag:resources@goskills.com,2024-09-09:Excel-challenge-44 https://www.goskills.com/Resources/Excel-challenge-44 Excel challenges Create a performance review sheet in Excel with weighted scores, conditional formulas, and a radar chart. Test your skills in GoSkills’ Excel Challenge 44! Mon, 09 Sep 2024 14:46:06 Z 2024-09-09T14:46:06Z tag:resources@goskills.com,2024-08-05:Excel-challenge-43 https://www.goskills.com/Resources/Excel-challenge-43 Excel challenges Test your skills with this Excel challenge: create random schedules for athletes and display dynamic rosters. Dive in, explore our resources, and get started! Mon, 05 Aug 2024 14:45:27 Z 2024-08-05T14:45:27Z tag:resources@goskills.com,2024-07-01:Excel-challenge-42 https://www.goskills.com/Resources/Excel-challenge-42 Excel challenges In this Excel challenge, reformat and prep a messy sales worksheet for printing. Join our Slack community; you might learn a trick or two! Mon, 01 Jul 2024 14:48:31 Z 2024-07-01T14:48:31Z tag:resources@goskills.com,2024-06-03:Excel-challenge-41 https://www.goskills.com/Resources/Excel-challenge-41 Excel challenges Take this Excel challenge to convert data in different formats using Excel functions. Which formulas will you use to organize this group of marathon runners? Mon, 03 Jun 2024 14:23:10 Z 2024-06-03T14:23:10Z tag:resources@goskills.com,2024-05-06:Excel-challenge-40 https://www.goskills.com/Resources/Excel-challenge-40 Excel challenges Would 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. Mon, 06 May 2024 15:00:42 Z 2024-05-06T15:00:42Z tag:resources@goskills.com,2024-04-01:Excel-challenge-39 https://www.goskills.com/Resources/Excel-challenge-39 Excel challenges What 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. Mon, 01 Apr 2024 14:31:20 Z 2024-04-01T14:31:20Z tag:resources@goskills.com,2024-03-04:Excel-challenge-38 https://www.goskills.com/Resources/Excel-challenge-38 Excel challenges Take this Excel challenge by showing us what to do when XLOOKUP or VLOOKUP alone isn't enough to extract the values you want. Mon, 04 Mar 2024 15:50:14 Z 2024-03-04T15:50:14Z tag:resources@goskills.com,2024-02-05:Excel-challenge-37 https://www.goskills.com/Resources/Excel-challenge-37 Excel challenges Use Excel to keep track of inventory with this challenge, guided by Microsoft MVP Deb Ashby. Mon, 05 Feb 2024 16:02:43 Z 2024-02-05T16:02:43Z tag:resources@goskills.com,2024-01-08:Excel-challenge-36 https://www.goskills.com/Resources/Excel-challenge-36 Excel challenges Can you apply what-if analysis to a real-world situation? Take this Excel challenge to find out. Mon, 08 Jan 2024 16:37:50 Z 2024-01-08T16:37:50Z tag:resources@goskills.com,2023-12-04:Excel-challenge-35 https://www.goskills.com/Resources/Excel-challenge-35 Excel challenges Challenge yourself to create a tracker in Excel that updates automatically when invoices are due soon or overdue. Mon, 04 Dec 2023 15:55:07 Z 2023-12-04T15:55:07Z tag:resources@goskills.com,2023-11-06:Excel-challenge-34 https://www.goskills.com/Resources/Excel-challenge-34 Excel challenges Flex your data validation and worksheet protection skills with this month's Excel challenge. Mon, 06 Nov 2023 16:00:42 Z 2023-11-06T16:00:42Z tag:resources@goskills.com,2023-10-02:Excel-challenge-33 https://www.goskills.com/Resources/Excel-challenge-33 Excel challenges Can 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! Mon, 02 Oct 2023 16:48:38 Z 2023-10-02T16:48:38Z tag:resources@goskills.com,2023-09-04:Excel-challenge-32 https://www.goskills.com/Resources/Excel-challenge-32 Excel challenges Explore ways to count values with specific criteria and flex your problem-solving skills with this month's Excel challenge. Mon, 04 Sep 2023 14:57:46 Z 2023-09-04T14:57:46Z tag:resources@goskills.com,2023-08-07:Excel-challenge-31 https://www.goskills.com/Resources/Excel-challenge-31 Excel challenges In 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. Mon, 07 Aug 2023 14:33:47 Z 2023-08-07T14:33:47Z tag:resources@goskills.com,2023-07-03:Excel-challenge-30 https://www.goskills.com/Resources/Excel-challenge-30 Excel challenges Take this free Excel challenge to test your ability to make dropdown lists and dynamic charts! Learn real-word skills in data management. Mon, 03 Jul 2023 14:55:04 Z 2023-07-03T14:55:04Z tag:resources@goskills.com,2023-06-05:Excel-challenge-29 https://www.goskills.com/Resources/Excel-challenge-29 Excel challenges Challenge your ability to create a functional progress bar in Excel with this workout, then check out our expert's solution! Mon, 05 Jun 2023 14:42:08 Z 2023-06-05T14:42:08Z tag:resources@goskills.com,2023-05-01:Excel-challenge-28 https://www.goskills.com/Resources/Excel-challenge-28 Excel challenges This 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! Mon, 01 May 2023 14:47:18 Z 2023-05-01T14:47:18Z tag:resources@goskills.com,2023-04-03:Excel-challenge-27 https://www.goskills.com/Resources/Excel-challenge-27 Excel challenges Take this Excel challenge to create a database using randomly-selected values from a list! Mon, 03 Apr 2023 14:46:28 Z 2023-04-03T14:46:28Z tag:resources@goskills.com,2023-03-06:Excel-challenge-26 https://www.goskills.com/Resources/Excel-challenge-26 Excel challenges In this Excel challenge, some of the lookup values are duplicated in the source data set. Can you get Excel to find the right one? Mon, 06 Mar 2023 18:08:52 Z 2023-03-06T18:08:52Z tag:resources@goskills.com,2023-02-06:Excel-challenge-25 https://www.goskills.com/Resources/Excel-challenge-25 Excel challenges What are your options when dates in Excel are stored as text? Take this Excel challenge for a spin, then check out our solution! Mon, 06 Feb 2023 17:55:06 Z 2023-02-06T17:55:06Z tag:resources@goskills.com,2023-01-09:Excel-challenge-24 https://www.goskills.com/Resources/Excel-challenge-24 Excel challenges Can you leverage the power of combining Excel dynamic array formulas? Take this Excel challenge to return unique values and non-contiguous columns! Mon, 09 Jan 2023 18:00:00 Z 2023-01-09T18:00:00Z tag:resources@goskills.com,2022-12-05:Excel-challenge-23 https://www.goskills.com/Resources/Excel-challenge-23 Excel challenges Take this Excel challenge! How do you rank the top 5 agents when duplicate scores exist? Mon, 05 Dec 2022 17:31:42 Z 2022-12-05T17:31:42Z tag:resources@goskills.com,2022-11-07:Excel-challenge-22 https://www.goskills.com/Resources/Excel-challenge-22 Excel challenges Can you create a dynamic chart range in Excel? Take our latest Excel challenge to prove it, and check out our solution! Mon, 07 Nov 2022 17:59:22 Z 2022-11-07T17:59:22Z tag:resources@goskills.com,2022-10-03:Excel-challenge-21 https://www.goskills.com/Resources/Excel-challenge-21 Excel challenges Can you decide on the best method for extracting data using multiple criteria from this Excel table? Test your skills with this Excel challenge! Mon, 03 Oct 2022 16:59:20 Z 2022-10-03T16:59:20Z tag:resources@goskills.com,2022-09-05:Excel-challenge-20 https://www.goskills.com/Resources/Excel-challenge-20 Excel challenges Choose the best Excel date function to calculate the number of years between two dates with this Excel challenge! Mon, 05 Sep 2022 17:55:48 Z 2022-09-05T17:55:48Z tag:resources@goskills.com,2022-08-01:Excel-challenge-19 https://www.goskills.com/Resources/Excel-challenge-19 Excel challenges What Excel functions do you use when multiple combinations could lead to different outcomes? Share it with us by working on our latest Excel challenge! Mon, 01 Aug 2022 16:51:45 Z 2022-08-01T16:51:45Z tag:resources@goskills.com,2022-07-04:Excel-challenge-18 https://www.goskills.com/Resources/Excel-challenge-18 Excel challenges How do you use two lookup values to return a single value in Excel? Join this month's Excel challenge to find out! Mon, 04 Jul 2022 16:50:56 Z 2022-07-04T16:50:56Z tag:resources@goskills.com,2022-06-06:Excel-challenge-17 https://www.goskills.com/Resources/Excel-challenge-17 Excel challenges Can you summarize large pieces of data with an informative, interactive chart? Test your skills with this Excel challenge by using PivotTables and Charts. Mon, 06 Jun 2022 16:59:16 Z 2022-06-06T16:59:16Z tag:resources@goskills.com,2022-05-02:Excel-challenge-16 https://www.goskills.com/Resources/Excel-challenge-16 Excel challenges Practice splitting and re-formatting text using time-saving techniques in Excel! Mon, 02 May 2022 17:06:54 Z 2022-05-02T17:06:54Z tag:resources@goskills.com,2022-04-04:Excel-challenge-15 https://www.goskills.com/Resources/Excel-challenge-15 Excel challenges For this Excel challenge, let's use conditional formatting to make this monthly expense sheet more visually appealing! Mon, 04 Apr 2022 16:57:23 Z 2022-04-04T16:57:23Z tag:resources@goskills.com,2022-03-07:Excel-challenge-14 https://www.goskills.com/Resources/Excel-challenge-14 Excel challenges Test your Excel skills with this multi-source, sequential lookup challenge! Mon, 07 Mar 2022 15:40:08 Z 2022-03-07T15:40:08Z tag:resources@goskills.com,2022-02-01:Excel-challenge-13 https://www.goskills.com/Resources/Excel-challenge-13 Excel challenges Can you filter in Excel using multiple criteria and wildcards? Test your skills by stepping up to this challenge! Tue, 01 Feb 2022 18:00:16 Z 2022-02-01T18:00:16Z tag:resources@goskills.com,2022-01-04:Excel-challenge-12 https://www.goskills.com/Resources/Excel-challenge-12 Excel challenges In this challenge, we are experimenting with different methods of splitting data in Excel. How many methods do you know? Which method is most efficient? Tue, 04 Jan 2022 11:53:07 Z 2022-01-04T11:53:07Z tag:resources@goskills.com,2021-11-23:Excel-challenge-11 https://www.goskills.com/Resources/Excel-challenge-11 Excel challenges Can you use data validation to minimize or eliminate selection errors? Test your skills with this Excel challenge! Tue, 23 Nov 2021 17:46:51 Z 2021-11-23T17:46:51Z tag:resources@goskills.com,2021-09-13:Excel-challenge-10 https://www.goskills.com/Resources/Excel-challenge-10 Excel challenges In this challenge, you get to build your first simple macro in Excel by automating a repetitive report! Can you solve this challenge? Mon, 13 Sep 2021 15:00:00 Z 2021-09-13T15:00:00Z tag:resources@goskills.com,2021-08-04:Excel-challenge-9 https://www.goskills.com/Resources/Excel-challenge-9 Excel challenges Think sorting data in Excel is simple enough? Well, try this challenge and let's see if you still think so. Wed, 04 Aug 2021 06:33:05 Z 2021-08-04T06:33:05Z tag:resources@goskills.com,2021-06-23:Excel-challenge-8 https://www.goskills.com/Resources/Excel-challenge-8 Excel challenges Use 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. Wed, 23 Jun 2021 05:31:18 Z 2021-06-23T05:31:18Z tag:resources@goskills.com,2021-05-25:Excel-challenge-7 https://www.goskills.com/Resources/Excel-challenge-7 Excel challenges Help this book store owner solve this Excel data management challenge using the XLOOKUP function. Tue, 25 May 2021 08:30:38 Z 2021-05-25T08:30:38Z tag:resources@goskills.com,2021-04-12:Excel-challenge-6 https://www.goskills.com/Resources/Excel-challenge-6 Excel challenges It’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? Mon, 12 Apr 2021 16:56:30 Z 2021-04-12T16:56:30Z tag:resources@goskills.com,2021-01-25:Excel-challenge-5 https://www.goskills.com/Resources/Excel-challenge-5 Excel challenges It's time for some more fun with Excel! Try solving this Excel formula challenge from Excel MVP Alan Murray (aka. Computergaga). Mon, 25 Jan 2021 17:51:28 Z 2021-01-25T17:51:28Z tag:resources@goskills.com,2020-12-14:Excel-challenge-4 https://www.goskills.com/Resources/Excel-challenge-4 Excel challenges Ready for some more fun with Power Query in Excel? Try solving this Excel challenge from Excel MVP Alan Murray (aka. Computergaga). Mon, 14 Dec 2020 17:53:13 Z 2020-12-14T17:53:13Z tag:resources@goskills.com,2020-11-16:Excel-challenge-3 https://www.goskills.com/Resources/Excel-challenge-3 Excel challenges Use power query and pivot tables to solve this GoSkills Excel challenge by Alan Murray. Mon, 16 Nov 2020 17:49:05 Z 2020-11-16T17:49:05Z tag:resources@goskills.com,2020-10-19:Excel-challenge-2 https://www.goskills.com/Resources/Excel-challenge-2 Excel challenges Ready for some fun with Power Query in Excel? Try your hand at solving this Excel challenge from Excel MVP Alan Murray (aka. Computergaga) now! Mon, 19 Oct 2020 19:34:47 Z 2020-10-19T19:34:47Z tag:resources@goskills.com,2020-09-15:Excel-challenge-1 https://www.goskills.com/Resources/Excel-challenge-1 Excel challenges Think you’re pretty good at Microsoft Excel? Prove it by solving this Excel challenge from Excel MVP Alan Murray! Tue, 15 Sep 2020 18:59:09 Z 2020-09-15T18:59:09Z