Intermediate Excel

Take your Excel skills to the next level with this intermediate course focused on Macros, VBA (Visual Basic for Applications), and automation.

4 hours
14 videos
28 exercises
611 xp

Let’s create your free account

OR

By continuing, you accept our Enterprise DNA Terms & Conditions , our Privacy & Cookie Policy and that your data is stored.

If you have an account Login here

Trusted by 220,000+ people worldwide.

coca-cola-logouniliver-logonhs-logonestle-logoatt-logoanglo-logomackinsey-logoalbemarle-logojonson-logopanasonic-logo

An outline of this training course

This Intermediate Excel course covers essential topics for data analysts such as tables, pivot tables, Power Query, Power Pivot, grouping and ranking, and charts. Key learning objectives include the ability to manipulate and analyze large data sets using pivot tables, import and transform data with Power Query, and create relationships and measures with Power Pivot.

This course is beneficial for data analysts who need to improve their skills in data analysis and management to make more informed decisions. Real-life scenarios where these skills could be applied include analyzing sales data to identify trends and forecasting future sales, analyzing customer behavior to inform marketing strategies, and analyzing financial data to identify cost-saving opportunities. By the end of the course, participants will have the skills and confidence to use Excel more effectively to gain insights and make data-driven decisions.

 

What is needed to take this course 

Enterprise DNA Microsoft Excel for Beginners is recommended although not necessary.

 

Who is the course for

Professionals who work with data and want to enhance their ability to effectively organize, analyze, and visualize large data sets in Excel

 

Details of what you will learn during this course

By the end of this course, you will:

  • Use tables and pivot tables for data analysis and organization
  • Extract, transform, and load data using Power Query
  • Create relationships and measures with Power Pivot
  • Group, rank, and summarize data for efficient analysis
  • Create and format charts to visualize data effectively

 

What you get with the course

  • A 4+hour self-paced video training

 

Program Level

Intermediate

 

Field(s) of Study

Computer Software & App

 

Instruction Delivery Method

QAS Self-study

 

***This course was published in May 2023

 

Enterprise DNA is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org

What our

Students Say
Curriculum
1

Course Overview


2

Resources


3

Introduction


4

Organizing and Analyzing Your Data


5

AI Bot


6

Enterprise DNA Workouts for Excel


7

Couse Wrap Up


8

Your Feedback


9

Certfication


10

Continuous Learning


Your

Instructor
Empty image or helper icon

Antriksh Sharma

We are always looking for the best solution for you

Frequently Asked

Questions

Recommended

Courses
Course Cover: Introduction to Python for Data Science
beginner
Total points: 272 XP 2 hours

Introduction to Python for Data Science

A comprehensive journey through the essentials of data science with Python, aimed at beginners ready to delve into data analysis and visualization.
Tools
Python
EDNA Experts
EDNA Experts
See details
Course Cover: VBA Automation Techniques for Businesses
beginner
Total points: 208 XP 1 hours

VBA Automation Techniques for Businesses

EXPERIMENTAL: This course teaches valuable Microsoft VBA automation techniques that optimize business processes, leading to increased productivity and efficiency.
Tools
Excel
Skills
Process Automation
App Development
EDNA Experts
EDNA Experts
See details
Course Cover: SQL Fundamentals for Financial Analysis
beginner
Total points: 212 XP 1 hours

SQL Fundamentals for Financial Analysis

EXPERIMENTAL: A comprehensive course providing financial professionals with the fundamentals of SQL and its application in financial analysis.
Tools
SQL
Skills
Data Analysis
EDNA Experts
EDNA Experts
See details

Get full access to unparalleled

training & skill-building resources
power-bi-custom-visuals

FOR INDIVIDUALS

Enterprise DNA

For Individuals

Empowering the most valuable data analysts to expand their analytical thinking and insight generation possibilities.

Learn More

FOR BUSINESS

Enterprise DNA

For Business

Training, tools, and guidance to unify and upskill the data analysts in your workplace.

Learn More
power-bi-custom-visuals