Av. de Cabo Verde 1, 4900-568
Viana do Castelo
info@datacolab.pt
Ph: +351 258 824 281
recrutamento@datacolab.pt
#CertifiedModularTraining

Spreadsheet – Advanced Level

Enroll now!

Duration

25 hours

UFCD

0757

Credit Points

2.25

closeup-of-hands-using-computer-laptop-with-screen-2025-02-10-07-46-20-utc
Objectives
  • Create links between multiple spreadsheets.
  • Perform data analysis.
  • Automate actions using macros.
Content
  • Multiple Spreadsheets
    • Multiple sheets
    • Consolidation of spreadsheets
    • Linking between sheets
  • Data Summary
    • Inserting subtotals
    • Highlights
    • Reports
  • Data Analysis
    • Data analysis in tables and lists
      • Creating, sorting, and filtering data
      • Forms
    • Creating and formatting a pivot table
    • Using totals and subtotals
    • Formulas in pivot tables
    • Creating charts
  • Macros
    • Predefined macros
    • Customizing toolbar macros
    • Creating and recording a macro
    • Assigning a macro to a button
    • Executing a macro

First Edition

North

Opening Soon

Enrollments Open

Center

Opening Soon

Enrollments Open

Beja

17 of November of 2025
(On site)

Enrollments Open
See courses
Enroll now!

Avenida de Cabo Verde 1
4900-568, Viana do Castelo
Portugal

Contacts

Useful Links

Portuguese Data Academy

Media

About

© 2022  Data CoLAB  All rights reserved

Terms and Conditions   |   Privacy and Personal Data Policy   |   Cookie Policy   |   Complaints Book