Microsoft Products

If you can't find what you want, Ask Us.

Refine Your Results

reset

Filter by Category

Location

Dates

FEATURED VENDORS

Showing 1-20 of 383 results Sort by:

Courses

  • 1 Request Info

    Mastering Excel Formulas and Functions

    An Excel formula is an equation or calculation that is stored in a worksheet cell. A formula enables you to perform simple or complex calculations on numbers. So think of any scenario that involves addition, subtraction, division or multiplication and that's where you'd use a formula. Functions are built-in formulas that have been programmed to perform a specific calculation. They range from the simple such as SUM and AVERAGE (used to calculate the total and average of numbers in a range of cells) to the powerful IF and VLOOKUP.
  • 2 Request Info

    Spreadsheets in FDA Regulated Environments

    Regulations such as HIPAA, Sarbanes Oxley Act and FDA's GxP and 21 CFR Part 11 require users of software and computer systems to demonstrate and document data accuracy, integrity and confidentiality. Out-of-the box Excel® has not been designed for regulated environments. However, with a good knowledge of Excel® capabilities combined with good procedures and practices on how to validate and use Excel® requirements can be met. For example, the FDA is widely using Excel® and complies with its own regulations.
  • 3 Request Info

    Webinar on Excel Dexterity: Payroll Analysis Methods

    There are multiple Excel features and functions payroll professionals can implement in order to improve the accuracy and efficiency of payroll production. In this comprehensive webinar, Excel expert David Ringstrom, CPA, explains: mathematics for employee timesheets, date and time formatting and stamping, conditional formatting to highlight HR requirements, password protection for sensitive payroll files and worksheets, salary information formatting, using pivot tables for HR reporting and analysis tasks, and 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/Excel-Dexterity-Payroll-Analysis-Methods-503626/MARCH-2018-ES-TRAININGREGISTRY
  • 4 Request Info

    Webinar on How to Use Excel to Detect Fraud

    This Excel training program will illustrate how best to use Excel's special tools and functions to spot fraud red flags. It will also review SAS No. 56 Analytics and related dashboard KPIs and offer insight into Benford's law and limitations. Attendees will learn how to set up a worksheet to help automate Benford's law analysis. 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/How-to-Use-Excel-to-Detect-Fraud-509892/MARCH-2018-ES-TRAININGREGISTRY
  • 5 Request Info

    Webinar on Advanced Excel Charting Skills Using Spinners, Sliders, Check Boxes, Other ActiveX Tools That Turn You Into a Guru

    This Excel training program will help attendees create interactive, dynamic Excel Charts helpful for financial modeling and dashboards. It will also help build Excel Charts to save time and eliminate manual input. Attendees will learn Excel Lookup functions, understand how to use INDEX and MATCH to retrieve data and chart with multiple criteria, learn how to use Excel dynamic named ranges with tables for chart automation, and 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/Advanced-Excel-Charting-Skills-Using-Spinners-Sliders-Check-Boxes-Other-ActiveX-Tools-That-Turn-You-Into-a-Guru-508950/MARCH-2018-ES-TRAININGREGISTRY
  • 6 Request Info

    Webinar on QuickBooks/Excel Report Speed Tips

    In this session, Excel and QuickBooks expert David Ringstrom, CPA, shows you how to overcome the limitations of internal reports in QuickBooks. He shares several techniques, including combining two reports into one and creating pivot tables from QuickBooks data. In addition, David explains how to: avoid the need to analyze data in Excel by implementing some QuickBooks techniques, use a wildcard character to summarize data based on a partial match, create one-click access to QuickBooks reports, and 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/QuickBooks-Excel-Report-Speed-Tips-504832/JANUARY-2018-ES-TRAININGREGISTRY
  • 7 Request Info

    Excel - Benefits and Hazards in Office 365

    Overview: In this valuable presentation, Excel expert David Ringstrom, CPA, explains how the Office 365 version of Excel 2016 differs from previous versions and perpetual licensed versions of Excel 2016. Historically, each major version of Excel was identical for all users, but that's no longer the case. Why should you Attend: Apply pivot table-specific options in the Office 365 version of Excel 2016 to minimize repetitive work Learn keyboard shortcuts and tips that will help you work more efficiently in Excel
  • 8 Request Info

    Microsoft Word: Overlooked Features and Functions

    Microsoft Word continues to improve with every new version. Occasionally, a new feature outshines the old fabulous features. In this session we will dust off those old and wonderful MS Word buttons, and you'll get a true refresher course. For instance: Auto Correct, Leap Frog paragraphs, Show/Hide codes, the trick to controlling bullets and numbering, 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://onlinecompliancepanel.com/webinar/MICROSOFT-WORD-OVERLOOKED-FEATURES-AND-FUNCTIONS-505697/NOVEMBER-2017-ES-TRAININGREGISTRY
  • 9 Request Info

    How to Configure and Validate a GxP Compliant

    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. What makes this session unique is the combination of step-by-step instructions and the hands on workings of each participant. Bring your laptop and use Excel for your own needs. This session will make you a better Excel user, saving you time and costs.
  • 10 Request Info

    Webinar On Microsoft Excel Productivity Tips and Tricks

    Microsoft Excel continues to improve with every new version. There are features that have been added in the past 3 version upgrades that should be used often. For instance: the Two Step Chart, Remove duplicates, Fast Formulas, and much more! Excel has paid attention to their customer's pleas for ease of use, and has added a new feature to make your Excel life easier.Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://onlinecompliancepanel.com/webinar/MICRROSOFT-EXCEL-PRODUCTIVITY-TIPS-AND-TRICKS-509206/OCTOBER-2017-ES-TRAININGREGISTRY
  • 11 Request Info

    Webinar On Benefits and Pitfalls of Linking Excel Workbooks

    Attend this presentation with Excel expert David Ringstrom, CPA, and you,ll discover the pros and cons of workbook links and how to create and work with them. Because workbook links allow you to connect an Excel spreadsheet to other spreadsheets, word documents, databases, and even web pages, they,re quite beneficial. David explains how to dramatically improve the integrity of linked workbooks, copy links across rows or down columns, repair broken links, 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://onlinecompliancepanel.com/webinar/BENIFITS-AND-PITFALLS-OF-LINKING-EXCEL-WORKBOOKS-505601/OCTOBER-2017-ES-TRAININGREGISTRY
  • 12 Request Info

    Webinar On Supercharge your Excel: BI Reporting with Power Pivot and Power Query

    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
  • 13 Request Info

    Cybersecurity and Computer Systems Validation - 2017

    Overview: Computer systems used in highly regulated companies include sensitive and valuable information. Some of this information includes valuable electronic submissions, clinical information, medical device design control records, legal information, and other such information. Recent events have highlighted sophisticated cybersecurity attacks everywhere including the White House! Corporations have been attacked at an alarming rate. What does this mean for computer systems validation?
  • 14 Request Info

    Webinar On Establishing Excel Dashboards

    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
  • 15 Request Info

    Webinar On Excel Business Intelligence - How to Create High Impact Reports

    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
  • 16 Request Info

    Excel - Functionality, Power Query is a lot Faster

    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
  • 17 Request Info

    Microsoft OneNote - To Manage Your Projects

    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.
  • 18 Request Info

    Webinar On Data Visualization and Infographics with Excel

    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
  • 19 Request Info

    Webinar On Managing Excel Lists and Databases: Time-Saving Shortcuts for Sorting, Filtering, Analyzing and More

    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
  • 20 Request Info

    Webinar On Excel Spreadsheets: Develop and Validate for 21 CFR Part 11 Compliance

    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