MS Excel - Windows

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.

Office 2013 and 2016 offer many great new practical features that you can put to immediate use in your daily work with Microsoft Office applications. This presentation will help you maximize the use of your new software, and get up to speed in a hurry. A quick start to the new features, this information is helpful for people using earlier versions of MS Office in preparation of the upgrade. Learn the new features of the Interface, Excel, Word, PowerPoint, and Outlook. Windows tips and other shortcuts will be included. 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/TRANSITION-MS-OFFICE-SUITE-2013-2016-506259/MARCH-2017-ES-TRAININGREGISTRY

Part 4 of this Microsoft Excel macros training series presented by Excel expert David Ringstrom, CPA, will explore how to create a UserForm in Excel. It will help attendees identify how to create macro buttons that enable users to display UserForms on demand. The webinar also will define the benefits of using Visual Basic for Applications (VBA) macros and illustrate how to apply the Tag property within UserForm controls.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/MICROSOFT-EXCEL-SERIES-PART-4-502006/MARCH-2017-ES-TRAININGREGISTRY

With Excel's data validation tools, you can control how users input data into workbooks and ensure data is entered consistently and accurately. You can control dates, times, and the length of the data they enter, or simply provide a list of acceptable choices to eliminate any possible mistakes. Using Excel's data validation tools you can also control data entry by formulas, provide dropdown lists that eliminate time-consuming and error-prone typing mistakes, control numeric data based on date and time constraints, and identify unwanted data by applying data validation rules on existing data.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/MICROSOFT-EXCEL-DATA-VALIDATION-TOOLS-503086/MARCH-2017-ES-TRAININGREGISTRY

Overview: Using formulas turns Excel into the world's most powerful calculator. Whether you need to calculate loan repayments, generate a profit and loss account, solve maths or engineering problems, in fact, think of any scenario that involves addition, subtraction, division or multiplication of numbers and you'll find that Excel is the best tool for the job. Why should you Attend: Although it is perfectly possible to use Excel without ever creating a formula or using a function, if you don't, you're missing out on a huge part of the application's power. Formulas and functions will automate your calculations and save you a ton of time. No more using your fingers. No more mental arithmetic. Areas Covered in the Session: Creating formulas to perform mathematical calculations Copying formulas and the difference between absolute and relative references Assigning names to cells and using them in formulas

Overview: There is a saying,a picture is worth a thousand words.In Excel that means finding ways to represent numerical data pictorially so that your audience can quickly and easily understand it. It's often easier to look at a chart or graph that interprets trends in a set of data, than to just look at a set of figures. Why should you Attend: Until a few years ago it was enough to take a set of numbers and create a bar chart or pie chart. Although in the right situation these traditional charts are still appropriate, things have moved on We're constantly hearing words like Data Visualisation and Infographic. It's time to get your Excel related business and communication skills up to date and learn how to use it to present data in the modern world.

Overview: Microsoft says that up to 70% of users surveyed use Excel to maintain a database or large lists. To be truly proficient in Excel, you must be familiar with these tools to manage data efficiently. It's all the more important as data collection has become more automated and you're getting swamped with tons of data. But what can you do with all that data? You need to know how to re-arrange the data (sort), see just what you want to see (filter), create quick summaries (subtotals), restructure fields containing too much data (the exciting new Flash Fill tool and the Text to Columns feature) and eliminate redundant records. Contact Detail: Compliance4All DBA NetZealous, Phone: +1-800-447-9407 Email: support@compliance4All.com http://www.compliance4all.com/ Event Link : http://bit.ly/2aZVDQV Twitter Follow us – https://twitter.com/compliance4all Facebook Like us – https://www.facebook.com/Compliance4all

Microsoft Excel has a tremendous amount of capability and features and is filled with shortcuts and methods not always visible to the casual user. Whether it's a keystroke shortcut or a hidden command sequence, such shortcuts can make you much more proficient and productive as you use this powerful and popular software. Most users are under-utilizing Excel and could be saving minutes every day and hours every week if they learn some of the many tips presented in this fast-paced webinar. In these days of tight budgets and hiring freezes, its' all the more important for you to use your existing software more efficiently. This webinar will give you the productivity boost you need as you become a more proficient Excel user.

We offer introductory and intermediate Excel training courses.

Look-up formulas such as VLOOKUP allow you to return data from other locations in your spreadsheets without linking to individual worksheet cells. However, VLOOKUP can't always return the data that you need. In this session Excel expert David Ringstrom, CPA explores the nuances and limitations of VLOOKUP, helps you expand your use of this function, and then leaves you with a handful of alternatives.

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.