Catalog Search Results
Author
Pub. Date
2019.
Language
English
Description
Learn how to use Excel and VBA for business process modeling. Find out how to create and run simulations for customer flow, queuing, and manufacturing.
Excel power users: Learn how to use Excel and Visual Basic for Applications (VBA) to create and run simulations of business processes for customer flow, queuing, and manufacturing. VBA exponentially extends the power of Excel, allowing you to control process flow and logic and add custom classes and...
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...
Author
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
Pub. Date
2019.
Language
English
Description
Learn to automate routine tasks and customize the functionality of Excel features with this crash course in Visual Basic for Applications (VBA).
The Visual Basic for Applications (VBA) programming language allows you to automate routine tasks in Excel—and it's not as hard to learn as most people think. In this course, Excel expert Curt Frye offers a crash course on VBA, sharing techniques that can help users of Excel 2007 or later get more out...
Author
Pub. Date
2016.
Language
English
Description
Learn everything you need to know to analyze and display data using Tableau Desktop—and make better, more data-driven decisions for your company.
Tableau is the widely used data analytics and visualization tool that many consider indispensable for data-science-related work. Its drag-and-drop interface makes it easy to sort, compare, and analyze data from multiple sources, including Excel, SQL Server, and cloud-based data repositories. Tableau 10:...
Author
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
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
Pub. Date
2018.
Language
English
Description
Learn how to use MATLAB 2018 for numerical analysis, data modeling, and data visualization.
Learn how to analyze data using one of the most powerful statistical software packages available: MATLAB 2018. 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...
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
2022.
Language
English
Description
Learn to use Excel's LAMBDA function to create your own custom functions.
Discover how to create your own custom Excel functions with the LAMBDA function. Instructor Curt Frye begins with a brief history of custom functions in Excel, then explains the structure of the Excel formula language. Next, Curt shows you how to create a LAMBDA and define it as a custom function in Excel’s Name Manager. He also highlights how to manage loops and conditional...
Author
Pub. Date
2023.
Language
English
Description
Learn what you need to know to analyze and display data using Tableau 2023. Discover how to leverage the software to make smarter, more data-driven decisions.
Tableau is a powerful and versatile data analytics and visualization tool that many consider indispensable for data science work. Its drag-and-drop interface makes it easy to sort, compare, and analyze data from multiple sources, including Excel, SQL Server, and cloud-based data repositories....
Author
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...
Author
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
Pub. Date
2017.
Language
English
Description
Discover how to create useful and powerful formulas in Tableau 10, the popular analytics and visualization tool.
Tableau 10—the popular analytics and visualization tool—provides you with the ability to create powerful calculations. In this course, learn how to leverage this aspect of the platform, and start creating useful and powerful formulas in Tableau Desktop. Instructor Curt Frye begins by going into data types, conversions, and function...
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
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
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
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...
Didn't find it?
Can't find what you are looking for? Try our Purchase Suggestion Service. Submit Request