{
    "id": 22610,
    "date": "2026-10-16T22:51:23",
    "date_gmt": "2026-10-17T02:51:23",
    "guid": {
        "rendered": "https:\/\/trident-academy.com\/courses\/tic-201-excel-intermedio-formulas-tabelas-e-graficos\/"
    },
    "modified": "2026-10-25T14:10:04",
    "modified_gmt": "2026-10-25T13:10:04",
    "slug": "tic-201-excel-intermedio-formulas-tabelas-e-graficos",
    "status": "publish",
    "type": "product",
    "link": "https:\/\/trident-academy.com\/en\/courses\/tic-201-excel-intermedio-formulas-tabelas-e-graficos\/",
    "title": {
        "rendered": "Excel Interm\u00e9dio: F\u00f3rmulas, Tabelas e Gr\u00e1ficos"
    },
    "content": {
        "rendered": "<p>Se j\u00e1 domina o b\u00e1sico do Excel, este curso leva-o ao n\u00edvel seguinte. Destinado a colaboradores de escrit\u00f3rio e analistas, acompanha a analista de opera\u00e7\u00f5es de uma empresa fict\u00edcia de transportes e armazenagem, que transforma mapas manuais em folhas que trabalham sozinhas. Construa decis\u00f5es com SE, SE encadeado, SE.S, E, OU e SE.ERRO. Cruze dados entre tabelas com PROCV, \u00cdNDICE e CORRESP e PROCX, e diagnostique o erro #N\/D. Some, conte e calcule m\u00e9dias com crit\u00e9rios com SOMA.SE.S, CONTAR.SE.S e M\u00c9DIA.SE.S, incluindo datas e caracteres universais, e construa um quadro-resumo que se atualiza sozinho. Estruture os dados em Tabelas do Excel com refer\u00eancias estruturadas, controle as entradas com listas pendentes e regras de valida\u00e7\u00e3o, e destaque o que importa com formata\u00e7\u00e3o condicional. Por fim, escolha e crie gr\u00e1ficos eficazes e honestos, incluindo gr\u00e1ficos de combina\u00e7\u00e3o e minigr\u00e1ficos. Inclui um ficheiro Excel de pr\u00e1tica por m\u00f3dulo, com solu\u00e7\u00e3o, um livro de casos pr\u00e1ticos de consolida\u00e7\u00e3o e um guia r\u00e1pido das fun\u00e7\u00f5es. Nomes de fun\u00e7\u00f5es conforme o Microsoft 365 Excel em portugu\u00eas de Portugal.<\/p>",
        "protected": false
    },
    "excerpt": {
        "rendered": "<p>PROCV, SE, SOMA.SE, tabelas, valida\u00e7\u00e3o de dados e gr\u00e1ficos.<\/p>",
        "protected": false
    },
    "featured_media": 22611,
    "comment_status": "open",
    "ping_status": "closed",
    "template": "",
    "meta": [],
    "product_brand": [],
    "product_cat": [
        497,
        553,
        419
    ],
    "product_tag": [],
    "class_list": [
        "post-22610",
        "product",
        "type-product",
        "status-publish",
        "has-post-thumbnail",
        "product_cat-area-tic",
        "product_cat-area-tic-n2",
        "product_cat-portugues",
        "first",
        "instock",
        "virtual",
        "sold-individually",
        "taxable",
        "purchasable",
        "product-type-simple"
    ],
    "_links": {
        "self": [
            {
                "href": "https:\/\/trident-academy.com\/en\/wp-json\/wp\/v2\/product\/22610",
                "targetHints": {
                    "allow": [
                        "GET"
                    ]
                }
            }
        ],
        "collection": [
            {
                "href": "https:\/\/trident-academy.com\/en\/wp-json\/wp\/v2\/product"
            }
        ],
        "about": [
            {
                "href": "https:\/\/trident-academy.com\/en\/wp-json\/wp\/v2\/types\/product"
            }
        ],
        "replies": [
            {
                "embeddable": true,
                "href": "https:\/\/trident-academy.com\/en\/wp-json\/wp\/v2\/comments?post=22610"
            }
        ],
        "version-history": [
            {
                "count": 1,
                "href": "https:\/\/trident-academy.com\/en\/wp-json\/wp\/v2\/product\/22610\/revisions"
            }
        ],
        "predecessor-version": [
            {
                "id": 22709,
                "href": "https:\/\/trident-academy.com\/en\/wp-json\/wp\/v2\/product\/22610\/revisions\/22709"
            }
        ],
        "wp:featuredmedia": [
            {
                "embeddable": true,
                "href": "https:\/\/trident-academy.com\/en\/wp-json\/wp\/v2\/media\/22611"
            }
        ],
        "wp:attachment": [
            {
                "href": "https:\/\/trident-academy.com\/en\/wp-json\/wp\/v2\/media?parent=22610"
            }
        ],
        "wp:term": [
            {
                "taxonomy": "product_brand",
                "embeddable": true,
                "href": "https:\/\/trident-academy.com\/en\/wp-json\/wp\/v2\/product_brand?post=22610"
            },
            {
                "taxonomy": "product_cat",
                "embeddable": true,
                "href": "https:\/\/trident-academy.com\/en\/wp-json\/wp\/v2\/product_cat?post=22610"
            },
            {
                "taxonomy": "product_tag",
                "embeddable": true,
                "href": "https:\/\/trident-academy.com\/en\/wp-json\/wp\/v2\/product_tag?post=22610"
            }
        ],
        "curies": [
            {
                "name": "wp",
                "href": "https:\/\/api.w.org\/{rel}",
                "templated": true
            }
        ]
    }
}