MS Excel - Windows

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 76 results Sort by:

Courses

  • 1 Request Info

    Power Pivot and Power Query 101 [BI tool] 2019

    Power Pivot and Power Query are free addins for Excel, written by Microsoft (in fact in Excel 2016 and later Power Query is built into the application and not an addin at all). Power Pivot puts the "power" into Pivot Tables (hence the name!), removing many of limitations and frustrations that many advanced users find with Pivot Tables (such as creating pivot tables from multiple lists and creating pivot tables from large datasets)
  • 2 Request Info

    Top [Keystroke Shortcuts] from Excel Experts 2019

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

    Raw Data to [Great Results] with Excel PowerPivot and PowerQuery

    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. Power Query and Power Pivot complement each other. Power Query is the recommended experience for discovering, connecting to, and importing data. Power Pivot is great for modeling the data you've imported.
  • 4 Request Info

    Take Advantage Of 21 Cfr Part 11 - Read [Immediately] These Tips

    Spreadsheets such as Excel, are available for creating a wide range of end user applications, including widespread use in the laboratory, creating customized statistical analyses, the creation of local databases, data mining, and multivariate analysis. These may be used for GxP regulated activities, and they present particular compliance challenges, as Excel and other spreadsheets are not originally designed for the regulated environment.
  • 5 Request Info

    Excel Formulas From Unlikely Sources [Awesome Tips]

    Overview: 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. Without formulas and functions, Excel would not be able to perform its calculations. So, think of any scenario that involves addition, subtraction, division or multiplication and that's where you'd use a formula.
  • 6 Request Info

    Your Data with Excel PowerPivot and PowerQuery

    Overview: 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- PowerPivot and PowerQuery-that solve ALL of these issues, right inside Excel.
  • 7 Request Info

    Future Trends in 21 CFR 11 compliance for (Excel Spreadsheets)

    Overview: Spreadsheet Applications such as MS Excel are frequently used in 21 CFR 11 compliant environments, but they were not specifically designed for regulated environments and their development is not optimized for 21 CFR 11 compliance. However, the FDA expects that spreadsheets be compliant and lack of compliance can result in a warning letter. Consequently, validation of Excel Spreadsheet Applications is required as part of a 21 CFR 11 compliant environment.
  • 8 Request Info

    Webinar on Create and Use Excel Dashboards to Gain Valuable Business Insights

    In this training session, you'll learn how to create a stunning, interactive professional-looking dashboard using Excel. This training will provide you with a solid foundation that you can use to build your own dashboards and reports. 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/Create-and-Use-Excel-Dashboards-to-Gain-Valuable-Business-Insights-506862/NOVEMBER-2018-ES-TRAININGREGISTRY
  • 9 Request Info

    Latest Excel Formulas and Functions in [2018-19]

    Overview: Built in to Excel are over 450 functions - a potent set of power tools that simplifies certain kinds of formulas and gives you a huge number of computational possibilities. Many Excel functions provide extended analytical capabilities and open the door to more efficient use of Excel. This session gives you perspective on what functions are available and explains (with extensive examples) how to use many of them, including: the IF function (with AND and OR), the powerful VLOOKUP function, selected Date, Statistical, Financial, and Mathematical functions, and the frequently overlooked Text functions. In addition, the powerful COUNTIF/SUMIF family of functions, as well as more recently introduced functions are also covered.
  • 10 Request Info

    Advanced Formulas & [Functions in Excel] 2018-19

    Overview: In the business world, or within your organization, you probably experience large amounts of data. Maybe the data is about your sales, customers, donations, orders, employees, vendors, expenses, or whatever it may be. Excel has many built-in functions that help you deal with that data. It is very important that you know how to use some of these functions to get the most out of your data in a time efficient manner. This way, you can turn the data into meaningful information and then provide the answers that you need for yourself, your boss, your company or your organization.
  • 11 Request Info

    Mastering Excel [Pivot Tables] in Advanced Technology

    Overview: You will learn the following in this webinar, The quickest and best ways to create PivotTables and Pivot Charts, including these capabilities: The following subjects will be covered in detail: How to compare two or more fields in a variety of layout styles How to sort and filter results How to perform ad-hoc grouping of information
  • 12 Request Info

    3-Hour Virtual Seminar on Master Validation Plan

    Overview: FDA Warning Letters and recent high-profile recalls indicate major cGMP deficiencies in many companies. One major failing is lack of sufficient or targeted risk-based company-wide V&V planning. Starting with a Master Validation Plan, evaluating its elements against ISO 14971 hazard analysis / risk management, allows development of meaningful product validations. The roles of different V&V protocols.
  • 13 Request Info

    Advanced Mastering Macros in Microsoft Excel

    This topic will show you how to create macros and give you examples of various macros that handle large amounts of information and interact with multiple files, This topic shows you how to create these macro shortcuts, alerts you to situations ideal for creating macros, and explores the actual code created when you record command sequences, This webinar will help you save time, avoid mistakes and make you more productive in Excel by teaching you how to record and use macros.
  • 14 Request Info

    Mastering Excel Formulas and Functions

    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. 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. Functions aren't limited to calculating numeric data.
  • 15 Request Info

    Step-By-Step Instructions for Ensuring Data Integrity

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

    2-Hour Virtual Seminar on Mastering Excel Pivot Tables

    Overview: You will learn the following in this webinar, The quickest and best ways to create PivotTables and Pivot Charts, including these capabilities: The following subjects will be covered in detail: The following subjects will be covered in detail: How to compare two or more fields in a variety of layout styles How to sort and filter results How to perform ad-hoc grouping of information How to use Slicers instead of filters to identify which field elements are displayed How to drill down to see the details behind the summary How to categorize date/time data in multiple levels
  • 17 Request Info

    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. For 75-minutes, Excel expert Dennis Tom Fragale will lead you through a full array of powerful and easy-to-use database commands and methods critical to effectively working with Excel databases. In this webinar, you will learn how to improve your Excel database skills so that you can better summarize info-making better, more-informed business decisions
  • 18 Request Info

    Excel Tricks and 100 Shortcuts 2018

    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.
  • 19 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.
  • 20 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.