Catalog Search Results
Author
Publisher
linkedin.com
Pub. Date
2023.
Language
English
Description
Learn how to use MATLAB for numerical analysis, data modeling, and data visualization.
Learn how to analyze data using one of the most powerful statistical software packages available. MATLAB is a highly useful tool for complex computation, as it allows high-order calculations and analysis in matrices. In fact, it treats all of its data as vectors and matrices, so the course starts with a basic linear algebra tutorial outside of the program before...
Author
Publisher
linkedin.com
Pub. Date
2017.
Language
English
Description
Get started with machine learning. Learn how to separate training data from test data, prepare data for machine learning, perform supervised machine learning tasks, and more.
Learn how to analyze data using the machine learning capabilities built into Mathematica 11. In this course, Curt Frye provides an overview of machine learning tasks, explains how to separate training data from test data, and shows how to import data from a file. He also demonstrates...
Author
Publisher
linkedin.com
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
Publisher
linkedin.com
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
Publisher
linkedin.com
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...
Author
Publisher
linkedin.com
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...
Author
Publisher
linkedin.com
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 from...
Author
Publisher
linkedin.com
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
Publisher
linkedin.com
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
Publisher
linkedin.com
Pub. Date
2017.
Language
English
Description
Explore techniques for analyzing a series of business scenarios using the flexible and powerful capabilities built into Excel.
A multitude of factors can affect the trajectory of your business. Learning how to document, summarize, and present projected business scenarios can help provide a basis for insightful business analysis, and help you evaluate the impact of various choices on your organization. In this course, explore techniques for analyzing...
Author
Publisher
linkedin.com
Pub. Date
2021.
Language
English
Description
Master the essential tasks in the Mac version of Excel for Office 365. Learn how to manage workbooks, use core functions and formulas, create charts, and much more.
Excel for Mac is a powerful tool, but it can be intimidating for new users who either don't know where to start or don't know how to proceed beyond the most basic tasks. In this course, learn how to master the essential tasks in the Mac version of Excel for Office 365. Excel expert Curt...
Author
Publisher
linkedin.com
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
Publisher
linkedin.com
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
Publisher
linkedin.com
Pub. Date
2020.
Language
English
Description
Find out how to build value stream maps in Excel and PowerPoint to analyze and visualize business processes.
Value stream mapping is a method for documenting business processes, allowing project managers and analysts to analyze the different states and identify areas of improvement. This course shows how to create value stream maps using Excel and PowerPoint. Learn how to document two real-world processes-a manufacturing process and a service process-by...
Author
Publisher
linkedin.com
Pub. Date
2021.
Language
English
Description
Learn how to use PivotTables to summarize, sort, count, and chart your data in Microsoft Excel.
Many Excel users aren't sure how to use PivotTables. In this course, Excel power user Curt Frye shows you how to navigate the complexity of PivotTables while taking advantage of their power. Curt explains how to build PivotTables from single or multiple data sources, pivot and configure a PivotTable, define a default PivotTable layout, and more. He demonstrates...
Author
Publisher
linkedin.com
Pub. Date
2022.
Language
English
Description
Discover how to use Excel Solver to find optimal solutions to problems that range from simple to complex.
You can use Excel's Solver function to find optimal solutions to a wide range of problems, from simple to complex. In this course, Excel power user Curt Frye shows you how, with a wide range of potential challenges. Curt explains the basics of working with Solver and gives you a chance to create a Solver model. He steps through how to tune investment...
17) Access: VBA
Author
Publisher
linkedin.com
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
Publisher
linkedin.com
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
Publisher
linkedin.com
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
Publisher
linkedin.com
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...
Interlibrary loan through ILLiad
Didn't find what you need? Items not owned by Knox County Public Library can be requested from other libraries to be delivered to your pickup location.
Suggest a purchase
If it is too new for interlibrary loan (6 months), you can place a suggestion with us. Suggest a Purchase