Inhalt: Excel is more than just a number cruncher. It's a Swiss Army knife that helps you work with data from anywhere-numbers, dates, times, text, and more. In this short course, Microsoft MVP Oz du Soleil shows how Excel can help solve real-world problems featuring any kind of information. Learn how Excel can be used in interesting, out-of-the-box ways: to manage property, calculate prices for a new product, simplify music arrangements, keep your kids on top of their chores, or even build seating charts for an event. There's nothing Excel can't do. So make it do more for you. Umfang: 00:42:32.00
Inhalt: Learn timesaving tips on using Power Query, also called Get & Transform, a data connection technology that simplifies gathering, connecting, combining, and refining data in Microsoft Excel and Power BI Desktop. Power Query is simple to use but can be especially powerful when you learn a few techniques. In this course, instructor Oz du Soleil demonstrates customizing your Excel environment, then dives into organizing your work. He offers strategies for working with queries including referencing, duplicating, and renaming queries. Finally, Oz shows how to approach tasks where Power Query works differently from Excel. Umfang: 00:51:36.00
Inhalt: You know your way around Excel? Want to put your skills to the test? This biweekly advanced Excel series with Excel MVP Oz du Soleil offers sophisticated exercises that can transform you into a bona fide power user. The challenges are drawn from Oz's real-world experience as a long-time Excel user, Excel trainer, and business intelligence consultant. Topics include formulas and functions, conditional formatting, pivot tables, Power Query, troubleshooting, and more. Note: Because this is an ongoing series, viewers will not receive a certificate of completion. Umfang: 01:41:02
Inhalt: There are countless books and courses that teach Microsoft Excel. However, true mastery requires practice. You have to apply what you've learned in order to make it stick. This series, with Excel MVP Oz du Soleil, provides weekly Excel challenges taken from Oz's experience helping clients with real-world problems. Each video begins with a challenge, such as inconsistent cell formatting, duplicate line items, or incomplete data. Pause the video and download the related exercise file to work out your own solution using the powerful features built into Excel. When you're ready, you can restart the video to see how Oz solves the challenge. In just a few minutes a week, you can learn the most popular and useful Excel formulas, functions, and features. Tune in every Friday for a new technique. Note: Because this is an ongoing series, viewers will not receive a certificate of completion. Umfang: 03:52:43.00
Inhalt: If you're a frequent user of Excel, chances are you have Excel tasks that you need to repeat often. Fortunately, you can automate these tasks by creating macros. Many people assume macros are complicated and reserved only for Excel power users. Not so! In this short course, Excel MVP Oz du Soleil first explains the best times to use a macro, and then how to use Visual Basic for Applications (VBA) to set up a basic macro in Excel to record your mouse clicks and keystrokes. Learn how to set up macros in Excel now, saving time later. Umfang: 00:37:07
Inhalt: Power Query is a feature in Excel that allows you to quickly import data from multiple sources and easily clean, transform, and reshape it to suit your needs. Follow along with Excel MVP Oz du Soleil as he shows you how to use this powerful, time-saving tool. Oz demonstrates how to import, merge, rearrange, and clean data, as well as how to repeat the process with one click if the data changes. Discover how to split columns, unpivot data, and use joins to merge, segment, and compare datasets. Oz offers dozens of techniques and tips in this comprehensive training. Umfang: 02:28:00.00
Inhalt: Learn how to build a super-charged Excel spreadsheet to help you and your team easily track any kind of data-sales transactions, inventory levels, project statuses, employee paid time off, student progress, household spending, and more. Follow along with Excel MVP Oz du Soleil as he shows how to create a basic spreadsheet and transform it into an effective tracking system for any kind of data that is regularly updated. Learn spreadsheet basics, as well as more advanced techniques such as writing formulas that check that information is complete, protecting and hiding sheets, and creating alerts for deadlines and bad data. Oz wraps up with a challenge that pulls together everything you've learned into a polished final project. Umfang: 01:29:59.00
Inhalt: In September 2018, Microsoft released a new family of functions in Excel called dynamic arrays. With dynamic arrays, a user can write one formula and get many different results. This allows users to build more robust spreadsheets, in less time, with fewer errors. Follow along with Excel MVP Oz du Soleil as he walks you through the new calculation engine and dynamic array functions. He walks through all seven functions-UNIQUE, SORT, SORTBY, SEQUENCE, FILTER, RANDARRAY, and SINGLE-showing practical, real-world uses for each one. Plus, learn how to use the spilled range operator (#) to reference a dynamic spill range. Oz concludes the course with a series of challenges so viewers can practice and master dynamic arrays. Umfang: 01:26:54.00
Inhalt: Excel scares a lot of people. Terms like PivotTables, VLOOKUP, and circular references make their heads spin. But once you have a basic grounding in Excel, you can do all these things and more. Follow along with Excel MVP Oz du Soleil in this fast-paced course, as he walks you through features, functions, and commands such as Freeze Panes, Flash Fill, COUNTIFS, and even VLOOKUP. Oz takes the bite out of the most intimidating features in Excel, so you can get more mileage every time you use it. Umfang: 00:34:42.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. 889 Zugriffe im Mai 2024. Insgesamt 511.119 Zugriffe seit Januar 2009
Mobil - Impressum - Datenschutz - CO2-Neutral