Training

Training In All Microsoft Applications (Excel, Access, Office, Mac Office, SQL Server, Azure & Power BI)

microsoft-office

100% Custom Training in a Variety of Training Formats

♦ We provide training in all of the Microsoft desktop productivity tools (Excel, Word, Outlook, PowerPoint) for both the PC and the Mac, as well as training in all of the Microsoft databases (Access, SQL Server, Azure, Power BI).

♦ We have the most efficient, enjoyable, and affordable Microsoft application training programs available. From our local one-on-one training to onsite group training, we have the best training formats to match your exact needs.

♦ Our Excel training instructors are Microsoft Certified, Microsoft Excel MVP’s, the real Excel and Access subject matter experts.

♦ Each of our trainers is a Microsoft Excel and Access expert and each is a data visualization expert with over a decade of experience. Why not work with the best Excel trainers available, why not work with a Microsoft Excel MVP and Excel subject matter expert.

Our Team of First Generation Microsoft Excel MVP’s have you covered, exceptional programmers and trainers. They are the Microsoft Certified, Microsoft Excel Subject Matter Experts.

♦ We have been providing our Smarter Microsoft Training Solutions for over 25 years now. A Microsoft Certified Partner every year since 1994.

♦ We have a variety of 100% custom training platforms available, exactly matching your organization’s training needs.

Onsite one-on-one training (The BEST way to learn Excel or Access).
Onsite micro-group training.
Remote one-on-one training. (Most affordable Excel training.)
Remote group-training.
Onsite group training.
Webinars.
Seminars.
Training Videos.
Training books.

♦ These are live training sessions, not a pre-recorded video you sit and watch, staring at a screen as they dribble on, frustrated that you are unable to ask questions, frustrated that there are not covering the materials you want to learn for your job.

How can you learn if you are not interested in the material being presented? You cannot, and that is why we offer 100% custom Microsoft Training Solutions. We will engage your team and they will enjoy learning. That is what we bring to the table.

This is Interactive, Dynamic Microsoft Training at its Best!

Our "Micro-Group" Training Workshops

Ultra Small Groups, Multiple Trainers, Intensive, Hands-On Learning

Our Smarter Microsoft Training Solutions:

♦ Micro Workshops can be setup either at our Irvine Training Center at our company headquarters located in Irvine California, or in our Manhattan New York office, or at your location.

♦ Our Micro sized group workshops are for 2-5 trainees. This is a powerful hands-on training experience. You are guaranteed to learn Microsoft Excel, Access, Office, databases and Power BI.

No matter where your business is located, we can train your entire team rapidly and effectively, and we guarantee that your team will learn the Microsoft application.

♦ Case Study – Microsoft Excel Workshop

♦ Why Workshops Can Benefit Your Business

Microsoft Training Classes

Groups of 5 or More, Interactive Training

Our Best Value:

♦ Our Microsoft Classes are just as powerful as our ultra small Micro-Group workshops, but our classes are for larger groups of 5 or more (Up to 30 students).

♦ Classes can be onsite at your location, remote, or held at either our Irvine Training Center located in our California office or in New York in our Manhattan office.

As with our workshops, learning is guaranteed. Optional, homework can be assigned and graded for an additional cost.

One-On-One Microsoft Training with a Microsoft Certified Microsoft Excel MVP

The Quickest Way to Learn The Microsoft Applications, Guaranteed

Clearly One-On-One Training is the quickest and most efficient way to learn Microsoft Excel, Access, Office, Mac Office, SQL Server, Azure and Power BI:

♦ We offer our unique one-on-one Microsoft application training either on site at one of our offices, at your office, or remotely.

♦ Work one-on-one with a Microsoft Excel MVP; the true Excel subject matter experts.

Get a Smarter Microsoft Training Solution

♦ Our course-ware developers and professional business application developers can provide positive, effective Microsoft training solutions directly to you or your staff on a one-on-one basis.

The Most Efficient and the Quickest Way To Learn Microsoft Excel, Access, Office and Power BI

Onsite Training Seminars

Affordable Large Group Training

The most cost effective way to train your staff in a live training session, for larger groups of 31 or more:

♦ Seminars can be conducted either at your location or at a training facility near you.

♦ These are a great option for imparting knowledge to a larger group, or where you want to cover more material quickly. This is well-suited for a hands-off approach.

Online Webinar Training

Microsoft Excel, Access, Office, SQL Server, Azure and Power BI Training.

The most convenient and most affordable way to train your team, no matter their location(s):

Ask the Microsoft Excel expert

♦ Our Virtual live training is available to provide a hands-on experience with interactive guidance for maximum impact and long-term retention of information. We deliver results to improve productivity.

♦ No Matter where your staff is located or how many trainees there will be, with our live webinars format Microsoft training is fast, affordable and convenient.

♦ As Microsoft Excel, Access, Office and Power BI experts we provide live Microsoft application training webinars covering topics of interest for Microsoft Excel, Microsoft Access, and Microsoft Power BI applications.

♦ Our webinars are 100% customized for our clients, be they a business, a government office, an educational institution or a non-profit.

♦ Our most recent Microsoft Excel training webinar was based out of our office in Manhattan New York. The session took place on March 1st, 2019 at 2pm est.

One of our local New York First Generation Microsoft Excel MVP’s, Developers and Trainers based in Manhattan New York will be running this live session for one of our long-term Excel consulting clients.

Bob Umlas – Excel Expert

♦ The team of Microsoft Training experts at Excel and Access, LLC provide webinar based training for our clients. Click here to see our Excel and Access Webinar Training Page.

Most Recent Microsoft Excel Training Webinar

March 1st, Manhattan New York Office - Trainer, Microsoft Excel MVP

Basic Formulas Functions

SUM
IF
COUNT-COUNTA
AVERAGE
SUBTOTAL
Index, Match & VLOOKUP
SUMIF, COUNTIF
DATE functions
Functions
SUMPRODUCT
String
Logical
Math
Information

Pivot Tables & Charts

Source Data
Helper columns
Arrange the output
Create Pivot Chart

♦ Video: See the full-length video recording of the FREE Microsoft Excel MVP Training video, based out of our office in Manhattan New York.

♦ Agenda: Excel training topics for DGS by Excel and Access, LLC

♦ Workbook: Microsoft-Excel-Functions–Excelandaccess-training-03022019

Upcoming Microsoft Power BI Training Webinar

Live Microsoft Power BI Training via Texas

Microsoft Power BI Desktop Training with a legendary First Generation Microsoft Excel MVP based out of Texas.

Just Completed Onsite Microsoft Excel Training

New York Excel trainer travels to Secaucus NJ

♦ This onsite training session was held on Friday, in Secaucus.

♦ This training will be conducted by one of our First Generation Microsoft Excel MVP based out of New York. This is onsite group training in Microsoft Excel.

Training will be focused mainly on:

Achieving understanding of formulas on templates provided (feel free to teach any alternative ways if available)
Convert text to value and vice versa
Mid, left, right
Vlookups, vlookups with combination of vlookup/match
Hlookups
Pivots
Vlookups from pivots
Goal seek
Sumif
Sumifs
Indirect formula/vlookup & indirect formula combination
Index match formula
Excel short cuts (formatting, numbers, column/row width , goal seek, insert rows, apply filters, remove filters, hide/ unhide rows- columns; go to end of text, go to home, select entire region, group and ungroup, refresh pivots, etc)

Agenda: Pending

Microsoft Application Training Videos

Webinar Based Recordings - FREE Microsoft Excel & Microsoft Access

♦ See numerous full-length examples of our past Microsoft Excel and Access webinar based training videos, for FREE.

Learn Microsoft Excel:

Formulas and Functions
Charts and Graphs
Pivot Tables and Pivot Charts
Conditional Formatting
Tips & Tricks
Refresher Course
Integration & Automation
VBA/Macros/Code
Power Pivot

Learn Microsoft Access:

Tables
Queries
Forms
Reports
Graphical User Interface
Integration & Automation
Visual Basic for Applications (VBA)

The Microsoft Excel VBA Academy

Self-Study, Microsoft Excel VBA Training

Written by top Microsoft Excel MVP, Jacob Hilderbrand

♦ Introduction: To most people Excel is nothing more than a glorified calculator, or a white board for setting up text and images. Some people view Excel as a simple word processor with built-in tables. Sadly, most Excel users will never know, let alone understand, the program’s full potential.

♦ To those that know, Microsoft Visual Basic for Applications (VBA/Macros) is the code behind the Microsoft Office applications that allows you to fully integrate and automate one or more of the Microsoft desktop productivity tools.

♦ Here Jacob Hilderbrand takes the time to teach you how to write VBA for your Microsoft Excel files. A leading Microsoft Excel MVP, co-owner of VBAExpress.Com, and expert Microsoft Solution Developer at Excel and Access, LLC.

Learn Excel VBA from A Microsoft Certified Excel VBA Expert

Our Microsoft College Courses

Microsoft Excel & Word For Small Business Owners

Written by a top Microsoft Excel MVP, Chris Smitty Smith, now on the internal Microsoft Excel Team, that is how talented some of these Excel, Access and Data Platform MVP’s are, the best of the best.

We had the opportunity to write two Microsoft Training courses for a large group of online community colleges, written just for small business owners. The courses were available for several years at over 500 community colleges.

The materials were written an easily understood manner, custom tailored for small business owners.

The result, we taught tens of thousands of small business owners how to effectively leverage Microsoft Excel and Microsoft Word at their small business. We can do the same for your business, small or large.

♦ Microsoft Excel Training for Small Business – College Course by E&A.

♦ Microsoft Word Training for Small Businesses – College Course by E&A.

* When it comes to the Microsoft Applications we are the Microsoft Certified Experts.

Microsoft Internally Hired one of our top Microsoft Excel MVP’s for a reason, they know Excel. Period.

For The Most Comprehensive Training In The Industry

Our Microsoft Excel, Access, Office, SQL Server, Azure, and Power BI Application Training Services

♦ Being a Microsoft Certified Partner and Microsoft application training firm for 25+ consecutive years doesn’t happen overnight. To become one of the leading Microsoft application subject matter experts. It took 25-years to build this company, that after working in the filed for 15 years as a professional programmer, consultant and trainer. In reality it rarely happens that you find a firm with that many years of business under its belt. The majority of our competitors have less than 5 years experience, many list 2-3 years, that is terrible! They are not experts, they are beginners.

♦ Microsoft Excel and Access application training is the most common application training that we provide. Very few firms in this space, working in the same Microsoft applications we work in can say the same thing, very very few, maybe a dozen or two globally?

♦ We pride ourselves in having an amazing team of dedicated Microsoft Excel MVP’s that get results. Our MVP Team programmers and trainers exceed client expectations and they deliver our 5-Star custom Microsoft solutions, Smarter Microsoft Solutions if you will. So if you need Microsoft Excel, Access, or Office training, contact us today. We answer our phones live 24/7, 877-32-3539.

Why do top colleges, businesses, government agencies, non-profits and individuals hire us for our Microsoft Training Solutions? Because we are Microsoft Certified application experts. We have been for the past 25-years and counting.

We draw heavily on our team of award-winning Microsoft application experts, Data Scientists, and Data Visualization Experts which is composed of:

Microsoft Excel, Access, Office, Mac Office, SQL Server, Azure, Power BI experts
Dedicated Microsoft Office Authors
Certified and Highly Skilled Microsoft Desktop Productivity Tools and Microsoft Database Trainers
Professional Consultants, Programmers, Developers and Trainers
Data Scientists and Data Visualization Experts

Each of our Excel, Access, Office and Power BI classes are crafted and customized based on your unique demands and data needs. Your team will learn only the exact information they require to fulfill and perform their duties.

Our in-depth understanding of the industries we serve (ranging from business organizations, government agencies, non-profits and education institutions of all sizes and nationalities) allows us to deliver superior Microsoft application training to groups and individuals, onsite and remotely. We have intimate knowledge of the ins and outs of the industries we serve.

Some of the common training curriculum is based around:

Microsoft Excel (2003, 2007, 2010, 2011, 2013, 2016 and 2019)
Microsoft Access (2003, 2007, 2010, 2011, 2013, 2016 and 2019)
Microsoft Office Applications Suite (2003, 2007, 2010, 2011, 2013, 2016 and 2019)
Mac Platforms (2004, 2008, 2011, 2016, 2019)

Our training is not complete until your team feels confident and capable of implementing and utilizing the skills and knowledge they have obtained.

What sets us apart from the competition?

We encourage you to reach out following our training sessions with any follow up questions.

Call us now and get started today 877-392-3539

Free Consultation