Excel 2007 Advanced Course (with certificate) - SL-Institute

SL-Institute

This lesson contains

Expand All

USE OF DATA LISTS 5 Chapters

Expand

Lesson Content

0% completed 0/5 steps

PRELIMINARY REMARKS ON THE DATA LISTS

FORMAT THE TABLE

UPDATE THE LIST

FILTER THE LIST BY CHOOSING CRITERIA

STATISTICAL CALCULATIONS

DOCUMENT AUTOMATION 3 Chapters

Expand

Lesson Content

0% completed 0/3 steps

THE ROLLING LISTS

THE CHECK BOXES

THE OPTION BOXES

PERSONALIZED LISTS 2 Chapters

Expand

Lesson Content

0% completed 0/2 steps

CREATE YOUR OWN LISTS

IMAGES 1 Chapter

Expand

Lesson Content

0% completed 0/1 steps

THE PLAN MODE 3 Chapters

Expand

Lesson Content

0% completed 0/3 steps

WORK IN PLAN MODE

CREATION OF A PLAN

USE THE PLAN MODE

MACRO COMMANDS 4 Chapters

Expand

Lesson Content

0% completed 0/4 steps

CONSTRUCTION OF A MACRO COMMAND

EXECUTION OF MACROS

INCORPORATION OF A MACRO BUTTON ON THE WORKSHEET

CONDITIONAL FORMATTING 7 Chapters

Expand

Lesson Content

0% completed 0/7 steps

HIGHLIGHT LINES CONTAINING TEXT

THE GRID APPEARS AS YOU TYPE IN COLUMN A

IDENTIFY AMOUNTS THAT EXCEED AN AVERAGE

IDENTIFY LINES BASED ON SEVERAL CRITERIA

FIND ROWS THAT EXCEED A PERCENTAGE OF A TOTAL

IDENTIFY UNPAID INVOICES

COLOR ONE LINE OUT OF 2

You are not registered for this course

Take this course

19.90€

This Includes course

7 Lessons
25 Chapters

SL-Institute

Smart Learning Institute is an online learning school offering courses, tutorials, eBooks that help students expand their knowledge. Through innovative technology, each student can learn 24/7 and develop their own skills.

Explore

SL-Institute

SL-Institute © 2021