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
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
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
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
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
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.
