Catalog Search Results
Author
Pub. Date
2022.
Language
English
Description
Unlock the power of your organization's data. Learn how to perform data analysis in Microsoft Excel.
Microsoft Excel is an important tool for data analysis. It helps companies accurately assess situations and make better business decisions. This course helps you unlock the power of your organization's data using the data analysis and visualization tools built into Excel. Author Curt Frye starts with the foundational concepts, including basic calculations...
2) Access: VBA
Author
Pub. Date
2019.
Language
English
Description
Learn how to leverage the Visual Basic for Applications (VBA) programing language in Access to create robust desktop database applications.
Enhance productivity by automating routine tasks and providing custom functionality not built into Access with a few basics in Visual Basic for Applications (VBA) code. In this course, Curt Frye introduces object-oriented programming and provides you with a solid grounding in the Access object model and the VBA...
Author
Pub. Date
2021.
Language
English
Description
Find out how to apply simulation techniques in Excel without the need for expensive specialty software.
Did you know you can record and run Solver macros, generate random inputs, run multiple simulations, and more, in Excel? Moreover, you can do all this without buying expensive specialty software. In this course, instructor Curt Frye shows how to enhance your supply chain analysis using the Solver add-in in combination with VBA. Working from an...
Author
Pub. Date
2023.
Language
English
Description
Get a beginner-level introduction to Excel formulas and functions. Learn how to summarize and analyze data using these powerful data analysis features.
To unlock the power of Excel, you need to use formulas and functions. These calculation tools help you bring information to the surface and make better decisions. Excel: Introduction to Formulas and Functions shows beginner-level users how to summarize and analyze data with these powerful data analysis...
Author
Pub. Date
2019.
Language
English
Description
Learn how to find free, public sources of data on a variety of business, education, and health issues and download the data for your own analysis.
Discover how to find free, public sources of data on a variety of business, education, and health issues and download the data for your own analysis. Instructor Curt Frye introduces several US government resources—from the US Census Bureau to the US Patent and Trademark Office—and surveys datasets...
Author
Pub. Date
2020.
Language
English
Description
Learn how to use Microsoft Excel to conceptualize, set up, and solve transportation problems in order to minimize costs in a supply chain.
Microsoft Excel can be a secret advantage when it comes to solving complex supply chain challenges. Follow along with instructor Curt Frye as he shows how to use the Excel Solver add-in to minimize transportation and transshipment costs within a supply chain. Curt covers a range of topics, including how to analyze...
Author
Pub. Date
2023.
Language
English
Description
Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.
VBA allows you to automate routine tasks in Excel, and it's easier to learn than you might think. In this course, Excel expert Curt Frye presents a thorough introduction to the Visual Basic for Applications programming language. Learn how to create subroutines and functions to hold code, and gain a solid grounding in the Excel object...
Author
Pub. Date
2019.
Language
English
Description
Learn how to combine the analytical strengths of R with the visualization power of Tableau to analyze and present data more effectively.
On its own, Tableau is a powerful tool that helps professionals analyze, display, and generally make sense of the data at their fingertips. With the addition of R—a free, open-source language for data science—you can glean even more insights from your data. In this course, learn how to combine the analytical...
Author
Pub. Date
2017.
Language
English
Description
Learn how to evaluate and visualize cash flows using Microsoft Excel.
By learning how to evaluate and visualize cash flows for your business, you can make more informed decisions about prospects and projects. In this course, Curt Frye demonstrates effective ways of evaluating and visualizing cash flows using Microsoft Excel. He demonstrates how to calculate the effect of interest rates and inflation, calculate the present value of an investment,...
Author
Pub. Date
2017.
Language
English
Description
Learn how to evaluate business processes using Excel 2016. Identify capacity, bottlenecks, underutilized resources, optimum batch size, order quantities, and more.
Operate with increased efficiency. Learn how to evaluate business processes using Excel worksheet formulas. These formulas let business analysts determine the theoretical throughput of processes, assess the impact of changeover time, identify bottlenecks, and weigh setup costs versus product...
Author
Pub. Date
2020.
Language
English
Description
Learn how to create surveys and quizzes quickly and easily with Microsoft Forms.
Learn how to create surveys and quizzes quickly and easily with Microsoft Forms, which comes bundled in the Office 365 suite. Curt Frye begins by showing how to create a basic survey, including how to add different question types—multiple choice, open-ended text, rating, and more—add ranking options, and allow for file uploads. Next, Curt steps through creating quizzes,...
Author
Pub. Date
2018.
Language
English
Description
Learn statistical process control techniques for Microsoft Excel. Learn how to build P charts, C charts, and X-bar R charts to measure the quality of manufacturing processes.
Learn how to analyze the accuracy and alignment of manufacturing processes using statistical tools. Veteran Excel trainer Curt Frye covers the three types of charts-P charts, C charts, and X-bar R charts-that are used to summarize the most common process metrics: proportion...
Author
Pub. Date
2018.
Language
English
Description
Learn data science in a fast-paced, fun, and non-technical way. Explore how the gambling and fantasy sports industries calculate odds and turn a profit.
Want to know how casinos calculate odds and turn a profit? Curious how fantasy sports leagues keep track of stats across the season? Get a fast-paced, fun, and non-technical overview of how the gambling and fantasy sports industries structure their offerings. Curt Frye uses data science to examine...
Author
Pub. Date
2017.
Language
English
Description
Learn how to analyze data using the Mathematica 11 environment and language.
Learn how to analyze data using the Mathematica 11 environment and language. In this course, Curt Frye shows how to set up Mathematica notebooks, find help, assign values to variables, import data into Mathematica, and research your results using Wolfram|Alpha. He also explains how to create and manipulate lists, analyze data using descriptive statistics, perform matrix...
Author
Pub. Date
2022.
Language
English
Description
Find out how to analyze hypothetical business cases in Excel.
Excel is a useful and versatile tool, but did you know you can also use it to analyze hypothetical business cases? Instructor Curt Frye walks you through the complete process. Curt begins by showing you how to create, define, edit, and delete scenarios, then goes into defining data tables. He explains how to use Goal Seek and Solver to create models, define constraints, and require integer...
Author
Pub. Date
2018.
Language
English
Description
Learn how to summarize, analyze, and calculate data using the advanced formulas and functions available in Google Sheets.
Many beginning and intermediate Google Sheets users are familiar with basic functions and formulas, but have no experience with the more advanced calculations the program offers. In this course, Curt Frye walks through the intermediate and advanced functions for summarizing data, performing statistics, analyzing financial data,...
Author
Pub. Date
2020.
Language
English
Description
Learn how to automate complex tasks and get more meaningful insights from data in Excel using Visual Basic for Applications (VBA) code.
Automate complex tasks and get more meaningful insights from data in Excel using Visual Basic for Applications (VBA) code. This course demonstrates how to work more efficiently in this powerful and popular spreadsheet program. Curt Frye shows how to focus in on important data, with filters; manage workbooks and worksheets;...
Author
Pub. Date
2020.
Language
English
Description
Learn how to use Excel to conceptualize, set up, and solve inventory problems to minimize purchasing cost and reduce the risk and cost of stockouts.
Excel pro Curt Frye shows how to analyze inventory costs and develop effective inventory policies within a supply chain. He explains how to calculate total costs and total relevant costs for a product. He covers how to incorporate the effects of lead time into analysis and how to determine how much extra...
Author
Pub. Date
2022.
Language
English
Description
Learn how to surface and summarize your data effectively in an Excel dashboard.
In this course, instructor Curt Frye shows you how to summarize spreadsheet data effectively to support decision-making throughout your organization. Curt explains how to set up a supporting workbook, including how to manage and filter data, streamline charts for dashboards, and create sparklines. He also goes over the process of creating a dashboard worksheet. Curt covers...
Author
Pub. Date
2018.
Language
English
Description
Learn how to summarize and rearrange your Google Sheets data dynamically with pivot tables.
Google Sheets users can leverage pivot tables to create useful summaries to gain insights into their business data. Follow along with Curt Frye as he shows how to summarize and rearrange data dynamically with pivot tables. Learn how to lay out your data, create the pivot table, edit the data source, add custom calculated fields, and sort and filter data to...
Didn't find it?
Can't find what you are looking for? Try our Purchase Suggestion Service. Submit Request