Information Technology
-
Drafting a Software V&V Documentation Package and Protocol
The verification and validation of medical software is coming under increased scrutiny by the U.S. FDA. This webinar will address the use of the FDA, DAMP, and other applicable industry software validation models, coupled with the ISO 14971 /... -
Effective and Practical use of FMEA For Risk-Based Approach to Computer Systems Validation
Validation of computer systems is a regulatory requirement within the life sciences. “How much to validate” is one of the biggest challenges validation teams face. The struggle to balance time and available resources with compliance requirements often leads to... -
Electronic Records Management in Compliance with FDA Regulations
GxP/GMP regulations are required to be used in regulated industries such as food, pharmaceutical, medical devices, and cosmetics. Good Documentation Practice, commonly abbreviated as GDocP, is the standard in the regulated industries by which documents and records should be... -
End Your Outlook Overwhelm
Do you ever open up Outlook and feel totally overwhelmed? Then this webinar is for you. In this one hour webinar you will learn how to take back control of your Inbox, Get to grips with your Calendar and... -
Excel – Advanced Functions
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... -
Excel – Automate Tasks and Processes with Macros
Do you find yourself repeatedly performing the same actions or tasks in your spreadsheets? If the answer is “Yes”, it’s time to learn how to create a macro. In this session you will learn how to create and edit... -
Excel – Automated Dashboards for Business Intelligence
No matter what business you are in, a dashboard is a critical tool in your communication armoury and as with any communication tool, presentation is everything. Although there are many tools that can be used to create a dashboard,... -
Excel – Create High-Impact Business Reports
No matter what business you are in, a report is a critical tool in your communication armoury. As with any communication tool, presentation is everything. Get it right and it offers the reader (typically a CEO, shareholder or Project... -
Excel – Importing and Manipulating Big Data with Power Query
Do you work with “Big Data”? Do you import and manipulate large datasets in Excel? If so you’ll already be familiar with the limitations of Excel. Power Query, (known as Get and Transform in Excel 2016) is designed to... -
Excel – Improve Data Visualization with Maps, Charts and Infographics
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... -
Excel – Managing Lists and Databases
If you think that Excel is all about working with numbers, then think again. More and more people are turning to Excel to help them to manage list-based and tabular data. In many cases they receive, download or import... -
Excel – Mastering Lookup Functions
“How do I compare the items in these two lists and see which are missing” “How do I look up a value in list ONE and pick up a related value from list TWO” “How do I avoid my... -
Excel – Power Pivot – Taking Pivot Tables to the Next Level
Power Pivot, a free addin for Excel, written by Microsoft, puts the “power” into Pivot Tables (hence the name!). Power Pivot removes many of limitations and frustrations that many advanced users find with Pivot Tables. For example, using Power... -
Excel as a Business Intelligence Tool – Pivot Tables
Microsoft Excel Pivot Tables are one of the most powerful tools in Excel’s data analysis and Business Intelligence (BI) armoury. With just a few clicks of the mouse (and no complicated formulas!) you can quickly and easily build the... -
Excel Beyond Numbers – Tame Lists and Tabular Data
If you think that Excel is all about working with numbers, then think again. More and more people are turning to Excel to help them to manage list-based and tabular data. In many cases they receive, download or import... -
Excel Lookup Functions – 2 Part Web Series
Apply a variety of lookup functions in order to work more efficiently in Excel Define how to improve spreadsheet integrity with Excel’s VLOOKUP function. Recall how to use the MATCH worksheet function to identify differences between two lists. Recognize...