Udemyintermediateen

Excel 2019 Intermediate

Master data visualization! Learn to create impactful charts, graphs, and sparklines using workbooks. Improve your data storytelling skills.

4.8(11)
29students
4h 46m
Certificate
Intellezy Trainers
Intellezy TrainersMulti-Award-Winning eLearning Specialists

Course Content

Excel 2019 Intermediate is an intermediate-level Udemy course taught by Intellezy Trainers. It runs 4h 46m, is taught in English, and includes a certificate of completion. Learners rate it 4.8 out of 5 from 11 reviews, with 29 students enrolled. It is a paid course, last updated August 2022.

Master Excel Data Analysis and Visualization: Unlock the Power of Your Spreadsheets

This comprehensive course empowers you to transform raw data into actionable insights using Microsoft Excel. You'll gain practical skills in organizing, analyzing, and presenting information effectively.

Here's what you'll learn:

  • Data Linking & Management: Seamlessly link and manage workbooks and worksheets for efficient data handling.
  • Range Names: Utilize range names to simplify formulas and enhance data readability.
  • Sorting & Filtering: Quickly sort and filter large datasets to isolate key information.
  • Table Analysis & Organization: Organize and analyze data using Excel tables for enhanced functionality.
  • Conditional Formatting: Highlight important data points and trends with dynamic conditional formatting.
  • Outlining & Subtotals: Create structured reports with subtotals and grouping for clear data presentation.
  • Data Visualization: Display data graphically with compelling charts and sparklines.
  • PivotTables & PivotCharts: Become proficient in using PivotTables and PivotCharts for powerful data summarization and analysis.
  • Slicers: Interact with PivotTables using slicers for dynamic data filtering.
  • Advanced PivotTable & PowerPivot: Explore advanced PivotTable features and leverage PowerPivot for large-scale data analysis.

Why Choose Intellezy?

Intellezy offers a vast library of Excel training videos and courses – nearly 10,000 resources covering desktop applications, technical concepts, and business skills. We provide engaging video content with pre- and post-course assessments to measure knowledge gain. Our training is regularly updated to reflect the latest software changes, ensuring you have access to the most current techniques. Plus, our in-house video development allows for quick adaptation and custom content creation for tailored software rollouts.

Certification & Compliance:

This course aligns with the CAP Body of Knowledge and is approved for 4.5 recertification points under the Technology and Information Distribution content area.

Get Your Certificate:

Upon completion, email proof of completion to [email protected] to receive your certificate. Elevate your skills and stay ahead with Intellezy's expert Excel courses!

$ whoami — the devs behind tutorialsearch.io

Need a web app built? Hire the team behind TutorialSearch.io

We ship fast, production-grade full-stack apps (Next.js, React, edge infra) — the same stack that powers this site.

5.0(462)
3h 57m
intermediate
skillshare
5.0(278)
4h 21m
intermediate
skillshare
5.0(437)
3h 15m
all
skillshare
skillshare
skillshare