Loading...
Loading content...
Spreadsheet - Advanced functionalities
UFCD CODE:0757 WORKLOAD:25 NUMBER OF ACTIONS TO BE HELD:01
LEVEL:LEVEL 4 PRICE:€100
START DATE FORECAST:2016-09-01 STATE:COMPLETED
OBJECTIVES:

Make connections between multiple worksheets.

Perform data analysis.

Automating actions through the use of macros.

CONTENTS:

Multiple Worksheets

Summary data

Data analysis

Analysis of data in tables and lists

-Creation, sorting and filtering data

- Forms

Creating and formatting a dynamic table

Use of totals and subtotals

Formulas in dynamic tables

Graphing

Macros