Course NT-Excel (Viz) Visualization of data in Microsoft Excel | nt.ua

(044) 390 73 35 (050) 352 68 64

EN RU UA

Course NT-Excel (Viz) Visualization of data in Microsoft Excel

Learning how to build pivot charts, use conditional formatting, and work with mini charts will allow you to effectively manage and visualize big volumes information that will facilitate the decision-making process. The skills you'll learn in this MS Excel data visualization course are hands-on, so you can quickly implement them in your work.

After completing this course, students will be able to:

  • Insert and edit charts, including using recommended styles and express Layouts
  • Apply Sparklines for visualization trends and key indicators, skillfully configure their parameters.
  • Create and configure conditional rules formatting to effectively highlight important data
  • Use pivot charts to analyze and visualize data, including creating dynamic pivot charts
  • Use filters combined charts and add dividers for easy management and visualization of data sets

Audience Profile

Received skills can be applied in various industries and fields of activity, so this course will be useful to specialists in various fields, from marketing to finance.

Before attending this course, students must have:

  1. Building and editing charts
    • Insert a Featured Chart (Chart Wizard)
    • Types of diagrams, recommendations for use
    • Quick Layouts and Chart Styles
    • Setting up charts
    • Adding and editing chart elements
    • Setting chart element formatting
    • Editing the layout and dimensions of a chart
    • Combination charts. Using an auxiliary axis
    • Filters in charts
    • Deleting a chart
  2. Mini charts
    • Using Sparklines
    • Settings
    • Types of Sparklines
  3. Conditional Formatting
    • Creating Conditional Formatting Rules
    • Advanced formula-based Conditional Formatting customization
    • Rule management
    • Some examples of practical application
  4. Working with PivotCharts
    • Create dynamic pivot charts using pivot tables
    • Customizing PivotCharts
    • Formatting PivotCharts
    • Updating PivotCharts
    • Adding and connecting separators
    • Building dashboards with pivot charts

Sign up for the closest date

Course Code

NT-Excel (Viz)

Length, days (hours)

1 (8)

Closest dates

on request

Price, UAH