Analytics Boot Camp: Excel Essentials

Overview

Unlock key skills in Microsoft Excel to develop a strong foundation in data analysis techniques, including numerous analytical techniques, data preparation, integration, and charting skills. Learn to use data to gain insight into sound business strategy, a key component in problem-solving and decision-making within a mission-critical organization. Working collaboratively through real-world scenarios using Microsoft Excel, you’ll be prepared to perform the most relevant, mission-critical analyses for your organization.

Who Attends

This course is designed for professionals who seek formal training or a refresher course in foundational skills for data analytics.

Course Level: Basic
CLP: 16 | CPE: 16
Duration: 2 Days

Price: $ 1409.00 Course prices shown here do not include a credit card surcharge. Payments by ACH, EFT, or check do not include the surcharge and are offered at a lower price. At checkout, you may choose a payment method that avoids the credit card surcharge.
A 3% credit card surcharge will be applied.

Course Details

FAQs Technology Requirements

For Groups

Volume Discounts (5+ Seats) Private Group Training Icon

Private Group Training

Available Dates

Guaranteed to Run are designated with a

January 19 - January 20, 2027

Class ID: 274660001

Virtual

9 AM - 5 PM EST

March 22 - March 23, 2027

Class ID: 274660002

Virtual

9 AM - 5 PM EST

May 17 - May 18, 2027

Class ID: 274660003

Virtual

8 AM - 4 PM EST

July 26 - July 27, 2027

Class ID: 274660004

Virtual

9 AM - 5 PM EST

September 13 - September 14, 2027

Class ID: 274660005

Virtual

9 AM - 5 PM EST

November 1 - November 2, 2027

Class ID: 274660006

Virtual

9 AM - 5 PM EST

Learning Objectives

Explain the importance of data analysis and data analysis tools to help organizations solve problems effectively
Review basic Excel components and functions
Use ranges, anchoring, and Excel tables to perform analysis tasks
Sort and filter data to identify relevant information
Create charts to clarify analysis results and make informed decisions
Use Excel's VLOOKUP function
Create pivot tables and charts to summarize data
Perform text manipulation functions to turn raw data into useable data
Utilize Excel’s Get and Transform feature to import and transform data

Additional Features

Learn More

Credits

CLP Credits: 16
CEU Credits: 1.3
PDUs: 14
NASBA Field(s) of Study and Credits: Statistics (16 CPEs)
NASBA Level: Basic
FM MyLearn Number: L3911

This course is part of the following Management Concepts Certificate Programs:

Core Courses

None

Elective Courses

Data Analytics Certificate Program
Agile in Government Master Track
Business Analysis and Requirements Management Master Track
Project Management Master Track
Program Management Certificate Program

Prerequisites:

Mandatory

Participants should have a basic understanding of Excel.

Suggested

Introduction to Analytics

Course Activities

Course Topics

Introduction to Data Analysis

What Is Analysis?
Why Analyze Data?
The Role of the Data Analyst
The Analytics Process Model
AI in Analytics

An Excel Primer

Using Excel for Data Analysis
Excel Components
Keyboard Shortcuts and Function Keys
Order of Operations

Ranges, Anchoring, and Excel Tables

Range References
Absolute References (Anchoring)
Excel Tables

Sorting and Filtering Data

Sorting Data
Filtering Data

Charting Data

Using Charts for Data Analysis
Formatting Charts
Creating Charts
Exercise: Variance Charts
Exercise: Line Charts
Exercise: Bar Charts
Exercise: Multiple Line Charts

VLOOKUP

Excel's LOOKUP Functions

PivotTables

The PivotTable
PivotTable Components
Creating a PivotTable
Exercise: PivotTables
PivotCharts

Text Manipulation Formulas

Text Manipulation Functions
Data Tools for Text Manipulation

Get and Transform

What Is Get and Transform?
Getting Data
Transforming Data
Leveraging Power BI
Course Wrap Up and Open Issues

Related Courses and Products

COURSE

Analytics Boot Camp: Core Analytics

Develop a strong foundation in data analysis techniques to gain insight into sound business strategy, an insight critical to problem-solving and decision-making within your organization. You will lear...

COURSE

Data Collection Techniques

Analyze and collect clean data, particularly in the context of your organization’s data management. Learn best practices to combat common obstacles in data collection. Gain strategies for identifying...

COURSE

Data Analysis and Modeling Techniques

Analyze data to help solve your organization’s most complex challenges and requirements. Learn the core techniques used to analyze and model complex data into understandable information. Gather the sk...

COURSE

Evaluating and Presenting Analysis Results

Capture the value of key data analyses and present them in a way that ensures decision-makers can interpret those results to make sound decisions. Learn how to capture, analyze, and determine relevanc...

COURSE

Data-Driven Decision-Making

Explore the General Decision Support Model, a framework that guides effective decision-making during the analytics process and helps ensure a sound business strategy based on facts. You will practice...

Loading Course Details

Analytics Boot Camp: Excel Essentials

Overview

Who Attends

For Groups

Available Dates

Learning Objectives

Additional Features

Credits

This course is part of the following Management Concepts Certificate Programs:

Core Courses

Elective Courses

Prerequisites:

Mandatory

Suggested

Course Activities

Course Topics

Introduction to Data Visualization

Leveraging Artificial Intelligence (SI) for Federal Decision-Making