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
Programm Findus Internet-OPAC findus.pl V20.235/8 auf Server windhund2.findus-internet-opac.de,
letztes Datenbankupdate: 08.05.2024, 18:40 Uhr. 846 Zugriffe im Mai 2024. Insgesamt 511.076 Zugriffe seit Januar 2009
Mobil - Impressum - Datenschutz - CO2-Neutral