Inhalt: Microsoft Access est un logiciel puissant de gestion de bases de données que vous pouvez rendre encore plus performant. Pour cela, découvrez ce cours et créez des applications personnalisées qui utilisent le langage VBA (Visual Basic for Applications). Lydia Provin, formatrice en e-learning et programmeuse informatique, vous présente des exemples concrets et détaillés afin de tirer le meilleur parti du langage de programmation et d'améliorer l'expérience des entreprises ainsi que des utilisateurs. Umfang: 04:28:39
Inhalt: 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 programming language. Discover how to automate tasks with macros, work in the Visual Basic Editor, and write functions. Plus, learn about adding logic, reading data, controlling forms, and more. Umfang: 04:37:17.00
Inhalt: 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 power from the program. Learn how to create reports using the Design Wizard, link to multiple data sources, work with sections, sort and group data, use report templates, format reports and individual fields, summarize data, visualize data using charts, focus analysis by selecting which data a report summarizes, display data in subreports and cross-tab reports, and export data. Umfang: 04:06:52.00
Inhalt: The Database Clinic series shows how to plan, build, and optimize databases using different software. This course focuses on Microsoft Excel. While Excel doesn't offer traditional relational database management features, its table-based sheets, functions links, and powerful search and reporting features make it a great tool for learning the basics of database design. Join Curt Frye as he shows how to create a simple database, join data sets, search for records, and perform CRUD (create, read, update, and delete) operations. Plus, learn how to use Excel's calculations, PivotTables, functions, and formulas to gain deeper insights into your data. Umfang: 01:52:36.00
Inhalt: 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 calculating averages and standard deviations, charts and graphs for summarizing data, and the Analysis ToolPak add-in for even greater insights into data. Exercise files are included with the course. Umfang: 04:19:04.00
Inhalt: 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, enabling users to see the meaning behind essential financial calculations. Curt explains how to review formulas to ensure they have the proper inputs, and shows how to interpret formula output. He also covers how to calculate leverage ratios and amortization and depreciation schedules, as well as forecast future growth. Exercise files accompany this course. Umfang: 02:18:02.00
Inhalt: 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 how to summarize values in sets of cells, create conditional formulas using IF and other related functions, and use validation rules to make data entry more accurate. He even teaches how to search for data within a list or table using the VLOOKUP and HLOOKUP functions. Exercise files accompany this course. Umfang: 02:26:33.00
Inhalt: In Excel 2007: Pivot Tables for Data Analysis, Microsoft Most Valuable Professional Curt Frye helps dispel the common fear of the Pivot Table feature, by demonstrating how to use this powerful tool to discover valuable business intelligence. Curt shows how to create Pivot Table reports from internal Excel data and outside data sources, use filters to focus on the most important data in the sheet, and make visual presentations of data using Pivot Chart reports. Exercise files accompany this course. Umfang: 02:45:17.00
Inhalt: In this course, author Curt Frye shows how to perform a wide range of financial calculations quickly and easily using the many financial functions found in Excel 2010. The course details dozens of functions for evaluating cash flows; calculating depreciation; determining rates of return, bond coupon dates, and security durations; and more. Umfang: 02:18:17.00
Inhalt: 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 records, display data in a PivotChart, print tables and charts, and also introduces the DAX language for performing advanced summaries in PowerPivot. Exercise files are included with the course. Umfang: 03:43:40.00
Inhalt: 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 rates of return, bond coupon dates, and security durations; and more. Umfang: 02:38:02.00
Inhalt: 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 format your layout to make it more readable. Plus, learn how to enhance PivotTable with macros, DAX expressions, and the PowerPivot add-in for analyzing millions of rows of data. Umfang: 04:20:00.00
Inhalt: Discover over 65 tips, tricks, and shortcuts in Microsoft Excel. In this course, Curt Frye reveals how to invoke commands, manage and organize data, and build formulas in Excel. Curt shares his power shortcuts for saving time on basic tasks, from entering data and selecting cell ranges to summarizing data with charts and tables and quickly finding information. Umfang: 03:16:54.00
Inhalt: Aprenda a usar tabelas dinâmicas para fazer análises complexas, montar resumos gerenciais e extrair informações estratégicas de bases de dados extensas. Conheça as principais aplicações e ferramentas do Excel para potencializar uma tabela dinâmica convencional, tais como gravação de macro, integração com Access e Power Pivot. Do nível básico ao intermediário, ensinamos tudo o que é essencial saber sobre tabela dinâmica para uma perfomance acima da média na sua empresa. Umfang: 04:02:22.00
Inhalt: 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 costs when placing an order. Curt Frye shows how to apply them to calculate capacity, identify what resources are idle and underutilized, determine optimum batch size, and calculate the right number of products to manufacture and the correct quantity to order to maximize cost savings. These are the kinds of business decisions that business analysis tools like Excel were built for! Learn how to use it to help your organization run at an entirely new level of productivity. Umfang: 01:25:08.00
Inhalt: 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 depreciation; determining rates of return, bond coupon dates, and security durations; calculating prices and yields; and more. Umfang: 02:38:04.00
Inhalt: 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 maintain the integrity of your original data, audit your formulas for correctness, and adjust values to be able to calculate how to reach outcome goals. Umfang: 02:58:26.00
Inhalt: Learn how to use PivotTables to summarize, sort, count, and chart your data in Microsoft Excel 2016. Author Curt Frye 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 format your layout to make it more readable. Plus, learn how to create PivotCharts to visualize your data, enhance PivotTables with macros, and use the Data Model feature to build PivotTables from related tables. Umfang: 03:42:27.00
Inhalt: Aprenda a usar tabelas dinâmicas para fazer análises complexas, montar resumos gerenciais e extrair informações estratégicas de bases de dados extensas. Conheça as principais aplicações e ferramentas do Excel para potencializar uma tabela dinâmica convencional, tais como gravação de macro, integração com Access e Power Pivot. Do nível básico ao intermediário, ensinamos tudo o que é essencial saber sobre tabela dinâmica para uma perfomance acima da média na sua empresa. Umfang: 02:34:12.00
Inhalt: Excel 2019 is a powerful tool, but it can be intimidating for new users who don't know where to start or how to proceed beyond the most basic tasks. In this course, Curt Frye provides training on all the essential tasks in the Mac version of this robust spreadsheet program. Learn how to manipulate workbook and cell data, use functions and formulas, and print worksheets. Curt also acquaints you with some more advanced techniques, including how to create a variety of charts, work with external data and objects, and create PivotTables. Umfang: 04:42:18.00
Inhalt: In Excel for Mac 2011 Essential Training, author Curt Frye gives a comprehensive overview of Excel, the full-featured spreadsheet software from Microsoft. The course covers key skills such as manipulating workbook and cell data, using functions, automating actions, printing worksheets, and collaborating with others. Exercise files accompany the course. Umfang: 06:32:34.00
Inhalt: Learn everything you need to master the Mac 2016 version of the world's most popular spreadsheet program. Curt Frye provides a comprehensive overview of Excel for Mac 2016, including manipulating workbook and cell data, using functions, printing worksheets, and collaborating with others. In the last half of the course, he covers more complex techniques, such as summarizing data with charts, working with external data, adding images and shapes, and automating routine tasks. Umfang: 06:23:42.00
Inhalt: Learn how to summarize, sort, and analyze your data in using one of the most overlooked features in Microsoft Excel for Mac 2016: PivotTables. Author Curt Frye shows you how to gain more valuable insights from your organization's data-demystifying the complexity of PivotTables while demonstrating their power. His tutorials show how to build PivotTables from Excel workbooks or external data sources, add calculated fields, filter results, and format your layout to make it more readable. Plus, learn how to use conditional formatting to intelligently highlight cells, apply color scales, create data bars, and share your PivotTable results in printouts or via PDF. Umfang: 02:03:10.00
Inhalt: 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 dates and times, creating and managing useful formulas, and summarizing data using charts and pivot tables. Find the solution you need to fix a specific problem or speed up a certain task, or watch all 60+ tips to become an Excel power user. Umfang: 02:41:45.00
Inhalt: 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 Frye shows how to manage workbooks, work with cells and cell data, and sort, filter, and manage worksheets. Plus, learn how to summarize data using core functions and formulas; format worksheet elements; create bar, column, and line charts; work with external data and objects; create and filter PivotTables; and share your spreadsheets with others. Umfang: 04:36:17.00
Inhalt: 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 Frye shows how to manage workbooks, work with cells and cell data, and sort, filter, and manage worksheets. Plus, learn how to summarize data using core functions and formulas; format worksheet elements; create bar, column, and line charts; create and filter PivotTables; and share your spreadsheets with others. Umfang: 03:53:54
Inhalt: 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 PivotTables from Excel workbooks or external data sources, add calculated fields, filter results, and format your layout to make it more readable. Plus, learn how to use conditional formatting to intelligently highlight cells, apply color scales, and format cells using data bars, as well as how to create and format PivotCharts. Note: This course was recorded in Office 365 for Mac. However, much of the content will be useful to those working with Office for Mac 2019 and 2016. Umfang: 02:07:35.00
Inhalt: 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 example transportation problem, Curt steps through creating a reference to the Solver VBA library, recording and running a Solver macro, generating random inputs, and defining a loop structure to run multiple simulations. Then he moves on to enabling detailed analysis by writing model output, creating a results dashboard to analyze your model output, exploring alternative scenarios with a Solver model, and more. Umfang: 00:54:59
Inhalt: 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 those minimum orders cost. Curt goes into how to evaluate quantity discounts and how to calculate production quantities to maximize profit. He discusses how back orders affect inventory policies and how to calculate the economic order quantity for inventory policies that allow back orders. He introduces you to difficulties associated with goods that have a limited lifespan, often called the newsvendor problem, then shows you how to generate the data and summaries required to solve a newsvendor problem. In conclusion, Curt walks you through how to calculate the base stock level for a target level of service and how to calculate a reorder point based on cycle service level performance. Umfang: 01:20:23
Inhalt: Microsoft Excel can be a secret advantage when it comes to solving complex supply chain challenges. Follow along with instructor Curt Frye as he shows how to use the Excel Solver add-in to minimize transportation and transshipment costs within a supply chain. Curt covers a range of topics, including how to analyze fixed costs and facility opening decisions, enforce level of service constraints, and perform scenario analysis. He also provides problem scenarios for you to solve, then goes through the solutions for each. After watching this course and working through the examples, you'll be able to describe the techniques specialized supply chain programs use to arrive at their results. Umfang: 01:55:49
Inhalt: Automate complex tasks and get more meaningful insights from data in Excel using Visual Basic for Applications (VBA) code. This course extends the techniques taught in Up and Running with Excel VBA, showing members how to work more efficiently in this powerful and popular spreadsheet program. Curt Frye shows how to focus in on important data, with filters; manage workbooks and worksheets; access built-in functions; create charts; and build UserForm interfaces for data entry. Umfang: 03:13:16.00
Inhalt: Automate complex tasks and get more meaningful insights from data in Excel using Visual Basic for Applications (VBA) code. This course demonstrates how to work more efficiently in this powerful and popular spreadsheet program. Curt Frye shows how to focus in on important data, with filters; manage workbooks and worksheets; access built-in functions; create charts; build UserForm interfaces for data entry; and manage PivotTables using Excel VBA. Umfang: 03:46:33
Inhalt: 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 variables. In this course, Curt Frye demonstrates how to build simulations of increasing complexity, which model the flow of customers through a multi-station process. Learn how to calculate arrival times, add customers, increase individual station capacity, and enable conditional station paths. At the end of the course, Curt shows how to convert output to an Excel table and analyze the results of your simulation. Umfang: 02:27:46.00
Inhalt: 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, and determine how much interest you can save by paying extra principal each month. Plus, he explains how to calculate net present value and internal rate of return, and shows how to create a cash tracking worksheet, where you can keep a record of income, expenses, and your current cash balance. Umfang: 01:16:24.00
Inhalt: 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 of the most powerful data analysis tools in Excel. He also shares how to define conditional formats and summarize your data with sparklines and charts. Plus, he shows how to set up your dashboard worksheet, link data to cells and shapes, maximize your screen space by hiding rows, and modify the Excel program window to meet your needs. Umfang: 01:31:23.00
Inhalt: 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 depreciation; determining rates of return, bond coupon dates, and security durations; calculating prices and yields; and more. Note: This course was recorded in Office 365, but anyone using a recent version of Excel-including 2019, 2016, and some earlier versions-will be able to follow along. Umfang: 02:35:12.00
Inhalt: 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 their business and display them in an easy-to-understand visualization built entirely in Excel. Instructor Curt Frye provides an overview of balanced scorecards, including the four perspectives and related key performance indicators (KPIs). He then shows how to ingest data from various sources and levels of the organization into dashboards that summarize overall performance, using popular Excel features such as PivotTables and conditional formatting. Umfang: 01:04:09.00
Inhalt: 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 features. Instructor Curt Frye shows how to create formulas with mathematical operations such as addition, subtraction, multiplication, and division, and how to use cell references in your formulas. He explains how to summarize data with functions like SUM and AVERAGE, and work with data in named ranges and Excel tables. Curt also covers procedures to ensure data integrity, such as data validation, and demonstrates auditing techniques to ensure formulas are correct. Plus, get an introduction to the What-If Analysis toolset, in an example that combines scenarios, data tables, and Goal Seek to generate accurate revenue projections. Note: This course was recorded on Excel for Office 365. Most of the course contents will also be useful to those working with the most recent standalone versions of Office, including Office 2019 and 2016. Umfang: 02:34:03.00
Inhalt: Many Excel users have a fear of PivotTables. This course provides a thorough introduction to this powerful and overlooked feature and, for more advanced students, shows how to use macros and the data model to extend PivotTables even further. Instructor Curt Frye demystifies PivotTables, using real-world examples that empower students to make the most of their time with the program and to analyze their data effectively. Learn how to evaluate and summarize data, sort and filter results, format your PivotTables with styles and conditional formatting, and visualize your analysis with PivotCharts. Note: This course was recorded in Office 365. However, anyone using Excel 2019, Excel 2016, and even prior editions of Excel should be able to follow along with the course contents. Umfang: 03:38:12.00
Inhalt: 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 a series of business scenarios using the flexible and powerful capabilities built into Excel. The course starts with a chapter on the art and craft of scenario planning before turning to the technical capabilities of Excel. Tools covered include row grouping to show and hide detail, PivotTables, and functions for using the normal distribution. Umfang: 02:07:25.00
Inhalt: 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 of defective output, number of defects, and variability of process outputs. He shows how to perform the analysis, plot the data, and interpret the results of each technique. He also how to examine processes from the customer''s perspective using process capability analysis. Business analysts and support staff who help prepare documents, as well as executives and senior managers who might not have a statistical background, will use the skills in this course to analyze their organizations'' processes and output. Umfang: 01:14:52.00
Inhalt: 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 calculating measures for various subprocesses, such as process time, cycle time, process utilization, and information flow time, and visualize the results in PowerPoint or other tools. By the end of the course, you will have a basic understanding of value stream maps and be able to create them using these popular Office apps. Umfang: 00:44:35.00
Inhalt: 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, and more. Learn how to use references and named ranges; apply mathematical functions to multiply, round, and count values; identify outliers and rank values; calculate investments and loan payments; determine dates and times; look up values based on multiple criteria; and summarize arrays of data. Umfang: 03:11:43.00
Inhalt: 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 display exactly the information you need. Umfang: 00:53:13.00
Inhalt: Learn how to use Excel's built-in data management and computation functions to identify clusters of data points-with little or no VBA! Author Curt Frye shows you how to set up a worksheet for cluster analysis, create formulas that identify the closest focal point (centroid) for each row, and analyze your results in an Excel table or XY scatter chart. Members who don't mind recording macros or writing VBA code can learn how to automate some parts of the procedure. Umfang: 01:09:20.00
Inhalt: 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 problems with Solver. The last two chapters show you how to create a configurable model with sliders and check boxes and how to run a Monte Carlo simulation. Umfang: 01:10:34.00
Inhalt: 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 such as mean, median, and standard deviation, and provides an introduction to the central limit theorem. He then shows how to visualize data, relationships, and future results with Excel''s histograms, graphs, and charts. He also covers testing hypotheses, modeling different data distributions, and calculating the covariance and correlation between data sets. Finally, he reviews the process of calculating Bayesian probabilities in Excel. Each chapter includes practical examples that show how to apply the techniques to real-world business problems. Umfang: 02:09:41.00
Inhalt: 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 international agencies such as the World Bank and United Nations. Plus, he goes over data search engines, web services, and even language resources like the Ngram Viewer for Google Books. Upon wrapping up this course, you''ll be better equipped to find the information you need for your scholarship and data analysis efforts. Umfang: 02:01:18.00
Inhalt: 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 this powerful program. Curt covers creating subroutines and functions to hold code, and provides a solid grounding in the Excel object model. Programming techniques are demonstrated through real-world examples. Exercise files accompany the course. Umfang: 03:14:32.00
Inhalt: Learn how to analyze data using the Mathematica 11 environment and language. In this course, Curt Frye shows how to set up Mathematica notebooks, find help, assign values to variables, import data into Mathematica, and research your results using Wolfram;Alpha. He also explains how to create and manipulate lists, analyze data using descriptive statistics, perform matrix calculations, create and debug Mathematica scripts, and plot your data using the capabilities built into Mathematica 11. To wrap up, he demonstrates how to convert files into the Computable Document Format (CDF), add animation to make your results more interactive, and get started with the Wolfram Cloud. Umfang: 03:19:52.00
Inhalt: 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 how to prepare data for machine learning, including how to replace values near zero with zero and sort elements using a rule. Curt also covers determining functions that generate data and performing supervised machine learning tasks. Umfang: 01:15:51.00
Inhalt: 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 the program before describing essential analytical skills performed using MATLAB. Instructor Curt Frye covers creating MATLAB scripts, accepting user input, extending MATLAB with user-defined functions, controlling flow with conditional logic and loops, managing text strings and other data structures like numbers, performing advanced plotting, and summarizing data using statistical analysis functions. By the end of the course, data scientists such as engineers and economist should be able to effectively use MATLAB for numerical analysis, data modeling, and data visualization. Umfang: 03:15:39.00
Inhalt: 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 using Solver. He also takes you through how to optimize investment portfolios by setting rules that limit the risk you're willing to take on, as well as how to change a model's parameters to analyze various scenarios. Plus, Curt shares how to define decision trees, represent a tree in an Excel table, and calculate the probability of reaching a node in your decision tree. Umfang: 01:43:14.00
Inhalt: 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, including adding quiz questions, assigning point values to questions, and adjusting quiz options. Once you've learned to create a basic survey or quiz, you can learn how to edit forms, share them with other users, adjust themes, and preview how your form will look on different platforms. Finally, Curt shows how to view and analyze your results. Umfang: 01:25:58.00
Inhalt: Office Online (formerly known as Office Web Apps) is the web-based version of Office, for collaborating on the go. In this course, Office expert Curt Frye shows viewers how to create, edit, and share Microsoft Word, Excel, PowerPoint, and OneNote documents using Office Online. He explains how to manage files in OneDrive, format text in Word, build worksheets and charts in Excel, present slideshows from anywhere with PowerPoint, and collect notes for meetings with OneNote. Plus, Curt covers the unique sharing and collaboration features of Office Online, which combines the best aspects of the cloud with the power of Microsoft Office. Umfang: 03:11:02.00
Inhalt: 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 and summarize data, create an app from a data source, and create and manage tables. He also steps through how to manage Qlik Sense sheets, which provide a canvas you can fill with data, charts, and other visualizations. Plus, learn how to create and manipulate a variety of data visualizations, from bar charts to histogram charts; create PivotTables and reports; sort and filter data; and combine your app''s sheets with objects, text, and images to create a story that clearly conveys your message. Umfang: 02:47:53.00
Inhalt: Social Network Analysis Using R teaches analysts how to visualize and analyze data from a social network like Twitter or Facebook with the text-based statistical language, R. If you're involved in analytics in any capacity, this course will be a huge help, teaching you how the R sna and igraph modules works and how to format data for analysis, create graphs, analyze network graphs, and visualize networks. Join instructor Curt Frye and learn how to examine the relationships and trends among networks in new and exciting ways, and discover information about how individuals in an organization interact. Umfang: 01:06:54.00
Inhalt: Learn how to use Solver, a free Excel add-in, to find optimal solutions to problems with multiple constraints, including linear and nonlinear mixtures, transportation problems, and scheduling conflicts. Along the way, author Curt Frye shows how to organize Excel worksheets for use with Solver, add and swap data, and set each problem's criteria in Solver. In the final chapter, you'll learn how to analyze Solver's results, create scenarios, and change parameters by hand. Umfang: 02:18:57.00
Inhalt: Um dos principais recursos do Excel para análise de dados é a Tabela Dinâmica. Desde o seu lançamento, a tabela dinâmica vem sendo atualizada e melhorada. A versão atual da suite de aplicativos Office (2019) apresenta melhorias que trarão a todos os analisadores dados melhorias que facilitarão bastante a criação de relatórios, dashboards e informações gerenciais rápidas e dinâmicas, permitindo uma tomada de decisão mais assertiva. Aprenda a utilizar corretamente a disposição dos campos para análise, cruze informações, inclua segmentação de dados, análise de linha de tempo e faça cálculos com campos e itens sem ter que alterar os dados originais, criando fórmulas em suas tabelas de dados. Umfang: 03:12:29
Inhalt: 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: Essential Training explains everything you need to know to analyze and display data using Tableau Desktop-and make better, more data-driven decisions for your company. After completing the course, you'll be able to install Tableau, connect to data sources, summarize data, and create, manipulate, and share data visualizations, including highlight tables, charts, scatter plots, histograms, maps, dashboards, and more. Umfang: 04:41:15.00
Inhalt: 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, and shares how to create a calculated field and an ad hoc calculation. He then covers how to summarize data using aggregate functions, explaining how to calculate the sum of a collection of values, as well as the average, minimum, and maximum of a set. He also discusses working with times and dates, creating conditional calculations, implementing level of detail expressions, and more. Umfang: 03:24:39.00
Inhalt: 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 strengths of R with the visualization power of Tableau to analyze and present data more effectively. Instructor Curt Frye demonstrates how to install R and RServe; create a connection between Tableau and R; perform several types of analyses in R, from linear regression to cluster identification; and incorporate those analyses into Tableau visualizations. Umfang: 02:27:46.00
Inhalt: 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 display data using Tableau Desktop 2019-and make better, more data-driven decisions for your company. Discover how to install Tableau, connect to data sources, and sort and filter your data. Instructor Curt Frye also demonstrates how to create and manipulate data visualizations-including highlight tables, charts, scatter plots, histograms, maps, and dashboards-and shows how to share your visualizations. Umfang: 04:30:20.00
Inhalt: 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. In this course, learn how to analyze and display data using Tableau 2021-and make better, more data-driven decisions for your company. Instructor Curt Frye shows how to install Tableau, connect to data sources, and sort and filter your data. Curt uses real-world examples to demonstrate how to create and manipulate data visualizations-including highlight tables, charts, scatter plots, histograms, maps, and dashboards-and shows how to share your visualizations. Umfang: 04:10:39
Inhalt: 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 display data using Tableau Desktop-and make better, more data-driven decisions for your company. Discover how to install Tableau, connect to data sources, and sort and filter your data. Instructor Curt Frye also demonstrates how to create and manipulate data visualizations-including highlight tables, charts, scatter plots, histograms, maps, and dashboards-and shows how to share your visualizations via the web. Umfang: 04:18:13.00
Inhalt: 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 display data using Tableau 2020-and make better, more data-driven decisions for your company. Discover how to install Tableau, connect to data sources, and sort and filter your data. Instructor Curt Frye also demonstrates how to create and manipulate data visualizations-including highlight tables, charts, scatter plots, histograms, maps, and dashboards-and shows how to share your visualizations. Along the way, he highlights the new features packed into this edition of the software, including Viz Animations, which allows you to visually follow the movement of marks in a data visualization to see and understand your changing data. Umfang: 04:36:44.00
Inhalt: O Tableau é uma ferramenta de análise e visualização de dados amplamente utilizada que muitos consideram indispensável para o trabalho relacionado à ciência dos dados. Sua interface de arrastar e soltar facilita a classificação, comparação e análise de dados de múltiplas fontes, incluindo Excel, SQL Server e repositórios de dados baseados em nuvem. Neste curso, aprenda o que você precisa saber para analisar e exibir dados usando o Tableau e tome decisões melhores e mais orientadas a dados para sua empresa. Descubra como instalar o Tableau, conectar-se às fontes de dados e classificar e filtrar seus dados. Aprenda a criar e manipular visualizações de dados - incluindo tabelas de destaque, gráficos, gráficos de dispersão, histogramas, mapas e painéis de controle - e a compartilhar suas visualizações. Umfang: 04:30:32
Inhalt: 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 how casinos make money, design their games, offer comps to customers, and expand their revenue streams through dining, golf, entertainment, and other attractions. He also reviews fantasy sports, comparing low-stakes leagues such as the NCAA tournament bracket to daily competitions where players gamble real money. Umfang: 01:30:31.00
Programm Findus Internet-OPAC findus.pl V20.236/8 auf Server windhund2.findus-internet-opac.de,
letztes Datenbankupdate: 17.05.2024, 12:10 Uhr. 2.976 Zugriffe im Mai 2024. Insgesamt 513.206 Zugriffe seit Januar 2009
Mobil - Impressum - Datenschutz - CO2-Neutral