Training: Excel – Giving visual impact to your spreadsheets

Ref. MOE-24

Download PDF

Duration:

0.5

day

Exam:

Not certifying

Level:

Advanced

Funding:

Temptraining

ITTA | Trainings | Office Automation | Spreadsheet | Excel – Giving visual impact to your spreadsheets

Description

This training will allow participants to make their spreadsheets more visually impactful, using formatting automation.

Participant profiles

Users who want to improve their spreadsheet formatting skills

Objectives

Set up complex conditional formatting
Modify and customize the theme of their worksheets
Use Sparkline charts

Prerequisites

Basic knowledge of Excel

Course content

Module 1: Conditional Formatting

Setting up simple conditional formatting
Understanding and applying conditional formatting of different types
Managing conditional formatting rules
Setting up complex conditional formatting with formulas
Reproducing conditional formatting
Find cells with conditional formatting
Modify conditional formatting
Delete conditional formatting

Module 2: Themes

Understanding how themes work in Excel
Modifying a theme
Customizing a theme and save it
Understanding the difference between theme colors and standard colors

Module 3: Sparkline Charts

Create a sparkline chart
Highlight specific values in a sparkline chart
Display and customize axis settings

Documentation

Digital courseware included

Lab / Exercises

Practice exercises will be given at the end of each module

Complementary courses

Temptraining funding

ITTA is a partner of Temptraining, the continuing education fund for temporary workers. This training fund can subsidize continuing education for anyone who works for an employer subject to the Collective Work Agreement (CCT) Rental of services.

Additional information

As we care about the quality of our training, ITTA offers you an online skills assessment test before and after your course so that you can evaluate your progress