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