Virtual Intermediate Excel

WorkShop Includes: Filters, SUBTOTAL VLOOKUP Merge Data with Lookup Functions Error Handling Tables Pivot Tables Must-Know Keyboard Shortcuts Workshop is led by an Excel Power User/Excel VBA Developer/Data Driven Application Developer. We recommend having a USB flash drive if you want to keep your work files after class. They serve as a great...

The bootcamp is designed to provide students with a general overview of Excel topics and specifically more knowledge of several different functions. It combines most of the material from the two workshops into an intense one-day session. Given the short timeframe and large amount of topics covered, students are expected to be able to learn quickly....

WorkShop Includes:  Logical Test  IF, AND, OR Functions  SUMIFS Function  INDEX & MATCH Merge Data with INDEX, MATCH Functions Text Manipulation and Cleaning Data  Date Function Table Objects

The Excel at Excel workshop is designed for students who are relatively familiar with other office productivity software, for example, Microsoft Word. (The students who succeed the most are comfortable using a computer and navigating around desktop programs on their own). It introduces a range of Excel topics giving students a taste of the potential...

The Excel at Excel workshop is designed for students who are relatively familiar with other office productivity software, for example Microsoft Word. (The students who succeed the most are comfortable using a computer and navigating around desktop programs on their own). It introduces a range of Excel topics giving students a taste of the potential...

Learn to create automated custom Excel applications using VBA. This two-day VBA Programming course helps advanced Excel users (Windows only) develop new skills writing and debugging powerful VBA code to automate workbook operations, create interactive forms, insert calculations and handle run-time errors. Prerequisites: This class is ideally suited...

In this three-hour session for Windows and Mac users, you will learn how to work on multiple worksheets simultaneously, how to set up what-if analyses models using Goal Seek, Scenario Manager and one- and two-input data tables. You will also learn how to record and edit simple macros. Prerequisites This class is ideally suited for people who have taken...

If you know the basics of Microsoft Excel and want to take your knowledge to the next level, then this hands-on bootcamp is for you. Whether you are in business, management, or simply interested in getting more organized, this Excel bootcamp will cover the tools and functions you need to automate or enhance the way you analyze and restructure your...

In this three-hour session for Windows and Mac users, you will learn to write complex formulas using Excel's built-in functions and array formulas. You will expand your library of functions to include financial, text parsing, logical, lookup and database functions. You will also learn to write array formulas, which are capable of performing multiple...

This course builds on the fundamentals in the Excel 2016 Basic course. In this class, you will create financial outlines and subtotals, create and manage cell range names, as well as create and modify column and pie charts. Sorting, filtering and calculations using calendar date functions will be covered as well as Pivot tables and charts. You'll also...

A PivotTable is Excel's most powerful data summarization tool. In this three-hour session for Windows and Mac users, you will learn what kinds of data works best for PivotTables and how to prepare your data. You will create PivotTables based on various data sources, summarize data by multiple categories using sum, average and count, format the PivotTable,...

Excel is one of the most complex and powerful software programs ever created, and becoming skilled in Excel can take many years! In this lively three-hour training session, you will learn many tips and tricks that will save you time every time you use Excel. We guarantee you will learn techniques worth remembering! Class Outline Formulas Display...

Virtually everyone who works with data could benefit by gaining a better understanding of Microsoft Excel. This class will extend beyond the simple addition of data and will put participants in a position where Excel is no longer a chore, but a powerful tool to assist in manipulating data efficiently. You’ll learn various functions to help you organize...

The main purpose of the course is to give students the ability to add analysis capabilities to Excel spreadsheets. Audience This course is intended for anyone responsible for analyzing data with Excel. Prerequisites Before attending this course, students must have: Basic knowledge of the Microsoft Windows operating system and its core functionality....

Build formulas to add, subtract, multiply, divide, average, and figure percentages. Create different spreadsheets from scratch, learn many tips and shortcuts, as well as Charts. What you will learn: Create Formulas that add, subtract, multiply divide, etc: Learn how to create Formulas that add, subtract, multiply, and divide numbers, calculate...

This course is designed to provide students with a basic to mature ability to collect, enter, and perform calculations with data in MS-EXCEL spreadsheets, and to utilize basic statistical techniques to analyze and present the data in words, graphs and charts. These skills will be useful in securing entry level IT positions in industry. Key topics...

This class will be held remotely through live videoconferencing. Excel 2016, the most popular spreadsheet program, has powerful features that allow you to analyze and manipulate financial and mathematical data. It’s great for budgets, simple bookkeeping, an easy database, or making charts and graphs.  In this hands-on beginning class, you’ll...

A dashboard is a single screen used for reporting that displays charts, tables, and other visual data components on a related subject. Learn how to create Dashboards that will transform business data into actionable information. You will: Create an interactive, dynamic information source within Excel without creating a monster workbook or submitting...

This one-day class offers tips, tricks and timesavers that will help you get the most from Excel. It is an easy quick-paced class that will touch on most of the popular Excel features and how to access them efficiently. Version Note While this class is being taught using the 2016 version of the Excel software, almost all topics will be applicable...

If you know the basics of Microsoft Excel and want to take your knowledge to the next level, then this hands-on bootcamp is for you. Whether you are in business, management, or simply interested in getting more organized, this Excel bootcamp will cover the tools and functions you need to automate or enhance the way you analyze and restructure your...