Curt Frye
Author
Summary
Learn to use Excel functions for financial analysis. Find out how to calculate loan payments, depreciation, rate of return, and more, in Excel 2016.
Analyzing financial data can seem intimidating, but 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 2016. Author Curt Frye covers evaluating loan payments; calculating...
Author
Summary
Learn what you need to know to analyze and display data using Tableau 2022. 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
Summary
Learn how to summarize and analyze data using one of the most powerful and overlooked features in Excel for Mac: PivotTables.
Learn to quickly summarize, sort, and analyze data with one of the most overlooked features in Microsoft Excel for Mac: PivotTables. Follow along with Curt Frye as he shows you how to gain more valuable insights from your data-demystifying the complexity of PivotTables while demonstrating their power. Curt shows how to build...
Author
Summary
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
Summary
Learn how to work with functions and formulas in Microsoft Excel. This course covers creating formulas, managing named ranges and tables, importing, exporting, and more.
Starting to build a spreadsheet from a blank worksheet is less intimidating if you are familiar with functions and how to create formulas in Excel. This course covers creating formulas, managing named ranges and tables, importing, exporting, validating data, and more. Learn how to...
Author
Summary
Demonstrates how to build various arithmetic and statistical analysis formulas and use Excel's built-in functions.
Excel 2007: Introduction to Formulas and Functions shows how to build impressive spreadsheets with the application's built-in capabilities. Excel expert and Microsoft Most Valuable Professional Curt Frye shares his vast knowledge of Excel, demonstrating how to build various arithmetic and statistical analysis formulas. Curt explains...
Author
Summary
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
Summary
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
Summary
Learn to summarize, sort, count, and chart your data with PivotTables in these Excel tutorials.
Join Curt Frye as he explains how to leverage PivotTables to summarize, sort, count, and chart your data in Microsoft Excel. Curt shows you how to navigate the complexity of PivotTables while taking advantage of their power. This course shows how to build PivotTables from single or multiple data sources, add calculated fields, filter your results, and...
Author
Summary
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
Summary
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
Summary
Learn what you need to know to analyze and display data using Tableau 2021. 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
Summary
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
Summary
Discover how to use Excel to create a balanced scorecard to measure business performance based on financial, process, customer, and learning and growth metrics.
Discover how to use Excel to create a balanced scorecard to measure business performance based on data available throughout your organization. This course shows intermediate Excel users how to capture metrics related to the financial, process, customer, and learning and growth aspects of...
Author
Summary
Learn how to analyze and display data. Discover how to install or connect to Qlik Sense, import and summarize data, create and manipulate data visualizations, and create dashboards.
Qlik Sense is a cloud-based data analytics solution that helps businesses gain valuable insights into their data. In this course, learn how to analyze and display data using this powerful platform. Instructor Curt Frye shows how to install or connect to Qlik Sense, import...
Author
Summary
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
Summary
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
Summary
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
Summary
Provides comprehensive, hands-on Excel tutorials on PivotTables, and more advanced techniques such as using macros and the new PowerPivot add-in.
In Excel 2010: Pivot Tables in Depth, author Curt Frye provides comprehensive, hands-on tutorials on Excel PivotTables, including more advanced techniques such as using macros and the new PowerPivot add-in. The course shows how to connect and consolidate data sources to power PivotTables, sort and filter...
Author
Summary
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...