https://www.goskills.com/Resources GoSkills Online Courses 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 tag:resources@goskills.com tag:resources@goskills.com,2025-11-03:excel-challenge-58 https://www.goskills.com/Excel/Resources/excel-challenge-58 Microsoft Excel 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-23:excel-lambda-function https://www.goskills.com/Excel/Resources/excel-lambda-function Microsoft Excel Learn how to use the LAMBDA function in Excel to create custom functions without VBA. See beginner-friendly examples and key differences from the LET function. Thu, 23 Oct 2025 14:59:37 Z 2025-10-23T14:59:37Z tag:resources@goskills.com,2025-10-06:excel-challenge-57 https://www.goskills.com/Excel/Resources/excel-challenge-57 Microsoft Excel 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/Excel/Resources/excel-challenge-56 Microsoft Excel 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/Excel/Resources/excel-challenge-55 Microsoft Excel 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/Excel/Resources/excel-challenge-54 Microsoft Excel 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/Excel/Resources/excel-challenge-53 Microsoft Excel 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/Excel/Resources/Excel-challenge-52 Microsoft Excel Data Analysis 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/Excel/Resources/Excel-challenge-51 Microsoft Excel 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-14:error-bars-excel https://www.goskills.com/Excel/Resources/error-bars-excel Microsoft Excel Error bars display the degree of variability associated with the data presented. Learn how to use them in Excel to make your charts clearer and more accurate. Fri, 14 Mar 2025 13:53:34 Z 2025-03-14T13:53:34Z tag:resources@goskills.com,2025-03-03:Excel-challenge-50 https://www.goskills.com/Excel/Resources/Excel-challenge-50 Microsoft Excel 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/Excel/Resources/Excel-challenge-49 Microsoft Excel 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/Excel/Resources/Excel-challenge-48 Microsoft Excel 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-12-09:Excel-challenge-47 https://www.goskills.com/Excel/Resources/Excel-challenge-47 Microsoft Excel Master Excel skills with this employee vacation tracker challenge. Practice date functions, lookups, and advanced logic for workforce management. Mon, 09 Dec 2024 15:45:31 Z 2024-12-09T15:45:31Z tag:resources@goskills.com,2024-11-25:Copilot-prompts-Excel https://www.goskills.com/Excel/Resources/Copilot-prompts-Excel Microsoft Excel Artificial Intelligence Learn how to use Copilot prompts in Excel to simplify data analysis, create visualizations, and perform predictive analytics. Mon, 25 Nov 2024 21:48:37 Z 2024-11-25T21:48:37Z tag:resources@goskills.com,2024-11-11:Copilot-in-Excel https://www.goskills.com/Excel/Resources/Copilot-in-Excel Microsoft Excel Artificial Intelligence Learn how to enable Copilot in Microsoft Excel to automate tasks, enhance data analysis, and boost productivity using AI and natural language prompts. Mon, 11 Nov 2024 16:12:53 Z 2024-11-11T16:12:53Z tag:resources@goskills.com,2024-11-04:Excel-challenge-46 https://www.goskills.com/Excel/Resources/Excel-challenge-46 Microsoft Excel 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/Excel/Resources/Excel-challenge-45 Microsoft Excel 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-19:free-excel-chart-templates-business https://www.goskills.com/Excel/Resources/free-excel-chart-templates-business Microsoft Excel Download 16 of the best chart templates for business in project planning, financial management, sales, social media analytics, and more. Thu, 19 Sep 2024 18:22:06 Z 2024-09-19T18:22:06Z tag:resources@goskills.com,2024-09-09:Excel-challenge-44 https://www.goskills.com/Excel/Resources/Excel-challenge-44 Microsoft Excel 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-21:IFS-function-Excel https://www.goskills.com/Excel/Resources/IFS-function-Excel Microsoft Excel The IFS function in Excel returns different results based on the result of progressive logical tests. It is a newer alternative to nesting multiple IF statements. Wed, 21 Aug 2024 22:19:47 Z 2024-08-21T22:19:47Z tag:resources@goskills.com,2024-08-10:Excel-skills-employers-looking-for https://www.goskills.com/Excel/Resources/Excel-skills-employers-looking-for Microsoft Excel Excel skills are required for most admin, engineering, and management jobs and can provide a pathway to high-paying jobs if you don't have a college degree. Sat, 10 Aug 2024 20:08:43 Z 2024-08-10T20:08:43Z tag:resources@goskills.com,2024-08-05:Excel-challenge-43 https://www.goskills.com/Excel/Resources/Excel-challenge-43 Microsoft Excel 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/Excel/Resources/Excel-challenge-42 Microsoft Excel 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-14:nested-formulas-Excel https://www.goskills.com/Excel/Resources/nested-formulas-Excel Microsoft Excel Nested functions allow you to combine multiple functions in Excel to perform several calculations in one go. Learn best practices and tips for formula nesting. Fri, 14 Jun 2024 00:40:28 Z 2024-06-14T00:40:28Z tag:resources@goskills.com,2024-06-03:Excel-challenge-41 https://www.goskills.com/Excel/Resources/Excel-challenge-41 Microsoft Excel 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/Excel/Resources/Excel-challenge-40 Microsoft Excel 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-22:Excel-sort-functions https://www.goskills.com/Excel/Resources/Excel-sort-functions Microsoft Excel Excel sort functions are superior to manual sorting methods because they will automatically update the sort order without user intervention. Mon, 22 Apr 2024 23:13:17 Z 2024-04-22T23:13:17Z tag:resources@goskills.com,2024-04-01:Excel-challenge-39 https://www.goskills.com/Excel/Resources/Excel-challenge-39 Microsoft Excel 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/Excel/Resources/Excel-challenge-38 Microsoft Excel 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-03-01:Excel-manage-travel-budget https://www.goskills.com/Excel/Resources/Excel-manage-travel-budget Microsoft Excel Finance You'll probably want to avoid surprises like going over budget when you travel. Take charge with these expert tips for managing your travel expenses in Excel. Fri, 01 Mar 2024 14:21:00 Z 2024-03-01T14:21:00Z tag:resources@goskills.com,2024-03-01:IF-functions-Excel https://www.goskills.com/Excel/Resources/IF-functions-Excel Microsoft Excel Master IF functions in Excel with this beginner's guide. Learn their logic and uses with real-world examples. Free cheatsheet included! Fri, 01 Mar 2024 00:00:00 Z 2024-03-01T00:00:00Z tag:resources@goskills.com,2024-02-13:Excel-vba-range-object https://www.goskills.com/Excel/Resources/Excel-vba-range-object Microsoft Excel Learn how to use Excel VBA Range object for manipulating cell ranges to streamline your spreadsheets. Tue, 13 Feb 2024 19:59:01 Z 2024-02-13T19:59:01Z tag:resources@goskills.com,2024-02-05:Excel-challenge-37 https://www.goskills.com/Excel/Resources/Excel-challenge-37 Microsoft Excel 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-29:Excel-vba-loops-guide https://www.goskills.com/Excel/Resources/Excel-vba-loops-guide Microsoft Excel Automate repetitive tasks in Excel using Loops in VBA. Learn about For Loops and Do Loops with examples and syntax. Check out GoSkills' Excel resources. Mon, 29 Jan 2024 20:41:42 Z 2024-01-29T20:41:42Z tag:resources@goskills.com,2024-01-17:Descriptive-statistics-excel https://www.goskills.com/Excel/Resources/Descriptive-statistics-excel Microsoft Excel Unlock the power of descriptive statistics in Excel with the Analysis ToolPak—easily calculate, organize, and analyze data for actionable insights. Wed, 17 Jan 2024 00:44:55 Z 2024-01-17T00:44:55Z tag:resources@goskills.com,2024-01-08:Excel-challenge-36 https://www.goskills.com/Excel/Resources/Excel-challenge-36 Microsoft Excel 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-29:Excel-FIND-function https://www.goskills.com/Excel/Resources/Excel-FIND-function Microsoft Excel The Excel FIND function helps you look for something within a specific text string. Learn how in this tutorial. Fri, 29 Dec 2023 22:18:48 Z 2023-12-29T22:18:48Z tag:resources@goskills.com,2023-12-18:excel-vba-functions https://www.goskills.com/Excel/Resources/excel-vba-functions Microsoft Excel Use this helpful guide to Excel VBA functions for a solid introduction to one of Excel's most powerful tools. Mon, 18 Dec 2023 19:52:20 Z 2023-12-18T19:52:20Z tag:resources@goskills.com,2023-12-04:Excel-challenge-35 https://www.goskills.com/Excel/Resources/Excel-challenge-35 Microsoft Excel 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-21:Excel-VBA-array https://www.goskills.com/Excel/Resources/Excel-VBA-array Microsoft Excel Understanding Excel VBA Array is crucial in mastering Microsoft Excel. Tue, 21 Nov 2023 21:17:22 Z 2023-11-21T21:17:22Z tag:resources@goskills.com,2023-11-17:Excel-lookup-functions https://www.goskills.com/Excel/Resources/Excel-lookup-functions Microsoft Excel Learn how to use the top 12 Excel lookup functions and download a free cheatsheet to keep for easy reference. Fri, 17 Nov 2023 15:23:38 Z 2023-11-17T15:23:38Z tag:resources@goskills.com,2023-11-13:Excel-vba-if-then-else https://www.goskills.com/Excel/Resources/Excel-vba-if-then-else Microsoft Excel Get a comprehensive overview of the If Then Else statement in Excel VBA and its different syntaxes. Mon, 13 Nov 2023 19:53:06 Z 2023-11-13T19:53:06Z tag:resources@goskills.com,2023-11-06:Excel-challenge-34 https://www.goskills.com/Excel/Resources/Excel-challenge-34 Microsoft Excel 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-11-03:Excel-FILTER-function https://www.goskills.com/Excel/Resources/Excel-FILTER-function Microsoft Excel Learn how to use the dynamic FILTER function in Excel from scratch. Fri, 03 Nov 2023 20:36:56 Z 2023-11-03T20:36:56Z tag:resources@goskills.com,2023-10-21:Formula-auditing-tools-Excel https://www.goskills.com/Excel/Resources/Formula-auditing-tools-Excel Microsoft Excel Learn how to use formula auditing tools in Excel, like trace precedents & trace dependents, to identify and troubleshoot any formula errors. Sat, 21 Oct 2023 20:36:37 Z 2023-10-21T20:36:37Z tag:resources@goskills.com,2023-10-02:Excel-challenge-33 https://www.goskills.com/Excel/Resources/Excel-challenge-33 Microsoft Excel 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-25:Excel-number-format https://www.goskills.com/Excel/Resources/Excel-number-format Microsoft Excel Excel has built-in number formats to control how cells with numeric data appear in Excel. Learning how they work will help you represent your data correctly. Mon, 25 Sep 2023 16:54:35 Z 2023-09-25T16:54:35Z tag:resources@goskills.com,2023-09-04:Excel-challenge-32 https://www.goskills.com/Excel/Resources/Excel-challenge-32 Microsoft Excel 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-26:Career-change-tips https://www.goskills.com/Finance/Resources/Career-change-tips Finance Microsoft Excel Considering a career change is increasingly common. But is it the right move? For those committed, here are five tips to ensure a successful transition. Sat, 26 Aug 2023 01:36:41 Z 2023-08-26T01:36:41Z tag:resources@goskills.com,2023-08-07:Excel-challenge-31 https://www.goskills.com/Excel/Resources/Excel-challenge-31 Microsoft Excel Data Analysis 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/Excel/Resources/Excel-challenge-30 Microsoft Excel 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-20:OFFSET-function-Excel https://www.goskills.com/Excel/Resources/OFFSET-function-Excel Microsoft Excel The Excel OFFSET function returns a cell or range of cells based on a reference point. It can be used to bring about dynamic behavior, even in legacy Excel. Tue, 20 Jun 2023 17:30:47 Z 2023-06-20T17:30:47Z tag:resources@goskills.com,2023-06-05:Excel-challenge-29 https://www.goskills.com/Excel/Resources/Excel-challenge-29 Microsoft Excel 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-25:online-learning-to-get-promoted https://www.goskills.com/Excel/Resources/online-learning-to-get-promoted Microsoft Excel Soft Skills Thirty minutes a day of learning new skills can have impactful outcomes, like a job promotion. This is the story of a GoSkills learner. Thu, 25 May 2023 18:30:10 Z 2023-05-25T18:30:10Z tag:resources@goskills.com,2023-05-16:Excel-errors https://www.goskills.com/Excel/Resources/Excel-errors Microsoft Excel Understand and solve common Excel errors, such as #DIV/0!, #N/A, #NAME? with this comprehensive guide and handy tips for error checking and formula auditing. Tue, 16 May 2023 12:52:19 Z 2023-05-16T12:52:19Z tag:resources@goskills.com,2023-05-01:Excel-challenge-28 https://www.goskills.com/Excel/Resources/Excel-challenge-28 Microsoft Excel 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-24:PI-function-excel https://www.goskills.com/Excel/Resources/PI-function-excel Microsoft Excel PI is one of the most popular numbers in mathematics, and it pops up quite frequently in the physical world. Unsurprisingly, Excel carries a function for PI. Mon, 24 Apr 2023 09:26:29 Z 2023-04-24T09:26:29Z tag:resources@goskills.com,2023-04-11:Excel-text-join-function https://www.goskills.com/Excel/Resources/Excel-text-join-function Microsoft Excel Discover the Excel TEXTJOIN function as a simpler way to combine text strings than CONCATENATE and &. Learn tricks like line breaks and dynamic outputs. Tue, 11 Apr 2023 04:09:52 Z 2023-04-11T04:09:52Z tag:resources@goskills.com,2023-04-05:excel-replace-function https://www.goskills.com/Excel/Resources/excel-replace-function Microsoft Excel The Excel REPLACE function can be used in a variety of unexpected ways. Wed, 05 Apr 2023 20:50:31 Z 2023-04-05T20:50:31Z tag:resources@goskills.com,2023-04-03:Excel-challenge-27 https://www.goskills.com/Excel/Resources/Excel-challenge-27 Microsoft Excel 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-29:Excel-SEQUENCE-function https://www.goskills.com/Excel/Resources/Excel-SEQUENCE-function Microsoft Excel Your simple, no-fluff guide on how to use the SEQUENCE function in Excel. Use dynamic arrays to return multiple values with a single input. Wed, 29 Mar 2023 00:55:58 Z 2023-03-29T00:55:58Z tag:resources@goskills.com,2023-03-07:best-career-resources https://www.goskills.com/Excel/Resources/best-career-resources Microsoft Excel Design Microsoft Office Office Productivity Project Management Soft Skills These GoSkills resources provide the best tips for personal and professional development. Discover even more helpful ways to boost your career and improve your skills. Tue, 07 Mar 2023 02:16:40 Z 2023-03-07T02:16:40Z tag:resources@goskills.com,2023-03-06:Excel-challenge-26 https://www.goskills.com/Excel/Resources/Excel-challenge-26 Microsoft Excel 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-20:excel-mid-function https://www.goskills.com/Excel/Resources/excel-mid-function Microsoft Excel The Excel MID function helps you extract a piece of text when there is text on either side. Mon, 20 Feb 2023 02:53:49 Z 2023-02-20T02:53:49Z tag:resources@goskills.com,2023-02-13:excel-compound-interest-formula https://www.goskills.com/Excel/Resources/excel-compound-interest-formula Microsoft Excel Discover how to easily calculate compound interest in Excel with this step-by-step guide. Use formulas and functions to accurately project growth over time. Mon, 13 Feb 2023 02:15:34 Z 2023-02-13T02:15:34Z tag:resources@goskills.com,2023-02-13:VBA-editor-Excel https://www.goskills.com/Excel/Resources/VBA-editor-Excel Microsoft Excel Open the VBA editor in Excel to add and edit VBA code. Learn the basics in this beginner-friendly, step-by-step guide. Mon, 13 Feb 2023 02:11:39 Z 2023-02-13T02:11:39Z tag:resources@goskills.com,2023-02-13:pivot-table-excel https://www.goskills.com/Excel/Resources/pivot-table-excel Microsoft Excel Master pivot tables in Excel to summarize and make sense of large data sets. Learn how to create pivot tables, create filters, slicers, and more. Mon, 13 Feb 2023 01:27:16 Z 2023-02-13T01:27:16Z tag:resources@goskills.com,2023-02-06:Excel-challenge-25 https://www.goskills.com/Excel/Resources/Excel-challenge-25 Microsoft Excel 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-11:Excel-ISERROR-function https://www.goskills.com/Excel/Resources/Excel-ISERROR-function Microsoft Excel Figure out whether an input will result in an error in advance with the Excel ISERROR Function. Wed, 11 Jan 2023 23:53:49 Z 2023-01-11T23:53:49Z tag:resources@goskills.com,2023-01-11:Vlookup-table-array https://www.goskills.com/Excel/Resources/Vlookup-table-array Microsoft Excel Learn the most useful tips and best practices for using VLOOKUP Table Array, from Microsoft Excel expert Claudia Buckley. Wed, 11 Jan 2023 23:37:20 Z 2023-01-11T23:37:20Z tag:resources@goskills.com,2023-01-09:Excel-challenge-24 https://www.goskills.com/Excel/Resources/Excel-challenge-24 Microsoft Excel 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,2023-01-08:vba-message-box https://www.goskills.com/Excel/Resources/vba-message-box Microsoft Excel Improve the interactivity of your worksheet by adding a message box to your macro's VBA code. Learn how to create a VBA message box with this easy tutorial. Sun, 08 Jan 2023 20:41:31 Z 2023-01-08T20:41:31Z tag:resources@goskills.com,2023-01-05:Divide-excel https://www.goskills.com/Excel/Resources/Divide-excel Microsoft Excel As simple as division may seem, learning how to divide in Excel is key to mastering some of the most complex functions and formulas. Thu, 05 Jan 2023 18:51:41 Z 2023-01-05T18:51:41Z tag:resources@goskills.com,2023-01-05:Freeze-panes-excel https://www.goskills.com/Excel/Resources/Freeze-panes-excel Microsoft Excel Once you learn how to freeze panes in Excel, analyzing giant spreadsheets won't seem so daunting. Thu, 05 Jan 2023 18:45:21 Z 2023-01-05T18:45:21Z tag:resources@goskills.com,2023-01-02:mail-merge-Excel https://www.goskills.com/Microsoft-Office/Resources/mail-merge-Excel Microsoft Office Microsoft Excel Looking to do mail merge in Excel? Get a step-by-step guide to mail merge in Microsoft Word using an Excel source list. See how to save time with this tool. Mon, 02 Jan 2023 11:00:00 Z 2023-01-02T11:00:00Z tag:resources@goskills.com,2022-12-05:Excel-challenge-23 https://www.goskills.com/Excel/Resources/Excel-challenge-23 Microsoft Excel 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-28:pivot-table-filter https://www.goskills.com/Excel/Resources/pivot-table-filter Microsoft Excel Excel pivot table filters help you to display select portions of data at your discretion and zero in on a special segment. Mon, 28 Nov 2022 03:31:18 Z 2022-11-28T03:31:18Z tag:resources@goskills.com,2022-11-28:Lookup-multiple-criteria https://www.goskills.com/Excel/Resources/Lookup-multiple-criteria Microsoft Excel Learn how to lookup multiple criteria in Excel. Analyze the best options from the FILTER function to XLOOKUP. Mon, 28 Nov 2022 03:22:59 Z 2022-11-28T03:22:59Z tag:resources@goskills.com,2022-11-07:Excel-challenge-22 https://www.goskills.com/Excel/Resources/Excel-challenge-22 Microsoft Excel 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-17:data-analysis-excel https://www.goskills.com/Excel/Resources/data-analysis-excel Microsoft Excel Data Analysis Excel is all about data! Learn these simple but essential data analysis tools in Excel. Mon, 17 Oct 2022 21:32:23 Z 2022-10-17T21:32:23Z tag:resources@goskills.com,2022-10-03:Excel-challenge-21 https://www.goskills.com/Excel/Resources/Excel-challenge-21 Microsoft Excel 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-30:Table-excel https://www.goskills.com/Excel/Resources/Table-excel Microsoft 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. Fri, 30 Sep 2022 02:15:57 Z 2022-09-30T02:15:57Z tag:resources@goskills.com,2022-09-22:Excel-data-analysis-toolpak https://www.goskills.com/Excel/Resources/Excel-data-analysis-toolpak Microsoft Excel Data Analysis The Excel Data Analysis Toolpak is a handy helper that analyzes complex or large data in a heartbeat. Thu, 22 Sep 2022 19:05:46 Z 2022-09-22T19:05:46Z tag:resources@goskills.com,2022-09-15:sort-pivot-table https://www.goskills.com/Excel/Resources/sort-pivot-table Microsoft Excel Wondering how to sort a pivot table? Learn how to sort in basic and custom orders in no time! Thu, 15 Sep 2022 08:21:27 Z 2022-09-15T08:21:27Z tag:resources@goskills.com,2022-09-07:how-to-subtract-in-excel https://www.goskills.com/Excel/Resources/how-to-subtract-in-excel Microsoft Excel Ever wondered how to subtract in Excel? Knowing this operation can simplify some of the most complex data from percentages to times to dates, and more. Wed, 07 Sep 2022 02:54:54 Z 2022-09-07T02:54:54Z tag:resources@goskills.com,2022-09-05:Excel-challenge-20 https://www.goskills.com/Excel/Resources/Excel-challenge-20 Microsoft Excel 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-25:excel-substitute https://www.goskills.com/Excel/Resources/excel-substitute Microsoft Excel Check out all the ways you can replace instances of text with the Excel SUBSTITUTE function. Thu, 25 Aug 2022 21:10:16 Z 2022-08-25T21:10:16Z tag:resources@goskills.com,2022-08-23:pivot-table-slicer https://www.goskills.com/Excel/Resources/pivot-table-slicer Microsoft Excel Meet pivot table slicers in Excel – the cooler, more efficient cousin to filters. Learn how to display your desired variables in an instant. Tue, 23 Aug 2022 01:43:29 Z 2022-08-23T01:43:29Z tag:resources@goskills.com,2022-08-01:Excel-challenge-19 https://www.goskills.com/Excel/Resources/Excel-challenge-19 Microsoft Excel 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-26:Excel-date-functions https://www.goskills.com/Excel/Resources/Excel-date-functions Microsoft Excel 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. Tue, 26 Jul 2022 18:56:27 Z 2022-07-26T18:56:27Z tag:resources@goskills.com,2022-07-04:Excel-challenge-18 https://www.goskills.com/Excel/Resources/Excel-challenge-18 Microsoft Excel 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-07-01:TRIM-function-Excel https://www.goskills.com/Excel/Resources/TRIM-function-Excel Microsoft Excel Learn how to clean up data easily using the TRIM function in Excel. Fri, 01 Jul 2022 13:00:00 Z 2022-07-01T13:00:00Z tag:resources@goskills.com,2022-06-06:Vstack-Hstack-Excel https://www.goskills.com/Excel/Resources/Vstack-Hstack-Excel Microsoft Excel Exciting new Excel functions are here! Learn how VSTACK and HSTACK in Excel make list combinations effortless. Mon, 06 Jun 2022 23:55:28 Z 2022-06-06T23:55:28Z tag:resources@goskills.com,2022-06-06:Excel-challenge-17 https://www.goskills.com/Excel/Resources/Excel-challenge-17 Microsoft Excel 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-27:textbefore-textafter-textsplit-excel https://www.goskills.com/Excel/Resources/textbefore-textafter-textsplit-excel Microsoft Excel Learn to use TEXTBEFORE, TEXTAFTER, and TEXTSPLIT for easier text handling in Excel. Fri, 27 May 2022 00:46:42 Z 2022-05-27T00:46:42Z tag:resources@goskills.com,2022-05-18:Excel-basics https://www.goskills.com/Excel/Resources/Excel-basics Microsoft Excel From figuring out the interface to using advanced filters, learn all there is to know when it comes to Excel basics. Wed, 18 May 2022 02:18:03 Z 2022-05-18T02:18:03Z tag:resources@goskills.com,2022-05-02:Excel-challenge-16 https://www.goskills.com/Excel/Resources/Excel-challenge-16 Microsoft Excel 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-19:Compare-two-columns-Excel https://www.goskills.com/Excel/Resources/Compare-two-columns-Excel Microsoft Excel Learn how to compare two columns in Excel in a few simple steps. Tue, 19 Apr 2022 16:55:31 Z 2022-04-19T16:55:31Z tag:resources@goskills.com,2022-04-19:Move-rows-columns-Excel https://www.goskills.com/Excel/Resources/Move-rows-columns-Excel Microsoft 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. Tue, 19 Apr 2022 15:59:39 Z 2022-04-19T15:59:39Z tag:resources@goskills.com,2022-04-04:Excel-challenge-15 https://www.goskills.com/Excel/Resources/Excel-challenge-15 Microsoft Excel 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-04-01:Cell-styles-Excel https://www.goskills.com/Excel/Resources/Cell-styles-Excel Microsoft Excel These useful hacks will make your Microsoft Excel sheet look impressive and organized. Discover how to use Cell Styles in Excel. Fri, 01 Apr 2022 17:48:54 Z 2022-04-01T17:48:54Z tag:resources@goskills.com,2022-03-22:Using-AutoFill-in-Excel https://www.goskills.com/Excel/Resources/Using-AutoFill-in-Excel Microsoft Excel The Autofill Excel function recognizes patterns and simplifies the task of data entry for large datasets. Learn more! Tue, 22 Mar 2022 21:59:45 Z 2022-03-22T21:59:45Z tag:resources@goskills.com,2022-03-07:Excel-challenge-14 https://www.goskills.com/Excel/Resources/Excel-challenge-14 Microsoft Excel 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-24:Excel-charts https://www.goskills.com/Excel/Resources/Excel-charts Microsoft Excel Learn how to create and use a variety of Excel charts. Charts help to summarize information in a way that makes numbers easier to understand and interpret. Thu, 24 Feb 2022 15:13:20 Z 2022-02-24T15:13:20Z tag:resources@goskills.com,2022-02-05:Excel-dynamic-arrays https://www.goskills.com/Excel/Resources/Excel-dynamic-arrays Microsoft Excel Excel dynamic arrays have changed the way we use all functions and formulas in Excel for the better. Learn about it in this article. Sat, 05 Feb 2022 01:45:33 Z 2022-02-05T01:45:33Z tag:resources@goskills.com,2022-02-01:Excel-challenge-13 https://www.goskills.com/Excel/Resources/Excel-challenge-13 Microsoft Excel 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-11:Waterfall-charts https://www.goskills.com/Excel/Resources/Waterfall-charts Microsoft Excel A waterfall chart is one of the most visually descriptive charts supported in Excel. Learn how to create your own. Tue, 11 Jan 2022 14:55:30 Z 2022-01-11T14:55:30Z tag:resources@goskills.com,2022-01-04:Excel-challenge-12 https://www.goskills.com/Excel/Resources/Excel-challenge-12 Microsoft Excel 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/Excel/Resources/Excel-challenge-11 Microsoft Excel 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-10-25:Excel-SEARCH-function https://www.goskills.com/Excel/Resources/Excel-SEARCH-function Microsoft Excel The Excel SEARCH function is meant to help you look for something within a specific text string. Learn about it here. Mon, 25 Oct 2021 12:45:06 Z 2021-10-25T12:45:06Z tag:resources@goskills.com,2021-10-22:COUNTIFS https://www.goskills.com/Excel/Resources/COUNTIFS Microsoft Excel COUNTIFS determines the number of occurrences by comparing each range with its respective criterion. It then counts how many rows match all the stated criteria. Fri, 22 Oct 2021 08:43:54 Z 2021-10-22T08:43:54Z tag:resources@goskills.com,2021-09-27:Excel-RIGHT-function https://www.goskills.com/Excel/Resources/Excel-RIGHT-function Microsoft Excel The Excel RIGHT function might be just the thing you need, when you want to extract data from the end of a string. A video and free exercise file are included. Mon, 27 Sep 2021 07:28:28 Z 2021-09-27T07:28:28Z tag:resources@goskills.com,2021-09-27:Excel-left-function https://www.goskills.com/Excel/Resources/Excel-left-function Microsoft Excel When you want to extract some values from one location in Excel without copying all the cell’s contents, the Excel LEFT function might be the thing you need. Mon, 27 Sep 2021 07:27:42 Z 2021-09-27T07:27:42Z tag:resources@goskills.com,2021-09-27:Lock-cells-Excel https://www.goskills.com/Excel/Resources/Lock-cells-Excel Microsoft Excel You can protect data in Excel at different levels. Learn how to lock cells in Excel. Mon, 27 Sep 2021 07:27:00 Z 2021-09-27T07:27:00Z tag:resources@goskills.com,2021-09-13:Excel-challenge-10 https://www.goskills.com/Excel/Resources/Excel-challenge-10 Microsoft Excel 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-16:Alphabetize-Excel https://www.goskills.com/Excel/Resources/Alphabetize-Excel Microsoft Excel Learn how to alphabetize in Excel to sharpen your sorting skills and keep your data organized. Master alphabetizing in Excel, simple to advanced methods. Mon, 16 Aug 2021 07:00:00 Z 2021-08-16T07:00:00Z tag:resources@goskills.com,2021-08-16:Excel-custom-number-format https://www.goskills.com/Excel/Resources/Excel-custom-number-format Microsoft Excel A number format controls how cells with numeric data appear in Excel. Learn about how Excel custom number formats work in this beginner's guide. Mon, 16 Aug 2021 06:57:58 Z 2021-08-16T06:57:58Z tag:resources@goskills.com,2021-08-04:Excel-challenge-9 https://www.goskills.com/Excel/Resources/Excel-challenge-9 Microsoft Excel 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-07-16:FREQUENCY-Excel https://www.goskills.com/Excel/Resources/FREQUENCY-Excel Microsoft Excel The FREQUENCY Excel function simplifies the task of grouping values, especially in large datasets. Learn more! Fri, 16 Jul 2021 12:10:34 Z 2021-07-16T12:10:34Z tag:resources@goskills.com,2021-07-15:Excel-Solver https://www.goskills.com/Excel/Resources/Excel-Solver Microsoft Excel Excel solver can be applied to workforce management, maximizing profitability, and financial planning. Learn how to use the tool! Thu, 15 Jul 2021 10:15:49 Z 2021-07-15T10:15:49Z tag:resources@goskills.com,2021-07-06:How-to-make-a-graph-in-Excel https://www.goskills.com/Excel/Resources/How-to-make-a-graph-in-Excel Microsoft Excel You can make a graph in Excel for simple, advanced, and complex data. Here's how to make a graph in Excel. Tue, 06 Jul 2021 12:09:23 Z 2021-07-06T12:09:23Z tag:resources@goskills.com,2021-06-25:Excel-TEXT-function https://www.goskills.com/Excel/Resources/Excel-TEXT-function Microsoft Excel The Excel TEXT function allows you to convert numbers to Excel text format using Excel’s format codes. Learn all about it. Fri, 25 Jun 2021 07:19:28 Z 2021-06-25T07:19:28Z tag:resources@goskills.com,2021-06-23:Excel-challenge-8 https://www.goskills.com/Excel/Resources/Excel-challenge-8 Microsoft Excel 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-06-22:Basic-Excel-formulas https://www.goskills.com/Excel/Resources/Basic-Excel-formulas Microsoft Excel Learn the basics of Excel with these 12 basic Excel formulas and get tips for beginners. Find frequently used formulas that can help you execute complex tasks. Tue, 22 Jun 2021 05:38:42 Z 2021-06-22T05:38:42Z tag:resources@goskills.com,2021-06-21:Remove-duplicates-Excel https://www.goskills.com/Excel/Resources/Remove-duplicates-Excel Microsoft Excel Let’s clean up your worksheet by learning how to find, and then, how to remove duplicates in Excel. Mon, 21 Jun 2021 08:03:59 Z 2021-06-21T08:03:59Z tag:resources@goskills.com,2021-06-14:Excel-INDIRECT-function https://www.goskills.com/Excel/Resources/Excel-INDIRECT-function Microsoft Excel With a single argument, you can add sophistication to your worksheet by allowing it to behave dynamically. That’s the Excel INDIRECT function. Mon, 14 Jun 2021 04:58:41 Z 2021-06-14T04:58:41Z tag:resources@goskills.com,2021-06-14:Excel-histogram https://www.goskills.com/Excel/Resources/Excel-histogram Microsoft Excel Histograms are useful for reporting on statistical data, especially when large datasets are involved. Here’s how to create a histogram in Excel. Mon, 14 Jun 2021 04:57:21 Z 2021-06-14T04:57:21Z tag:resources@goskills.com,2021-06-03:Strikethrough-Excel https://www.goskills.com/Excel/Resources/Strikethrough-Excel Microsoft Excel The strikethrough effect is an effective way to visually highlight that a task has been completed. Learn how to strikethrough in Excel. Thu, 03 Jun 2021 09:14:12 Z 2021-06-03T09:14:12Z tag:resources@goskills.com,2021-06-02:Standard-deviation-formula-Excel https://www.goskills.com/Excel/Resources/Standard-deviation-formula-Excel Microsoft Excel Excel eliminates the manual work by offering not one, but six functions to calculate standard deviation. Learn about the standard deviation formula in Excel. Wed, 02 Jun 2021 08:37:50 Z 2021-06-02T08:37:50Z tag:resources@goskills.com,2021-06-02:Excel-SUMPRODUCT https://www.goskills.com/Excel/Resources/Excel-SUMPRODUCT Microsoft Excel The Excel SUMPRODUCT function is your secret weapon for functions you may not have access to if you're using an older Excel version. Learn more in this guide. Wed, 02 Jun 2021 08:36:44 Z 2021-06-02T08:36:44Z tag:resources@goskills.com,2021-05-25:Excel-challenge-7 https://www.goskills.com/Excel/Resources/Excel-challenge-7 Microsoft Excel 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-05-18:How-to-make-pie-chart-Excel https://www.goskills.com/Excel/Resources/How-to-make-pie-chart-Excel Microsoft Excel Pie charts are a popular way to show how much individual amounts contribute to a total amount. Learn how to make a pie chart in Excel. Tue, 18 May 2021 14:35:26 Z 2021-05-18T14:35:26Z tag:resources@goskills.com,2021-05-15:How-to-make-a-scatter-plot-in-Excel https://www.goskills.com/Excel/Resources/How-to-make-a-scatter-plot-in-Excel Microsoft Excel A scatter plot is a type of chart that shows whether there is a relationship between two variables. Let’s explore how to make a scatter plot in Excel! Sat, 15 May 2021 05:55:00 Z 2021-05-15T05:55:00Z tag:resources@goskills.com,2021-05-15:Variance-formula-Excel https://www.goskills.com/Excel/Resources/Variance-formula-Excel Microsoft Excel Variance is a number that gives a general idea of the dispersion of a dataset. Learn about the variance formula in Excel. Sat, 15 May 2021 05:51:43 Z 2021-05-15T05:51:43Z tag:resources@goskills.com,2021-05-10:How-to-merge-split-cells-in-Excel https://www.goskills.com/Excel/Resources/How-to-merge-split-cells-in-Excel Microsoft Excel Excel has several features which give us the ability to merge and split cells in multiple ways. Here’s how to merge cells in Excel and split cells in Excel. Mon, 10 May 2021 12:40:22 Z 2021-05-10T12:40:22Z tag:resources@goskills.com,2021-05-02:How-to-make-a-line-graph-in-Excel https://www.goskills.com/Excel/Resources/How-to-make-a-line-graph-in-Excel Microsoft Excel Line graphs are some of the most common types of charts used to display continuous data. Here’s how to make a line graph in Excel. Sun, 02 May 2021 05:36:07 Z 2021-05-02T05:36:07Z tag:resources@goskills.com,2021-04-26:SUM-function-in-Excel https://www.goskills.com/Excel/Resources/SUM-function-in-Excel Microsoft Excel One of the best functions for beginners to learn is the SUM function in Excel. Start learning with this comprehensive tutorial. Mon, 26 Apr 2021 05:32:22 Z 2021-04-26T05:32:22Z tag:resources@goskills.com,2021-04-22:How-to-filter-in-Excel https://www.goskills.com/Excel/Resources/How-to-filter-in-Excel Microsoft Excel Have you ever wanted to temporarily display only certain data from a larger dataset without deleting the rest? Learn how to filter in Excel. Thu, 22 Apr 2021 11:37:15 Z 2021-04-22T11:37:15Z tag:resources@goskills.com,2021-04-14:LEN-function-Excel https://www.goskills.com/Excel/Resources/LEN-function-Excel Microsoft Excel The LEN Excel function returns the number of characters in a text string. Learn all about it in this beginner's guide. Wed, 14 Apr 2021 12:32:28 Z 2021-04-14T12:32:28Z tag:resources@goskills.com,2021-04-12:Excel-challenge-6 https://www.goskills.com/Excel/Resources/Excel-challenge-6 Microsoft Excel 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-04-12:How-to-calculate-percentage-in-Excel https://www.goskills.com/Excel/Resources/How-to-calculate-percentage-in-Excel Microsoft Excel If you do lots of work with numbers in Excel, then you’ll be working with percentages fairly often. Learn how to calculate percentages in Excel. Mon, 12 Apr 2021 14:46:29 Z 2021-04-12T14:46:29Z tag:resources@goskills.com,2021-04-02:Excel-dropdown-list https://www.goskills.com/Excel/Resources/Excel-dropdown-list Microsoft Excel Excel drop down lists are an easy way to control the values entered in a cell. We’ll explore how to create a drop down list in Excel using three methods. Fri, 02 Apr 2021 08:50:36 Z 2021-04-02T08:50:36Z tag:resources@goskills.com,2021-04-01:IFERROR-Excel https://www.goskills.com/Excel/Resources/IFERROR-Excel Microsoft Excel The IFERROR Excel function is a logical function that tells Excel what to do if the formula that was entered returns an error response. Learn how to use it. Thu, 01 Apr 2021 11:16:45 Z 2021-04-01T11:16:45Z tag:resources@goskills.com,2021-03-31:How-to-multiply-in-Excel https://www.goskills.com/Excel/Resources/How-to-multiply-in-Excel Microsoft Excel There are two main ways to do multiplication in Excel. Learn how to multiply in Excel here. Wed, 31 Mar 2021 11:32:25 Z 2021-03-31T11:32:25Z tag:resources@goskills.com,2021-03-29:Excel-checkbox https://www.goskills.com/Excel/Resources/Excel-checkbox Microsoft Excel Learn about Excel checkboxes in this beginner's guide. Did you know you can use Excel to insert checkboxes for to-do lists, dynamic charts, and dashboards? Mon, 29 Mar 2021 17:30:35 Z 2021-03-29T17:30:35Z tag:resources@goskills.com,2021-03-27:How-to-make-a-bar-graph-in-Excel https://www.goskills.com/Excel/Resources/How-to-make-a-bar-graph-in-Excel Microsoft Excel Bar graphs are an effective way to visually compare frequency, amounts, or units. Learn how to make a bar graph in Excel. Sat, 27 Mar 2021 17:28:22 Z 2021-03-27T17:28:22Z tag:resources@goskills.com,2021-03-10:PMT-function-Excel https://www.goskills.com/Excel/Resources/PMT-function-Excel Microsoft Excel Learn how to use the Excel PMT function in this comprehensive beginner's guide. Wed, 10 Mar 2021 08:27:27 Z 2021-03-10T08:27:27Z tag:resources@goskills.com,2021-03-02:Concatenate-Excel https://www.goskills.com/Excel/Resources/Concatenate-Excel Microsoft Excel There are four ways to concatenate in Excel (the CONCATENATE Excel function, CONCAT, TEXTJOIN, and the & operator). Learn about them in this beginner's guide. Tue, 02 Mar 2021 14:28:48 Z 2021-03-02T14:28:48Z tag:resources@goskills.com,2021-02-28:Checkmark-in-Excel https://www.goskills.com/Excel/Resources/Checkmark-in-Excel Microsoft Excel If you're trying to figure out how to insert a check mark in Excel, here are 5 easy ways with examples. Choose a favorite for your next task-oriented project. Sun, 28 Feb 2021 10:05:00 Z 2021-02-28T10:05:00Z tag:resources@goskills.com,2021-02-24:Excel-COUNTA https://www.goskills.com/Excel/Resources/Excel-COUNTA Microsoft Excel The Excel COUNTA function counts all cells with data. Learn all about it in this beginner's guide. Wed, 24 Feb 2021 07:28:30 Z 2021-02-24T07:28:30Z tag:resources@goskills.com,2021-02-24:COUNT-function-Excel https://www.goskills.com/Excel/Resources/COUNT-function-Excel Microsoft Excel Excel is all about large quantities of data. Learn how to use the COUNT function in Excel to count your data in various ways. Wed, 24 Feb 2021 07:16:42 Z 2021-02-24T07:16:42Z tag:resources@goskills.com,2021-02-24:INDEX-MATCH https://www.goskills.com/Excel/Resources/INDEX-MATCH Microsoft Excel Learn about INDEX MATCH in Excel. Combining INDEX and MATCH is a great way to overcome the limitations of VLOOKUP and a clever way to perform a two-way lookup. Wed, 24 Feb 2021 06:53:53 Z 2021-02-24T06:53:53Z tag:resources@goskills.com,2021-02-21:Count-unique-values-Excel https://www.goskills.com/Excel/Resources/Count-unique-values-Excel Microsoft Excel To help you count unique values in Excel, try the UNIQUE function. Learn all about it in this beginner's guide. Sun, 21 Feb 2021 22:37:25 Z 2021-02-21T22:37:25Z tag:resources@goskills.com,2021-02-15:Excel-goal-seek https://www.goskills.com/Excel/Resources/Excel-goal-seek Microsoft Excel The Excel Goal Seek feature is a useful what if analysis tool. Learn all about it in this beginner's guide! Mon, 15 Feb 2021 21:47:00 Z 2021-02-15T21:47:00Z tag:resources@goskills.com,2021-02-13:AVERAGEIF-function https://www.goskills.com/Excel/Resources/AVERAGEIF-function Microsoft Excel Learn all about the Excel AVERAGEIF function in this comprehensive beginner's guide. Sat, 13 Feb 2021 22:30:03 Z 2021-02-13T22:30:03Z tag:resources@goskills.com,2021-02-11:Conditional-formatting-Excel https://www.goskills.com/Excel/Resources/Conditional-formatting-Excel Microsoft Excel Learn how to use conditional formatting in Excel to easily visualize your data. Thu, 11 Feb 2021 07:23:12 Z 2021-02-11T07:23:12Z tag:resources@goskills.com,2021-02-05:What-if-analysis-Excel https://www.goskills.com/Excel/Resources/What-if-analysis-Excel Microsoft Excel To help you do a what if analysis in Excel, there are three tools. Learn how to use them all in this guide - Goal Seek, Scenario Manager, and data tables. Fri, 05 Feb 2021 23:14:42 Z 2021-02-05T23:14:42Z tag:resources@goskills.com,2021-01-29:Weighted-average-Excel https://www.goskills.com/Excel/Resources/Weighted-average-Excel Microsoft Excel Explore this guide on how to calculate a weighted average in Excel using the SUMPRODUCT function. Fri, 29 Jan 2021 00:42:57 Z 2021-01-29T00:42:57Z tag:resources@goskills.com,2021-01-25:Excel-challenge-5 https://www.goskills.com/Excel/Resources/Excel-challenge-5 Microsoft Excel 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,2021-01-24:How-to-calculate-average-in-Excel https://www.goskills.com/Excel/Resources/How-to-calculate-average-in-Excel Microsoft Excel Learn how to calculate averages in Excel using the AVERAGE, MEDIAN, and MODE functions. Includes a video walkthrough and exercise file. Sun, 24 Jan 2021 22:00:10 Z 2021-01-24T22:00:10Z tag:resources@goskills.com,2021-01-19:Pivot-table-calculated-field https://www.goskills.com/Excel/Resources/Pivot-table-calculated-field Microsoft Excel Want to level up your pivot table skills? Learn how to add and modify a pivot table calculated field with this how-to guide. Tue, 19 Jan 2021 05:50:22 Z 2021-01-19T05:50:22Z tag:resources@goskills.com,2021-01-17:SUMIFS-Excel-function https://www.goskills.com/Excel/Resources/SUMIFS-Excel-function Microsoft Excel Learn how to use the SUMIFS Excel function to add values that meet multiple specific criteria with this step-by-step tutorial. Sun, 17 Jan 2021 21:14:39 Z 2021-01-17T21:14:39Z tag:resources@goskills.com,2021-01-11:IF-function-Excel https://www.goskills.com/Excel/Resources/IF-function-Excel Microsoft Excel Learn how to use the IF function in Excel and see how it can be combined with the OR and AND functions. Mon, 11 Jan 2021 00:46:56 Z 2021-01-11T00:46:56Z tag:resources@goskills.com,2021-01-03:SUMIF-Excel https://www.goskills.com/Excel/Resources/SUMIF-Excel Microsoft Excel Discover what the SUMIF Excel function is and how to use it. Sun, 03 Jan 2021 00:23:53 Z 2021-01-03T00:23:53Z tag:resources@goskills.com,2020-12-22:COUNTIF-Excel-function https://www.goskills.com/Excel/Resources/COUNTIF-Excel-function Microsoft Excel Improve your data management skills by learning how to use the COUNTIF function in Excel. Tue, 22 Dec 2020 10:27:35 Z 2020-12-22T10:27:35Z tag:resources@goskills.com,2020-12-22:Excel-AND-function https://www.goskills.com/Excel/Resources/Excel-AND-function Microsoft Excel Learn how to use the Excel AND function and combine it with other functions for more flexibility. Tue, 22 Dec 2020 10:27:33 Z 2020-12-22T10:27:33Z tag:resources@goskills.com,2020-12-22:Running-total-Excel-cumulative-sum https://www.goskills.com/Excel/Resources/Running-total-Excel-cumulative-sum Microsoft Excel Learn how to create a running total in Excel with this step-by-step tutorial. Tue, 22 Dec 2020 10:20:26 Z 2020-12-22T10:20:26Z tag:resources@goskills.com,2020-12-15:Excel-OR-function https://www.goskills.com/Excel/Resources/Excel-OR-function Microsoft Excel What is the Excel OR function? How do you use it? Find out in this tutorial. Tue, 15 Dec 2020 13:24:33 Z 2020-12-15T13:24:33Z tag:resources@goskills.com,2020-12-14:Excel-challenge-4 https://www.goskills.com/Excel/Resources/Excel-challenge-4 Microsoft Excel Data Analysis 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-12-09:Excel-LET-function https://www.goskills.com/Excel/Resources/Excel-LET-function Microsoft Excel Learn about the new Excel LET function. This new function can help make complex formulas easier to read and use. Wed, 09 Dec 2020 19:32:36 Z 2020-12-09T19:32:36Z tag:resources@goskills.com,2020-12-06:Excel-ribbon https://www.goskills.com/Excel/Resources/Excel-ribbon Microsoft Excel Improve your Excel navigational skills with these tips on how to use and customize the Excel ribbon. Sun, 06 Dec 2020 04:08:05 Z 2020-12-06T04:08:05Z tag:resources@goskills.com,2020-12-04:How-to-sort-in-Excel https://www.goskills.com/Excel/Resources/How-to-sort-in-Excel Microsoft Excel Learn how to sort in Excel including multi level sorting, alphabetical sorting, numeric sorting, and custom sorting. Fri, 04 Dec 2020 01:53:08 Z 2020-12-04T01:53:08Z tag:resources@goskills.com,2020-11-16:Excel-challenge-3 https://www.goskills.com/Excel/Resources/Excel-challenge-3 Microsoft Excel 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-11-13:VLOOKUP-exact-match-approximate-match https://www.goskills.com/Excel/Resources/VLOOKUP-exact-match-approximate-match Microsoft Excel Learn one of Excel's most useful functions: VLOOKUP exact match and approximate match. Fri, 13 Nov 2020 02:26:57 Z 2020-11-13T02:26:57Z tag:resources@goskills.com,2020-11-13:VBA-variable-types https://www.goskills.com/Excel/Resources/VBA-variable-types Microsoft Excel Learn what a variable is, why they are important, and understand how to use the different VBA variable types in Excel. Fri, 13 Nov 2020 02:02:51 Z 2020-11-13T02:02:51Z tag:resources@goskills.com,2020-10-29:Remove-blank-rows-in-Excel https://www.goskills.com/Excel/Resources/Remove-blank-rows-in-Excel Microsoft Excel Microsoft Office Avoid data errors by learning how to remove blank rows in Excel the right way. Thu, 29 Oct 2020 23:24:38 Z 2020-10-29T23:24:38Z tag:resources@goskills.com,2020-10-29:Mixed-reference-Excel https://www.goskills.com/Excel/Resources/Mixed-reference-Excel Microsoft Excel Microsoft Office Learn all about the mixed reference Excel feature in this beginner's guide. Thu, 29 Oct 2020 22:54:19 Z 2020-10-29T22:54:19Z tag:resources@goskills.com,2020-10-21:Relative-reference-Excel https://www.goskills.com/Excel/Resources/Relative-reference-Excel Microsoft Excel Learn all about the relative reference Excel feature in this beginner's guide. Wed, 21 Oct 2020 02:19:23 Z 2020-10-21T02:19:23Z tag:resources@goskills.com,2020-10-19:Excel-challenge-2 https://www.goskills.com/Excel/Resources/Excel-challenge-2 Microsoft Excel 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-10-18:VBA-code-library https://www.goskills.com/Excel/Resources/VBA-code-library Microsoft Excel Automate your Excel tasks with ready-made code from our VBA code library. Sun, 18 Oct 2020 21:45:01 Z 2020-10-18T21:45:01Z tag:resources@goskills.com,2020-10-12:Absolute-reference-Excel https://www.goskills.com/Excel/Resources/Absolute-reference-Excel Microsoft Excel Learn all about the absolute reference Excel feature in this beginner's guide. Mon, 12 Oct 2020 00:17:45 Z 2020-10-12T00:17:45Z tag:resources@goskills.com,2020-10-07:Best-practices-in-dashboard-design https://www.goskills.com/Excel/Resources/Best-practices-in-dashboard-design Microsoft Excel Learn what a dashboard is, the different types, and the best practices in dashboard design. Wed, 07 Oct 2020 21:33:48 Z 2020-10-07T21:33:48Z tag:resources@goskills.com,2020-10-01:Wildcard-characters-in-Excel https://www.goskills.com/Excel/Resources/Wildcard-characters-in-Excel Microsoft Excel Learn how to use wildcard characters in Excel to save time when working with formulas. Thu, 01 Oct 2020 05:00:16 Z 2020-10-01T05:00:16Z tag:resources@goskills.com,2020-09-20:Xlookup-vs-vlookup https://www.goskills.com/Excel/Resources/Xlookup-vs-vlookup Microsoft Excel XLOOKUP vs VLOOKUP! What is the difference between VLOOKUP and XLOOKUP? And which one is better? You be the judge. Includes a video and practice file. Sun, 20 Sep 2020 22:07:54 Z 2020-09-20T22:07:54Z tag:resources@goskills.com,2020-09-15:Excel-challenge-1 https://www.goskills.com/Excel/Resources/Excel-challenge-1 Microsoft Excel 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 tag:resources@goskills.com,2020-09-10:Hlookup-vs-vlookup https://www.goskills.com/Excel/Resources/Hlookup-vs-vlookup Microsoft Excel It's the battle of the lookups - this time it's HLOOKUP vs VLOOKUP. Which will win? Thu, 10 Sep 2020 01:42:15 Z 2020-09-10T01:42:15Z tag:resources@goskills.com,2020-08-26:Xlookup-in-Excel https://www.goskills.com/Excel/Resources/Xlookup-in-Excel Microsoft Excel XLOOKUP in Excel is a powerful function that will help you save time and effort. Learn about it here. Wed, 26 Aug 2020 19:39:29 Z 2020-08-26T19:39:29Z tag:resources@goskills.com,2020-07-27:Most-useful-Excel-functions-for-data-analysis https://www.goskills.com/Excel/Resources/Most-useful-Excel-functions-for-data-analysis Microsoft Excel Data Analysis Learn 12 of the most useful Excel functions for data analysis, with free practice worksheet included! Mon, 27 Jul 2020 18:39:21 Z 2020-07-27T18:39:21Z tag:resources@goskills.com,2020-06-23:Google-Sheets-vs-Excel https://www.goskills.com/Excel/Resources/Google-Sheets-vs-Excel Microsoft Excel Office Productivity In the battle of best spreadsheet software, who will win? Let's dig into Google Sheets vs. Excel. Tue, 23 Jun 2020 00:50:20 Z 2020-06-23T00:50:20Z tag:resources@goskills.com,2020-05-11:Vlookup-vs-Pivot-Table https://www.goskills.com/Excel/Resources/Vlookup-vs-Pivot-Table Microsoft Excel In this article we will examine VLOOKUP, Pivot Tables and Power Pivot, and when you should use each of them for best results. Mon, 11 May 2020 10:34:39 Z 2020-05-11T10:34:39Z tag:resources@goskills.com,2020-02-17:Power-query-vs-power-pivot-power-bi https://www.goskills.com/Excel/Resources/Power-query-vs-power-pivot-power-bi Microsoft Excel Data Analysis We demystify the differences between Power Query, Power Pivot, and Power BI and show you how they all work together. Mon, 17 Feb 2020 09:21:24 Z 2020-02-17T09:21:24Z tag:resources@goskills.com,2020-01-08:How-to-master-Excel https://www.goskills.com/Excel/Resources/How-to-master-Excel Microsoft Excel It's no secret that Excel is an essential skill. If you are ready to level up your skills, check out our guide on the steps needed to become a pro! Wed, 08 Jan 2020 23:43:21 Z 2020-01-08T23:43:21Z tag:resources@goskills.com,2019-11-21:How-to-make-column-chart-Excel https://www.goskills.com/Excel/Resources/How-to-make-column-chart-Excel Microsoft Excel Ready to wow your colleagues with some impressive graphs and charts? Then learn the in's and out's of Excel column charts with this handy guide! Thu, 21 Nov 2019 21:30:20 Z 2019-11-21T21:30:20Z tag:resources@goskills.com,2019-10-17:Use-anova-in-Excel https://www.goskills.com/Lean-Six-Sigma/Resources/Use-anova-in-Excel Lean Six Sigma Data Analysis Microsoft Excel Looking to improve your processes by running an analysis of variance? Learn how to run one and two-way ANOVA in Excel with this step-by-step guide! Thu, 17 Oct 2019 20:33:50 Z 2019-10-17T20:33:50Z tag:resources@goskills.com,2019-09-05:Excel-skills-for-accountants https://www.goskills.com/Excel/Resources/Excel-skills-for-accountants Microsoft Excel Like most people, you're probably using Excel for accounting. If you want to maximize your efficiency then check out these top Excel skills for accountants. Thu, 05 Sep 2019 18:08:50 Z 2019-09-05T18:08:50Z tag:resources@goskills.com,2019-08-06:Excel-presentation-tips https://www.goskills.com/Excel/Resources/Excel-presentation-tips Microsoft Excel Make not just professional but stunning spreadsheets with these 11 Excel presentation tips! Tue, 06 Aug 2019 00:21:58 Z 2019-08-06T00:21:58Z tag:resources@goskills.com,2019-07-07:Excel-gantt-chart-template https://www.goskills.com/Project-Management/Resources/Excel-gantt-chart-template Project Management Microsoft Excel Make your life a lot easier with this free Excel Gantt chart template! Download it now! Sun, 07 Jul 2019 19:22:55 Z 2019-07-07T19:22:55Z tag:resources@goskills.com,2019-06-06:Power-BI-pie-chart https://www.goskills.com/Microsoft-Office/Resources/Power-BI-pie-chart Microsoft Office Data Analysis Microsoft Excel Want to make a Power BI Pie chart? Follow along with our step-by-step guide! Thu, 06 Jun 2019 23:04:15 Z 2019-06-06T23:04:15Z tag:resources@goskills.com,2019-05-23:How-to-use-PowerPivot https://www.goskills.com/Excel/Resources/How-to-use-PowerPivot Microsoft Excel Data Analysis Learn how to use PowerPivot and take your data processing skills to the next level! We cover why and how to use PowerPivot with real business use cases. Thu, 23 May 2019 04:15:03 Z 2019-05-23T04:15:03Z tag:resources@goskills.com,2019-04-08:Power-Query-tips https://www.goskills.com/Excel/Resources/Power-Query-tips Microsoft Excel Data Analysis Check out these Power Query tips that will help you transform your data like a pro! Mon, 08 Apr 2019 23:50:13 Z 2019-04-08T23:50:13Z tag:resources@goskills.com,2019-03-14:Excel-tips-for-beginners https://www.goskills.com/Excel/Resources/Excel-tips-for-beginners Microsoft Excel Getting started in the world of spreadsheets? Check out these essential Excel tips for beginners to level up your skills. Thu, 14 Mar 2019 22:53:08 Z 2019-03-14T22:53:08Z tag:resources@goskills.com,2019-02-12:Advanced-pivot-table-techniques https://www.goskills.com/Excel/Resources/Advanced-pivot-table-techniques Microsoft Excel Up your Excel game with these advanced pivot table techniques. Tue, 12 Feb 2019 00:41:10 Z 2019-02-12T00:41:10Z tag:resources@goskills.com,2018-12-27:Vlookup-index-match https://www.goskills.com/Excel/Resources/Vlookup-index-match Microsoft Excel Where the VLOOKUP is lacking, INDEX MATCH picks up the slack. Learn how INDEX MATCH can make your life that much easier. Thu, 27 Dec 2018 15:49:34 Z 2018-12-27T15:49:34Z tag:resources@goskills.com,2018-11-06:Excel-user-defined-function-examples https://www.goskills.com/Excel/Resources/Excel-user-defined-function-examples Microsoft Excel Excel UDF give you more control of your spreadsheets. Check out our guide to create your own, including some handy Excel user defined function examples. Tue, 06 Nov 2018 18:33:10 Z 2018-11-06T18:33:10Z tag:resources@goskills.com,2018-10-08:Advanced-Excel-charts https://www.goskills.com/Excel/Resources/Advanced-Excel-charts Microsoft Excel Interested in taking your spreadsheet skills to the next level? Check out our advanced Excel chart tutorial to find out how. Mon, 08 Oct 2018 00:00:00 Z 2018-10-08T00:00:00Z tag:resources@goskills.com,2018-09-10:Excel-chart-tutorial https://www.goskills.com/Excel/Resources/Excel-chart-tutorial Microsoft Excel Follow our pain-free Excel chart tutorial to easily shape your data into a beautiful graph. Mon, 10 Sep 2018 21:31:10 Z 2018-09-10T21:31:10Z tag:resources@goskills.com,2018-08-01:Pivot-table-tutorial https://www.goskills.com/Excel/Resources/Pivot-table-tutorial Microsoft Excel Need to sift through a lot of data fast? Our Excel Pivot Table tutorial shows you how to do it quickly and painlessly in 5 easy steps! Wed, 01 Aug 2018 00:59:13 Z 2018-08-01T00:59:13Z tag:resources@goskills.com,2018-07-02:How-to-create-excel-dashboard https://www.goskills.com/Excel/Resources/How-to-create-excel-dashboard Microsoft Excel In this step by step tutorial, we’re breaking down exactly how to create an Excel dashboard (with no stress or headaches required). Mon, 02 Jul 2018 14:00:00 Z 2018-07-02T14:00:00Z tag:resources@goskills.com,2018-06-11:Excel-templates-for-business https://www.goskills.com/Excel/Resources/Excel-templates-for-business Microsoft Excel To make your life easier, here are some of our favorite Excel templates for business to help boost productivity in the workplace. See all you can do with Excel. Mon, 11 Jun 2018 14:00:00 Z 2018-06-11T14:00:00Z tag:resources@goskills.com,2018-05-14:Excel-macro-tutorial-for-beginners https://www.goskills.com/Excel/Resources/Excel-macro-tutorial-for-beginners Microsoft Excel Excel Macros might seem complicated. But learning to use them to your advantage is actually surprisingly simple. Learn how to use macros from scratch. Mon, 14 May 2018 00:00:00 Z 2018-05-14T00:00:00Z tag:resources@goskills.com,2018-04-23:Excel-hacks https://www.goskills.com/Excel/Resources/Excel-hacks Microsoft Excel We’ve rounded up 11 different Excel hacks you’re sure to use and love. Mon, 23 Apr 2018 06:14:17 Z 2018-04-23T06:14:17Z tag:resources@goskills.com,2018-04-03:Excel-VBA-advanced-filter https://www.goskills.com/Excel/Resources/Excel-VBA-advanced-filter Microsoft Excel If you find yourself performing repetitive tasks in Excel that don't have a single formula fix, VBA may just be your solution. Tue, 03 Apr 2018 08:37:25 Z 2018-04-03T08:37:25Z tag:resources@goskills.com,2018-03-06:How-to-do-taxes-in-Excel https://www.goskills.com/Excel/Resources/How-to-do-taxes-in-Excel Microsoft Excel Finance How to do your taxes in Excel, without the headaches. Tue, 06 Mar 2018 09:49:17 Z 2018-03-06T09:49:17Z tag:resources@goskills.com,2018-02-11:Uses-of-Excel-in-business https://www.goskills.com/Excel/Resources/Uses-of-Excel-in-business Microsoft Excel From lists to charts to design mock-ups, here are some of the coolest ways you can use Excel. Sun, 11 Feb 2018 23:00:34 Z 2018-02-11T23:00:34Z tag:resources@goskills.com,2018-01-02:Best-Excel-add-ins https://www.goskills.com/Excel/Resources/Best-Excel-add-ins Microsoft Excel Microsoft Office With a few of these Excel add-ins, your spreadsheets will reach pro-level in no time. Tue, 02 Jan 2018 08:24:42 Z 2018-01-02T08:24:42Z tag:resources@goskills.com,2017-12-04:Jobs-require-Excel https://www.goskills.com/Excel/Resources/Jobs-require-Excel Microsoft Excel Microsoft Office Honing your Excel skills may be the key to landing your dream job. Data skills are important, and Excel is showing up in some previously unheard-of spaces. Mon, 04 Dec 2017 06:23:05 Z 2017-12-04T06:23:05Z tag:resources@goskills.com,2017-11-15:Free-Excel-templates https://www.goskills.com/Excel/Resources/Free-Excel-templates Microsoft Excel Microsoft Office Manage your business and organize your life with the 52 best free Excel templates. The list covers template spanning 7 categories, from personal to business. Wed, 15 Nov 2017 10:09:02 Z 2017-11-15T10:09:02Z tag:resources@goskills.com,2017-07-04:Excel-essentials https://www.goskills.com/Excel/Resources/Excel-essentials Microsoft Excel Are you the last one in your office to know Excel? Get up to speed now. Here's six things you should absolutely know how to do in Excel. Tue, 04 Jul 2017 17:53:32 Z 2017-07-04T17:53:32Z tag:resources@goskills.com,2017-05-02:Why-learn-excel https://www.goskills.com/Excel/Resources/Why-learn-excel Microsoft Excel Microsoft Office You may be wondering: Why learn Excel? It's a valid question, and we wrote this post to explain all the reasons why you need to learn it ASAP. Tue, 02 May 2017 05:31:52 Z 2017-05-02T05:31:52Z tag:resources@goskills.com,2017-05-02:Excel-shortcuts https://www.goskills.com/Excel/Resources/Excel-shortcuts Microsoft Excel Microsoft Office Use our Excel keyboard shortcuts cheatsheet to save time in Excel. This infographic features the 80 best Excel shortcuts for Mac and PC, side-by-side. Tue, 02 May 2017 05:11:03 Z 2017-05-02T05:11:03Z