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

Courses

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

    Advanced Microsoft® Excel® Techniques

    Learn ways to make your job easier and increase the sophistication of your data reporting and analyzing. Each session focuses on saving-you-time techniques, advanced "how-to" exploring those previously programmer only features and more.
  • 6 Request Info

    Automating Excel - How to edit an Existing Macro - 2017

    Overview: 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. Although Excel has a macro recorder, there's a limit to what it can do. So where the macro recorder's functionality ends, VBA takes over.
  • 7 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!
  • 8 Request Info

    Conference about Excel Tips, Tricks, and Shortcuts

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

    Data Visualization with Excel

    Overview: 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 chart or graph that interprets trends in a set of data, than to just look at a set of figures. Why should you Attend: Until a few years ago it was enough to take a set of numbers and create a bar chart or pie chart. Although in the right situation these traditional charts are still appropriate, things have moved on We're constantly hearing words like Data Visualisation and Infographic. It's time to get your Excel related business and communication skills up to date and learn how to use it to present data in the modern world.
  • 10 Request Info

    Easy Excel Training

    We specialize in Microsoft Excel training for all skill levels (basic, advanced financial modeling, and VBA macro programming). We train anywhere in the continental USA. Call 646-325-9094 or email mike@easyexcelclasses.com for a quote.
  • 11 Request Info

    Excel - Benefits and Hazards in Office 365

    Overview: In this valuable presentation, Excel expert David Ringstrom, CPA, explains how the Office 365 version of Excel 2016 differs from previous versions and perpetual licensed versions of Excel 2016. Historically, each major version of Excel was identical for all users, but that's no longer the case. Why should you Attend: Apply pivot table-specific options in the Office 365 version of Excel 2016 to minimize repetitive work Learn keyboard shortcuts and tips that will help you work more efficiently in Excel
  • 12 Request Info

    Excel - Functionality, Power Query is a lot Faster

    Overview: If you've been frustrated by other limitations of pivot tables then Power Pivot is for you. Simply put, Power Pivot takes pivot tables and data analysis to the next level. If you're a fan of pivot tables, you'll love Power Pivot. Areas Covered in the Session: Importing data into Excel from external sources Creating pivot tables from multiple sources Creating relationships and data models Introduction to DAX formulas Cleaning and transforming data using Power Query Combining data from Multiple Tables
  • 13 Request Info

    Excel - How to Create Resilient and Practical Budget Spreadsheets - 2017

    Overview: David shares a wide range of helpful techniques, including how to separate inputs from calculations, streamline formula writing, preserve key formulas, and create both operating and cash flow budgets. Why you should attend: Learn to create both operating and cash flow budgets Learn how to Streamline formula writing Transform filtering tasks using the Table feature Understand the benefits associated with a variety of Excel functions
  • 14 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.
  • 15 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.
  • 16 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.
  • 17 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
  • 18 Request Info

    Excel for Right-Brain Thinkers

    An innovative approach to learning Excel for those who need a basic working knowledge. Especially geared for right-brain thinkers...those who learn best by starting with examples, rather than an array of commands & functions. Enhances engagement/retention.
  • 19 Request Info

    Excel Formulas and Functions in Mastering

    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. Why should you Attend: 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. Formulas and functions will automate your calculations and save you a ton of time. No more using your fingers. No more mental arithmetic. Areas Covered in the Session: Creating formulas to perform mathematical calculations Copying formulas and the difference between absolute and relative references Assigning names to cells and using them in formulas
  • 20 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.