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
Programm Findus Internet-OPAC findus.pl V20.235/8 auf Server windhund2.findus-internet-opac.de,
letztes Datenbankupdate: 08.05.2024, 18:40 Uhr. 905 Zugriffe im Mai 2024. Insgesamt 511.135 Zugriffe seit Januar 2009
Mobil - Impressum - Datenschutz - CO2-Neutral
