Data Analytics with Excel Mastery

 

Now more than ever, important business decisions are based on the precision mining, organization and analysis of data.  It’s not far-fetched to say that data analytics has become an art.  If it’s true that the devil is in the details, then the answer is in the data – but only if you know the right queries answering the right questions.  Data manipulation starts with Microsoft Excel, to this day one of the most enduring and powerful software programs ever written.

Excel 1 Foundation 

Intro to spreadsheets, general formatting, simple calculations, everyday functions, printing options.

Oct 8, 2021  1:00PM - 5:00PM
Feb 4, 2022 1:00PM - 5:00PM

Register online

 

Excel 2 Useful Tools

Conditional formatting, Intro to charts & graphs, Table tools, Sort & Filter data, Multiple worksheet management.

Oct 15, 2021  1:00PM - 5:00PM
Feb 11, 2022  1:00PM - 5:00PM

Register online

 

 

Excel 3 Powerful Functions 

IF, AND, OR, Nested Functions, VLOOKUP, HLOOKUP, INDEX, MATCH, Conditional Functions, Dates and Text Functions.

Oct 29, 2021  1:00PM - 5:00PM
Feb 18, 2022  1:00PM - 5:00PM

register online

 
 
 

Excel 4 Analyzing Data

Importing data from various sources, Summarizing data with functions & tools, Advanced Filters, Database Functions.

Nov 5, 2021  1:00PM - 5:00PM
Feb 25, 2022  1:00PM - 5:00PM

Register online

 

 

Excel 5 Complex Data Analysis

PivotTables and Pivot Charts, PowerPivot and Data Models, CUBE functions, Goal Seek Analysis. Tools for Market Analysis

Nov 12, 2021  1:00PM - 5:00PM
March 4, 2022  1:00PM - 5:00PM

register online

 

 

 

About Us

Launched by Amarillo College in 2020, the mission of the Innovation Outpost is to advance industrial innovation, digital transformation, and twenty-first-century skill development to foster a more competitive and advanced economy in the Texas Panhandle.

Amarillo College Logo

Contact Us

P.O. Box 447
1314 S. Polk St.
Amarillo, TX 79101

 

Return to top