MS Excel - Windows

If you work with data, you're likely already familiar with common frustrations with Microsoft Excel like size limitations and manually entering data from multiple sources. Luckily there are two Microsoft tools- Power Pivot and Power Query-that solve ALL of these issues, right inside Excel. No Access databases or IT department help needed. With imports of 1-million-plus rows of data sets from virtually any source and the ability to save query definitions, you can completely overhaul your reporting and analysis workflow..Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://www.onlinecompliancepanel.com/webinar/POWER-PIVOT-POWER-QUERY-502229/AUGUST-2017-ES-TRAININGREGISTRY

In this webcast, Excel expert David Ringstrom, CPA, introduces participants to Microsoft Excel dashboards. Dashboard techniques empower users to assimilate large amounts of data quickly and easily by way of charts and summary tables. David explains how to bring data into Excel from other sources, outlines different techniques for presenting information in dashboard form, demonstrates how to use Excel's PivotTable feature to condense large amounts of data, and much more.Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://www.onlinecompliancepanel.com/webinar/ESTABLISHING-EXCEL-DASHBOARDS-503130/AUGUST-2017-ES-TRAININGREGISTRY

The training will focus on 4 areas - Pivot tables, charts/graphs, the Power View report addin and how to present geographic information. In the pivot tables section, you'll learn how to create a basic pivot table, display numbers as a percentage (no formulas, arithmetic or programming required!) and make the pivot table eye-catching appealing to read and then group the data (by month or numeric range).Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://www.onlinecompliancepanel.com/webinar/EXCEL-BUSINESS-INTELLIGENCE-508110/AUGUST-2017-ES-TRAININGREGISTRY

Overview: If you've been frustrated by other limitations of pivot tables then Power Pivot is for you. Simply put, Power Pivot takes pivot tables and data analysis to the next level. If you're a fan of pivot tables, you'll love Power Pivot. Areas Covered in the Session: Importing data into Excel from external sources Creating pivot tables from multiple sources Creating relationships and data models Introduction to DAX formulas Cleaning and transforming data using Power Query Combining data from Multiple Tables

Overview: OneNote is a digital notebook. It is available for Windows, Mac and mobile. Use it to capture, store and organise your ideas and information. OneNote notes can store text, images, videos, embedded files and even drawings and sketches. Why should you Attend: For many people the holy grail of organization is a world where email overload doesn't exist and where all those sticky notes and paper notepads are magically replaced by a digital paperless system.

In this session, you'll learn how to create and enhance the appearance of traditional charts such as bar charts. You'll also learn how to create Sparkline charts (really useful in dashboards), infographic-style charts and how to represent data in a visual way without using the charting features at all. Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://www.onlinecompliancepanel.com/webinar/DATA-VISUALIZATION-INFOGRAPHICS-EXCEL-509044/JULY-2017-ES-TRAININGREGISTRY

Microsoft Excel has become the de facto spreadsheet application for business. But do you sometimes feel like you have rows and rows of data and it's hard to make heads or tails of it? This class will help you learn how to manage databases in Excel and get the most out of them.Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://www.onlinecompliancepanel.com/webinar/MANAGING-EXCEL-LIST-DATABASES-506661/JULY-2017-ES-TRAININGREGISTRY

Spreadsheets are powerful business tools, and are increasingly used in manufacturing, tracking and quality systems - as well as in generating and interpreting business data. FDA requires spreadsheets to be validated per 21 CFR 210-211, Part 820 and to be compliant to 21 CFR Part 11 in some cases.Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://www.onlinecompliancepanel.com/webinar/EXCEL-SPREADSHEETS-502490/JULY-2017-ES-TRAININGREGISTRY

Overview: FDA regulations cover both the use of workbooks and the creation of electronic records device manufacturers must understand these regulations and their application. The presentation begins with Excel methods to help ensure the spreadsheet produces the results you want. Why should you Attend: Excel workbooks must produce correct results, so the first concept helps ensure correctness. Excel workbooks may also cause regulatory problems, because they are easy to implement and very common. Often people that improve processes with these workbooks are not aware of the regulatory requirement.

In this session by expert speaker Dennis Taylor, you will learn the quickest and best ways to create PivotTables and Pivot Charts in Excel to analyze and represent data. This will be presented in Excel 2013 with references to Excel 2010 & 2016. Tools such as Sorting and Filtering in Excel allow users to easily manage large lists of data. However, if you require analyzing every data quickly, PivotTable is the best available option. Based on the huge data, you can quickly create a compact summary report without the use of complex formulas or lengthy techniques.Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://www.onlinecompliancepanel.com/webinar/MASTERING-EXCEL-PIVOT-TABLES-509478/JUNE-2017-ES-TRAININGREGISTRY

In this presentation, Excel expert David Ringstrom, CPA, demonstrates how to create effective and resilient budget spreadsheets as well as how to future-proof them once they're built. David shares several design techniques, including separating inputs from calculations, building out separate calculations spreadsheets, and developing both operating and cash flow budgets. Cash flow budgets are beneficial in that they calculate when to borrow against a line of credit, when to pay down the line of credit, and when cash is available to pay dividends.Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link http://www.onlinecompliancepanel.com/webinar/BUDGET-SPREADSHEETS-EXCEL-508086/JUNE-2017-ES-TRAININGREGISTRY

Overview: David shares a wide range of helpful techniques, including how to separate inputs from calculations, streamline formula writing, preserve key formulas, and create both operating and cash flow budgets. Why you should attend: Learn to create both operating and cash flow budgets Learn how to Streamline formula writing Transform filtering tasks using the Table feature Understand the benefits associated with a variety of Excel functions

This topic shows you how to create these macro shortcuts, alerts you to situations ideal for creating macros and explores the actual code (in the language called Visual Basic) created when you record command sequences. This is not a course in Visual Basic, but you will get a quick look at it and understand its role in creating and using macros.Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link http://onlinecompliancepanel.com/webinar/MASTERING-MACROS-MICROSOFT-EXCEL-508605/JUNE-2017-ES-TRAININGREGISTRY

No matter how long or how deeply you use the Microsoft Office Suite, there is always more to learn. The best tips are the ones that save you time and duplication of effort. These 10 hacks do exactly that. And what makes this program unique is that it teaches how to leverage the applications in combinations you may never even considered. Terms like mail merge and slide presentations won't seem like such time consuming tasks fraught with frustration and pitfalls. You'll learn that Excel and Outlook may very well be a match made in heaven.Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link http://onlinecompliancepanel.com/webinar/10-MICROSOFT-OFFICE-PRODUCTIVITY-HACKS-504903/MAY-2017-ES-TRAININGREGISTRY

Overview: VBA is the programming language that is built in to Excel (and the other applications in the MS Office Suite).VBA is used to automate tasks that would otherwise have to be performed manually by pressing keys and selecting items with the mouse-and if that sounds like a macro-well it is. Although Excel has a macro recorder, there's a limit to what it can do. So where the macro recorder's functionality ends, VBA takes over.

One common statistical technique, especially useful in manufacturing is the hypothesis test. While it is common, it is not always well understood. In addition, some instances can involve complicated calculations. Hypothesis testing is a statistical procedure that helps determine if a set of data, typically from a sample, is compatible with a given hypothesis. This presentation focuses on hypothesis tests involving the means of a distribution, one of the most common applications.Price:$250.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link http://onlinecompliancepanel.com/webinar/HYPOTHESIS-TESTING-503403/MAY-2017-ES-TRAININGREGISTRY

Dashboards and reports are a critical tool in your communication armoury. A well-designed and meaningful dashboard offers a CEO, shareholder or Project Manager a valuable insight into the Key Performance Indicators (KPI's) upon which a business or project is measured and enables them to determine the future direction of the business or project.Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link http://onlinecompliancepanel.com/webinar/USE-EXCEL-DASHBOARDS-507439/MAY-2017-ES-TRAININGREGISTRY

In this webcast, Excel expert David H. Ringstrom, CPA shows you how to create dynamic accounting reports for any month of the year on a single worksheet. Many users set out to build a worksheet for each month of the year, which can be cumbersome to revise. Instead David will show you how to use worksheet functions like VLOOKUP, OFFSET and SUMIFS.Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link http://onlinecompliancepanel.com/webinar/EXCEL-BASED-FINANCIAL-REPORTS-503504/MAY-2017-ES-TRAININGREGISTRY

Excel has a variety of formatting tools and techniques, as well as many shortcuts that let you invigorate a worksheet, provide emphasis for selected cells and present information in a lively and informative way. Most Excel users are under-utilizing its features don't know how to make their printed and displayed Excel data more attractive and presentable; this webinar makes these users become familiar with the most effective and efficient formatting tools.Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link http://www.onlinecompliancepanel.com/webinar/MASTERING-EXCEL-FORMATTING-505014/APRIL-2017-ES-TRAININGREGISTRY

Overview: 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. Areas Covered in the Session: Develop spreadsheet applications that are GxP compliant. Learn how to use Excel’s built in 21 CFR Part 11 features. Validate your application with minimal documentation.