Microsoft Products

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: If you're like millions of other business professionals, you probably use Microsoft Outlook every day to manage your email, calendar and to do's. It's available for Windows, Mac, mobile and there's even a web version. In this session you will learn how to control Outlook, rather than letting it control you. Why should you Attend: In this session you'll learn how, used in the right way, Outlook can save you time, help you to gain more control, improve your response time and allow you to keep up with the never ending stream of critical actions and due dates. Who Will Benefit: Any Excel user who needs to go beyond the basics of using formulas or simply wants to become more comfortable and productive in using Excel formulas and functions. Any Excel user who deals with large lists needs these tools and techniques to effectively manage the lists and become more productive. Nearly all Excel users, except for those just getting started, are candidates for this webinar.

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.

From calculating DSO and DSI and planning for seasonal adjustments to using Excel date arithmetic to schedule payables, receivables and cash flow, this training program will assist attendees in effectively constructing the monthly cash flow forecast using Excel. Who Will Benefit: CPAs CFOs Controllers Staff Accountants Finance and Accounting Department Personnel Independent Auditors Internal Auditors Financial Analysts Budget Directors Instructor Profile: Joe Weil, CPA, M. Acc., is the president of the National Center for Continuing Education (NCCE), a Tallahassee based nationwide financial training firm. Mr. Weil has led over 400 seminars on Excel and financial topics and several highly acclaimed webinars on the same topics. He is a former corporate controller, former state agency director of auditing, and a former municipal CFO. Note: Use coupon code NB5SQH8N and get 10% off on registration.

Office 365 is a subscription based service from Microsoft that allows you to be productive anywhere. Not only does it give you MS Office licenses for your desktop/laptop computer, but you also get access to the powerful online and mobile versions of Office as well as 1TB of storage for your files, which you can access from anywhere on any device. This session combines background knowledge with practical demonstrations.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/MICROSOFT-OFFICE-CLOUD-501694/DECEMBER-2016-ES-TRAININGREGISTRY

This training program will detail applying new charting capabilities in Excel 2013 and later, define how to save time by copying chart formatting between charts, and list ways to simplify chart-related tasks. It will also enumerate how to enliven Excel charts with clip art. Who Will Benefit: Banking Finance Insurance Education Telecom IT CPAs CFOs Controllers Marketing Sales Investments Pharmaceutical Instructor Profile: David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on 25 years of consulting and teaching experience. Mr. Ringstrom focuses on what users don’t, but should know about Microsoft Excel. His goal is to empower attendees to use Excel more effectively. Note: Use coupon code NB5SQH8N and get 10% off on registration.

This Excel macros training program will help attendees apply your extended knowledge of Excel macros. It will define how to create loops within your spreadsheets and help recall when to use the SELECT CASE function versus IF statements. Attendees will also understand how to use Breakpoints to simplify debugging errors in the programming code. Who Will Benefit: Banking Finance Insurance Education Telecom IT CPAs CFOs Controllers Marketing Sales Investments Pharmaceutical Medical Devices Instructor Profile: Acclaimed Microsoft Excel expert David H. Ringstrom, CPA, is the president and owner of Accounting Advisors, Inc. based in Atlanta, Georgia. Mr. Ringstrom’s Excel courses cover the gamut of the software’s features and functions to provide CPAs as well as accounting and financial professionals the knowledge they need to work more efficiently and effectively in Excel. Note: Use coupon code NB5SQH8N and get 10% off on registration.

This training program in the Microsoft Excel series will define how to adjust Excel’s macro security settings. Attendees will learn how to apply an enhanced understanding of Visual Basic for Applications (VBA) macros and also learn identify how to enhance the code you’ve created with the Macro Record feature. Who Will Benefit: Banking Finance Insurance Education Telecom IT CPAs CFOs Controllers Marketing Sales Investments Pharmaceutical Medical Devices FDA Aviation Instructor Profile: Acclaimed Microsoft Excel expert David H. Ringstrom, CPA, is the president and owner of Accounting Advisors, Inc. based in Atlanta, Georgia. Mr. Ringstrom’s Excel courses cover the gamut of the software’s features and functions to provide CPAs as well as accounting and financial professionals the knowledge they need to work more efficiently and effectively in Excel. Note: Use coupon code NB5SQH8N and get 10% off on registration.

This webinar will help you master pivot tables in Excel 2007, 2010, 2013, and 2016. Learn tricks and traps of working with pivot tables to help ensure accuracy of reports and convert obsolete Excel spreadsheet files to modern workbook formats. Who Will Benefit: Accountants CPAs CFOs Financial consultants Controllers Banking Finance Insurance Education Telecom I.T Marketing Instructor Profile: David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on 25 years of consulting and teaching experience. Mr. Ringstrom’s mantra is “Either you work Excel, or it works you,” so he focuses on what he sees and users should about Microsoft Excel. His goal is to empower you to use Excel more effectively. Note: Use coupon code NB5SQH8N and get 10% off on registration.

This first training program in the Microsoft Excel webinar series will discuss the automation possibilities that Excel macros offer and the nuances of Excel’s Personal Macro Workbook. It will also define how to use Excel’s Macro Recorder, and offer a quick guide on how to create a keyboard shortcut on the Quick Access Toolbar and on applying Relative References when recording macros. Who Will Benefit: Banking Finance Insurance Education Telecom IT CPAs CFOs Controllers Marketing Sales Investments Pharmaceutical Medical Devices FDA Instructor Profile: Acclaimed Microsoft Excel expert David H. Ringstrom, CPA, is the president and owner of Accounting Advisors, Inc. based in Atlanta, Georgia. Note: Use coupon code NB5SQH8N and get 10% off on registration.

This training program will detail applying new charting capabilities in Excel 2013 and later, define how to save time by copying chart formatting between charts, and list ways to simplify chart-related tasks. It will also enumerate how to enliven Excel charts with clip art. Who Will Benefit: Banking Finance Insurance Education Telecom IT CPAs CFOs Controllers Marketing Sales Investments Pharmaceutical Instructor Profile: David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on 25 years of consulting and teaching experience. Mr. Ringstrom focuses on what users don’t, but should know about Microsoft Excel. His goal is to empower attendees to use Excel more effectively. Note: Use coupon code NB5SQH8N and get 10% off on registration.

This webinar will discuss the excel What-If Analysis tools within Microsoft Excel’s Data menu. In addition id will explain Excel Scenario Manager, Data Table features, Excel’s Goal Seek feature, Excel Solver feature, FORECAST and more. Participants can avoid replicating worksheets. The advance function can also help compare different scenario and extrapolate trends based on existing data in your spreadsheets. Who Will Benefit: CPAs and Accountants Marketing and Management Consultants Bankers CFOs Controllers Financial Planners and Consultants Business Professionals Business Analysts Bookkeepers Instructor Profile: David H. Ringstrom is a CPA and the owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started in 1991. Note: Use coupon code NB5SQH8N and get 10% off on registration.