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

Course Details

FAQs Technology Requirements

For Groups

Volume Discounts (5+ Seats) Private Group Training Icon

Private Group Training

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

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

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 for Federal Decision-Making