Microsoft Products

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.

This webinar covers the underlying principles of visual design, practical goals that emerge from design theory, and useful techniques to achieve those objectives. Participants will learn a systematic process designed to improve the appeal of presentations. The training will help you to create high-profile, articulate, and memorable slide presentations that will enable your audience to make informed decisions with confidence. Who Will Benefit: Banking managers Business forecasters Economic advisors Executive consultants Information technology experts Pharmaceutical representatives Retail specialists Risk analysts Instructor Profile: Philip Vassallo, Ed.D., has designed, delivered, and supervised communication training programs for more than 20,000 executive, managerial, supervisory, administrative, and technical professionals internationally over the past three decades. Note: Use coupon code NB5SQH8N and get 10% off on registration.

Excel Dashboards are the new buzzword employers are searching for. If you have, or want a career that involves creating reports in Excel, then you need to know how to build impressive, interactive, visually stunning, Excel dashboards. This practical, one-day workshop will leave you with Excel techniques you can immediately put to use making killer dashboards that set your skill level apart from others There are two major methods to produce Excel Dashboards: (1) Pivot Tables and (2) Dynamic Interactive Charts which are different and much more complex than normally produced charts. The first method is easier and this one day seminar will focus on How to Create Excel Dashboards Using Pivot Tables. Who will Benefit: CFO's, Financial Controllers, Accounting and Finance Managers and Staff, Financial Analysts, Budget Directors and staff, CPAs, Auditors Note: Use coupon code NB5SQH8N and get 10% off on registration.

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.

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.