Inhalt: Conquer some of the most daunting features in Microsoft Excel: formulas and functions. In this Excel for Mac 2016 update to his popular series, author Dennis Taylor presents numerous formulas and functions in Excel and shows how to use them efficiently. The course begins with tips and keyboard shortcuts to accelerate the way you work with formulas within one or multiple worksheets. Dennis then covers how to perform logical tests with the IF, AND, OR, and NOT functions; search and retrieve data with lookup functions (VLOOKUP, MATCH, and INDEX); analyze data with statistical functions; use text functions to clean up worksheets; work with array formulas and functions, and master date and time calculations. Dennis focuses on practical examples that transition effortlessly to real-world scenarios. Start watching to take advantage of the tremendous power offered by Excel formulas and functions. Umfang: 06:54:03.00
Inhalt: Charts allow you to communicate information visually, with greater impact than tables or raw data. They also happen to be one of the most powerful and easy-to-use features in Microsoft Excel for Mac. Let Dennis Taylor show you how to create different kinds of Excel charts, from column, bar, and line charts to doughnuts and scatter charts, and decide which type works best for your data. Learn how to fine-tune your chart's colors and style; add titles, labels, and legends; insert shapes and pictures; and pull data from multiple sources. Along the way, Dennis offers shortcuts and tips for being more productive and efficient. Umfang: 04:22:06.00
Inhalt: Macros-automated actions or sets of actions in Excel-can spare you some of the tedium associated with repetitious command sequences and data manipulation tasks. In this course, learn how to create and use macros to automate tasks in Excel 2016 for Mac. Discover when it's appropriate to use macros, how to create macros by recording keystroke and command sequences, and how to expand a macro for more than one task. Learn how to launch macros with keystroke shortcuts and buttons, record a formatting macro and alter VBA code, and expand macro functionality with If statements and interactive techniques. Plus, watch the step-by-step execution of macro code. Umfang: 01:29:00.00
Inhalt: Excel expert Dennis Taylor helps Excel for Mac 2016 users take their spreadsheet skills to the next level with this collection of tips and tricks. He begins with his top 10 productivity boosters, and then highlights navigation, display, and selection techniques to keep you moving quickly. The course then dives into data entry and editing techniques, formatting and drag-and-drop tricks, keyboard shortcuts for working with formulas, data management strategies, and chart tricks. Short on time? Make sure to check out the "Ten Tiny Tips" chapter for a quick productivity boost. Umfang: 05:27:07.00
Inhalt: Looking to master all the formulas and functions available in Excel for Mac? In this comprehensive course, Dennis Taylor presents numerous Excel formulas and functions and shows how to use them efficiently. Dennis begins with tips and keyboard shortcuts to accelerate the way you work with formulas within one or multiple worksheets. He then covers how to perform logical tests with the IF, AND, OR, and NOT functions, search and retrieve data with lookup functions (VLOOKUP, XLOOKUP, MATCH, and INDEX), analyze data with statistical functions, use text functions to clean up worksheets, work with array formulas and functions, and master date and time calculations. If you're looking to up your formulas and functions skills in Excel, join Dennis as he uses practical examples that transition effortlessly to real-world scenarios. Umfang: 02:18:14
Inhalt: This tips-based course will show Excel users productivity-boosting tricks, cool hidden features, need-to-know functions, and advanced content on subjects such as using PivotTables for data analysis. Tune in every Tuesday for a new tip from expert Dennis Taylor. Each tutorial is a short, self-contained lesson guaranteed to give you new insights into Excel. Note: Because this is an ongoing series, viewers will not receive a certificate of completion. Umfang: 30:09:04.00
Inhalt: View simple, powerful tips for making Excel data more readable and easier to manipulate. Author Dennis Taylor shows you how to emphasize individual cells with fonts, borders, and colors; adjust the position of cell contents; format numeric data; and increase the readability of worksheets. You can also learn how to add images to worksheets and discover automation techniques that can take the drudgery out of formatting even large amounts of data. Umfang: 01:46:27.00
Inhalt: Follow along with Excel expert Dennis Taylor as he demystifies the hundreds of formulas and functions available in Excel. Dennis starts with a few critical formula shortcuts that will speed up your work, then covers a variety of functions, such as VLOOKUP, MATCH, and INDEX, statistical functions, text functions, and date and time, math, text, and information functions. Dennis provides practical examples to help viewers easily transition to using Excel's most powerful formulas and functions in real-world scenarios. Note that this course is recorded in Excel for Office 365 but anyone using a recent version-including 2019, 2016, and 2013-will be able to follow along. Umfang: 04:35:35.00
Inhalt: If you work in Excel, you know that even a small error can have big consequences, throwing off important calculations or transmitting incorrect information to your team. In this concise course, Excel expert Dennis Taylor provides quick and easy tips to help you avoid common mistakes. Dennis begins with the basics-how to display data so that errors can be easily spotted, enter data correctly the first time, and apply shortcuts for frequent entries. Dennis provides easy ways to protect worksheets and validate your data-techniques that are particularly helpful when multiple team members are contributing to the same spreadsheet. He also shows how to correctly use row and column references and avoid mistakes in formulas. Umfang: 00:45:23.00
Inhalt: Excel charts allow you to communicate information with much more impact than raw numbers and are surprisingly easy to generate. Instructor Dennis Taylor shows you how to create different kinds of Excel charts, from column, bar, line and pie to more recently introduced types like Treemap, Funnel, and Pareto. He explains what types of data work best with each so you can decide which type to choose for your specific information. Plus, learn how to fine-tune your chart's color and style; add titles, labels, and legends; insert shapes, pictures, and text boxes; and pull data from multiple sources. Umfang: 02:36:54.00
Inhalt: Conditional formatting sounds more complicated than it is. This powerful tool in Microsoft Excel allows you to highlight data based on cell contents, making it easy to spot trends and patterns and emphasize key results. Though this process can be quick and easy, many Excel users don't know how to use conditional formatting to its fullest potential. In this short course, Excel trainer Dennis Taylor walks you through how to apply and customize conditional formatting to quickly pinpoint variances in your data. Learn how to use all the rules and options, such as data bars and icon sets, and apply conditional formatting across many rows of data. Umfang: 00:34:17.00
Inhalt: Este é um curso para quem já utiliza o Microsoft Excel, porém precisa aumentar a velocidade de trabalho através de um uso mais eficiente dos recursos que a ferramenta oferece. Através de um conjunto amplo de dicas focadas nas tarefas mais frequentes do dia a dia de trabalho com planilhas, ao terminar este curso você será capaz de poupar muitas horas de trabalho repetitivo ou manual, mesmo sem ter que entrar em detalhes de programação. Ao começar este curso, você verá que já nas primeiras aulas, com apenas algumas das dicas, você já vai passar a poupar tempo na frente do computador. Umfang: 04:41:55
Inhalt: Learn the basics of Excel charts and graphs in this concise course. Excel expert Dennis Taylor begins by explaining Excel chart concepts, including identifying the different elements of a chart and choosing the right chart type. Next, Dennis walks through creating a basic chart, using the Recommended Charts feature and keyboard shortcuts to get the job done quickly. Dennis then covers formatting charts with styles, colors, and more. Finally, he steps through the most popular chart options: column, bar, and line charts. Note that this course is recorded in Excel for Office 365 but anyone using a recent version-including 2019, 2016, and 2013-will be able to follow along. Umfang: 00:56:03.00
Inhalt: Get a quick crash course in Excel formatting to make your spreadsheets more readable and compelling. Dennis Taylor shows the basics of formatting in Excel, including how to emphasize data with fonts, borders, and colors. Learn how to adjust the formatting of numbers, dates, and times; create value-based conditional formatting; adjust rows and columns without commands; and easily copy and even paint formatting across multiple cells. Umfang: 00:59:27.00
Inhalt: Microsoft Excel offers a variety of powerful lookup functions that allow you to easily retrieve information across spreadsheets. In this course, Excel expert Dennis Taylor demystifies some of the most significant lookup functions. Tune in to learn how to use the new XLOOKUP function, which can handle all the capabilities of the widely used VLOOKUP and HLOOKUP functions, in addition to providing more power and flexibility. Explore uses of the MATCH function and the newer, more robust XMATCH function to match up data, and learn how to extract data using the INDEX function. Discover how to restructure the lists being searched to ensure that you're using each function efficiently, and learn about dynamic array lookup functions like UNIQUE, SORT, SORTBY, and FILTER. Along the way, Dennis shares practical examples that help you grasp how to implement these functions in your workflow. Umfang: 01:08:47
Inhalt: Learn about how to use macros to automate tasks in Excel and see how to create simple macros of your own. Veteran Excel trainer Dennis Taylor shows how to record a macro in stages, share macros between workbooks, set up keyboard shortcuts to run macros quickly, and use Visual Basic for Applications (VBA) to code macros that can't be recorded. The course wraps up with a macro project that brings together each of the elements in a real-world scenario: converting a mailing list into a database-friendly format. Umfang: 02:04:31.00
Inhalt: Did you know you can use Excel to create a simple database and get even more insights into your data? Join instructor Dennis Taylor and learn how to create a simple database. Dennis explains how to prepare lists that are suitable for data analysis. He goes into how to use the Form tool to view and manage records in a list, then covers how to use the Data Validation command to enter data quickly and accurately. Dennis steps through how to convert data to a table and use its many valuable features. He discusses the Table Design tab, demonstrating how to access the many formatting features to apply to tables. He demonstrates how to expand tables quickly and easily by adding adjacent rows and columns, as well as total rows. Dennis highlights some techniques for creating formulas using field names. He concludes by showing you how to use slicers to filter data with appealing, easy-to-read visuals. Umfang: 00:47:26
Inhalt: O curso Excel: Técnicas Avançadas de Formatação traz um conteúdo voltado especialmente aos usuários que já conhecem os recursos básicos de formatação no Excel e que precisam ir além na melhoria visual de suas planilhas. Através de exemplos práticos, acompanhados de um material de apoio, você vai aprender detalhes da formatação que além de permitirem o refinamento do seu trabalho na ferramenta, permitirão ainda que você o faça de maneira muito mais produtiva e sem a necessidade de ser um profissional de Design. Este curso abordará diferentes aspectos de formatação de fontes, tópicos especiais sobre o uso de cores em trabalhos profissionais que possibilitarão uma melhor exibição de seus dados, seja através de um melhor ajuste ou da personalização deles. Você vai aprender, por exemplo, a modificar a exibição escalas de números em milhares e criar na tela unidades de medida personalizadas, podendo ainda alterar as cores do seu trabalho automaticamente. Este curso vai levar o seu conhecimento sobre formatação no Excel a um novo patamar. Umfang: 02:14:09
Inhalt: Want to take your Excel game to the next level? In this course, veteran Excel trainer and instructor Dennis Taylor shares powerful tips, tricks, and shortcuts that can help you leverage more of what Excel has to offer. Learn time-saving tricks for creating formulas rapidly, accelerating data entry, and navigating within worksheets efficiently. Plus, discover drag and drop techniques, formatting shortcuts, charting and PivotTable tips, and much more. Note: This course was recorded on Excel for Office 365; however, most of the contents will benefit anyone using Office 2019 or 2016. Umfang: 04:20:03.00
Inhalt: Dados brutos ou apenas informações podem não transmitir a informação de forma apropriada. Gráficos são recursos visuais que facilitam a interpretação desses dados. Além disto, eles são um recurso muito poderoso e fácil de usar, que faz parte do Excel desde suas primeiras versões. Neste curso vamos analisar a maior parte dos gráficos existentes e ainda analisar os seis gráficos novos que foram implementados na versão 2016 do aplicativo. Este é um curso adaptado do instrutor Dennis Taylor e você verá como utilizar recursos dos gráficos de coluna, barra e linha, pizza, além de aprender a manipular seus componentes e recursos. Depois de ver esse curso você conseguirá avaliar qual o melhor gráfico para a análise que estiver desenvolvendo. Aprenda como ajustar a cor e o estilo do seu gráfico; adicionar títulos, rótulos e legendas; insira formas, figuras e caixas de texto, além de extrair dados de várias fontes. Praticando todos os conceitos abordados neste curso você conseguirá criar excelentes gráficos, além de imprimí-los e compartilhá-los. Umfang: 03:43:23
Inhalt: In this course, Dennis Taylor shares easy-to-use database commands and methods for maintaining an Excel database. The course covers sorting, adding subtotals, auto-filtering, and using the Excel Advanced Filter feature and specialized database functions. Umfang: 01:32:12.00
Inhalt: Large amounts of data can become unmanageable fast. But with the data management and analysis features in Excel, you can keep the largest spreadsheets under control. In this course, Dennis Taylor shares easy-to-use commands, features, and functions for maintaining large lists of data in Excel 2019 and Excel for Office 365. He covers sorting, adding subtotals, filtering, eliminating duplicate data, working with tables, and using functions to isolate and analyze data. With these techniques, you'll be able to better manage your lists and extract the most important information from them, in the shortest amount of time. Umfang: 02:30:40.00
Inhalt: In Excel 2007: Managing Multiple Worksheets and Workbooks, author Dennis Taylor shows how to move and copy data to multiple worksheets and gives tips for adding, moving, and navigating worksheets and workbooks efficiently. This course covers how to make global changes, create simple formulas that connect different worksheets, make super-efficient 3-D formulas to calculate summary totals from multiple worksheets, and use pivot tables to summarize data from multiple workbooks. Exercise files accompany the course. Umfang: 01:12:33.00
Inhalt: Esse curso possui uma abordagem focada nas principais ferramentas do Excel em ambiente Office 365 e na produtividade de profissionais por meio de execuções, atalhos e facilidades que são ensinadas ao longo das aulas. São desenvolvidas planilhas, análises e execuções em casos semelhantes ao dia a dia de profissionais. Umfang: 02:09:53.00
Inhalt: Excel isn't just for flat files. You can use it to create a simple database and get even more insights into your data. Join author Dennis Taylor and learn how to create a simple database. The course explains the limits of Excel as a data-management tool and spells out the design considerations for creating a database with it. Dennis also shows how to simplify database creation with tables and manage data with the Form and Data Validation tools. Umfang: 00:49:17.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.972 Zugriffe im Mai 2024. Insgesamt 513.202 Zugriffe seit Januar 2009
Mobil - Impressum - Datenschutz - CO2-Neutral