Excel Web-based Seminars

Data Integration for Data Mining with Talend Open Studio OS This course covers the many data integration procedures necessary to create a Customer Analytic Record (CAR) suitable for data mining operations. Talend OS is an Open Source tool; the client version is available for free download. The Talend company charges for the client/ server version of the tool and any support required for its installation and use. Data integration tools like Talend perform  more...

Data Manipulation Techniques ...inging in different types of files (SPSS, SAS, txt, dat., excel, use the ODBC, etc); Clean data and address such issues as missing data, duplicate entries, outliers; Reshaping, aggregating, merging data; Performing such tasks as looping, vectors, beginning automations with macros specific to data manipulation. Primarily syntax will be used, but where helpful to those learning syntax, some GUI  more...

Introduction to Statistics Using Common Software Packages ...e-up of results. This course is available in SPSS, SAS or Excel. Our courses are offered in three formats a resident course at our office, a corporate course on location of the company or a location of their choosing, and remote (online) courses. Resident Course: Date: This course is run twice a month but can be conducted at different times during the week; contact us for arrangements.  more...

Mastering Microsoft Excel PivotTables Turn the tables on data analysis [WEBINAR] ...Excela ™s most powerful analysis tools - PivotTables ®. Youa ™ll learn what PivotTables are, how they work and how YOU can tailor them to fill your needs. Herea ™s a small sample of what youa ™ll learn: a how to take advantage of the calculation power of PivotTables. a how to create complex data comparisons. a how to quickly drill-down to specific  more...

Introduction to Visual Basic for Applications (VBA) In this introductory Visual Basic for Applications (VBA) training course, you will learn how to manipulate objects in Word, Access and Excel with VBA. Specifically, you will learn how to use the Visual Basic editor, work with the object model, create and use variables, and use the selection structure.Each lesson of the class begins with a general overview of a feature and then shows how that  more...

Introduction to Microsoft Excel 2003 Training In this introductory Microsoft Excel 2003 training course, you will learn to create and edit basic Microsoft Office Excel 2003 worksheets and workbooks. This course was designed for students desiring to gain the skills necessary to create, edit, format, and print basic Microsoft ® Excel 2003 worksheets.  more...

Intermediate and Advanced Microsoft Excel 2003 Training ...Excel 2003 training course, you will learn to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.This course was designed for students who need the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the Web. In this advanced Microsoft Excel 2003 training course, you will automate some  more...

Introduction to Microsoft Excel 2007 Training This Microsoft Excel training course is designed for students new to working with Microsoft Excel 2007. Students will learn to use Excel to create, modify and format Excel worksheets, perform calculations, and print and Excel workbooks.  more...

Intermediate and Advanced Excel 2007 Training ...Excel training course is designed for students with some experience working with Microsoft Excel 2007. You will learn to apply visual elements and advanced formulas to a worksheet to display data in various formats. In addition, you will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data  more...

Excel 2007: VBA Programming Training This VBA programming for Excel 2007 training course is designed to give experienced Excel users proficiency in creating procedures that run in response to specific events, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code.  more...

SharePoint 2007 Development Training This advanced SharePoint training class focuses on the SharePoint Developer and targets developers who need to customize SharePoint at a core level. The course focuses on Windows SharePoint Services 3.0 (WSS) fundamental building blocks such as features, application pages, site pages, Web Parts, custom list types, site columns, content types, custom workflows and site definitions. You will also  more...

Microsoft Business Intelligence from SQL 2008 through SharePoint and Office 2007 This Business Intelligence (BI) training class provides students with the knowledge and skills to develop Microsoft End-to-End business solutions using SQL Server 2008 in an integrated environment with SharePoint and Office 2007. The BI class introduces students to Microsoft Unified Data Model, SQL Server 2008 Analysis Services, Integration Services, Reporting Services, Report Builder 2.0,  more...

Introduction to Microsoft Access 2003 Training This Microsoft Access training course is designed for students who wish to learn the basic operations of the Access 2003 database program to perform their day-to-day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes. The introductory Access course is for the individual whose job responsibilities include working with  more...

Intermediate Microsoft Excel 2003 Training In this intermediate Microsoft Excel 2003 training course, you will learn to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas. This course was designed for students who need the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the Web.  more...

Intermediate Microsoft Excel 2003 Training In this intermediate Microsoft Excel 2003 training course, you will learn to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas. This course was designed for students who need the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the Web.  more...

Advanced Microsoft Excel 2003 Training ...Excel 2003 training course, you will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create PivotTables and  more...

Advanced Microsoft Excel 2007 Training In this advanced Microsoft Excel 2007 training course, you will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.  more...

SQL Server 2005 Analysis Services (SSAS) Training In this SSAS training course, you will learn how to use Microsoft SQL Server 2005 Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions.This SSAS course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server 2005 developer  more...

Excel Spreadsheet Validation to Eliminate 483s - GlobalCompliancePanel This interactive webinar provides explicit details and live demonstration followed by a collaborative workshop that explains how to configure and validate a GxP compliant spreadsheet application. Tuesday, March 20, 2012 10: 00 AM PST | 01: 00 PM EST  more...

Excel Spreadsheet Validation for FDA 21 CFR Part 11 - Webinar By GlobalCompliancePanel This webinar will describe the regulatory and business requirements for Excel spreadsheets, using examples from FDA recommendations. It will then cover the design and installation of those Excel Spreadsheets, to ensure the integrity of the data, and will discuss how to ensure 21 CFR 11 compliance during the development, installation and maintenance of a spreadsheet application. Tuesday,  more...

Excel Spreadsheet Validation to Eliminate 483s - Webinar GlobalCompliancePanel This interactive webinar provides explicit details and live demonstration followed by a collaborative workshop that explains how to configure and validate a GxP compliant spreadsheet application. Tuesday, January 10, 2012 10: 00 AM PST | 01: 00 PM EST  more...

Excel Spreadsheets and FDA Device Regulations - Webinar By GlobalCompliancePanel This seminar helps you understand the FDA device regulations related to Excel spreadsheets. These spreadsheets can be automated processes and create electronic records. Both of these aspects are regulated by the FDA, so device manufacturers must understand the regulations and how to apply them. Thursday, October 20, 2011 10: 00 AM PDT | 01: 00 PM EDT  more...

Excel Spreadsheet Validation to Eliminate 483 - Webinar By GlobalCompliancePanel This interactive webinar provides explicit details and live demonstration followed by a collaborative workshop that explains how to configure and validate a GxP compliant spreadsheet application. What makes this session unique is the combination of step-by-step instructions and the hands on workings of each participant. Bring your laptop and use Excel for yo  more...

Excel Spreadsheet Validation to Eliminate 483s by gcp This interactive webinar provides explicit details and live demonstration followed by a collaborative workshop that explains how to configure and validate a GxP compliant spreadsheet application.  more...

Excel Spreadsheets Step-By-Step Instructions for Compliance - Webinar By GlobalCompliancePanel ...n workings of each participant. Bring your laptop and use Excel for your own needs. This session will make you a better Excel user, saving you time and costs. Areas Covered in the Session: * Develop spreadsheet applications that are GxP compliant. * Avoid 483s and warning letters. Critical data, such as laboratory information and other GxP data, is often recorded in spreadsheet  more...

WorkPlace Skills A set of skills that are essential to success in the work life. These are very basic and fundamental skills one should possess to be successful in job selection or to succeed in his/ her work atmosphere. 1. Email and Telephone etiquette 2. Using MS Excel 2007 / 2010 3. Using MS Word 2007 / 2010 4. Using MS PowerPoint 2007 / 2010 5. Using emails - Webmails, Outlook etc., 6.  more...

Excel Spreadsheets and FDA Device Regulations - Webinar by GlobalCompliancePanel ...elps you understand the FDA device regulations related to Excel spreadsheets. These spreadsheets can be automated processes and create electronic records. Both of these aspects are regulated by the FDA, so device manufacturers must understand the regulations and how to apply them. The seminar begins with Excel methods to help ensure the spreadsheet produces the results you want. We explain  more...

Validating Excel and Word Applications Documents - Webinar By GlobalCompliancePanel ...slate to common software applications programs, e. g., MS-Excel and MS-Word, or similar. How can these be verified and validated? Company quality data must be more "science based". What V&V (verification and validation) planning steps are expected under the CGMPs and other guidance documents for such apps software? How can these consistently be executed? Where does ISO 14971, ICH Q9, and  more...

Project Management in a cGMP Environment - Webinar By GlobalCompliancePanel ... will be discussed. One very simple approach using common Excel- or Word-type PC applications programs that can be used immediately. Regular use of a few simple but powerful tools will virtually eliminate "fire fighting" in a new project. Regular use can contribute greatly to reduction of scheduling uncertainty, incomplete projects when time is running out, increased product liability, assist  more...

Excel Spreadsheets - Develop and Validate to Eliminate 483s - Webinar By GlobalCompliancePanel ...excel spreadsheet for GXP data and reduce validation cost and time. Configure Excel for audit trails, security features, and data entry verification. What makes this session unique is the combination of step-by-step instructions and the hands on workings of each participant. Bring your laptop and use Excel for your own needs. This session will make you a better Excel user, saving you time  more...

Validation and Use of Excel Spreadsheets in FDA Regulated Environments - Webinar by GlobalCompliancePanel ...Excel Applications are widely used in laboratories, offices and manufacturing e. g., for data capture, data manipulation and report generation. Regulations such as HIPAA, Sarbanes Oxley Act and FDA's GxP and 21 CFR Part 11 require users of software and computer systems to demonstrate and document data accuracy, integrity and confidentiality. Out-of-the box Excel has not been designed for  more...

Excel Spreadsheet Validation To Eliminate 483s - Webinar by GlobalCompliancePanel This interactive webinar provides explicit details and live demonstration followed by a collaborative workshop that explains how to configure and validate a GxP compliant spreadsheet application. What makes this session unique is the combination of step-by-step instructions and the hands on workings of each participant. Bring your laptop and use Excel for your own needs. This session will make  more...

Project Management for FDA-Regulated Companies - Webinar by GlobalCompliancePanel ...will be discussed. One very simple approach using common Excel- or Word-type PC applications programs that can be used immediately. Regular use of a few simple but powerful tools will virtually eliminate "fire fighting" in a new project. Regular use can contribute greatly to reduction of scheduling uncertainty, incomplete projects when time is running out, increased product liability, assist  more...

Excel Spreadsheet Validation To Eliminate 483s ...lobalCompliancePanel brings a new webinar on the topic of Excel Spreadsheet Validation To Eliminate 483s. Webinar will be on March 10, 2010. Webinar will be presented by David Nettleton. Mr. Nettleton is an FDA Compliance Specialist for 21 CFR Part 11, HIPAA, and Computer System Validation. His latest book is "Risk Based Software Validation - Ten easy Steps" that relates to the development,  more...

Excel at Filing - On-Demand Webinar ...excellent organizing tool and yet the last thing clients want to do is buy more software. In this popular webinar, Certified Professional Organizer ® Debra Milne takes you through the different ways Microsoft Excel ® can be used to create an electronic filing system including electronic filing practices; printing file inventory lists; searching and tracking files; networking an  more...

Online Excel Macros VBA Training -Get it from Home ...excel macros and master the vba skills at the comfort of your home. Using online screen sharing mode with a systematical training plan acquire the necessary macro skills to automate your day-2-day excel activities. The training will give a competitive advantage to you over your colleagues. The training will be for 10 hours divided as per your interest. Payment can be done after taking a  more...