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

Courses

  • 1 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
  • 2 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.
  • 3 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.
  • 4 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.
  • 5 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.
  • 6 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.
  • 7 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.
  • 8 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
  • 9 Request Info

    Excel Dashboards

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

    Excel Managing Databases

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

    Excel Pivot Tables & Charts

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

    Excel Functions & Formulas

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

    Excel Advanced

    Our Advanced Excel class covers more intricate formulas, creating validations, writing macros, embedding other documents, and protecting your data in Excel. The class includes useful functions for various business applications, as well as how to combine these with other functions. Our instructors will be on hand to answer any questions you have and lead you to a thorough understanding of Excel at an advanced level. In the Advanced Excel class students will come from this class feeling confident using many of the advanced features within Microsoft Excel, including nested IF statements, VLookups, HLookups, macros, and validations. The primary focus of the is on formulas, specifically functions, and how to nest them with other functions for more advanced automation. Tools for making your spreadsheets easier for others to use and view are also included. These include validations, custom views, protecting worksheets, and embedding other documents or spreadsheets within your workbook.
  • 14 Request Info

    Excel Basic

    Are you new to Excel? An understanding of Excel is a requirement of nearly all professionals in today’s working world. This class is designed for students who need Excel training for beginners. This course will teach you how to get started on the right foot with essential skills for using Excel spreadsheets. You will learn how navigate within Excel, easily enter information into spreadsheets, learn tricks to best view and manipulate and format data, and you will even learn how to create simple formulas. With basic Excel training, you will learn how to work with pre-created spreadsheets, as well as create your own simple spreadsheets from scratch. Our instructors will be on hand to answer your questions and lead you to a thorough understanding of the application on a beginner’s level.
  • 15 Request Info

    Excel Boot Camp

    Our Microsoft Excel Boot Camp covers most of our Excel content in an action packed 3 days in Denver or Phoenix. This Excel course includes the content from the intermediate, advanced, pivot tables and charts, functions and formulas, and managing databases classes. This is not an overview class; instead, it will give you a thorough understanding of what you can do with this powerful spreadsheet application. Our instructors will lead you through this intensive Excel course, to take you from novice to master in just a few days. Students exiting the Microsoft Excel Boot Camp class will be comfortable using advanced features in Microsoft Excel to do a variety of tasks. They will understand formulas and functions in depth, will be able to expertly format spreadsheets, will know how to analyze and display data with pivot tables and charts, and will be able to share spreadsheets with others, as well as be able to create drop-downs and automation, and lock cells.
  • 16 Request Info

    Excel Intermediate

    Build upon your basic knowledge of this essential application to learn more formatting, more formulas, and more functionality. You will learn to work with functions such as IF, Proper, Roundup, and Date and Time functions, as well as how to create visual impact with your data by creating charts. It also looks at how to create formulas across multiple spreadsheets in the same document. Our instructors will be available to answer your questions and make sure you have a firm understanding of Excel at a deeper level. In the Intermediate Excel training course, we will begin to explore how to utilize more complex functions, including date and time functions and IF statements, as well as AutoSum. We will also look at organizing data, working with multiple worksheets, and basic charting. Students will learn how to do more with copying and pasting, such as creating custom lists. They will learn more advanced formatting techniques like Conditional formatting.
  • 17 Request Info

    Best Mastering Excel Formulas and Functions 2019

    Overview: 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. Why should you Attend: How to create formulas will automate your calculations and save you a ton of time. No more using your fingers. No more mental arithmetic. No more using the calculator app on your Smartphone! Let Excel do the work for you!
  • 18 Request Info

    Webinar on Creating Smart Presentation: Integrating the use of Word, Excel and PPT

    Learn the details on how to link MS word, excel and PPT to make effective reports and presentation. 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/Creating-Smart-Presentation-Integrating-the-use-of-Word-Excel-and-PPT-504292/FEBRUARY-2019-ES-TRAININGREGISTRY
  • 19 Request Info

    Webinar on Tricks of the Trade: MS OFFICE for EAs, PAs & Office Managers

    Join this MS OFFICE Training to learn how to take control of your inbox and calendar with MS Outlook; how to use features and functions of the spreadsheet tool. Price:$150.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/Tricks-of-the-Trade-MS-OFFICE-for-EAs-PAs-Office-Managers-503190/FEBRUARY-2019-ES-TRAININGREGISTRY
  • 20 Request Info

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

    Learn best practices to create dynamic, interactive charts. Understand how to use INDEX and MATCH to retrieve data and chart with multiple criteria. 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-504477/FEBRUARY-2019-ES-TRAININGREGISTRY