GoSkills - Microsoft ExcelGoSkills Online Courses 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-23:excel-lambda-functionHow to Use the LAMBDA function in Excel: Beginners' Version2025-10-23T14:59:37Z2025-10-23T14:59:37ZGoSkills.comhttps://www.goskills.comLearn 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.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-14:error-bars-excelHow to Add Error Bars in Excel2025-03-14T13:53:34Z2025-03-14T13:53:34ZGoSkills.comhttps://www.goskills.comError 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.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-12-09:Excel-challenge-47Excel Challenge 47 - Calculate Vacation Entitlement2024-12-09T15:45:31Z2024-12-09T15:45:31ZGoSkills.comhttps://www.goskills.comMaster Excel skills with this employee vacation tracker challenge. Practice date functions, lookups, and advanced logic for workforce management.
tag:resources@goskills.com,2024-11-25:Copilot-prompts-ExcelSample Copilot Prompts for Excel 3652024-11-25T21:48:37Z2024-11-25T21:48:37ZGoSkills.comhttps://www.goskills.comLearn how to use Copilot prompts in Excel to simplify data analysis, create visualizations, and perform predictive analytics.tag:resources@goskills.com,2024-11-11:Copilot-in-ExcelCopilot in Excel — How to Get Started2024-11-11T16:12:53Z2024-11-11T16:12:53ZGoSkills.comhttps://www.goskills.comLearn how to enable Copilot in Microsoft Excel to automate tasks, enhance data analysis, and boost productivity using AI and natural language prompts.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-19:free-excel-chart-templates-business16 Free Excel Chart Templates for Business2024-09-19T18:22:06Z2024-09-19T18:22:06ZGoSkills.comhttps://www.goskills.comDownload 16 of the best chart templates for business in project planning, financial management, sales, social media analytics, and more.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-21:IFS-function-ExcelHow to Use IFS in Excel | GoSkills2024-08-21T22:19:47Z2024-08-21T22:19:47ZGoSkills.comhttps://www.goskills.comThe 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.tag:resources@goskills.com,2024-08-10:Excel-skills-employers-looking-forWhat Excel Skills Employers Are Looking For in 2025?2024-08-10T20:08:43Z2024-08-10T20:08:43ZGoSkills.comhttps://www.goskills.comExcel 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.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-14:nested-formulas-ExcelNesting Multiple Formulas in Excel: A Beginner’s Guide2024-06-14T00:40:28Z2024-06-14T00:40:28ZGoSkills.comhttps://www.goskills.comNested functions allow you to combine multiple functions in Excel to perform several calculations in one go. Learn best practices and tips for formula nesting.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-22:Excel-sort-functionsHow to Use Excel SORT and SORTBY Functions2024-04-22T23:13:17Z2024-04-22T23:13:17ZGoSkills.comhttps://www.goskills.comExcel sort functions are superior to manual sorting methods because they will automatically update the sort order without user intervention. 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-03-01:Excel-manage-travel-budgetUse Excel to Manage Your Travel Budget | GoSkills2024-03-01T14:21:00Z2024-03-01T14:21:00ZGoSkills.comhttps://www.goskills.comYou'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.tag:resources@goskills.com,2024-03-01:IF-functions-ExcelHow to Use All Excel IF Functions | GoSkills2024-03-01T00:00:00Z2024-03-01T00:00:00ZGoSkills.comhttps://www.goskills.comMaster IF functions in Excel with this beginner's guide. Learn their logic and uses with real-world examples. Free cheatsheet included!tag:resources@goskills.com,2024-02-13:Excel-vba-range-objectUsing VBA Range Object in Microsoft Excel2024-02-13T19:59:01Z2024-02-13T19:59:01ZGoSkills.comhttps://www.goskills.comLearn how to use Excel VBA Range object for manipulating cell ranges to streamline your spreadsheets.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-29:Excel-vba-loops-guideA Quick Reference Guide to Excel VBA Loops2024-01-29T20:41:42Z2024-01-29T20:41:42ZGoSkills.comhttps://www.goskills.comAutomate repetitive tasks in Excel using Loops in VBA. Learn about For Loops and Do Loops with examples and syntax. Check out GoSkills' Excel resources.tag:resources@goskills.com,2024-01-17:Descriptive-statistics-excelDescriptive Statistics in Excel (Tutorial)2024-01-17T00:44:55Z2024-01-17T00:44:55ZGoSkills.comhttps://www.goskills.comUnlock the power of descriptive statistics in Excel with the Analysis ToolPak—easily calculate, organize, and analyze data for actionable insights.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-29:Excel-FIND-functionHow to Use the Excel FIND Function2023-12-29T22:18:48Z2023-12-29T22:18:48ZGoSkills.comhttps://www.goskills.comThe Excel FIND function helps you look for something within a specific text string. Learn how in this tutorial.tag:resources@goskills.com,2023-12-18:excel-vba-functionsHow To Write VBA Functions | GoSkills2023-12-18T19:52:20Z2023-12-18T19:52:20ZGoSkills.comhttps://www.goskills.comUse this helpful guide to Excel VBA functions for a solid introduction to one of Excel's most powerful tools. 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-21:Excel-VBA-arrayExcel VBA Array for Beginners | GoSkills2023-11-21T21:17:22Z2023-11-21T21:17:22ZGoSkills.comhttps://www.goskills.comUnderstanding Excel VBA Array is crucial in mastering Microsoft Excel.tag:resources@goskills.com,2023-11-17:Excel-lookup-functionsTop 12 Excel Lookup Functions (+ Free Cheatsheet!)2023-11-17T15:23:38Z2023-11-17T15:23:38ZGoSkills.comhttps://www.goskills.comLearn how to use the top 12 Excel lookup functions and download a free cheatsheet to keep for easy reference.tag:resources@goskills.com,2023-11-13:Excel-vba-if-then-elseUnderstanding Excel VBA If Then Else Statements2023-11-13T19:53:06Z2023-11-13T19:53:06ZGoSkills.comhttps://www.goskills.comGet a comprehensive overview of the If Then Else statement in Excel VBA and its different syntaxes.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-11-03:Excel-FILTER-functionHow to use FILTER in Excel | GoSkills2023-11-03T20:36:56Z2023-11-03T20:36:56ZGoSkills.comhttps://www.goskills.comLearn how to use the dynamic FILTER function in Excel from scratch.tag:resources@goskills.com,2023-10-21:Formula-auditing-tools-ExcelFormula Auditing Tools in Excel2023-10-21T20:36:37Z2023-10-21T20:36:37ZGoSkills.comhttps://www.goskills.comLearn how to use formula auditing tools in Excel, like trace precedents & trace dependents, to identify and troubleshoot any formula errors.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-25:Excel-number-formatUnderstanding Number Formats in Excel2023-09-25T16:54:35Z2023-09-25T16:54:35ZGoSkills.comhttps://www.goskills.comExcel 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.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-26:Career-change-tips5 Tips for a Successful Career Change | GoSkills2023-08-26T01:36:41Z2023-08-26T01:36:41ZGoSkills.comhttps://www.goskills.comConsidering a career change is increasingly common. But is it the right move? For those committed, here are five tips to ensure a successful transition.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-20:OFFSET-function-ExcelHow to Use the OFFSET Function in Excel2023-06-20T17:30:47Z2023-06-20T17:30:47ZGoSkills.comhttps://www.goskills.comThe 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.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-25:online-learning-to-get-promotedHow 30 Minutes of Online Learning Led to a Promotion | GoSkills2023-05-25T18:30:10Z2023-05-25T18:30:10ZGoSkills.comhttps://www.goskills.comThirty minutes a day of learning new skills can have impactful outcomes, like a job promotion. This is the story of a GoSkills learner.tag:resources@goskills.com,2023-05-16:Excel-errors10 Most Common Excel Errors (and How to Fix Them)2023-05-16T12:52:19Z2023-05-16T12:52:19ZGoSkills.comhttps://www.goskills.comUnderstand 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.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-24:PI-function-excelHow to Use PI in Excel | GoSkills2023-04-24T09:26:29Z2023-04-24T09:26:29ZGoSkills.comhttps://www.goskills.comPI 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.tag:resources@goskills.com,2023-04-11:Excel-text-join-functionHow to Use the Excel TEXTJOIN Function2023-04-11T04:09:52Z2023-04-11T04:09:52ZGoSkills.comhttps://www.goskills.comDiscover the Excel TEXTJOIN function as a simpler way to combine text strings than CONCATENATE and &. Learn tricks like line breaks and dynamic outputs.tag:resources@goskills.com,2023-04-05:excel-replace-functionHow to Use the Excel REPLACE Function2023-04-05T20:50:31Z2023-04-05T20:50:31ZGoSkills.comhttps://www.goskills.comThe Excel REPLACE function can be used in a variety of unexpected ways. 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-29:Excel-SEQUENCE-functionHow to Use the Excel SEQUENCE Function2023-03-29T00:55:58Z2023-03-29T00:55:58ZGoSkills.comhttps://www.goskills.comYour simple, no-fluff guide on how to use the SEQUENCE function in Excel. Use dynamic arrays to return multiple values with a single input.tag:resources@goskills.com,2023-03-07:best-career-resourcesTop 10 Resources for Leveling Up Your Career | GoSkills2023-03-07T02:16:40Z2023-03-07T02:16:40ZGoSkills.comhttps://www.goskills.comThese GoSkills resources provide the best tips for personal and professional development. Discover even more helpful ways to boost your career and improve your skills.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-20:excel-mid-functionHow to Use the Excel MID Function2023-02-20T02:53:49Z2023-02-20T02:53:49ZGoSkills.comhttps://www.goskills.comThe Excel MID function helps you extract a piece of text when there is text on either side. tag:resources@goskills.com,2023-02-13:excel-compound-interest-formulaHow to Calculate Compound Interest in Excel2023-02-13T02:15:34Z2023-02-13T02:15:34ZGoSkills.comhttps://www.goskills.comDiscover how to easily calculate compound interest in Excel with this step-by-step guide. Use formulas and functions to accurately project growth over time.tag:resources@goskills.com,2023-02-13:VBA-editor-ExcelIntroduction to VBA Editor in Excel2023-02-13T02:11:39Z2023-02-13T02:11:39ZGoSkills.comhttps://www.goskills.comOpen the VBA editor in Excel to add and edit VBA code. Learn the basics in this beginner-friendly, step-by-step guide.tag:resources@goskills.com,2023-02-13:pivot-table-excelThe Ultimate Guide to Pivot Tables in Excel2023-02-13T01:27:16Z2023-02-13T01:27:16ZGoSkills.comhttps://www.goskills.comMaster pivot tables in Excel to summarize and make sense of large data sets. Learn how to create pivot tables, create filters, slicers, and more.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-11:Excel-ISERROR-functionHow to Use the Excel ISERROR Function2023-01-11T23:53:49Z2023-01-11T23:53:49ZGoSkills.comhttps://www.goskills.comFigure out whether an input will result in an error in advance with the Excel ISERROR Function. tag:resources@goskills.com,2023-01-11:Vlookup-table-arrayYour Guide to VLOOKUP Table Array2023-01-11T23:37:20Z2023-01-11T23:37:20ZGoSkills.comhttps://www.goskills.comLearn the most useful tips and best practices for using VLOOKUP Table Array, from Microsoft Excel expert Claudia Buckley.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,2023-01-08:vba-message-boxEasy VBA MsgBox Tutorial | GoSkills2023-01-08T20:41:31Z2023-01-08T20:41:31ZGoSkills.comhttps://www.goskills.comImprove 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.tag:resources@goskills.com,2023-01-05:Divide-excelHow to Divide in Excel2023-01-05T18:51:41Z2023-01-05T18:51:41ZGoSkills.comhttps://www.goskills.comAs simple as division may seem, learning how to divide in Excel is key to mastering some of the most complex functions and formulas. tag:resources@goskills.com,2023-01-05:Freeze-panes-excelHow to Freeze Panes in Excel2023-01-05T18:45:21Z2023-01-05T18:45:21ZGoSkills.comhttps://www.goskills.comOnce you learn how to freeze panes in Excel, analyzing giant spreadsheets won't seem so daunting. tag:resources@goskills.com,2023-01-02:mail-merge-ExcelHow To Do a Mail Merge in Excel2023-01-02T11:00:00Z2023-01-02T11:00:00ZGoSkills.comhttps://www.goskills.comLooking 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.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-28:pivot-table-filterPivot Table Filter in Excel2022-11-28T03:31:18Z2022-11-28T03:31:18ZGoSkills.comhttps://www.goskills.comExcel pivot table filters help you to display select portions of data at your discretion and zero in on a special segment.tag:resources@goskills.com,2022-11-28:Lookup-multiple-criteriaLookup Multiple Criteria or Return Multiple Results in Excel2022-11-28T03:22:59Z2022-11-28T03:22:59ZGoSkills.comhttps://www.goskills.comLearn how to lookup multiple criteria in Excel. Analyze the best options from the FILTER function to XLOOKUP.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-17:data-analysis-excelThe Ultimate Guide to Data Analysis in Excel2022-10-17T21:32:23Z2022-10-17T21:32:23ZGoSkills.comhttps://www.goskills.comExcel is all about data! Learn these simple but essential data analysis tools in Excel.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-30:Table-excelHow to Make a Table in Excel2022-09-30T02:15:57Z2022-09-30T02:15:57ZGoSkills.comhttps://www.goskills.comWant 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. tag:resources@goskills.com,2022-09-22:Excel-data-analysis-toolpakHow to Use the Data Analysis Toolpak in Excel2022-09-22T19:05:46Z2022-09-22T19:05:46ZGoSkills.comhttps://www.goskills.comThe Excel Data Analysis Toolpak is a handy helper that analyzes complex or large data in a heartbeat.tag:resources@goskills.com,2022-09-15:sort-pivot-tableHow to Sort a Pivot Table2022-09-15T08:21:27Z2022-09-15T08:21:27ZGoSkills.comhttps://www.goskills.comWondering how to sort a pivot table? Learn how to sort in basic and custom orders in no time!tag:resources@goskills.com,2022-09-07:how-to-subtract-in-excelHow to Subtract in Excel2022-09-07T02:54:54Z2022-09-07T02:54:54ZGoSkills.comhttps://www.goskills.comEver 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.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-25:excel-substituteHow to Use the Excel SUBSTITUTE Function2022-08-25T21:10:16Z2022-08-25T21:10:16ZGoSkills.comhttps://www.goskills.comCheck out all the ways you can replace instances of text with the Excel SUBSTITUTE function.tag:resources@goskills.com,2022-08-23:pivot-table-slicerExcel slicer2022-08-23T01:43:29Z2022-08-23T01:43:29ZGoSkills.comhttps://www.goskills.comMeet pivot table slicers in Excel – the cooler, more efficient cousin to filters. Learn how to display your desired variables in an instant.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-26:Excel-date-functions20 Excel Date Functions - Explained!2022-07-26T18:56:27Z2022-07-26T18:56:27ZGoSkills.comhttps://www.goskills.comThere 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.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-07-01:TRIM-function-ExcelHow to Use the TRIM Function in Excel2022-07-01T13:00:00Z2022-07-01T13:00:00ZGoSkills.comhttps://www.goskills.comLearn how to clean up data easily using the TRIM function in Excel.tag:resources@goskills.com,2022-06-06:Vstack-Hstack-ExcelHow to Use VSTACK and HSTACK in Excel2022-06-06T23:55:28Z2022-06-06T23:55:28ZGoSkills.comhttps://www.goskills.comExciting new Excel functions are here! Learn how VSTACK and HSTACK in Excel make list combinations effortless. 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-27:textbefore-textafter-textsplit-excelHow to use TEXTBEFORE, TEXTAFTER and TEXTSPLIT in Excel2022-05-27T00:46:42Z2022-05-27T00:46:42ZGoSkills.comhttps://www.goskills.comLearn to use TEXTBEFORE, TEXTAFTER, and TEXTSPLIT for easier text handling in Excel.tag:resources@goskills.com,2022-05-18:Excel-basicsExcel Basics - Step by Step Tutorial for Beginners2022-05-18T02:18:03Z2022-05-18T02:18:03ZGoSkills.comhttps://www.goskills.comFrom figuring out the interface to using advanced filters, learn all there is to know when it comes to Excel basics. 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-19:Compare-two-columns-ExcelHow to Compare Two Columns in Excel2022-04-19T16:55:31Z2022-04-19T16:55:31ZGoSkills.comhttps://www.goskills.comLearn how to compare two columns in Excel in a few simple steps. tag:resources@goskills.com,2022-04-19:Move-rows-columns-ExcelHow to Move Rows and Columns in Excel2022-04-19T15:59:39Z2022-04-19T15:59:39ZGoSkills.comhttps://www.goskills.comRearranging 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. 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-04-01:Cell-styles-ExcelCell Styles in Excel: The Complete Guide2022-04-01T17:48:54Z2022-04-01T17:48:54ZGoSkills.comhttps://www.goskills.comThese useful hacks will make your Microsoft Excel sheet look impressive and organized. Discover how to use Cell Styles in Excel.tag:resources@goskills.com,2022-03-22:Using-AutoFill-in-ExcelUsing AutoFill in Excel2022-03-22T21:59:45Z2022-03-22T21:59:45ZGoSkills.comhttps://www.goskills.comThe Autofill Excel function recognizes patterns and simplifies the task of data entry for large datasets. Learn more!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-24:Excel-chartsThe Ultimate Guide to Excel Charts2022-02-24T15:13:20Z2022-02-24T15:13:20ZGoSkills.comhttps://www.goskills.comLearn 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.tag:resources@goskills.com,2022-02-05:Excel-dynamic-arraysExcel Dynamic Array: A Beginner's Tutorial2022-02-05T01:45:33Z2022-02-05T01:45:33ZGoSkills.comhttps://www.goskills.comExcel dynamic arrays have changed the way we use all functions and formulas in Excel for the better. Learn about it in this article.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-11:Waterfall-chartsWaterfall Charts in Excel - A Beginner's Guide2022-01-11T14:55:30Z2022-01-11T14:55:30ZGoSkills.comhttps://www.goskills.comA waterfall chart is one of the most visually descriptive charts supported in Excel. Learn how to create your own.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-10-25:Excel-SEARCH-functionHow to Use the Excel SEARCH Function2021-10-25T12:45:06Z2021-10-25T12:45:06ZGoSkills.comhttps://www.goskills.comThe Excel SEARCH function is meant to help you look for something within a specific text string. Learn about it here.tag:resources@goskills.com,2021-10-22:COUNTIFSHow to Use the COUNTIFS Excel Function2021-10-22T08:43:54Z2021-10-22T08:43:54ZGoSkills.comhttps://www.goskills.comCOUNTIFS determines the number of occurrences by comparing each range with its respective criterion. It then counts how many rows match all the stated criteria.tag:resources@goskills.com,2021-09-27:Excel-RIGHT-functionHow to Use the Excel RIGHT Function2021-09-27T07:28:28Z2021-09-27T07:28:28ZGoSkills.comhttps://www.goskills.comThe 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.tag:resources@goskills.com,2021-09-27:Excel-left-functionHow to Use the Excel LEFT Function2021-09-27T07:27:42Z2021-09-27T07:27:42ZGoSkills.comhttps://www.goskills.comWhen 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. tag:resources@goskills.com,2021-09-27:Lock-cells-ExcelHow to Lock Cells in Excel2021-09-27T07:27:00Z2021-09-27T07:27:00ZGoSkills.comhttps://www.goskills.comYou can protect data in Excel at different levels. Learn how to lock cells in Excel.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-16:Alphabetize-ExcelHow to Alphabetize in Excel2021-08-16T07:00:00Z2021-08-16T07:00:00ZGoSkills.comhttps://www.goskills.comLearn how to alphabetize in Excel to sharpen your sorting skills and keep your data organized. Master alphabetizing in Excel, simple to advanced methods.tag:resources@goskills.com,2021-08-16:Excel-custom-number-formatExcel Custom Number Format - A Beginner’s Guide2021-08-16T06:57:58Z2021-08-16T06:57:58ZGoSkills.comhttps://www.goskills.comA number format controls how cells with numeric data appear in Excel. Learn about how Excel custom number formats work in this beginner's guide.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-07-16:FREQUENCY-ExcelHow to Use the FREQUENCY Excel Function2021-07-16T12:10:34Z2021-07-16T12:10:34ZGoSkills.comhttps://www.goskills.comThe FREQUENCY Excel function simplifies the task of grouping values, especially in large datasets. Learn more!tag:resources@goskills.com,2021-07-15:Excel-SolverHow to Use Excel Solver2021-07-15T10:15:49Z2021-07-15T10:15:49ZGoSkills.comhttps://www.goskills.comExcel solver can be applied to workforce management, maximizing profitability, and financial planning. Learn how to use the tool!tag:resources@goskills.com,2021-07-06:How-to-make-a-graph-in-ExcelHow to Make a Graph in Excel2021-07-06T12:09:23Z2021-07-06T12:09:23ZGoSkills.comhttps://www.goskills.comYou can make a graph in Excel for simple, advanced, and complex data. Here's how to make a graph in Excel.tag:resources@goskills.com,2021-06-25:Excel-TEXT-functionThe Excel TEXT Function2021-06-25T07:19:28Z2021-06-25T07:19:28ZGoSkills.comhttps://www.goskills.comThe Excel TEXT function allows you to convert numbers to Excel text format using Excel’s format codes. Learn all about it.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-06-22:Basic-Excel-formulas12 Basic Excel Formulas You Need to Know2021-06-22T05:38:42Z2021-06-22T05:38:42ZGoSkills.comhttps://www.goskills.comLearn 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.tag:resources@goskills.com,2021-06-21:Remove-duplicates-ExcelHow to Remove Duplicates in Excel2021-06-21T08:03:59Z2021-06-21T08:03:59ZGoSkills.comhttps://www.goskills.comLet’s clean up your worksheet by learning how to find, and then, how to remove duplicates in Excel.tag:resources@goskills.com,2021-06-14:Excel-INDIRECT-functionHow to Use the Excel INDIRECT Function2021-06-14T04:58:41Z2021-06-14T04:58:41ZGoSkills.comhttps://www.goskills.comWith a single argument, you can add sophistication to your worksheet by allowing it to behave dynamically. That’s the Excel INDIRECT function.tag:resources@goskills.com,2021-06-14:Excel-histogramHow to Create a Histogram in Excel2021-06-14T04:57:21Z2021-06-14T04:57:21ZGoSkills.comhttps://www.goskills.comHistograms are useful for reporting on statistical data, especially when large datasets are involved. Here’s how to create a histogram in Excel.tag:resources@goskills.com,2021-06-03:Strikethrough-ExcelHow to Strikethrough in Excel2021-06-03T09:14:12Z2021-06-03T09:14:12ZGoSkills.comhttps://www.goskills.comThe strikethrough effect is an effective way to visually highlight that a task has been completed. Learn how to strikethrough in Excel.tag:resources@goskills.com,2021-06-02:Standard-deviation-formula-ExcelStandard Deviation Formula in Excel2021-06-02T08:37:50Z2021-06-02T08:37:50ZGoSkills.comhttps://www.goskills.comExcel eliminates the manual work by offering not one, but six functions to calculate standard deviation. Learn about the standard deviation formula in Excel.tag:resources@goskills.com,2021-06-02:Excel-SUMPRODUCTHow to Use the Excel SUMPRODUCT Function2021-06-02T08:36:44Z2021-06-02T08:36:44ZGoSkills.comhttps://www.goskills.comThe 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.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-05-18:How-to-make-pie-chart-ExcelHow to Make a Pie Chart in Excel2021-05-18T14:35:26Z2021-05-18T14:35:26ZGoSkills.comhttps://www.goskills.comPie 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.tag:resources@goskills.com,2021-05-15:How-to-make-a-scatter-plot-in-ExcelHow to Make a Scatter Plot in Excel2021-05-15T05:55:00Z2021-05-15T05:55:00ZGoSkills.comhttps://www.goskills.comA 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!tag:resources@goskills.com,2021-05-15:Variance-formula-ExcelVariance Formula Excel2021-05-15T05:51:43Z2021-05-15T05:51:43ZGoSkills.comhttps://www.goskills.comVariance is a number that gives a general idea of the dispersion of a dataset. Learn about the variance formula in Excel.tag:resources@goskills.com,2021-05-10:How-to-merge-split-cells-in-ExcelHow to Merge Cells and Split Cells in Excel2021-05-10T12:40:22Z2021-05-10T12:40:22ZGoSkills.comhttps://www.goskills.comExcel 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.tag:resources@goskills.com,2021-05-02:How-to-make-a-line-graph-in-ExcelHow to Make a Line Graph in Excel2021-05-02T05:36:07Z2021-05-02T05:36:07ZGoSkills.comhttps://www.goskills.comLine 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.tag:resources@goskills.com,2021-04-26:SUM-function-in-ExcelHow to Use the SUM Function in Excel2021-04-26T05:32:22Z2021-04-26T05:32:22ZGoSkills.comhttps://www.goskills.comOne of the best functions for beginners to learn is the SUM function in Excel. Start learning with this comprehensive tutorial.tag:resources@goskills.com,2021-04-22:How-to-filter-in-ExcelHow to Filter in Excel2021-04-22T11:37:15Z2021-04-22T11:37:15ZGoSkills.comhttps://www.goskills.comHave you ever wanted to temporarily display only certain data from a larger dataset without deleting the rest? Learn how to filter in Excel.tag:resources@goskills.com,2021-04-14:LEN-function-ExcelLEN Function Excel - A Beginner's Guide2021-04-14T12:32:28Z2021-04-14T12:32:28ZGoSkills.comhttps://www.goskills.comThe LEN Excel function returns the number of characters in a text string. Learn all about it in this beginner's guide.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-04-12:How-to-calculate-percentage-in-ExcelHow to Calculate Percentage in Excel2021-04-12T14:46:29Z2021-04-12T14:46:29ZGoSkills.comhttps://www.goskills.comIf 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.tag:resources@goskills.com,2021-04-02:Excel-dropdown-listHow to Create a Drop Down List in Excel2021-04-02T08:50:36Z2021-04-02T08:50:36ZGoSkills.comhttps://www.goskills.comExcel 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.tag:resources@goskills.com,2021-04-01:IFERROR-ExcelHow to Use the IFERROR Excel Function2021-04-01T11:16:45Z2021-04-01T11:16:45ZGoSkills.comhttps://www.goskills.comThe 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.tag:resources@goskills.com,2021-03-31:How-to-multiply-in-ExcelHow to Multiply in Excel2021-03-31T11:32:25Z2021-03-31T11:32:25ZGoSkills.comhttps://www.goskills.comThere are two main ways to do multiplication in Excel. Learn how to multiply in Excel here.tag:resources@goskills.com,2021-03-29:Excel-checkboxHow to Insert a Checkbox in Excel2021-03-29T17:30:35Z2021-03-29T17:30:35ZGoSkills.comhttps://www.goskills.comLearn 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? tag:resources@goskills.com,2021-03-27:How-to-make-a-bar-graph-in-ExcelHow to Make a Bar Graph in Excel2021-03-27T17:28:22Z2021-03-27T17:28:22ZGoSkills.comhttps://www.goskills.comBar graphs are an effective way to visually compare frequency, amounts, or units. Learn how to make a bar graph in Excel.tag:resources@goskills.com,2021-03-10:PMT-function-ExcelPMT Function Excel2021-03-10T08:27:27Z2021-03-10T08:27:27ZGoSkills.comhttps://www.goskills.comLearn how to use the Excel PMT function in this comprehensive beginner's guide.tag:resources@goskills.com,2021-03-02:Concatenate-ExcelHow to Concatenate in Excel (CONCATENATE, CONCAT, TEXTJOIN)2021-03-02T14:28:48Z2021-03-02T14:28:48ZGoSkills.comhttps://www.goskills.comThere are four ways to concatenate in Excel (the CONCATENATE Excel function, CONCAT, TEXTJOIN, and the & operator). Learn about them in this beginner's guide.tag:resources@goskills.com,2021-02-28:Checkmark-in-ExcelHow to Insert a Check Mark in Excel2021-02-28T10:05:00Z2021-02-28T10:05:00ZGoSkills.comhttps://www.goskills.comIf 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.tag:resources@goskills.com,2021-02-24:Excel-COUNTAHow to Use the Excel COUNTA Function2021-02-24T07:28:30Z2021-02-24T07:28:30ZGoSkills.comhttps://www.goskills.comThe Excel COUNTA function counts all cells with data. Learn all about it in this beginner's guide.tag:resources@goskills.com,2021-02-24:COUNT-function-ExcelHow to Use the COUNT Function in Excel2021-02-24T07:16:42Z2021-02-24T07:16:42ZGoSkills.comhttps://www.goskills.comExcel is all about large quantities of data. Learn how to use the COUNT function in Excel to count your data in various ways. tag:resources@goskills.com,2021-02-24:INDEX-MATCHWhat is INDEX MATCH in Excel?2021-02-24T06:53:53Z2021-02-24T06:53:53ZGoSkills.comhttps://www.goskills.comLearn 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.tag:resources@goskills.com,2021-02-21:Count-unique-values-ExcelHow to Count Unique Values in Excel with the UNIQUE Function2021-02-21T22:37:25Z2021-02-21T22:37:25ZGoSkills.comhttps://www.goskills.comTo help you count unique values in Excel, try the UNIQUE function. Learn all about it in this beginner's guide.tag:resources@goskills.com,2021-02-15:Excel-goal-seekExcel Goal Seek Explained (Step by Step Guide)2021-02-15T21:47:00Z2021-02-15T21:47:00ZGoSkills.comhttps://www.goskills.comThe Excel Goal Seek feature is a useful what if analysis tool. Learn all about it in this beginner's guide!tag:resources@goskills.com,2021-02-13:AVERAGEIF-functionHow to Use the Excel AVERAGEIF Function2021-02-13T22:30:03Z2021-02-13T22:30:03ZGoSkills.comhttps://www.goskills.comLearn all about the Excel AVERAGEIF function in this comprehensive beginner's guide.tag:resources@goskills.com,2021-02-11:Conditional-formatting-ExcelConditional Formatting in Excel - a Beginner's Guide2021-02-11T07:23:12Z2021-02-11T07:23:12ZGoSkills.comhttps://www.goskills.comLearn how to use conditional formatting in Excel to easily visualize your data. tag:resources@goskills.com,2021-02-05:What-if-analysis-ExcelWhat If Analysis in Excel - Beginner's Guide (Step by Step)2021-02-05T23:14:42Z2021-02-05T23:14:42ZGoSkills.comhttps://www.goskills.comTo 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.tag:resources@goskills.com,2021-01-29:Weighted-average-ExcelHow to Calculate Weighted Average in Excel2021-01-29T00:42:57Z2021-01-29T00:42:57ZGoSkills.comhttps://www.goskills.comExplore this guide on how to calculate a weighted average in Excel using the SUMPRODUCT function. 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,2021-01-24:How-to-calculate-average-in-ExcelHow to Calculate Averages in Excel (7 Simple Ways)2021-01-24T22:00:10Z2021-01-24T22:00:10ZGoSkills.comhttps://www.goskills.comLearn how to calculate averages in Excel using the AVERAGE, MEDIAN, and MODE functions. Includes a video walkthrough and exercise file.tag:resources@goskills.com,2021-01-19:Pivot-table-calculated-fieldHow to Create Pivot Table Calculated Fields 2021-01-19T05:50:22Z2021-01-19T05:50:22ZGoSkills.comhttps://www.goskills.comWant to level up your pivot table skills? Learn how to add and modify a pivot table calculated field with this how-to guide.tag:resources@goskills.com,2021-01-17:SUMIFS-Excel-functionThe SUMIFS Excel Function2021-01-17T21:14:39Z2021-01-17T21:14:39ZGoSkills.comhttps://www.goskills.comLearn how to use the SUMIFS Excel function to add values that meet multiple specific criteria with this step-by-step tutorial. tag:resources@goskills.com,2021-01-11:IF-function-ExcelHow to Use the IF Function in Excel2021-01-11T00:46:56Z2021-01-11T00:46:56ZGoSkills.comhttps://www.goskills.comLearn how to use the IF function in Excel and see how it can be combined with the OR and AND functions.tag:resources@goskills.com,2021-01-03:SUMIF-ExcelThe SUMIF Excel Function2021-01-03T00:23:53Z2021-01-03T00:23:53ZGoSkills.comhttps://www.goskills.comDiscover what the SUMIF Excel function is and how to use it.tag:resources@goskills.com,2020-12-22:COUNTIF-Excel-functionThe COUNTIF Function in Excel2020-12-22T10:27:35Z2020-12-22T10:27:35ZGoSkills.comhttps://www.goskills.comImprove your data management skills by learning how to use the COUNTIF function in Excel.tag:resources@goskills.com,2020-12-22:Excel-AND-functionThe Excel AND Function2020-12-22T10:27:33Z2020-12-22T10:27:33ZGoSkills.comhttps://www.goskills.comLearn how to use the Excel AND function and combine it with other functions for more flexibility. tag:resources@goskills.com,2020-12-22:Running-total-Excel-cumulative-sumHow to Create a Running Total in Excel (Cumulative Sum)2020-12-22T10:20:26Z2020-12-22T10:20:26ZGoSkills.comhttps://www.goskills.comLearn how to create a running total in Excel with this step-by-step tutorial. tag:resources@goskills.com,2020-12-15:Excel-OR-functionThe Excel OR Function2020-12-15T13:24:33Z2020-12-15T13:24:33ZGoSkills.comhttps://www.goskills.comWhat is the Excel OR function? How do you use it? Find out in this tutorial.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-12-09:Excel-LET-functionThe New Excel LET Function: How to Use It & Why You'll Love it2020-12-09T19:32:36Z2020-12-09T19:32:36ZGoSkills.comhttps://www.goskills.comLearn about the new Excel LET function. This new function can help make complex formulas easier to read and use.tag:resources@goskills.com,2020-12-06:Excel-ribbonThe Excel Ribbon2020-12-06T04:08:05Z2020-12-06T04:08:05ZGoSkills.comhttps://www.goskills.comImprove your Excel navigational skills with these tips on how to use and customize the Excel ribbon.tag:resources@goskills.com,2020-12-04:How-to-sort-in-ExcelHow to Sort in Excel 2020-12-04T01:53:08Z2020-12-04T01:53:08ZGoSkills.comhttps://www.goskills.comLearn how to sort in Excel including multi level sorting, alphabetical sorting, numeric sorting, and custom sorting.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-11-13:VLOOKUP-exact-match-approximate-matchVLOOKUP Exact Match & Approximate Match2020-11-13T02:26:57Z2020-11-13T02:26:57ZGoSkills.comhttps://www.goskills.comLearn one of Excel's most useful functions: VLOOKUP exact match and approximate match. tag:resources@goskills.com,2020-11-13:VBA-variable-typesVBA Variable Types in Excel2020-11-13T02:02:51Z2020-11-13T02:02:51ZGoSkills.comhttps://www.goskills.comLearn what a variable is, why they are important, and understand how to use the different VBA variable types in Excel.tag:resources@goskills.com,2020-10-29:Remove-blank-rows-in-ExcelHow to Remove Blank Rows in Excel 2020-10-29T23:24:38Z2020-10-29T23:24:38ZGoSkills.comhttps://www.goskills.comAvoid data errors by learning how to remove blank rows in Excel the right way.tag:resources@goskills.com,2020-10-29:Mixed-reference-ExcelMixed Reference Excel - a Beginner's Guide2020-10-29T22:54:19Z2020-10-29T22:54:19ZGoSkills.comhttps://www.goskills.comLearn all about the mixed reference Excel feature in this beginner's guide.tag:resources@goskills.com,2020-10-21:Relative-reference-ExcelRelative Reference Excel - A Beginner's Guide 2020-10-21T02:19:23Z2020-10-21T02:19:23ZGoSkills.comhttps://www.goskills.comLearn all about the relative reference Excel feature in this beginner's guide. 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-10-18:VBA-code-libraryExcel VBA Code Library - Useful Macros for Beginners2020-10-18T21:45:01Z2020-10-18T21:45:01ZGoSkills.comhttps://www.goskills.comAutomate your Excel tasks with ready-made code from our VBA code library.tag:resources@goskills.com,2020-10-12:Absolute-reference-ExcelAbsolute Reference Excel - A Beginner's Guide 2020-10-12T00:17:45Z2020-10-12T00:17:45ZGoSkills.comhttps://www.goskills.comLearn all about the absolute reference Excel feature in this beginner's guide. tag:resources@goskills.com,2020-10-07:Best-practices-in-dashboard-design12 Best Practices in Dashboard Design2020-10-07T21:33:48Z2020-10-07T21:33:48ZGoSkills.comhttps://www.goskills.comLearn what a dashboard is, the different types, and the best practices in dashboard design.tag:resources@goskills.com,2020-10-01:Wildcard-characters-in-ExcelHow to Use Wildcard Characters in Excel2020-10-01T05:00:16Z2020-10-01T05:00:16ZGoSkills.comhttps://www.goskills.comLearn how to use wildcard characters in Excel to save time when working with formulas. tag:resources@goskills.com,2020-09-20:Xlookup-vs-vlookupXLOOKUP vs VLOOKUP in Excel - What's the Difference?2020-09-20T22:07:54Z2020-09-20T22:07:54ZGoSkills.comhttps://www.goskills.comXLOOKUP 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.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!tag:resources@goskills.com,2020-09-10:Hlookup-vs-vlookupHLOOKUP vs VLOOKUP: A Beginner's Guide2020-09-10T01:42:15Z2020-09-10T01:42:15ZGoSkills.comhttps://www.goskills.comIt's the battle of the lookups - this time it's HLOOKUP vs VLOOKUP. Which will win?tag:resources@goskills.com,2020-08-26:Xlookup-in-ExcelXLOOKUP in Excel: A Beginner's Guide2020-08-26T19:39:29Z2020-08-26T19:39:29ZGoSkills.comhttps://www.goskills.comXLOOKUP in Excel is a powerful function that will help you save time and effort. Learn about it here.tag:resources@goskills.com,2020-07-27:Most-useful-Excel-functions-for-data-analysis12 Most Useful Excel Functions for Data Analysis2020-07-27T18:39:21Z2020-07-27T18:39:21ZGoSkills.comhttps://www.goskills.comLearn 12 of the most useful Excel functions for data analysis, with free practice worksheet included!
tag:resources@goskills.com,2020-06-23:Google-Sheets-vs-ExcelGoogle Sheets Vs. Excel: Everything You Need to Know2020-06-23T00:50:20Z2020-06-23T00:50:20ZGoSkills.comhttps://www.goskills.comIn the battle of best spreadsheet software, who will win? Let's dig into Google Sheets vs. Excel. tag:resources@goskills.com,2020-05-11:Vlookup-vs-Pivot-TableVLOOKUP vs Pivot Tables: A Beginner’s Guide2020-05-11T10:34:39Z2020-05-11T10:34:39ZGoSkills.comhttps://www.goskills.comIn this article we will examine VLOOKUP, Pivot Tables and Power Pivot, and when you should use each of them for best results.tag:resources@goskills.com,2020-02-17:Power-query-vs-power-pivot-power-biPower Query vs Power Pivot vs Power BI: A Beginner's Guide2020-02-17T09:21:24Z2020-02-17T09:21:24ZGoSkills.comhttps://www.goskills.comWe demystify the differences between Power Query, Power Pivot, and Power BI and show you how they all work together. tag:resources@goskills.com,2020-01-08:How-to-master-ExcelHow to Master Excel in 12 Steps2020-01-08T23:43:21Z2020-01-08T23:43:21ZGoSkills.comhttps://www.goskills.comIt'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!tag:resources@goskills.com,2019-11-21:How-to-make-column-chart-ExcelHow to Make a Column Chart in Excel: A Guide to Doing it Right2019-11-21T21:30:20Z2019-11-21T21:30:20ZGoSkills.comhttps://www.goskills.comReady 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!tag:resources@goskills.com,2019-10-17:Use-anova-in-ExcelHow to Use ANOVA in Excel: The Ultimate Guide2019-10-17T20:33:50Z2019-10-17T20:33:50ZGoSkills.comhttps://www.goskills.comLooking 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!tag:resources@goskills.com,2019-09-05:Excel-skills-for-accountants9 Best Excel Skills for Accountants in 2025 2019-09-05T18:08:50Z2019-09-05T18:08:50ZGoSkills.comhttps://www.goskills.comLike 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.tag:resources@goskills.com,2019-08-06:Excel-presentation-tips11 Best Excel Presentation Tips in 20252019-08-06T00:21:58Z2019-08-06T00:21:58ZGoSkills.comhttps://www.goskills.comMake not just professional but stunning spreadsheets with these 11 Excel presentation tips!tag:resources@goskills.com,2019-07-07:Excel-gantt-chart-templateFree Excel Gantt Chart Template (Easy to Use)2019-07-07T19:22:55Z2019-07-07T19:22:55ZGoSkills.comhttps://www.goskills.comMake your life a lot easier with this free Excel Gantt chart template! Download it now!tag:resources@goskills.com,2019-06-06:Power-BI-pie-chartCreate a Power BI Pie Chart in 6 Easy Steps2019-06-06T23:04:15Z2019-06-06T23:04:15ZGoSkills.comhttps://www.goskills.comWant to make a Power BI Pie chart? Follow along with our step-by-step guide!tag:resources@goskills.com,2019-05-23:How-to-use-PowerPivotHow to use PowerPivot in Excel: The Ultimate Guide2019-05-23T04:15:03Z2019-05-23T04:15:03ZGoSkills.comhttps://www.goskills.comLearn 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.tag:resources@goskills.com,2019-04-08:Power-Query-tipsPower Query Tips: 10 Most Useful Commands2019-04-08T23:50:13Z2019-04-08T23:50:13ZGoSkills.comhttps://www.goskills.comCheck out these Power Query tips that will help you transform your data like a pro!tag:resources@goskills.com,2019-03-14:Excel-tips-for-beginnersExcel for Dummies: Our Top Tips | GoSkills2019-03-14T22:53:08Z2019-03-14T22:53:08ZGoSkills.comhttps://www.goskills.comGetting started in the world of spreadsheets? Check out these essential Excel tips for beginners to level up your skills.tag:resources@goskills.com,2019-02-12:Advanced-pivot-table-techniques6 Advanced Pivot Table Techniques in 20252019-02-12T00:41:10Z2019-02-12T00:41:10ZGoSkills.comhttps://www.goskills.comUp your Excel game with these advanced pivot table techniques. tag:resources@goskills.com,2018-12-27:Vlookup-index-matchVLOOKUP vs INDEX MATCH: Which is Better?2018-12-27T15:49:34Z2018-12-27T15:49:34ZGoSkills.comhttps://www.goskills.comWhere the VLOOKUP is lacking, INDEX MATCH picks up the slack. Learn how INDEX MATCH can make your life that much easier. tag:resources@goskills.com,2018-11-06:Excel-user-defined-function-examplesExcel User Defined Function Examples2018-11-06T18:33:10Z2018-11-06T18:33:10ZGoSkills.comhttps://www.goskills.comExcel UDF give you more control of your spreadsheets. Check out our guide to create your own, including some handy Excel user defined function examples.tag:resources@goskills.com,2018-10-08:Advanced-Excel-chartsCreating Advanced Excel Charts: Step by Step Tutorial2018-10-08T00:00:00Z2018-10-08T00:00:00ZGoSkills.comhttps://www.goskills.comInterested in taking your spreadsheet skills to the next level? Check out our advanced Excel chart tutorial to find out how.tag:resources@goskills.com,2018-09-10:Excel-chart-tutorialExcel Chart Tutorial: a Beginner's Step-By-Step Guide2018-09-10T21:31:10Z2018-09-10T21:31:10ZGoSkills.comhttps://www.goskills.comFollow our pain-free Excel chart tutorial to easily shape your data into a beautiful graph.tag:resources@goskills.com,2018-08-01:Pivot-table-tutorialExcel Pivot Table Tutorial - 5 Easy Steps for Beginners2018-08-01T00:59:13Z2018-08-01T00:59:13ZGoSkills.comhttps://www.goskills.comNeed 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!tag:resources@goskills.com,2018-07-02:How-to-create-excel-dashboardHow to Create an Excel Dashboard in 7 Steps2018-07-02T14:00:00Z2018-07-02T14:00:00ZGoSkills.comhttps://www.goskills.comIn this step by step tutorial, we’re breaking down exactly how to create an Excel dashboard (with no stress or headaches required).tag:resources@goskills.com,2018-06-11:Excel-templates-for-business34 Excel Templates for Business to Improve Your Efficiency: 2025 Update2018-06-11T14:00:00Z2018-06-11T14:00:00ZGoSkills.comhttps://www.goskills.comTo 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.tag:resources@goskills.com,2018-05-14:Excel-macro-tutorial-for-beginnersExcel Macro for Beginners: Build a Macro in 4 Easy Steps2018-05-14T00:00:00Z2018-05-14T00:00:00ZGoSkills.comhttps://www.goskills.comExcel Macros might seem complicated. But learning to use them to your advantage is actually surprisingly simple. Learn how to use macros from scratch.tag:resources@goskills.com,2018-04-23:Excel-hacks11 Excel Hacks You Need to Know Now2018-04-23T06:14:17Z2018-04-23T06:14:17ZGoSkills.comhttps://www.goskills.comWe’ve rounded up 11 different Excel hacks you’re sure to use and love.tag:resources@goskills.com,2018-04-03:Excel-VBA-advanced-filterExcel VBA - Advanced Filtering Tutorial2018-04-03T08:37:25Z2018-04-03T08:37:25ZGoSkills.comhttps://www.goskills.comIf you find yourself performing repetitive tasks in Excel that don't have a single formula fix, VBA may just be your solution.tag:resources@goskills.com,2018-03-06:How-to-do-taxes-in-ExcelHow to Do Taxes in Excel - Free Template Included2018-03-06T09:49:17Z2018-03-06T09:49:17ZGoSkills.comhttps://www.goskills.comHow to do your taxes in Excel, without the headaches. tag:resources@goskills.com,2018-02-11:Uses-of-Excel-in-business21 Important Uses of Excel in Business 2018-02-11T23:00:34Z2018-02-11T23:00:34ZGoSkills.comhttps://www.goskills.comFrom lists to charts to design mock-ups, here are some of the coolest ways you can use Excel.tag:resources@goskills.com,2018-01-02:Best-Excel-add-ins48 Best Excel Add-Ins That Will Make Your Life Easier2018-01-02T08:24:42Z2018-01-02T08:24:42ZGoSkills.comhttps://www.goskills.comWith a few of these Excel add-ins, your spreadsheets will reach pro-level in no time.tag:resources@goskills.com,2017-12-04:Jobs-require-ExcelA Complete Breakdown of Jobs That Use Excel Skills2017-12-04T06:23:05Z2017-12-04T06:23:05ZGoSkills.comhttps://www.goskills.comHoning 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.tag:resources@goskills.com,2017-11-15:Free-Excel-templates51 Free Excel Templates to Make Your Life Easier - Updated November 20252017-11-15T10:09:02Z2017-11-15T10:09:02ZGoSkills.comhttps://www.goskills.comManage your business and organize your life with the 52 best free Excel templates. The list covers template spanning 7 categories, from personal to business.
tag:resources@goskills.com,2017-07-04:Excel-essentials6 Things You Should Absolutely Know How to Do in Excel2017-07-04T17:53:32Z2017-07-04T17:53:32ZGoSkills.comhttps://www.goskills.comAre 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.tag:resources@goskills.com,2017-05-02:Why-learn-excelWhy Learn Excel? Here are 4 Good Reasons2017-05-02T05:31:52Z2017-05-02T05:31:52ZGoSkills.comhttps://www.goskills.comYou 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.tag:resources@goskills.com,2017-05-02:Excel-shortcutsThe Top 80 Excel Keyboard Shortcuts2017-05-02T05:11:03Z2017-05-02T05:11:03ZGoSkills.comhttps://www.goskills.comUse 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.