Conteúdo / Main content
Menu Rodapé
  1. Início
  2. Cursos
  3. Gestão
  4. Ferramentas de Produtividade para a Gestão

Ferramentas de Produtividade para a Gestão

Código 13994
Ano 1
Semestre S2
Créditos ECTS 6
Carga Horária TP(60H)
Área Científica Gestão
Learning outcomes Master the industry-standard office productivity software. This includes providing students with advanced skills in word processing software useful from a business point of view. However, a large part of the curricular unit aims to prepare students for advanced and sophisticated use of spreadsheets in order to perform calculations of any kind, analyze large amounts of data, simulate, model and optimize problems emphasizing the use of spreadsheets as decision support tools.
Syllabus 1. Advanced use of word processing tools (image wrapping, headers and footers, page and section breaks, styles, indexes, cross-references, tables, review tools, document comparison, and mail merge);
2. Basic, intermediate, and advanced use of spreadsheet tools (basic Excel, navigation, paste special, alignment, relative and absolute references, data validation, conditional formatting, functions IF, VLOOKUP, HLOOKUP, XLOOKUP, INDIRECT, AND, OR, XOR, VALUE, SUMPRODUCT, descriptive statistics, array operations, number formatting, names, dynamic lists, cell/sheet/workbook protection, number rounding, text functions, conditional functions, random number generation, sorting functions, basic and advanced sorting and filtering tools, pivot tables, printing, solver and goal seek, charts).
Main Bibliography Building Complex Documents: Using Microsoft Word 2007, 2010, and 2013, Mark Schiavone, 2014, Sycamore Technical Press
Excel 2019 Bible, Michael Alexander, Richard Kusleika, John Walkenbach, 2018, Wiley
Microsoft Excel 365 Bible, Michael Alexander, Richard Kusleika, 2022, Wiley
Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th edition, Wayne L. Winston, 2021, Microsoft Press
Language Portuguese. Tutorial support is available in English.
Data da última atualização: 2025-06-06
As cookies utilizadas neste sítio web não recolhem informação pessoal que permitam a sua identificação. Ao continuar está a aceitar a política de cookies.