{"id":9855,"date":"2021-09-03T14:00:00","date_gmt":"2021-09-03T12:00:00","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=9855"},"modified":"2021-09-03T14:00:00","modified_gmt":"2021-09-03T12:00:00","slug":"como-usar-o-complemento-do-xlminer-analysis-toolpak-para-o-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/finance-processes\/how-to-use-xlminer-analysis-toolpak-add-on-for-google-sheets\/","title":{"rendered":"Como usar o complemento XLMiner Analysis ToolPak para o Google Sheets"},"content":{"rendered":"

[et_pb_section fb_built=”1″ admin_label=”section” module_class=”sheetgo-post” _builder_version=”3.26.6″ custom_padding=”54px|0px|0|0px|false|false” global_colors_info=”{}”][et_pb_row admin_label=”row” _builder_version=”3.25″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.9.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n

Excel fans turned Google Sheets users can rejoice.\u00a0XLMiner Analysis ToolPak\u00a0is another add-on that increases the power of Google Sheets. When Google first launched Sheets, it changed the game for many spreadsheet users, allowing for real-time collaboration\u00a0from any device at any time. But as amazing as this new style of spreadsheets was, advanced Excel users were left out of the excitement. This because Google Sheets was pretty basic and did not have some of the advanced features that select users need to process and perform statistical analyses. However, Google Sheets and Excel both changed a lot over the years. Excel has created a collaborative, online component. Whereas Google Sheets has become more advanced to keep up with the competition. Sheets has improved their own features and introduced add-ons, a feature that allows 3rd party developers to create tools that boost the capabilities of Sheets.<\/p>\n

Solver<\/a>\u00a0created an add-on that solved one of those Google Sheets issues. It mimics the same tool used in Excel and allows users to perform essentially the exact same analyses. This is great for the many users who are making the switch from Excel to Google Sheets because it is free, cloud-based, and so easy to share and collaborate with using Google\u2019s unique sharing permission. There are also many users, like myself, who work across both programs! The ease of being able to switch between programs without having to change the way you operate features is extremely valuable for individuals and teams who need to create and share important data.<\/p>\n

Who is using XLMiner Analysis ToolPak?<\/h4>\n

Statistical analysis is performed by research scientists, analysists, government organizations, non-profits, and private companies. Being able to correctly understand data allows us to make better decisions in\u00a0finance, investment, production, distribution, scheduling, and more. Users are using this add-on to predict flight delays and even optimize professional football scheduling<\/a>. How will you use XLMiner Analysis ToolPak to change the world around you?<\/p>\n

How to access XLMiner Analysis ToolPak<\/h4>\n

It is really simple to get add-ons for Sheets! The fastest way to get XLMiner Analysis Toolpak is to click this link<\/a> that will take you directly to the Google Workspace Marketplace. Simply click the Install<\/b> button and the add-on will be added to your Google Sheets account.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/09\/XLMiner-Analysis-Toolpak-add-on-install-GWM-1-1.png” alt=”XLMiner Analysis Toolpak installation” title_text=”XLMiner Analysis Toolpak add-on install GWM 1 (1)” align=”center” _builder_version=”4.9.4″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.9.4″ _module_preset=”default” global_colors_info=”{}”]Alternatively, you can get the add-on by following these steps:<\/p>\n

    \n
  1. Open a Google Sheets file<\/li>\n
  2. Click the Add-ons<\/b> button in the navigation menu<\/li>\n
  3. Click the Get add-ons<\/b> button<\/li>\n
  4. A window will pop up for you to browse<\/li>\n
  5. Type \u201cXLMiner Analysis ToolPak\u201d in the search box.<\/li>\n
  6. Click the Install<\/b> button to get the add-on<\/li>\n<\/ol>\n

    You are now ready to start using XLMiner Analysis ToolPak!<\/p>\n

    [\/et_pb_text][et_pb_text _builder_version=”4.9.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n

    How to use the Add-on<\/h4>\n

    Starting the XLMiner Analysis Toolpak is easy. Simple click Add-ons<\/strong>\u00a0\u2192 XLMiner Analysis ToolPak<\/strong>\u00a0\u2192 Start<\/strong>.<\/p>\n

    [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/XLMiner-Analysis-ToolPak-2.png” _builder_version=”4.10.7″ _module_preset=”default” alt=”XLMiner Analysis ToolPak 2″ title_text=”XLMiner Analysis ToolPak 2″ hover_enabled=”0″ sticky_enabled=”0″][\/et_pb_image][et_pb_text _builder_version=”4.9.4″ _module_preset=”default” global_colors_info=”{}”]<\/strong>Google Sheets\u00a0will open the add-on, and a toolbar will appear on the right side of your spreadsheet. From this sidebar you can choose from twenty different options to perform statistical analyses on your data:<\/p>\n