Catalog Search Results
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
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
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
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
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....
Didn't find it?
Can't find what you are looking for? Try our Purchase Suggestion Service. Submit Request