Welcome to ONLC Training Centers

Excel Analytics & Power Classes

Microsoft Excel has features that bring advanced business analytics, business intelligence and publishing capabilities to average users. These features became available with version 2013 through the “Power” add-ins of Power Pivot, Power Query, Power View and Power Map.

With the BI (business intelligence) and business analytics tool in Excel, data science is no longer solely in the hands of the technical elite. Business analytics and business intelligence is now democratized for every Excel users with features including:

  • Get Data. Power Query lets you connect to public data or corporate data sources. Then it makes “data munging” and “data wrangling” easy by merging data from multiple sources and re-shaping and transforming data with repeatable steps.

  • Analyze. Power Pivot creates sophisticated data models with relationships, custom calculated fields, hierarchies, and KPIs that can analyze 100s of millions of rows of data with lightning-fast performance. After getting your data, use Power Pivot for Excel to put it all together in sophisticated data models.

  • Visualize. Power View lets you quickly create interactive reports, analytical views and dashboards.With Power Map for Excel you can perform geospatial explorations of your data by taking advantage of any data with location to plot across 3-D maps. Interact and story tell with this captivating map tool to see your data in new perspectives and unlock deeper insights.

  • Publish. Power BI publishes your reports making them available for your team. Colleagues can then access and interact with your reports in a browser, making it easier to consume data and unlock insights.


Instructor-led Training (ILT)

Click for FAQs about remote instructor-led training

ILT classes are live, hands-on classes led and supported by an online instructor. You'll do hands-on exercises throughout the class to ensure learning and can engage directly with the instructor at any point. Attend class from any of ONLC's hundreds of training centers click or from your own location click. Training is fully interactive no matter what class location you choose.

ONLC Value Adds

Work hands-on with the software for best learning

You get more with ONLC. Train with confidence knowing ONLC has a money-back satisfaction guarantee link plus the option to see the same class a 2nd time with our optional free refresher course link. These ONLC value-adds are available when students attend our public, instructor-led training (ILT) classes.

Group Training from ONLC

Save time and money bringing teams up to speed on Camtasia with our group training solutions. Instruction can be virtual or in-person with public or private sessions. We can even customize content to meet specific learning objectives, schedules and budgets. To learn more and for a price quote see Group Training .

Excel Analytics Classes & Schedule

Click the title of the Adobe Captivate certification training courses marked with the green flag () to see specific locations and dates of Ready to Run classes.  Click the title of the Adobe Captivate certification training courses marked with the yellow flag () to see specific locations and dates of Early Notice classes.

Class Information
Click Title for Dates & Outlines Days Fee
Excel Analytics
Excel PowerPivot and Interactive Visualizations 3 $1495
Power BI Tools: DAX Introduction 2 $995
Power BI Tools: Get and Transform Data (with M Programming) 1 $495

Looking for other Excel titles?
ONLC offers multiple levels of Excel training as well as Specialty titles. See more Excel classes.

 

Looking for more Data Analytics / Business Intelligence classes?
ONLC offers Business Intelligence / Data Analytics courses from a variety of vendors. See all Business Intelligence classes.

 


News & Offers

Call an ONLC Education Advisor for certification and course selection assistance

Education Advisors for Personal Guidance
Our Education Advisors can answer questions you may have about our classes and training options. Our Advisors can help you find training is right for your goals. ONLC's Education Advisors are available weekdays at our toll free number or via CHAT (icon on this page).

 

Train at any ONLC center

Hundreds of ONLC Centers Coast to Coast
We schedule every online instructor-led (ILT) class for each of our ONLC Training Centers locations. Our training rooms are outfitted with the equipment needed for training and provide an interruption-free space so you can concentrate fully on learning. Find an ONLC center near you click link.

 

Train at Home

Live Classes from Home
You can attend our live, instructor-led classes from the comfort and convenience of your own home. The setup is really easy and you don't have to have the class software. Follow our easy setup video click link. After viewing, if you're still not sure about the setup contact an ONLC Advisor toll free for assistance.

 

Group training available from ONLC

Group Training Option
ONLC offers complete learning solutions so training coordinators can quickly and successfully upskill their teams while maintaining their budget. Training can be via our public class schedule or private sessions delivered virtually or in-person on-site. We can also customize content to meet the client's specific needs and technologies. To discuss our group training options and to receive a price quote complete our quick Group Training Request form click link or call 1.800.288.8221 (weekdays).

 

spacer

For More Information

To register for class by phone or for more information contact our Education Advisors weekdays via the chat feature or by calling:

1.800.288.8221

 

Locations
Virtual Excel BI training
AlabamaBirmingham Excel BI trainingHuntsville Excel BI training
Mobile Excel BI trainingMontgomery Excel BI training
ArkansasBentonville Excel BI trainingLittle Rock Excel BI training
ArizonaMesa Excel BI trainingPhoenix Excel BI training
Scottsdale Excel BI trainingTucson Excel BI training
CaliforniaIrvine Excel BI trainingLos Angeles Excel BI training
Manhattan Beach Excel BI trainingOrange Excel BI trainingRiverside Excel BI training
Sacramento Excel BI trainingSan Diego Excel BI trainingSan Diego Excel BI training
San Francisco Excel BI training
ColoradoBoulder Excel BI trainingCentennial Excel BI training
Colorado Springs Excel BI trainingDenver Excel BI trainingFt. Collins Excel BI training
Grand Junction Excel BI trainingLoveland Excel BI training
ConnecticutCheshire Excel BI trainingRocky Hill Excel BI training
Shelton Excel BI trainingStamford Excel BI training
District of ColumbiaWashington Excel BI training
DelawareWilmington Excel BI training
FloridaBoca Raton Excel BI trainingBonita Springs Excel BI training
Bradenton Excel BI trainingFort Lauderdale Excel BI trainingFort Myers Excel BI training
Fort Walton Beach Excel BI trainingJacksonville Excel BI trainingKissimmee Excel BI training
Lakeland Excel BI trainingMiami Excel BI trainingMiramar Beach Excel BI training
Orange Park Excel BI trainingOrlando Excel BI trainingPensacola Excel BI training
Plantation Excel BI trainingTallahassee Excel BI trainingTampa Excel BI training
GeorgiaAlpharetta Excel BI trainingAtlanta Excel BI training
Duluth Excel BI trainingKennesaw Excel BI trainingMacon Excel BI training
Martinez Excel BI trainingSavannah Excel BI training
IowaBettendorf Excel BI trainingDes Moines Excel BI training
IdahoBoise Excel BI training
IllinoisChicago Excel BI trainingGurnee Excel BI training
Joliet Excel BI trainingOak Brook Excel BI trainingPeoria Excel BI training
Schaumburg Excel BI trainingWarrenville Excel BI training
IndianaCarmel Excel BI trainingEvansville Excel BI training
Fort Wayne Excel BI trainingGreenwood Excel BI trainingIndianapolis Excel BI training
South Bend Excel BI training
KansasLenexa Excel BI trainingWichita Excel BI training
KentuckyFlorence Excel BI trainingLexington Excel BI training
Louisville Excel BI training
LouisianaBaton Rouge Excel BI trainingNew Orleans Excel BI training
MassachusettsBoston Excel BI trainingDanvers Excel BI training
Woburn Excel BI trainingWorcester Excel BI training
MarylandAnnapolis Excel BI trainingColumbia Excel BI training
Frederick Excel BI trainingGermantown Excel BI trainingGreenbelt Excel BI training
Owings Mills Excel BI trainingRockville Excel BI training
MainePortland Excel BI training
MichiganAnn Arbor Excel BI trainingGrand Rapids Excel BI training
Livonia Excel BI trainingSouthfield Excel BI trainingTroy Excel BI training
MinnesotaBloomington Excel BI trainingMaple Grove Excel BI training
Minneapolis Excel BI trainingWoodbury Excel BI training
MissouriLee's Summit Excel BI trainingSpringfield Excel BI training
St. Louis Excel BI training
MississippiRidgeland Excel BI training
MontanaGreat Falls Excel BI training
North CarolinaChapel Hill Excel BI trainingCharlotte Excel BI training
Charlotte Excel BI trainingFayetteville Excel BI trainingGreensboro Excel BI training
Raleigh Excel BI trainingRaleigh Excel BI trainingWilmington Excel BI training
North DakotaGrand Forks Excel BI training
NebraskaOmaha Excel BI training
New HampshireBedford Excel BI trainingConcord Excel BI training
Portsmouth Excel BI training
New JerseyBridgewater Excel BI trainingMahwah Excel BI training
Morristown Excel BI trainingMount Laurel Excel BI trainingParamus Excel BI training
Princeton Excel BI trainingRed Bank Excel BI training
New MexicoAlbuquerque Excel BI training
NevadaHenderson Excel BI trainingLas Vegas Excel BI training
Reno Excel BI training
New YorkAlbany Excel BI trainingBohemia Excel BI training
Buffalo Excel BI trainingLiverpool Excel BI trainingMt. Kisco Excel BI training
New York Excel BI trainingRochester Excel BI trainingUniondale Excel BI training
OhioBeachwood Excel BI trainingBeavercreek Excel BI training
Cincinnati Excel BI trainingCleveland Excel BI trainingColumbus Excel BI training
Dublin Excel BI trainingToledo Excel BI training
OklahomaOklahoma City Excel BI trainingTulsa Excel BI training
OregonPortland Excel BI trainingSalem Excel BI training
PennsylvaniaAllentown Excel BI trainingErie Excel BI training
Lancaster Excel BI trainingMalvern Excel BI trainingMechanicsburg Excel BI training
Philadelphia Excel BI trainingPittsburgh Excel BI trainingSouth York Excel BI training
State College Excel BI trainingWexford Excel BI training
Rhode IslandWest Warwick Excel BI training
South CarolinaColumbia Excel BI trainingGreenville Excel BI training
North Charleston Excel BI training
TennesseeKnoxville Excel BI trainingMemphis Excel BI training
Murfreesboro Excel BI trainingNashville Excel BI training
TexasAllen Excel BI trainingAmarillo Excel BI training
Austin Excel BI trainingBryan Excel BI trainingDallas Excel BI training
Dallas Excel BI trainingDenton Excel BI trainingEl Paso Excel BI training
Fort Worth Excel BI trainingHouston Excel BI trainingKaty Excel BI training
Keller Excel BI trainingPlano Excel BI trainingSan Antonio Excel BI training
San Antonio Excel BI trainingSouthlake Excel BI trainingSugar Land Excel BI training
The Woodlands Excel BI training
UtahProvo Excel BI trainingSalt Lake City Excel BI training
VirginiaAlexandria Excel BI trainingArlington Excel BI training
Charlottesville Excel BI trainingFairfax Excel BI trainingForest Excel BI training
Fredericksburg Excel BI trainingGlen Allen Excel BI trainingHerndon Excel BI training
Manassas Excel BI trainingMcLean Excel BI trainingRichmond Excel BI training
Roanoke Excel BI trainingStafford Excel BI trainingVirginia Beach Excel BI training
WashingtonBellevue Excel BI trainingFederal Way Excel BI training
Lacey Excel BI trainingPuyallup Excel BI trainingSeattle Excel BI training
WisconsinBrookfield Excel BI trainingGreen Bay Excel BI training
Madison Excel BI training
West VirginiaMartinsburg Excel BI training
WyomingCasper Excel BI trainingCheyenne Excel BI training
ONLC TRAINING CENTERS
800-288-8221
www.onlc.com