Catalog Search Results
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
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
2017.
Language
English
Description
Discover how to summarize data in Excel 2016. Learn how to set up a dashboard worksheet, create links to workbook elements, maximize your screen space by hiding rows, and more.
Learn easy-to-implement techniques that can help you quickly create a visual representation of your data to inform your decision making.�In this brief course, Curt Frye walks through the basics of creating a dashboard in Excel. Curt begins with a primer on using PivotTables?one...
Author
Publisher
linkedin.com
Pub. Date
2017.
Language
English
Description
Learn how to leverage Solver?a Microsoft Office Excel add-in?to find optimal solutions to problems with multiple constraints.
Solver?a Microsoft Office Excel add-in?can help you analyze your data more efficiently. In this course, learn how to leverage Solver to find optimal solutions to problems with multiple constraints. Curt Frye explains how to install Solver, organize worksheets to make the data and summary operations clear, and find a solution...
Author
Publisher
linkedin.com
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 of...
Author
Publisher
linkedin.com
Pub. Date
2017.
Language
English
Description
Learn how to use SAP Crystal Reports 2016 to analyze and summarize data and make better business decisions.
Maximize the power of SAP Crystal Reports 2016. Crystal Reports helps you to import and analyze data from a variety of places, including Excel, Access, groupware applications like Lotus Notes, HTML and XML files, SAP, and more. Join author Curt Frye as he shows the essentials you need to get started, and provides tips to get more reporting...
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
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
2019.
Language
English
Description
Learn to use Excel functions for financial analysis. Find out how to calculate loan payments, depreciation, rate of return, and more, in Microsoft Excel.
Analyzing financial data can seem intimidating, but Microsoft Excel has a wide range of functions to perform these calculations quickly and easily. This course shows users how and when to use each of the financial functions available in Excel. Author Curt Frye covers evaluating loan payments; calculating...
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
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
2014.
Language
English
Description
Analyze hypothetical business cases using Excel formulas and variable data.
Make better decisions for your business by taking a deeper dive into your data with Microsoft Excel's analysis tools. In this advanced course, Curt Frye shows how to analyze hypothetical business cases using formulas and variable data. He'll show you how to build data tables, define alternative data sets with scenarios, find target values with Goal Seek, and analyze complex...
Author
Publisher
linkedin.com
Pub. Date
2010.
Language
English
Description
Shows managers and executives how to assess their organization's data effectively by applying statistical analysis techniques.
Excel 2007: Business Statistics with Curtis Frye shows managers and executives how to assess their organization's data effectively by applying statistical analysis techniques. The course covers important statistical terms and definitions, and then dives into techniques using the tools in Excel: formulas and functions for...
Author
Publisher
linkedin.com
Pub. Date
2018.
Language
English
Description
Discover how to visualize your data using Tableau Desktop?and make better, more data-driven decisions.
Tableau is a 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. In this course, learn what you need to know to analyze and...
Author
Publisher
linkedin.com
Pub. Date
2016.
Language
English
Description
Become a more productive, efficient Excel user with this collection of tips and tricks?just for Mac.
Become a more productive, efficient Excel user with this collection of tips and tricks?just for Mac. Curt Frye kicks off with his top 10 power shortcuts, and introduces techniques for controlling and customizing the user interface, managing workbooks and worksheets, and organizing, entering, and formatting data. He offers shortcuts for working with...
Author
Publisher
linkedin.com
Pub. Date
2009.
Language
English
Description
Provides a basic fluency in corporate finance, enabling users to grasp the meaning behind the calculations.
Numbers and financial data drives today's business world and Excel 2007: Financial Analysis can help decode this information. The proper understanding of these numbers, and the formulas behind them, can be the gateway to corporate and personal success. Microsoft MVP (Most Valuable Professional) Curt Frye teaches basic fluency in corporate finance,...
Author
Publisher
linkedin.com
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
Publisher
linkedin.com
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 syntax,...
Author
Publisher
linkedin.com
Pub. Date
2016.
Language
English
Description
Master Excel's financial functions. Find out how to calculate loan payments, depreciation, rate of return, and more, in Excel 2013.
Analyzing financial data can seem intimidating, but Excel 2013 has a wide range of functions that you can use to perform these analyses quickly and easily. This course shows users how and when to use each of the functions available to them in Excel 2013. Learn how to evaluate cash flows; calculate depreciation; determine...
Author
Publisher
linkedin.com
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,...
Didn't find it?
Can't find what you are looking for? Try our Materials Request Service. Submit Request