{"id":30648,"name":"Excel 2019 - Extração e Tratamento de Texto com Funções (online)","description":"

As funções de texto são muito úteis na extração de informações, substituição de caracteres e ajuste na aparência do texto nas células da planilha. No curso Excel 2019 - Extração e Tratamento de Texto com Funções, você irá aprender como utilizá-las no tratamento de dados obtidos de outras fontes.

Este curso é ministrado por Fernando de Carvalho Navarro, consultor e instrutor em TI especializado no pacote Microsoft Office, e profissional certificado Microsoft Office Specialist Expert. Possui formação em engenharia e ministra cursos de tecnologia da informação na Impacta Certificação e Treinamento desde 2011. Também é autor de material didático e publicações sobre aplicativos Microsoft Office.

Pré-requisitos

Para obter um bom aproveitamento do curso, é imprescindível que o aluno tenha familiaridade com o ambiente do sistema operacional Windows 7 ou superior e possua conhecimentos básicos de Excel, como digitação de dados, uso de fórmulas, funções, formatação, gráficos, classificação e filtragem de dados.

","image_url":"https://core-cdn.herospark.com/org-6352/school-6353/cdfee32d6b9dc8a89d6d3fe30d6476ad/banner-2709-1617739103.png","created_at":"2019-11-06T15:03:16.519Z","updated_at":"2025-02-24T13:27:40.883Z","code":null,"organization_owner_id":6352,"duration":"3","ready":true,"linear_requirements":false,"rating_min_progress":null,"kind":"online_course","drm_enabled":false,"drm_options":{},"rating":null,"contents":{"opts":{"paginate":{"collection_url":"/excel-2019-extracao-e-tratamento-de-texto-com-funcoes-online"},"name":"contents"},"paginate":{"collection_url":"/excel-2019-extracao-e-tratamento-de-texto-com-funcoes-online"},"limit":null,"collection":[{"id":1268520,"course_module_id":301957,"order":0,"content_id":1414712,"content_type":"Lesson","created_at":"2019-11-06T15:03:24.023Z","updated_at":"2019-11-06T15:03:24.023Z","available":null,"downloadable":false,"root_module_id":301957,"next_content_id":null,"prev_content_id":1269699},{"id":1268354,"course_module_id":301946,"order":0,"content_id":1414546,"content_type":"Lesson","created_at":"2019-11-06T15:03:16.600Z","updated_at":"2019-11-06T15:03:16.600Z","available":null,"downloadable":false,"root_module_id":301946,"next_content_id":1268393,"prev_content_id":null},{"id":1268393,"course_module_id":301949,"order":0,"content_id":1414585,"content_type":"Lesson","created_at":"2019-11-06T15:03:18.448Z","updated_at":"2019-11-06T15:04:39.003Z","available":null,"downloadable":false,"root_module_id":301949,"next_content_id":1268398,"prev_content_id":1268354},{"id":1268401,"course_module_id":301949,"order":2,"content_id":1414593,"content_type":"Lesson","created_at":"2019-11-06T15:03:18.770Z","updated_at":"2019-11-06T15:04:39.001Z","available":null,"downloadable":false,"root_module_id":301949,"next_content_id":1268400,"prev_content_id":1268398},{"id":1269927,"course_module_id":301949,"order":9,"content_id":1416119,"content_type":"Lesson","created_at":"2019-11-07T12:22:02.041Z","updated_at":"2020-05-28T20:27:06.860Z","available":null,"downloadable":true,"root_module_id":301949,"next_content_id":1269771,"prev_content_id":1268396},{"id":1268399,"course_module_id":301949,"order":4,"content_id":1414591,"content_type":"Lesson","created_at":"2019-11-06T15:03:18.685Z","updated_at":"2019-11-06T15:04:38.996Z","available":null,"downloadable":false,"root_module_id":301949,"next_content_id":1268397,"prev_content_id":1268400},{"id":1269928,"course_module_id":301949,"order":11,"content_id":1416120,"content_type":"Lesson","created_at":"2019-11-07T12:22:04.362Z","updated_at":"2020-05-28T20:27:08.540Z","available":null,"downloadable":true,"root_module_id":301949,"next_content_id":1269904,"prev_content_id":1269771},{"id":1268398,"course_module_id":301949,"order":1,"content_id":1414590,"content_type":"Lesson","created_at":"2019-11-06T15:03:18.642Z","updated_at":"2019-11-06T15:04:38.983Z","available":null,"downloadable":false,"root_module_id":301949,"next_content_id":1268401,"prev_content_id":1268393},{"id":1268397,"course_module_id":301949,"order":5,"content_id":1414589,"content_type":"Lesson","created_at":"2019-11-06T15:03:18.601Z","updated_at":"2019-11-06T15:04:38.977Z","available":null,"downloadable":false,"root_module_id":301949,"next_content_id":1268388,"prev_content_id":1268399},{"id":1269771,"course_module_id":301949,"order":10,"content_id":1415963,"content_type":"Lesson","created_at":"2019-11-06T18:31:47.172Z","updated_at":"2019-11-07T12:22:25.761Z","available":null,"downloadable":null,"root_module_id":301949,"next_content_id":1269928,"prev_content_id":1269927},{"id":1268388,"course_module_id":301949,"order":6,"content_id":1414580,"content_type":"Lesson","created_at":"2019-11-06T15:03:18.256Z","updated_at":"2019-11-06T15:04:39.016Z","available":null,"downloadable":false,"root_module_id":301949,"next_content_id":1268392,"prev_content_id":1268397},{"id":1268392,"course_module_id":301949,"order":7,"content_id":1414584,"content_type":"Lesson","created_at":"2019-11-06T15:03:18.410Z","updated_at":"2019-11-06T15:04:38.981Z","available":null,"downloadable":false,"root_module_id":301949,"next_content_id":1268396,"prev_content_id":1268388},{"id":1269699,"course_module_id":301949,"order":13,"content_id":1415891,"content_type":"Lesson","created_at":"2019-11-06T15:34:01.437Z","updated_at":"2019-11-07T12:22:25.803Z","available":null,"downloadable":false,"root_module_id":301949,"next_content_id":1268520,"prev_content_id":1269904},{"id":1268396,"course_module_id":301949,"order":8,"content_id":1414588,"content_type":"Lesson","created_at":"2019-11-06T15:03:18.564Z","updated_at":"2019-11-06T15:04:39.049Z","available":null,"downloadable":false,"root_module_id":301949,"next_content_id":1269927,"prev_content_id":1268392},{"id":1269904,"course_module_id":301949,"order":12,"content_id":1416096,"content_type":"Lesson","created_at":"2019-11-07T11:56:51.808Z","updated_at":"2019-11-07T12:22:25.756Z","available":null,"downloadable":true,"root_module_id":301949,"next_content_id":1269699,"prev_content_id":1269928},{"id":1268400,"course_module_id":301949,"order":3,"content_id":1414592,"content_type":"Lesson","created_at":"2019-11-06T15:03:18.726Z","updated_at":"2019-11-06T15:04:39.004Z","available":null,"downloadable":false,"root_module_id":301949,"next_content_id":1268399,"prev_content_id":1268401}],"collection_url":"/excel-2019-extracao-e-tratamento-de-texto-com-funcoes-online","allowed_payment_options":[],"paginate_param":null}}

Conteúdo do curso

Assista ao curso e aumente a performance da sua organização!