MS Office & Workgroups

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

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

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

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

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

In-House training classes In NC, SC, GA, FL, MS, AL, TN.

We specialize in Microsoft Excel training for all skill levels (basic, advanced financial modeling, and VBA macro programming). We train anywhere in the continental USA. Call 646-325-9094 or email mike@easyexcelclasses.com for a quote.

NYIM offers PowerPoint & Excel training for any level. Private/custom training available for corporate or industry specific needs. Call or e-mail to inquire: 718-795-3608 mary@newyorkinteractivemedia.com