MS Excel - Windows

Overview: "How do I look up a value in list ONE and pick up a related value from list TWO" "How do I avoid my lookup formula displaying an ugly error when it can't find a match?" "I've heard of VLOOKUP but what's HLOOKUP and what’s XLOOKUP?" These are just a few of the questions I get asked on a regular basis. You can get the answers to these questions (and more) by attending this training session dedicated to mastering the various lookup functions that are built into Excel.

Overview: PivotTable capabilities are enormous; among its many tools and features. 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 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 How to create a Pivot Chart that is in sync with a PivotTable How to add calculated fields to perform additional analysis How to hide/reveal detail/summary information with a simple click How to deal with dynamic source data and the "refresh" concept How to create a PivotTable based on data from multiple worksheets

Overview: If you're looking for ways to improve the integrity of your decision-making formulas other than relying on Excel's IF function, you'll find this presentation quite helpful. Excel expert David Ringstrom, CPA, briefly discusses the IF function and then, in detail, takes you beyond the basics. He explains what can go awry with the IF function, and he then shares alternatives to using the IF function, including IFNA, MINIFS, SUMPRODUCT, and others. David's assertion is that if you're nesting more than a couple of IF functions, there are probably more refined and resilient approaches you can take.

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 How to create a Pivot Chart that is in sync with a PivotTable

This webinar will show you how to use the tools sort and filter and subtotals in Excel to really help get the most out of your data, be more efficient, and find the information that you are looking for. Attend this webinar if you are using MS Office in a business or educational setting to create reports and presentations.

This webinar on how to use VLOOKUP, MATCH and INDEX, which will help you tremendously. In this webinar you will learn about VLOOKUP function in Excel, which enables you to quickly and easily look for a value down a column of data and return a value from the same row in a different column.

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 is commonly used due to its power, it's flexibility and the fact that most people have it installed on their computer. This training focuses on what you need to know to create an interactive professional-looking dashboard using Excel.

Learn how to represent data visually using different excel charts and tools. Register to learn 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-Data-Visualization-Charts-and-Infographics-505910/JULY-2019-ES-TRAININGREGISTRY

Learn to utilise the features of Power Pivot and Query to summarise large amounts of data and streamline the process of presenting the results. Register now. 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/Supercharge-your-Excel-BI-Reporting-with-Power-Pivot-and-Power-Query-509835/JULY-2019-ES-TRAININGREGISTRY

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

Excel functions can greatly enhance your ability to perform tasks in day to day activities in Excel. While there are hundreds of functions in available, there are 10 functions that all Excel users should know. Whether you are an office worker, or a small business owner using Excel to keep track of your finances or just the casual user, these Excel functions can be very important time savers and enhance your ability to create better performing spreadsheets!

Overview: This session will make you a better Excel user, saving you time and costs, also provides explicit details and live demonstration followed by a collaborative workshop that explains how to configure and validate a GxP compliant spreadsheet application. Why should you Attend: 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.

Overview: 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.

Overview: Excel Applications are widely used in laboratories, offices and manufacturing e.g., for data capture, data manipulation and report generation. 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.

Learn all the basics and techniques of Excel pivot table which can be applied to transform all your raw data into simplified summary 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/Professional-Essentials-Excel-Pivot-Tables-Beyond-505226/MARCH-2019-ES-TRAININGREGISTRY

xcel macros are an excellent tool to help streamline your workflow, and cut down on repetitive tasks. The ability to record macros in Microsoft Excel means that you can easily add macros to your daily work. This class will cover the steps necessary to create macros, recording macros, your personal macro workbook and a brief introduction to the VBA Editor that will allow you to edit existing macros. Topics Covered Creating and Editing Macros Planning a macro Recording macros Accessing macros Intro to VBA Editor Editing an existing macro in the VBA Editor Personal Macro Workbook Moving a macro to your personal macro workbook

Whether you need to crunch numbers for sales, inventory, information technology, human resources, or other organizational purposes and departments, the ability to get the right information to the right people at the right time can create a powerful competitive advantage. Learn how to create dashboards in Excel that allow you to extract actionable organizational intelligence from your raw data, and present it in a visual format that enables decision makers to view key trends and conclusions at a glance. This class will cover the steps necessary to create an interactive Excel Dashboard, with visual displays that pull from spreadsheet tables of data. Topics Covered Creating Advanced Formulas Automating Workbook Functionality Apply Data Validation Work with Forms and Controls Applying Conditional Logic Use Lookup Functions Combine Functions Visualizing Data with Basic Charts Create and modify Charts Advanced Charting Techniques Analyzing Data with PivotTables, Slicers, and PivotCharts

Do you feel like you have rows and rows of data and it’s hard to make heads or tails of it? This Excel training will help you learn how to manage databases in Excel, and get the most out of them. You will learn how to analyze Excel data, as well as better manage large tables of it. You will learn the most useful database functions in Excel to help you add, average, count, and find information in your rows. You will learn how to use macros, which can help you automate repetitive steps in large lists of data. This Excel Database class is for people who have to regularly manage large tables of data within Excel. Upon completing this course, students will know how to manage databases in Excel, and have a mastery of the tools and formulas that work best in dealing with large sets of information. Students will gain an understanding of database functions, macros, analysis tools, and viewing tips, to best work with large amounts of data.

In the Microsoft Excel Pivot Table and Charts training, in our Denver and Phoenix training centers, students will come from class with more confidence in using Pivot Tables and Charts, as well as have an understanding of how data in Excel can be displayed in a visual way. They will learn how to create Pivot Tables that can calculate, compare, and total data from a table. They will also feel confident in how to use all of the various formatting tools to make their Pivot Tables really pop. Students will also learn all of the different types of charts available in Excel, and when best to use each. Additional charting techniques will be covered, allowing the students make their charts really stand out from the default templates, including drop-lines and unique axis formatting, as well as using trending, and analysis tools.

Do you need that extra boost to develop more complex functions and formulas? In this class you will learn advanced Excel formulas and functions to bring your spreadsheets to the next level. Learn how to develop more complex formulas and learn the power of arrays. Learn formulas to help you automate your spreadsheets to simplify them for easier use for others, as well as yourself. Bring your brains for this one! Students will leave this class with a solid understanding of advanced Excel formulas and functions that can help with their more complicated projects. This course takes an intense look at complex formulas, as well as how to nest several different functions. Students will learn how to create dynamic drop-down lists to automate their spreadsheets for others to use. Arrays will also be applied to expand formulas to wider uses. Students will also learn how to write formulas that create filtered columns that eliminate blanks.