VTC - Microsoft Excel 2003 for StatisticsRuntime: 8.5h | Work files incl | 407 mbMicrosoft Excel is the world's best-selling mathematical application, one that is installed on nearly every business computer out there. Although not a statistical application, Excel can perform many basic statistical tasks, from computing simple descriptive statistics such as mean and standard deviation, to complex regression analyses, chi-squared and t tests, and Analysis of Variance (ANOVAs). Join Mark and Beth Clarkson as they introduce you to the basics of statistics, statistical analysis, and statistical graphing with Microsoft Excel. Each step along the way is illustrated with real-world situations.
Video2Brain - Excel VBA in 14 Schritten (German) Schritt für Schritt zu Excel VBA 898 MBNach ersten Einheiten zu Entwicklungsumgebung und Syntax nehmen Sie die Programmierung von Excel in Angriff. Lernen Sie Excel zu steuern – von einer einzelnen Zelle über Arbeitsmappen bis zum gesamten Programm! Bald erstellen Sie eigene Funktionen mit Dialogen und Steuerelementen, die von Ereignissen gesteuert werden!
Formulas and Functions Microsoft Excel 2010Que | 2010 | 978-0789743060 | PDF | 25.6 MBMASTER CORE EXCEL 2010 TOOLS FOR BUILDING POWERFUL, RELIABLE SPREADSHEETS!Excel expert Paul McFedries shows how to use Excel 2010’s core features to solve problems and get the answers you need! Using real-world examples, McFedries helps you get the absolute most out of breakthrough Excel 2010 improvements–from Sparklines to the brand-new version of Solver. Along the way, you’ll discover the fastest, best ways to handle essential day-to-day tasks ranging from generating account numbers to projecting the impact of inflation.Becoming an Excel expert has never been easier! You’ll find crystal-clear instructions… insider insights… even complete step-by-step projects for building timesheets, projecting cash flow, aging receivables, analyzing defects, and more.
Microsoft Excel 2010 for Medical ProfessionalsCourse Technology | Jan 2011 | 978-0538748452 | PDF | 15.7 MBDesigned for students in medical office administration and allied health programs, MICROSOFT EXCEL 2010 FOR MEDICAL PROFESSIONALS teaches introductory Microsoft Excel 2010 skills. This book includes real world examples and projects within a case study related to the medical industry, providing you with the Excel skills necessary to successfully support the front or back office of a clinic, hospital, or medical practice.
Video2Brain - Excel 2011 fuer Mac Crashkurs GERMAN Der schnelle Weg zum Excel-KennerLaufzeit :2 1/2 hr | 425 MBDer schnelle Einstieg in Excel 2011. Dieser knapp dreistündige Crashkurs macht Sie zunächst mit der neuen Benutzeroberfläche vertraut. Anschließend lernen Sie, wie Sie die Möglichkeiten dieses Kalkulationsprogramms für Ihre Arbeit nutzen können. Nachdem Sie die grundlegenden Techniken verstanden haben, zeigt Ihnen Ihre Trainerin Rebekka Strauß, wie Sie mit Formeln arbeiten und Diagramme erstellen – alles schnell, kompakt anhand von Beispielen.
LiveLessons - Excel VBA and Macros Video Training61 Flv + 51 XLS spreadsheets includedEnglish | FLV | FLV 1119 kbps 30 fps | 320x180 | MP3 96 kbps 44 KHz | 1h27mns | 1.70 GBGenre: elearning* 7+ HOURS OF VIDEO INSTRUCTION* 50 TIPS & TECHNIQUES* SKILLS YOU CAN LEARN IN Fifteen MINUTES OR LESSIn Excel VBA and Macros with MrExcel, renowned Excel instructor and author Bill Jelen (MrExcel) teaches all the skills you'll need to automate virtually any routine task with Excel and build powerful Excel macros! This package brings together nearly eight hours hours of personalized, expert video training: 50 quick, practical video lessons that demonstrate all the skills you'll need to successfully use both the Excel macro recorder and the Visual Basic for Applications development environment. You'll learn one step at a time, at your own pace using hands-on examples that reflect realistic challenges and showcase Excel's remarkable capabilities. Along the way, Jelen will take you from the absolute basics through PivotTables and data filtering.
Lynd@com - Setting Up a Database in Excel Work files incl | 112 mbIn this course, author Dennis Taylor shows how to use Excel for creating 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. It also demonstrates using tables to simplify database creation as well as the Form and Data Validation tools to manage data. Exercise files are included with the course.Topics include:
Total Training - Microsoft Excel 2010 Essentials & AdvancedWork files incl | Duration: 7.2h + 6h608 mb + 539 mb
Lynda.com- Excel 2010 Pivot Tables in Depth 508 mb | work files incl | released: 4/19/2011In Excel 2010: Pivot Tables in Depth, author Curt Frye provides comprehensive, hands-on tutorials on Excel PivotTables, including more advanced techniques such as using macros and the new PowerPivot add-in. The course shows how to connect and consolidate data sources to power PivotTables, sort and filter records, display data in a PivotChart, print tables and charts, and also introduces the DAX language for performing advanced summaries in PowerPivot. Exercise files are included with the course.Topics include:
Lynda.com - Excel 2010 Power ShortCutswork files incl | 312 mbIn 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.Topics include:
Office 2010 Pro + Toolkit and EZ-Activator v 2.1.6 FinalPlatform: Windows | 752 mb
Lynda - Excel 2010: Advanced Formatting Techniqueswork files incl | 348 mblynda.com/Excel-2010-tutorials/advanced-formatting-techniques/74462-2.htmlIn 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.Topics include:
Lynda - Excel 2007: Data Validation in Depthwork files incl | 101 mblynda.com/Excel-2007-tutorials/Data-Validation-in-Depth/77849-2.htmlIn 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.Topics include:
Video2Brain - Excel VBA in 14 SchrittenSchritt für Schritt zu Excel VBAAlle Dateien inkl. |879 mbNach ersten Einheiten zu Entwicklungsumgebung und Syntax nehmen Sie die Programmierung von Excel in Angriff. Lernen Sie Excel zu steuern – von einer einzelnen Zelle über Arbeitsmappen bis zum gesamten Programm! Bald erstellen Sie eigene Funktionen mit Dialogen und Steuerelementen, die von Ereignissen gesteuert werden!Am Ende des Video-Trainings können Sie:
Lynda.com Excel 2007 Macros in DepthHF | 180 MB | Exercice files incl.lynda.com/home/DisplayCourse.aspx?lpk2=62643In 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 course
VTC - Microsoft Visual Basic for Excel TutorialsHF | 320.4MB vtc.com/products/Microsoft-Visual-Basic-for-Excel-tutorials.htmIn Visual Training Company's tutorial Microsoft Visual Basic for Excel, Pravah Pugh helps you get started by going over macros, the VBA programming language, and the VBA development environment. He then teaches you about the use and creation of functions for Visual Basic for Excel and how to access and save code. You will also learn about cell referencing, labels, names and much more.
Lynda.com - Excel 2007: Financial AnalysisHF | 131 MB | Exercise files incl.http://www.lynda.com/home/DisplayCourse.aspx?lpk2=52291Numbers and financial data drives today's business world and Excel 2007: Financial Analysis can help decode this information. The proper understanding of these numbers, and the formulas behind them, can be the gateway to corporate and personal success. Microsoft MVP (Most Valuable Professional) Curt Frye teaches basic fluency in corporate finance, enabling users to see the meaning behind essential financial calculations. Curt explains how to review formulas to ensure they have the proper inputs, and shows how to interpret formula output. He also covers how to calculate leverage ratios and amortization and depreciation schedules, as well as forecast future growth. Exercise files accompany this course.
Lynda.com - Excel 2007: Creating and Managing InvoicesHF | 52.6MB | Exercise files incl. http://www.lynda.com/home/DisplayCourseN.aspx?lpk2=58705In Excel 2007: Creating and Managing Invoices, Microsoft Most Valuable Professional Curt Frye shows how to set up an efficient and flexible invoice management system. As part of the instruction on how to design a custom invoice in Excel, Curt explains how to use a PivotTable to put each customer's information on its own worksheet. If Word is the preferred method for creating an invoice, Curt covers how to use Word 2007's Mail Merge function to work with an Excel sheet. He also outlines some advanced tips, including calculating interest on unpaid items and tracking invoices. Exercise files accompany the course.
Lynda.com - Excel: VBA in DepthHF | 161.7MB | Exercise files incl.www.lynda.com/home/DisplayCourse.aspx?lpk2=62906In Excel: VBA in Depth, Excel and VBA expert Curt Frye introduces object-oriented programming and shows how to automate routine tasks and provide custom functionality to enhance Excel performance and efficiency. This course introduces the Visual Basic for Applications programming language, covers creating subroutines and functions to hold code, and provides a solid grounding in the Excel 2007 object model. Programming techniques are demonstrated through real-world examples. Exercise files accompany the course.
Lynda.com- Excel 2010 Advanced Formulas and FunctionsWork files incl. | 453 mblynda.com/tutorial/75923-TrueIn 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.
|
