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

Courses

  • 1 Request Info

    Using VLOOKUP, MATCH, and INDEX

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

    Excel: VBA 101 -Automation Beyond the Macro Recorder

    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. VBA is the programming language that is built in to Excel (and the other applications in the MS Office Suite). VBA is used to automate tasks that would otherwise have to be performed manually by pressing keys and selecting items with the mouse -and if that sounds like a macro -well it is.
  • 3 Request Info

    Create and Use Excel Dashboards to Gain Valuable Business Insights

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

    Webinar on Excel Data Visualization: How to Represent your Data in Charts

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

    Webinar on Learn BI Reporting with Power Pivot and Power Query for Excel

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

    Latest and [Advanced] Mastering Excel Pivot Tables

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

    The Top Ten Excel Functions Everyone Should Know

    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!
  • 8 Request Info

    Step-By-Step Instructions for Ensuring Data Integrity

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

    3-Hour Virtual Seminar on Mastering Excel Formulas and Functions

    Overview: 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.
  • 10 Request Info

    Time-Saving Excel Tips, Tricks and 100 Shortcuts

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

    Excel Spreadsheets in FDA Regulated Environments

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

    Excel Formulas and Functions in Advanced

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

    Webinar on Professional Essentials - Excel Pivot Tables & Beyond

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

    Access Boot Camp

    Do you need to master building and managing databases in a hurry? Our Boot Camp is an intensive crash course in Access. You will start with the basics, such as navigation and basic forms, and work your way through to the advanced features of the application, such as macros and writing statements in SQL. You will even finish with a workshop, where you can get instructor feedback on your individual projects. There will be ample of hands-on activities that allow you to be sure you have mastered each lesson, and our experienced educators will be there to lead you to a thorough understanding of the material. This intensive four-day Access Boot Camp will take you from beginner to master of this powerful database application.
  • 15 Request Info

    SharePoint Designer and Workflows

    With Mission Critical’s SharePoint Designer training courses in Denver and Phoenix, you will be able to open up the back end of SharePoint, enabling you to create a more customized site, and create better branding. You will learn to create customer pages and workflows. In our two-day course, you will learn SharePoint Designer to bring your skills to the next level, beyond the basic functionality of SharePoint. This training course includes plenty of hands-on activities, so that you can be sure you have mastered the material. In this SharePoint Designer class, Students exiting this class will be able to improve the customization and content on their sites. Students will also learn to build and deploy workflows, using this powerful tool to pursue more complex projects.
  • 16 Request Info

    SharePoint Level 3

    Our SharePoint Level 3 provides advanced level training that allows the site editor to add complex functionality to their SharePoint sites, with out-of-the-box components. If you are the company or departmental site manager, you are looking to improve your skills as a SharePoint designer/consultant, or you want to learn different concepts for building dynamic SharePoint sites, then our SharePoint Level 3 class is for you. Learn more advanced features that a site manager and editor would use in creating dynamic company sites. Learn how to edit and configure more advanced webparts, how to create app templates, and view settings to customize content by audience targets. Use lookup content and filtered columns to make accessing data easier. Learn about Document Sets to better organize and access documents in a library.
  • 17 Request Info

    SharePoint Level 2

    Our SharePoint Level 2 class provides Intermediate and Advanced level training in this powerful website application. It builds on concepts covered in SharePoint Level 1 , and covers more advanced features and design techniques. If you will be maintaining and editing a SharePoint site or sub-site for your company, then you will want to take both Level 1 and Level 2 to get the entire range of knowledge needed. Students completing this SharePoint course will have the skills needed to use more advanced features of SharePoint and develop better and more effective sites. Students will learn to better organize their sites, and incorporate pages and other web parts. They will master the implementation of collaboration tools, discussion boards, wikis, and blogs. Developing workflows and Task Lists to further simplify and manage complex projects will also be covered. InfoPath integration will be introduced in this class. Students will also learn to manage permissions.
  • 18 Request Info

    SharePoint Level 1

    Welcome to SharePoint 101! This class is designed to be an Introduction to SharePoint, and covers basic concepts which allow you to design and develop a SharePoint site. This SharePoint course, is intended for non-technical administrators of sites and pages, and will enable you to be comfortable with SharePoint’s out-of-the-box functionality, after the back-end of the application’s structure has been set up. This course includes plenty of interactive activities to make sure you have mastered each lesson. Upon completion of this SharePoint introduction training course, students will have a mastery of the basic functionality and tools of the application. They will be able to navigate sites, search for and work with content, create and customize a home page, create additional types of content, work with libraries, and integrate other applications, such as Outlook and Excel, into their SharePoint sites.
  • 19 Request Info

    SharePoint Boot Camp

    If you need to become the expert on building, editing and maintaining SharePoint sites after your SharePoint server or 365 account has been set up, then this class is for you. It is for people who are going to be the point person on maintaining company sub-sites for SharePoint. You do not need to be an IT person to attend this class as SharePoint is a software program that allows individual department heads and regular business users the power to create and manage their own sites. This course includes plenty of interactive activities to make sure you have mastered each lesson. It covers all content from our SharePoint Level 1, 2 and 3 classes as well as SharePoint Designer. This course is intended for non-technical administrators of sites and pages, and will enable you to be comfortable with SharePoint’s out-of-the-box functionality, after the back-end of the application’s structure has been set up.
  • 20 Request Info

    Excel Macros

    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