Inhalt: In this course, Dennis Taylor explores the functions, commands, and techniques in Excel that restructure data, remove unwanted characters, convert date data into the desired format, and prepare data for efficient analysis. This course helps get data from a business management system file, other database software, a text file, or a poorly designed Excel worksheet into optimal shape for working with in Excel. Umfang: 01:27:56.00
Inhalt: Need to get data from a business-management system file, database software, text file, or poorly designed Excel worksheet into optimal shape for Excel 2013? This course can help. Dennis Taylor explores the functions, commands, and techniques in Excel that restructure data, remove unwanted characters, convert data into the desired format, and prepare data for efficient analysis. He''ll cover adjusting row and column placement; transposing data with Replace and Substitute functions, the Text to Columns command, and the new Flash Fill; and formatting and converting text, numbers, and other values. Umfang: 01:59:53.00
Inhalt: In Excel 2007: Advanced Formulas and Functions, author and trainer Dennis Taylor demystifies some of the most challenging of the 300+ formulas and functions in Excel and shows how to put them to their best use. Dennis starts with a review of the more basic, building-block functions, and a few critical keyboard shortcuts that will speed up working with Excel data, even on multiple sheets. He then covers how to perform advanced searching and data retrieval with Lookup functions, tabulate and sort data with counting and statistical functions, format data with text and math functions, and even work with financial data using advanced formulas. Dennis focuses on practical examples that will help users easily transition to using these formulas and functions in real-world scenarios. Exercise files accompany this course. Umfang: 05:17:07.00
Inhalt: In this course, Dennis Taylor shows how to analyze and communicate the value of data with charts in Excel. The course starts with the foundations: what the parts of a chart are, what the different types of charts are, and which charts work best for your data. The course then shows how to create a presentation-ready chart in minutes and offers dozens of in-depth tutorials on formatting and fine-tuning charts so they represent data clearly and accurately. Umfang: 03:36:38.00
Inhalt: In Excel 2007: Data Validation in Depth, author Dennis Taylor shows how to use the data validation tools in Excel to control how users can input data into workbooks and ensure data is entered consistently and accurately. The course covers creating dropdown lists, preventing duplicate entries, and controlling the format of numeric data, dates and times, and text entered into worksheets. Exercise files are included with the course. Umfang: 00:58:31.00
Inhalt: In Excel 2007: Macros in Depth, author Dennis Taylor demonstrates common tasks for which macros are used, and walks through the process of creating and running simple macros. This course also covers more advanced topics, including making macros widely available through the Personal Macro Workbook, recording a macro in stages, absolute and relative recording, and using Visual Basic for Applications (VBA) for actions 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. Exercise files accompany the Umfang: 02:29:56.00
Inhalt: In Excel 2010: Advanced Formatting Techniques, author Dennis Taylor shares simple and powerful tips for making spreadsheet information readable and understandable, from emphasizing specific cells to adding style and readability to worksheets. It also covers automation techniques that take the drudgery out of formatting even the largest amounts of data. Exercise files accompany this course. Umfang: 03:02:49.00
Inhalt: In Excel 2010: Advanced Formulas and Functions, author Dennis Taylor demystifies formulas and some of the most challenging of the nearly 400 functions in Excel and shows how to put them to their best use. The course reviews the building-block functions, along with a few critical keyboard shortcuts that will speed up working with Excel data. It also covers how to perform advanced searching and data retrieval with LOOKUP functions, tabulate data with counting, statistical, and math functions, reformat data with text functions, and work with financial data using advanced formulas. Exercise files accompany the course. Umfang: 05:05:30.00
Inhalt: In this course, Dennis Taylor shows how to analyze and communicate the value of data with charts in Excel. The course starts with the foundations: what the parts of a chart are, what the different types of charts are, and which charts work best for your data. The course then shows how to create a presentation-ready chart in minutes and offers dozens of in-depth tutorials on formatting and fine-tuning charts so they represent data clearly and accurately. Umfang: 03:38:33.00
Inhalt: In Excel 2010: Data Validation in Depth, author Dennis Taylor shows how to use the data validation tools in Excel to control how users can input data into workbooks and ensure data is entered consistently and accurately. The course covers creating dropdown lists, preventing duplicate entries, and controlling the format of numeric data, dates and times, and text entered into worksheets. Exercise files are included with the course. Umfang: 00:59:38.00
Inhalt: In Excel 2010: Macros in Depth, author Dennis Taylor explains how macros can be used to automate tasks in Excel and walks through the process of creating and running simple macros. This course also covers advanced topics such as making macros widely available through the Personal Macro Workbook, recording a macro in stages, absolute and relative recording, and using Visual Basic for Applications (VBA) for actions 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. Exercise files are included with the course. Umfang: 02:44:17.00
Inhalt: In Excel 2010: Managing Multiple Worksheets and Workbooks, author Dennis Taylor shows how to share data between multiple worksheets and workbooks 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 worksheets, make super-efficient 3D 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:29:07.00
Inhalt: In Excel 2010 Power Shortcuts, Excel expert Dennis Taylor shares tips and shortcuts to vastly increase efficiency and get the full power out of Excel 2010. There are tips for working with the Ribbon and Quick Access toolbar, navigating workbooks and selecting cells, rapid data entry and editing, working with formulas, formatting data, working with charts, sorting data, and much more. Exercise files accompany the course. Umfang: 03:43:21.00
Inhalt: Conquer some of the most daunting features in Microsoft Excel once and for all. In this version of his popular course, designed specifically for Excel for Mac users, author Dennis Taylor demystifies some of the most challenging of the 300+ formulas and functions in Excel, and shows how to put them to their best use. Dennis covers key shortcuts, the IF and LOOKUP functions for search and data retrieval, the statistical and math functions, and the date, time, and text functions that make formatting easier. He also covers combining functions to extend their power. These practical examples transition effortlessly to real-world scenarios. Umfang: 06:13:51.00
Inhalt: Whether you're a novice or an expert wanting to refresh your skillset with Microsoft Excel, this course covers all the basics you need to start entering your data and building organized workbooks. Author Dennis Taylor teaches you how to enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and how to automate many of these tasks with macros. Umfang: 06:32:02.00
Inhalt: Increase your Excel productivity with the power user tips and tricks packed into this fast-paced course. Dennis Taylor will show you how to create formulas quickly, split data into columns, apply formatting, build charts, and fast-track routine data-entry chores. Short on time? Make sure to check out the "Top Ten Shortcuts" and "Ten Tiny Tips" chapters for a quick productivity boost. Start now and get an immediate return on your investment, with powerful techniques that will save you hours every week. Umfang: 04:34:14.00
Inhalt: Get simple, powerful tips for making spreadsheet information readable and understandable in Excel 2013. Dennis Taylor shows how to emphasize specific cells with fonts, borders, and color; adjust the positioning of cell contents; format numeric data; and add style and readability to worksheets. You'll also learn how to add pictures to worksheets and discover automation techniques that take the drudgery out of formatting even the largest amounts of data. Umfang: 02:58:46.00
Inhalt: Conquer some of the most daunting features in Microsoft Excel once and for all. In this 2013 update to his popular series, author Dennis Taylor demystifies some of the most challenging of the 300+ formulas and functions in Excel and shows how to put them to their best use. The course starts with a review of the more basic, building-block functions, and a few critical keyboard shortcuts that will speed up working with Excel data, even on multiple sheets. Dennis then covers how to perform advanced searching and data retrieval with Lookup functions, tabulate and sort data with counting and statistical functions, format data with text and math functions, and work with financial data using advanced formulas. Dennis focuses on practical examples that transition effortlessly to real-world scenarios. Umfang: 05:26:37.00
Inhalt: Charts allow you to communicate information visually, in a way that's more impactful than raw data, and they happen to be one of the most powerful and easy-to-use features in Microsoft Excel. Let Dennis Taylor show you how to create different kinds of Excel charts, from column, bar, and line charts to exploded pies, and decide which type works best for your data. 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: 03:46:18.00
Inhalt: Descubra este curso com dicas de produtividade e truques pouco conhecidas pela maioria dos usuários do Excel. Cada capítulo engloba um conjunto diferente de conceitos e ferramentas do software. Nele vamos ensinar a fazer de forma muito mais ágil tarefas frequentemente desempenhadas em grandes empresas. O resultado lhe proporcionará maior produtividade no seu trabalho e mais possibilidades na resolução de problemas. Umfang: 04:02:51.00
Inhalt: Esse curso possui uma abordagem focada nas principais ferramentas do Excel e na produtividade de profissionais por meio de execuções, atalhos e facilidades que são ensinadas ao longo das aulas. Serão desenvolvidas planilhas, análises e execuções em casos semelhantes ao dia a dia de profissionais. Umfang: 05:39:22.00
Inhalt: O treinamento fórmulas e funções avançadas do Excel 2013 consistem em demonstrar na prática a aplicação das principais fórmulas e funções do Excel. São centenas de funções distribuídas em 12 categorias diferentes. Não há como dominar o Excel sem conhecer minimamente o poder das suas funções. Neste treinamento são abordadas as principais funções para agregações de valores, cálculos condicionais e funções lógicas, cálculos estatísticos e matemáticos, manipulação de datas e hora, uso de referências relativas e absolutas e como depurar erros. Essencial para quem quer subir um degrau no uso do Excel no dia a dia. Umfang: 03:58:29.00
Inhalt: Na nossa nova economia, as empresas são orientadas por dados, e estes dados crescem a cada dia. Neste curso de Gestão e Análise de Dados, você vai aprender a aplicar conceitos simples em cenários realistas que representam desafios no dia a dia de muitas empresas. O Excel é a ferramenta ideal para gerir e analisar esses dados de uma forma simples, dinâmica e eficaz. Umfang: 01:34:05.00
Inhalt: Want to save time on routine tasks in Microsoft Excel? Macros are your answer. In this course, author Dennis Taylor explains how macros can be used to automate tasks in Excel, and how you can create simple macros of your own. Learn 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 mailing list data into a database-friendly format. Umfang: 02:43:17.00
Inhalt: Sometimes multiple worksheets or workbooks are the only solution to storing large amounts of data. But how do you analyze data that's spread out that way? In this course, author Dennis Taylor shows you how to move, copy, and analyze large amounts of data stored in multiple worksheets and workbooks in Excel 2013. Learn how to insert, delete, move, and copy data from multiple sheets; hide and un-hide sheets; and make global changes. Plus, discover how to create simple formulas that connect different worksheets, make super-efficient 3D formulas to calculate summary totals from multiple worksheets, and use PivotTables to summarize data from multiple workbooks. Umfang: 02:07:35.00
Inhalt: Most Excel users incorporate dates and times in their spreadsheets, but getting them to show up the way you want can be difficult. Excel expert Dennis Taylor shares his solutions for formatting and calculating dates and times in Excel 2013. This one-hour course explains what's going on behind the scenes when Excel stores dates and times, gives tips for entering them, and teaches the options for date and time formatting. It also demonstrates the various date and time functions and shows how to calculate with dates and times in a range of scenarios. Umfang: 01:35:31.00
Inhalt: Start mastering Excel, the world's most popular and powerful spreadsheet program, with Excel expert Dennis Taylor. Learn how to best enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data and cells, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and automating tasks with macros. Umfang: 08:53:04.00
Inhalt: Large amounts of data can become unmanageable fast. But with the data management and analysis features in Excel 2016, 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. He covers sorting, adding subtotals, filtering, eliminating duplicate data, and using the program's Advanced Filter feature and specialized database functions to isolate and analyze data. With these techniques, you'll be able to extract the most important information from your data, in the shortest amount of time. Umfang: 02:16:32.00
Inhalt: Get simple, powerful tips for making spreadsheet information readable and understandable in Microsoft Excel 2016. Dennis Taylor shows how to emphasize specific cells with fonts, borders, and color; adjust the positioning of cell contents; format numeric data; and add style and readability to worksheets. You'll also learn how to add pictures to worksheets and discover automation techniques (including conditional formatting) that take the drudgery out of formatting even the largest amounts of data. Umfang: 03:29:14.00
Inhalt: Excel expert Dennis Taylor demystifies some of the most useful of the 450+ formulas and functions in Excel and shows how to put them to their best use. Dennis starts with a review of the more basic functions (SUM, AVERAGE, and MAX), and a few critical keyboard shortcuts that will let you locate and display formula cells and accelerate working with Excel formulas-even on multiple sheets. He then covers how to find and retrieve data with the VLOOKUP and INDEX functions, calculate totals with counting and statistical functions, extract data with text functions, and work with date, time, array, math and information functions. The course focuses on practical examples that will help viewers easily transition to using Excel's most powerful formulas and functions in real-world scenarios. Umfang: 06:18:57.00
Inhalt: If you do a lot of work in Excel, you know that errors can easily creep into your data. And 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 making common mistakes. Dennis begins with the basics-how to display data so that errors can be easily spotted. Next, he offers handy tips to ensure data is entered correctly the first time, using the AutoFill feature and using AutoCorrect shortcut codes for frequently used entries. Dennis provides easy ways to validate your data, which is particularly helpful when multiple team members are contributing to the same spreadsheet. This includes restricting the data that can appear in a spreadsheet by setting value limits, pre-populating data with drop-down lists, and other methods. He also shows how to avoid mistakes in formulas, how to hide data that doesn't need to be seen, and how to use workbook protection to prevent errors, and more. Umfang: 01:44:13.00
Inhalt: Charts allow you to communicate information visually, in a way that's more impactful than raw data, and they happen to be one of the most powerful and easy-to-use features in Microsoft Excel. In Excel 2016, there are six brand-new chart types to learn. Let Dennis Taylor show you how to create different kinds of Excel charts, from column, bar, and line charts to exploded pies, and decide which type works best for your data. 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. Plus, get an overview of the new chart types in Excel 2016: Treemap, Sunburst, Waterfall, Histogram, Pareto, and Box & Whisker. The training wraps up with lesson on changing data sources for charts and printing and sharing charts. Umfang: 04:36:20.00
Inhalt: Excel's conditional formatting feature 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 brief course, Excel trainer Dennis Taylor walks you through how to apply and customize conditional formatting to quickly pinpoint variances in your data. Dennis begins with a demonstration of how to format based on cell content or formulas. Next, he shows how to go beyond Excel's default formatting (cell highlighting) by using data bars, icon sets, and color scales. Lastly, Dennis shows how to apply conditional formatting across rows, including how to highlight PivotTable results and incorporate check boxes and data validation pick lists to create dynamic visual displays. Umfang: 01:01:36.00
Inhalt: With Excel's data validation tools, you can control how users enter data into workbooks, ensuring that data is consistent and accurate. You can control dates, times, even the length of the text they enter, or simply provide a list of acceptable choices to eliminate any possible mistakes. Here, Dennis Taylor explores how the data validation tools in Excel 2016 can be used to set dropdown lists and control numeric, text, date, and time entries. Umfang: 01:34:57.00
Inhalt: Descubra neste curso dicas de produtividade e truques pouco conhecidos pela maioria dos usuários do Excel. Cada módulo engloba um conjunto diferente de conceitos e ferramentas do software. Nele vamos ensinar a fazer de forma muito mais ágil tarefas frequentemente desempenhadas em grandes empresas. O resultado lhe proporcionará maior produtividade no seu trabalho e mais possibilidades na resolução de problemas. Umfang: 04:01:47.00
Inhalt: O Excel é um dos softwares mais utilizados no mundo e saber trabalhar com ele pode realmente fazer diferença na produtividade e na performance de profissionais. Esse curso possui uma abordagem focada nas principais ferramentas do Excel 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: 05:27:44.00
Inhalt: O treinamento sobre fórmulas e funções avançadas do Excel 2016 consiste em demonstrar na prática a aplicação das principais fórmulas e funções do Excel. São centenas de funções distribuídas em 12 categorias diferentes. Não há como dominar o Excel sem conhecer minimamente o poder das suas funções. Neste treinamento é abordado as principais funções para agregações de valores, cálculos condicionais e funções lógicas, cálculos estatísticos e matemáticos, manipulação de datas e hora, uso de referências relativas e absolutas e como depurar erros. Essencial para quem quer subir um degrau a mais no uso do Excel no dia a dia. Umfang: 04:08:41.00
Inhalt: Neste curso, descreveremos e aprenderemos o básico a respeito de um dos programas mais completos e versáteis da suíte do Microsoft Office disponíveis no mercado: o Excel 2016. Desta forma, seremos capazes de lidar com as mais diversificadas fórmulas, cálculos e análises, variando das mais simples às mais complexas, através de comandos num programa simples, user-friendly, disponível na maioria dos micros do mundo. Esperamos que aprenda e desfrute deste aplicativo em seu maior potencial, da maneira que mais lhe convier, e que mais lhe traga benefícios. Umfang: 01:44:32.00
Inhalt: Macros can help you save enormous amounts of time, but they are uncharted territory for many Excel users. Learn how to create your own simple macros to automate repetitive tasks in Excel 2016, in this course with Excel expert Dennis Taylor. Find out 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 easily recorded. Discover how to expand macros with Do loops and If statements, and test macros step-by-step. The course wraps up with a macro project that brings together each of the elements in a real-world scenario: converting mailing list data into a database-friendly format. Umfang: 03:33:46.00
Inhalt: Large amounts of data can become unmanageable fast. But with the data management and analysis features in Excel 2016, 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. He covers sorting, adding subtotals, filtering, eliminating duplicate data, and using Excel's Advanced Filter feature and specialized database functions to isolate and analyze data. With these techniques, you'll be able to extract the most important information from your data, in the shortest amount of time. Umfang: 03:00:35.00
Inhalt: In this short, task-focused course, learn how to grapple with a common Excel problem: managing large amounts of data contained in multiple worksheets and workbooks. Follow Dennis Taylor as he takes you through how to move, copy, and link data across multiple worksheets. Dennis shares tips for adding, moving, and navigating worksheets and workbooks efficiently. He covers how to implement global changes, create formulas to connect worksheets and calculate data from multiple worksheets, and use PivotTables to summarize data from multiple workbooks. Umfang: 01:27:22.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 instructor Dennis Taylor and learn how to create a simple database. Dennis explains the key strengths of Excel as a data-management tool-and what it can and can't do-and spells out the design considerations you'll want to keep in mind as you create your database. Dennis also shows how to simplify database creation with tables and manage data with the built-in Form and Data Validation tools. Umfang: 00:53:03.00
Inhalt: Excel expert Dennis Taylor helps Excel 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 "10 Tiny Tips" chapter for a quick productivity boost. Umfang: 05:51:59.00
Inhalt: Getting dates and times to show up the way you want in an Excel spreadsheet can be tricky. In this concise course, Excel expert Dennis Taylor shares easy solutions for formatting and calculating dates and times in Excel 2016. Dennis explains what's going on behind the scenes when Excel stores dates and times, and offers tips for entering and formatting data. Next, he demonstrates how to work with dates and times in common Excel functions, and how to calculate data with dates and times. Finally, Dennis explains how to use dates and times with Excel commands, including working with data filters. Umfang: 01:57:23.00
Inhalt: Start mastering Excel, the world-renowned powerful spreadsheet program, with Excel expert Dennis Taylor. Learn how to enter data, organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of data and cells, build charts, and create PivotTables. Find out how to use the IF, VLOOKUP, and COUNTIF family of functions. See how to use data analysis tools, including Goal Seek and Solver. Discover how to automate tasks with macros, manage data, and more. Umfang: 02:08:31.00
Inhalt: Esse curso possui uma abordagem focada nas principais ferramentas do Excel na sua versão 2019 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: 01:59:14.00
Inhalt: Get up to speed with Microsoft Excel, the world's most popular spreadsheet program. Follow along with Excel expert Dennis Taylor as he demonstrates how to efficiently manage and analyze data with this powerful program. Learn how to enter and organize data, perform calculations with simple functions, and format the appearance of rows, columns, cells, and data. Other lessons cover how to work with multiple worksheets, build charts and PivotTables, sort and filter data, use the printing capabilities of Excel, and more. Umfang: 02:10:46.00
Inhalt: Learn how to use Excel for Mac 2011 to create different kinds of charts-from column, bar, and line charts to Gantt and exploded pie charts-and understand how to decide which type works best for your data. Plus, find out 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. Author Dennis Taylor also introduces analytical tools that will help you make sense of your data and a few dynamic controls that allow you to adapt your charts on the fly. Along the way, he provides tips and tricks to be more productive and efficient. Umfang: 04:18:56.00
Inhalt: This course features tons of tips to make Excel for Mac 2011 users more proficient and productive with the popular spreadsheet program. Learn the top shortcuts, find out how to most efficiently navigate and control the display, and discover the best ways to select, enter, and format data. The course also includes ways to leverage drag-and-drop features, shortcuts for formulas and operations, data management efficiency techniques, guidelines for working with charts efficiently, and a selection of quick tips. Umfang: 04:31:16.00
Inhalt: When it comes to Excel, appearances count. Get simple, powerful tips for making spreadsheet information more readable and understandable in Excel for Mac 2016. Dennis Taylor shows how to emphasize specific cells with fonts, borders, and color; adjust the positioning of cell contents; format numeric data quickly; use conditional formatting; and add style and readability to worksheets. You'll also learn how to add pictures to worksheets and discover power formatting techniques-such as shortcuts and a quick copy/paste technique-that take the drudgery out of formatting even the largest amounts of data. Umfang: 03:14:26.00
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
Inhalt: Take this fun and fast 5-day Excel challenge to test and build your Excel skills. The challenges are based on the questions that Excel expert Dennis Taylor encounters most often, and they grow progressively harder each day. For every challenge, Dennis offers a few different solutions, as well as useful time-saving shortcuts and tips. The challenges will ask you to: Generate a list of future dates Clean up a list of employee data Create a dynamic chart Create a pivot table to analyze sales data Match data across multiple lists Starter and solution files for Excel 2010, 2013, 365, and Excel for Mac 2011 are provided in the exercise files, so you can follow along with your version of Excel. Umfang: 00:41:44.00
Inhalt: In Excel 2007: Working with Dates and Times, Dennis Taylor shares his solutions for optimizing the use of dates and times in Excel 2007. This course explains what's going on behind the scenes when Excel stores dates and times, gives tips for entering dates and times, and shows options for date and time formatting. It also demonstrates the various date and time functions and shows how to calculate with dates and times in a range of scenarios. Exercise files are included with the course. Umfang: 01:27:45.00
Inhalt: In Excel 2010: Working with Dates and Times, Dennis Taylor shares his solutions for optimizing the use of dates and times in Excel 2010. This course explains what's going on behind the scenes when Excel stores dates and times, gives tips for entering dates and times, and shows options for date and time formatting. It also demonstrates the various date and time functions and shows how to calculate with dates and times in a range of scenarios. Exercise files are included with the course. Umfang: 01:20:48.00
Inhalt: Heute ist nicht gerade Jack Kernigans bester Tag. Erst ist er vom MIT geflogen und muss jetzt diesen langweiligen Lieferjob in Ohio machen. Und dann hat er gerade eben jemanden überfahren, oder ? etwas. Denn das, was da leblos am Straßenrand liegt, ist weder Mensch noch Tier. Ein Alien, ernsthaft? Kurz darauf entdeckt Jack mit seinen Freunden auch noch das Raumschiff ? und als sie einsteigen, beginnt für Jack das verrückteste, kosmischste Abenteuer seines Lebens. Umfang: 400 S. ISBN: 978-3-641-30273-3
Inhalt: Hundert Jahre ist es jetzt her, dass Bender sich auf den Weg zu den Sternen gemacht hat. Seither haben Bob und die Klone nichts mehr von ihm gehört. Bob ist fest entschlossen, eine Expedition in den Deep Space zu organisieren, um herauszufinden, was mit Bender geschehen ist, doch er hat ein gewaltiges Problem: Inzwischen sind seine Klone in der 24. Generation. Manche von ihnen haben sich so verändert, dass sie gar nicht mehr er selbst zu sein scheinen. Sie haben ihre eigenen Pläne. Und so droht über Bobs Suchaktion ein Bürgerkrieg zwischen den Klonen auszubrechen ... Umfang: 720 S. ISBN: 978-3-641-28016-1
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