Inhalt: Using Excel, you can optimize reporting for Access databases. Learn how to build powerful dashboards to visualize your data, using tools such as slicers, timelines, charts, and PivotCharts. Instructor Robin Hunt shows how to analyze, query, and export Access data for use in Excel, and connect directly to Access from Excel, so that you always have a live view of your data. Then learn how to build dashboards with slicers, timelines, and charts, and create macros that make your dashboards more user friendly. By the end of the course, you should be able to extend your current reporting capabilities and create more engaging visualizations. Umfang: 01:52:14.00
Inhalt: Take your Excel and Access skills to the next level by learning how to create interactive dashboards users will find attractive and easy to use. Instructor Robin Hunt shows you how to use these two programs in combination to create queries, macros, slicers, and more. Learn how to generate charts, graphs, and other appealing data visualizations that can update in real time as the dashboards collect and display information, giving your users an experience they'll appreciate. Umfang: 01:47:55.00
Inhalt: What happens when you combine Excel and Access? You get the best of both programs. Learn how to use Excel 2013 to get the most out of Access 2013 and save time building database solutions and running reports. Robin Hunt shows how to import and link to Excel data, run calculations in Excel and Access, build forms and reports in both programs, and automate tasks with macros, including the AutoExec startup macro in Access. These techniques are the key to better personal productivity data systems. Start watching now. Umfang: 01:46:14.00
Inhalt: By combining the power of Microsoft Excel and Access 2016, you can build better end-user solutions and greatly enhance your own personal productivity. In this course, learn how to leverage Excel and Access, and get the most out of both tools working together. Robin Hunt shares strategies and techniques that can help you work smarter with these two programs, and avoid needing to manually rebuild each time you run reports by building solutions. Robin kicks off the course by reviewing how Excel and Access can be used together, and explaining how to build tables and calculate data in these two programs. She also explains how to work with imports and exports, automate using macros and the AutoExec, build forms and reports, and more. Umfang: 02:19:07.00
Inhalt: By combining the powers of Microsoft Excel and Access 2019, you can automate repetitive Excel tasks and boost your personal productivity. In this course, learn strategies and techniques that can help you work smarter with Excel and Access, and avoid needing to manually rebuild each time you run reports by building solutions. Discover how to most effectively leverage these two programs, and get the most out of both tools working together. Robin kicks off the course by reviewing how Excel and Access can be used together, and explaining how to build tables and calculate data in these two programs. She also demonstrates how to work with imports and exports, automate using macros and the AutoExec, build forms and reports, and more. Umfang: 02:29:12.00
Inhalt: Every person who works with data has to perform analytics at some point. This popular training course-dramatically expanded and enhanced for 2018-teaches analysts and non-analysts alike the basics of data analytics and reporting. Robin Hunt defines what data analytics is and what data analysts do. She then shows how to identify your data set-including the data you don't have-and interpret and summarize data. She also shows how to perform specialized tasks such as creating workflow diagrams, cleaning data, and joining data sets for reporting. Coverage continues with best practices for data analytics projects, such as verifying data and conducting effective meetings, and common mistakes to avoid. Then learn techniques for repurposing, charting, and pivoting data. Plus, get helpful productivity-enhancing shortcuts and troubleshooting tips for the most popular data analytics program, Microsoft Excel. Umfang: 01:39:38.00
Inhalt: It's one thing to work with data. It's another to provide quality data sets and accurate visualizations for decisions to be made. If you are considering a course emphasis or a career in data analytics, this course can help you get off to a good start. Robin Hunt, CEO and co-founder of ThinkData Solutions, shares practical skills to help you get the most from your data and jumpstart your career in data. Robin discusses business rules, filtering out the noise in the data we all deal with, and how to deliver what decision-makers want. She covers how to create data sets with queries, joins, and appends, then goes into building aggregate data with total queries. Robin goes over pivots, how to use pivots to build basic dashboards and visualizations, and how to use Power Query for data transformations. She concludes with best practices for meetings and taking your work to the next level for your organization. Umfang: 03:23:21
Inhalt: Are you interested in pursuing a career in data analytics? In this course, instructor Robin Hunt brings you into the mind of an analyst. She defines and explains foundational concepts, such as how to think about data, how to work with others in different roles to get the data you need, and the tools you need to work with data, such as Excel and Microsoft Access. She introduces you to SQL queries, PowerBI, and more. Robin goes into syntax and explains how to interpret the data you see, find the data you need, and clean the data for effective data work. She explains data governance and how to ask the right questions of different departments to gather the data you need. Robin shows how to work with data, including how to import data, work with flat files such as CSVs, and create datasets for others. Robin goes into what cleaning and modeling mean, as well as how to use Power Query in Excel. She has also added challenge/solution sets in each chapter to help you evaluate your skills. Umfang: 03:29:38
Inhalt: Using the user-friendly data input features of SharePoint Online-along with an Access database-you can build business apps that mobilize workflows and create easy-to-manage databases. In this course, learn how to integrate Access with SharePoint to make data-rich applications. Instructor Robin Hunt shares strategies and techniques that can help you work smarter with these two programs. Robin explains how to align data between SharePoint and Access and set up alerts from Access. She also covers how to build forms and reports for your integration-including how to create views that recreate some of your most valuable reports; how to build views for data in SharePoint; how to generate Excel reports for SharePoint; and how to finalize a database for production. Umfang: 02:19:55.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. 902 Zugriffe im Mai 2024. Insgesamt 511.132 Zugriffe seit Januar 2009
Mobil - Impressum - Datenschutz - CO2-Neutral