Live Instructor-Led, Online Training Classes  in Phoenix, Arizona

OJT.com offers enterprises, corporations, organizations, and individual career seekers. Easy access to live instructor-led, online training classes for Excel in Phoenix, Arizona.

Microsoft Excel is the most widely utilized program in business today used by financial and business analysts, administrative staff, project managers, data scientists, and many other careers. This powerful spreadsheet software program helps organizations and individuals track, analyze, manipulate, and display data.

OJT.com live instructor-led, online training classes for Excel in Phoenix, Arizona. Offer seven levels of Excel to help make the complexities of this program easy to understand. Learn how to use formulas and functions to perform complex calculations. Create stunning graphs and charts to visually tell the story behind the data. Use macros and run scripts to automate repetitive tasks. Develop an expert understanding of VLOOKUP, Pivot Tables, and VBA.

OJT.com live instructor-led, online training classes for Excel in Phoenix, Arizona. Provide the skills and confidence to make an immediate impact on productivity and efficiency. Which makes live instructor-led, online training classes for Excel in Phoenix, Arizona. A valuable investment in the career development of your executive staff, employees, and yourself!

Excel Level 1 – Introduction

This one-day Excel training class takes you through the basics, introducing you to the Excel interface and then getting into worksheet features to help you become more comfortable using the program. You will be able to create worksheets, use basic formulas and functions and learn to format your data.

– Excel Basics
– Worksheets
– Formatting
– Manipulating Data
– Protecting Data
– Basic Importing
– Options

Excel Level 2 – Intermediate

This one-day Excel training class assumes you have a basic knowledge of the program and covers more advanced topics in customization, named ranges and tables. You will learn advanced formatting techniques and data visualization using charts and graphics while ending the class with an introduction to PivotTables.

– Customizing Excel
– Managing Worksheets
– Named Ranges
– Tables
– Advanced Formatting and Graphics
– Charting
– Intro to Pivot Tables

Excel Level 3 – Functions & Formulas

This one-day Excel training class provides an in-depth and hands-on experience using Excel’s more advanced functions and formulas to perform complex calculations. Data manipulation is a key competency today making this level a must-take for any Excel user.

– Logical and Lookup Functions
– Date and Time Functions
– Text Functions
– Reference Functions
– Statistical and Financial Functions
– Advanced Formulas
– Summarizing Data

Excel Level 4 – Macros & Advanced Features

This one-day Excel training class teaches advanced tools and techniques to help perform more complex tasks in Microsoft Excel like creating macros, using what-if analysis, and applying data analysis and validation techniques. You will be able to import, export and link your data and create custom lists and views.

– Introduction to Macros
– What-if Analysis
– Data Validation
– Advanced Importing, Exporting and Linking
– Custom Lists and Custom Views
– Quick Analysis Features

Excel Level 5 – PivotTables

This one-day Excel training class will help you become an expert in using PivotTables to manipulate and display large data sets. You will learn how to scrub, summarize, and sort your data using advanced techniques inside PivotTables and present it with visually appealing Pivot Charts. This class has become widely popular as data visualization gains steam.

– PivotTables Basics
– Drilling Down, Sorting and Grouping
– Filtering and Slicers
– Field and Global Options
– Report Layout Features
– Working with Calculations
– Pivot Charts
– Show Commands

Excel Level 6 – Power Pivot

This one-day Excel training class covers the add-in feature, Power Pivot, which is used to perform complex data analysis and create stunning data models. You will be able to wrangle multiple and large data sets from different sources and quickly execute sophisticated data analysis that can be shared.

– Power Pivot Data Model
– Relationships Between Data Tables
– Shaping the Data Model with Data Analysis Expressions Functions (DAX)
– Data Tables
– Time Intelligence

Excel Level 7 – VBA (Visual Basic Introduction)

This two-day advanced Excel training class teaches the foundational skills in Microsoft’s programming language for Excel. You will learn how to take complex and time-consuming tasks and automate them with code. As far as coding languages go, VBA is one of the easier languages to learn and should be known by those in or seeking a role in data science.

– Introduction to Visual Basic for Applications
– Reviewing Macros
– Excel VBA Programming Fundamentals
– Modules, Procedures and Functions
– Decision and Control Structures
– Arrays, PivotTables, and Screen Refresh
– Debugging Code
– Error Resolution
– UserForms