Inhalt: Track, analyze, and then forecast sales efficiently and accurately using Microsoft Excel. This course focuses on essential features and best practices that sales professionals can use. Learn how to import your sales data into Excel. Then, see how to clean up that data by removing redundancies, fixing incorrect information, and applying formatting. Next, step through the various methods of analyzing sales data in Excel, from filtering and sorting to using Quick Analysis and slicers. Additionally, explore how to create a leaderboard, spot trends, forecast sales, create dashboards, and more. Join instructors and Excel trainers Chris "Smitty" Smith and Dave Ludwig as they draw on decades of combined sales experience to show you how to make the most of this powerful software. Umfang: 02:42:52.00
Inhalt: Did you know Excel enables you to zero in on exactly the data you need with the click of a mouse? In this short course, Microsoft Excel content publisher Dave Ludwig shows the ins and outs of filtering in Excel. He shows how to filter for text, numeric values, and ranges of data. Dave also shows how to filter with color coding, and how to use advanced filtering options such as slicers and shortcuts. Advance your Excel skills in minutes with this mini course. Umfang: 00:29:57.00
Inhalt: PivotTables don't have to be scary! This powerful Excel feature cuts the time you spend on formulas in half. In this concise course, Excel trainer Dave Ludwig demystifies PivotTables and shows you how to get started using them to analyze your data. Dave begins by explaining two PivotTable basic building blocks: value fields and row fields. Then he shows you how to adjust a PivotTable by adding fields, filters, and formatting. Finally, Dave shows you how to use special filter buttons which are known as slicers, and he also demonstrates how to use timelines. At the end, he goes over the basics of refreshing and updating a PivotTable. Umfang: 00:23:52.00
Inhalt: If even a small part of your job entails using Microsoft Excel, there's a good chance that at some point you've received a spreadsheet where the data is unorganized, disconnected, or generally not in great shape. And despite common practice, a long, heavy sigh is not officially part of any recommended Excel workflow. Rather than pull your hair out at the mess of data you see before you, you can use Power Query in Excel to help you import and clean data into something easier to work with. In this course, Excel expert Dave Ludwig takes you through the robust features set of Power Query. Dave shows you how to use Power Query to connect to your data source, filter data, and create conditional columns of data. He also shows off the significant cleansing capabilities of Power Query. Once your data is cleaned up, you can more easily create formulas, PivotTables, charts, and generally get on with your business. Umfang: 00:24:10
Programm Findus Internet-OPAC findus.pl V20.235/8 auf Server windhund2.findus-internet-opac.de,
letztes Datenbankupdate: 09.05.2024, 14:13 Uhr. 964 Zugriffe im Mai 2024. Insgesamt 511.194 Zugriffe seit Januar 2009
Mobil - Impressum - Datenschutz - CO2-Neutral