Online course - Excel: Conditional Formats
Online course - Excel: Conditional Formats
With this course you will have the opportunity to learn to master the creation of conditional formats, providing your data to Excel with tools that offer more effective control over your information.
Specific goals | Temary
In this course on Excel conditional formats, you will learn to master the creation and management of tools that provide more effective control over your data.
Designed for a level of knowledge of Middle Excel, this training addresses topics that can be easily assimilated, offering an excellent opportunity to improve your skills in this tool.
You will learn to apply advanced conditional formats such as data bars, color scales and icon sets, thus expanding your professional skills and your Excel domain.
Topic
Introduction and creation of simple conditional formats
- Definition and usefulness of the conditional format
- Conditional format type
- Other tools available
- Creating simple conditional formats
Creation and management of advanced conditional formats
- Data Bars
- Color Scales
- Icon Set
- Creating new rules
Editions
From Mon 01/04/24 al Tue 30/04/24
From Wed 01/05/24 al Fri 31/05/24
General information
Enrolment
>> This online activity is available between the first and last day of each month.
>> Registration is possible even if it has already been started.
>> To enroll in any online activity you need to have a web user created. You can create it here.
>> Once enrolled you will find the course in your Personal Space --> Activities --> Activities in progress (barcelonactiva.cat)
>> You can access the materials of the activity while editing is active.
>> This online course is self-training.
>> To view the videos subtitled, click on the CC button you will find in the video playbar and select language.
Certificate
>> You will get a certificate of accomplishment when completing all modules and overcoming the activities/test, of the formation before the end of the editing in which the enrolment was made.
>> Course completion status. Within the same course you will find the Results menu point, you will find the Export option (top right). Clicking will open a document showing a report with the status of each lesson. If there are any lessons that are not approved, the contents need to be re-examined as there is some part left undisplayed/made.
>> Once the training is completed, within 24 to 48 hours you will be able to download the certificate to your Personal Space --> Activities --> Activities performed (barcelonactiva.cat)
Recommendations
>> It is recommended to perform training from a computer and not from mobile or tablets.
>> The most used browsers are: Google Chrome, Safari (for iOS operating systems), Microsoft Edge (for Windows operating systems) and Mozilla Firefox.
Course ratings
Lesson taught by
FERRER MARTÍNEZ