/**
* Note: This file may contain artifacts of previous malicious infection.
* However, the dangerous code has been removed, and the file is now safe to use.
*/

/**
 * @file
 * Pathologic text filter for Drupal.
 *
 * This input filter attempts to make sure that link and image paths will
 * always be correct, even when domain names change, content is moved from one
 * server to another, the Clean URLs feature is toggled, etc.
 */

/**
 * Implements hook_filter_info().
 */
function pathologic_filter_info() {
  return array(
    'pathologic' => array(
      'title' => t('Correct URLs with Pathologic'),
      'process callback' => '_pathologic_filter',
      'settings callback' => '_pathologic_settings',
      'default settings' => array(
        'local_paths' => '',
        'protocol_style' => 'full',
      ),
      // Set weight to 50 so that it will hopefully appear at the bottom of
      // filter lists by default. 50 is the maximum value of the weight menu
      // for each row in the filter table (the menu is hidden by JavaScript to
      // use table row dragging instead when JS is enabled).
      'weight' => 50,
    )
  );
}

/**
 * Settings callback for Pathologic.
 */
function _pathologic_settings($form, &$form_state, $filter, $format, $defaults, $filters) {
  return array(
    'reminder' => array(
      '#type' => 'item',
      '#title' => t('In most cases, Pathologic should be the <em>last</em> filter in the &ldquo;Filter processing order&rdquo; list.'),
      '#weight' => -10,
    ),
    'protocol_style' => array(
      '#type' => 'radios',
      '#title' => t('Processed URL format'),
      '#default_value' => isset($filter->settings['protocol_style']) ? $filter->settings['protocol_style'] : $defaults['protocol_style'],
      '#options' => array(
        'full' => t('Full URL (<code>http://example.com/foo/bar</code>)'),
        'proto-rel' => t('Protocol relative URL (<code>//example.com/foo/bar</code>)'),
        'path' => t('Path relative to server root (<code>/foo/bar</code>)'),
      ),
      '#description' => t('The <em>Full URL</em> option is best for stopping broken images and links in syndicated content (such as in RSS feeds), but will likely lead to problems if your site is accessible by both HTTP and HTTPS. Paths output with the <em>Protocol relative URL</em> option will avoid such problems, but feed readers and other software not using up-to-date standards may be confused by the paths. The <em>Path relative to server root</em> option will avoid problems with sites accessible by both HTTP and HTTPS with no compatibility concerns, but will absolutely not fix broken images and links in syndicated content.'),
      '#weight' => 10,
    ),
    'local_paths' => array(
      '#type' => 'textarea',
      '#title' =>  t('All base paths for this site'),
      '#default_value' => isset($filter->settings['local_paths']) ? $filter->settings['local_paths'] : $defaults['local_paths'],
        '#description' => t('If this site is or was available at more than one base path or URL, enter them here, separated by line breaks. For example, if this site is live at <code>http://example.com/</code> but has a staging version at <code>http://dev.example.org/staging/</code>, you would enter both those URLs here. If confused, please read <a href="!docs">Pathologic&rsquo;s documentation</a> for more information about this option and what it affects.', array('!docs' => 'http://drupal.org/node/257026')),
      '#weight' => 20,
    ),
  );
}

/**
 * Pathologic filter callback.
 *
 * Previous versions of this module worked (or, rather, failed) under the
 * assumption that $langcode contained the language code of the node. Sadly,
 * this isn't the case.
 * @see http://drupal.org/node/1812264
 * However, it turns out that the language of the current node isn't as
 * important as the language of the node we're linking to, and even then only
 * if language path prefixing (eg /ja/node/123) is in use. REMEMBER THIS IN THE
 * FUTURE, ALBRIGHT.
 *
 * The below code uses the @ operator before parse_url() calls because in PHP
 * 5.3.2 and earlier, parse_url() causes a warning of parsing fails. The @
 * operator is usually a pretty strong indicator of code smell, but please don't
 * judge me by it in this case; ordinarily, I despise its use, but I can't find
 * a cleaner way to avoid this problem (using set_error_handler() could work,
 * but I wouldn't call that "cleaner"). Fortunately, Drupal 8 will require at
 * least PHP 5.3.5, so this mess doesn't have to spread into the D8 branch of
 * Pathologic.
 * @see https://drupal.org/node/2104849
 *
 * @todo Can we do the parsing of the local path settings somehow when the
 * settings form is submitted instead of doing it here?
 */
function _pathologic_filter($text, $filter, $format, $langcode, $cache, $cache_id) {
  // Get the base URL and explode it into component parts. We add these parts
  // to the exploded local paths settings later.
  global $base_url;
  $base_url_parts = @parse_url($base_url . '/');
  // Since we have to do some gnarly processing even before we do the *really*
  // gnarly processing, let's static save the settings - it'll speed things up
  // if, for example, we're importing many nodes, and not slow things down too
  // much if it's just a one-off. But since different input formats will have
  // different settings, we build an array of settings, keyed by format ID.
  $cached_settings = &drupal_static(__FUNCTION__, array());
  if (!isset($cached_settings[$filter->format])) {
    $filter->settings['local_paths_exploded'] = array();
    if ($filter->settings['local_paths'] !== '') {
      // Build an array of the exploded local paths for this format's settings.
      // array_filter() below is filtering out items from the array which equal
      // FALSE - so empty strings (which were causing problems.
      // @see http://drupal.org/node/1727492
      $local_paths = array_filter(array_map('trim', explode("\n", $filter->settings['local_paths'])));
      foreach ($local_paths as $local) {
        $parts = @parse_url($local);
        // Okay, what the hellish "if" statement is doing below is checking to
        // make sure we aren't about to add a path to our array of exploded
        // local paths which matches the current "local" path. We consider it
        // not a match, if…
        // @todo: This is pretty horrible. Can this be simplified?
        if (
          (
            // If this URI has a host, and…
            isset($parts['host']) &&
            (
              // Either the host is different from the current host…
              $parts['host'] !== $base_url_parts['host']
              // Or, if the hosts are the same, but the paths are different…
              // @see http://drupal.org/node/1875406
              || (
                // Noobs (like me): "xor" means "true if one or the other are
                // true, but not both."
                (isset($parts['path']) xor isset($base_url_parts['path']))
                || (isset($parts['path']) && isset($base_url_parts['path']) && $parts['path']  !== $base_url_parts['path'])
              )
            )
          ) ||
          // Or…
          (
            // The URI doesn't have a host…
            !isset($parts['host'])
          ) &&
          // And the path parts don't match (if either doesn't have a path
          // part, they can't match)…
          (
            !isset($parts['path']) ||
            !isset($base_url_parts['path']) ||
            $parts['path'] !== $base_url_parts['path']
          )
        ) {
          // Add it to the list.
          $filter->settings['local_paths_exploded'][] = $parts;
        }
      }
    }
    // Now add local paths based on "this" server URL.
    $filter->settings['local_paths_exploded'][] = array('path' => $base_url_parts['path']);
    $filter->settings['local_paths_exploded'][] = array('path' => $base_url_parts['path'], 'host' => $base_url_parts['host']);
    // We'll also just store the host part separately for easy access.
    $filter->settings['base_url_host'] = $base_url_parts['host'];

    $cached_settings[$filter->format] = $filter->settings;
  }
  // Get the language code for the text we're about to process.
  $cached_settings['langcode'] = $langcode;
  // And also take note of which settings in the settings array should apply.
  $cached_settings['current_settings'] = &$cached_settings[$filter->format];

  // Now that we have all of our settings prepared, attempt to process all
  // paths in href, src, action or longdesc HTML attributes. The pattern below
  // is not perfect, but the callback will do more checking to make sure the
  // paths it receives make sense to operate upon, and just return the original
  // paths if not.
  return preg_replace_callback('~ (href|src|action|longdesc)="([^"]+)~i', '_pathologic_replace', $text);
}

/**
 * Process and replace paths. preg_replace_callback() callback.
 */
function _pathologic_replace($matches) {
  // Get the base path.
  global $base_path;

  // Get the settings for the filter. Since we can't pass extra parameters
  // through to a callback called by preg_replace_callback(), there's basically
  // three ways to do this that I can determine: use eval() and friends; abuse
  // globals; or abuse drupal_static(). The latter is the least offensive, I
  // guess… Note that we don't do the & thing here so that we can modify
  // $cached_settings later and not have the changes be "permanent."
  $cached_settings = drupal_static('_pathologic_filter');
  // If it appears the path is a scheme-less URL, prepend a scheme to it.
  // parse_url() cannot properly parse scheme-less URLs. Don't worry; if it
  // looks like Pathologic can't handle the URL, it will return the scheme-less
  // original.
  // @see https://drupal.org/node/1617944
  // @see https://drupal.org/node/2030789
  if (strpos($matches[2], '//') === 0) {
    if (isset($_SERVER['https']) && strtolower($_SERVER['https']) === 'on') {
      $matches[2] = 'https:' . $matches[2];
    }
    else {
      $matches[2] = 'http:' . $matches[2];
    }
  }
  // Now parse the URL after reverting HTML character encoding.
  // @see http://drupal.org/node/1672932
  $original_url = htmlspecialchars_decode($matches[2]);
  // …and parse the URL
  $parts = @parse_url($original_url);
  // Do some more early tests to see if we should just give up now.
  if (
    // If parse_url() failed, give up.
    $parts === FALSE
    || (
      // If there's a scheme part and it doesn't look useful, bail out.
      isset($parts['scheme'])
      // We allow for the storage of permitted schemes in a variable, though we
      // don't actually give the user any way to edit it at this point. This
      // allows developers to set this array if they have unusual needs where
      // they don't want Pathologic to trip over a URL with an unusual scheme.
      // @see http://drupal.org/node/1834308
      // "files" and "internal" are for Path Filter compatibility.
      && !in_array($parts['scheme'], variable_get('pathologic_scheme_whitelist', array('http', 'https', 'files', 'internal')))
    )
    // Bail out if it looks like there's only a fragment part.
    || (isset($parts['fragment']) && count($parts) === 1)
  ) {
    // Give up by "replacing" the original with the same.
    return $matches[0];
  }

  if (isset($parts['path'])) {
    // Undo possible URL encoding in the path.
    // @see http://drupal.org/node/1672932
    $parts['path'] = rawurldecode($parts['path']);
  }
  else {
    $parts['path'] = '';
  }

  // Check to see if we're dealing with a file.
  // @todo Should we still try to do path correction on these files too?
  if (isset($parts['scheme']) && $parts['scheme'] === 'files') {
    // Path Filter "files:" support. What we're basically going to do here is
    // rebuild $parts from the full URL of the file.
    $new_parts = @parse_url(file_create_url(file_default_scheme() . '://' . $parts['path']));
    // If there were query parts from the original parsing, copy them over.
    if (!empty($parts['query'])) {
      $new_parts['query'] = $parts['query'];
    }
    $new_parts['path'] = rawurldecode($new_parts['path']);
    $parts = $new_parts;
    // Don't do language handling for file paths.
    $cached_settings['is_file'] = TRUE;
  }
  else {
    $cached_settings['is_file'] = FALSE;
  }

  // Let's also bail out of this doesn't look like a local path.
  $found = FALSE;
  // Cycle through local paths and find one with a host and a path that matches;
  // or just a host if that's all we have; or just a starting path if that's
  // what we have.
  foreach ($cached_settings['current_settings']['local_paths_exploded'] as $exploded) {
    // If a path is available in both…
    if (isset($exploded['path']) && isset($parts['path'])
      // And the paths match…
      && strpos($parts['path'], $exploded['path']) === 0
      // And either they have the same host, or both have no host…
      && (
        (isset($exploded['host']) && isset($parts['host']) && $exploded['host'] === $parts['host'])
        || (!isset($exploded['host']) && !isset($parts['host']))
      )
    ) {
      // Remove the shared path from the path. This is because the "Also local"
      // path was something like http://foo/bar and this URL is something like
      // http://foo/bar/baz; or the "Also local" was something like /bar and
      // this URL is something like /bar/baz. And we only care about the /baz
      // part.
      $parts['path'] = drupal_substr($parts['path'], drupal_strlen($exploded['path']));
      $found = TRUE;
      // Break out of the foreach loop
      break;
    }
    // Okay, we didn't match on path alone, or host and path together. Can we
    // match on just host? Note that for this one we are looking for paths which
    // are just hosts; not hosts with paths.
    elseif ((isset($parts['host']) && !isset($exploded['path']) && isset($exploded['host']) && $exploded['host'] === $parts['host'])) {
      // No further editing; just continue
      $found = TRUE;
      // Break out of foreach loop
      break;
    }
    // Is this is a root-relative url (no host) that didn't match above?
    // Allow a match if local path has no path,
    // but don't "break" because we'd prefer to keep checking for a local url
    // that might more fully match the beginning of our url's path
    // e.g.: if our url is /foo/bar we'll mark this as a match for
    // http://example.com but want to keep searching and would prefer a match
    // to http://example.com/foo if that's configured as a local path
    elseif (!isset($parts['host']) && (!isset($exploded['path']) || $exploded['path'] === $base_path)) {
      $found = TRUE;
    }
  }

  // If the path is not within the drupal root return original url, unchanged
  if (!$found) {
    return $matches[0];
  }

  // Okay, format the URL.
  // If there's still a slash lingering at the start of the path, chop it off.
  $parts['path'] = ltrim($parts['path'],'/');

  // Examine the query part of the URL. Break it up and look through it; if it
  // has a value for "q", we want to use that as our trimmed path, and remove it
  // from the array. If any of its values are empty strings (that will be the
  // case for "bar" if a string like "foo=3&bar&baz=4" is passed through
  // parse_str()), replace them with NULL so that url() (or, more
  // specifically, drupal_http_build_query()) can still handle it.
  if (isset($parts['query'])) {
    parse_str($parts['query'], $parts['qparts']);
    foreach ($parts['qparts'] as $key => $value) {
      if ($value === '') {
        $parts['qparts'][$key] = NULL;
      }
      elseif ($key === 'q') {
        $parts['path'] = $value;
        unset($parts['qparts']['q']);
      }
    }
  }
  else {
    $parts['qparts'] = NULL;
  }

  // If we don't have a path yet, bail out.
  if (!isset($parts['path'])) {
    return $matches[0];
  }

  // If we didn't previously identify this as a file, check to see if the file
  // exists now that we have the correct path relative to DRUPAL_ROOT
  if (!$cached_settings['is_file']) {
    $cached_settings['is_file'] = !empty($parts['path']) && is_file(DRUPAL_ROOT . '/'. $parts['path']);
  }

  // Okay, deal with language stuff.
  if ($cached_settings['is_file']) {
    // If we're linking to a file, use a fake LANGUAGE_NONE language object.
    // Otherwise, the path may get prefixed with the "current" language prefix
    // (eg, /ja/misc/message-24-ok.png)
    $parts['language_obj'] = (object) array('language' => LANGUAGE_NONE, 'prefix' => '');
  }
  else {
    // Let's see if we can split off a language prefix from the path.
    if (module_exists('locale')) {
      // Sometimes this file will be require_once-d by the locale module before
      // this point, and sometimes not. We require_once it ourselves to be sure.
      require_once DRUPAL_ROOT . '/includes/language.inc';
      list($language_obj, $path) = language_url_split_prefix($parts['path'], language_list());
      if ($language_obj) {
        $parts['path'] = $path;
        $parts['language_obj'] = $language_obj;
      }
    }
  }

  // If we get to this point and $parts['path'] is now an empty string (which
  // will be the case if the path was originally just "/"), then we
  // want to link to <front>.
  if ($parts['path'] === '') {
    $parts['path'] = '<front>';
  }
  // Build the parameters we will send to url()
  $url_params = array(
    'path' => $parts['path'],
    'options' => array(
      'query' => $parts['qparts'],
      'fragment' => isset($parts['fragment']) ? $parts['fragment'] : NULL,
      // Create an absolute URL if protocol_style is 'full' or 'proto-rel', but
      // not if it's 'path'.
      'absolute' => $cached_settings['current_settings']['protocol_style'] !== 'path',
      // If we seem to have found a language for the path, pass it along to
      // url(). Otherwise, ignore the 'language' parameter.
      'language' => isset($parts['language_obj']) ? $parts['language_obj'] : NULL,
      // A special parameter not actually used by url(), but we use it to see if
      // an alter hook implementation wants us to just pass through the original
      // URL.
      'use_original' => FALSE,
    ),
  );

  // Add the original URL to the parts array
  $parts['original'] = $original_url;

  // Now alter!
  // @see http://drupal.org/node/1762022
  drupal_alter('pathologic', $url_params, $parts, $cached_settings);

  // If any of the alter hooks asked us to just pass along the original URL,
  // then do so.
  if ($url_params['options']['use_original']) {
    return $matches[0];
  }

  // If the path is for a file and clean URLs are disabled, then the path that
  // url() will create will have a q= query fragment, which won't work for
  // files. To avoid that, we use this trick to temporarily turn clean URLs on.
  // This is horrible, but it seems to be the sanest way to do this.
  // @see http://drupal.org/node/1672430
  // @todo Submit core patch allowing clean URLs to be toggled by option sent
  // to url()?
  if (!empty($cached_settings['is_file'])) {
    $cached_settings['orig_clean_url'] = !empty($GLOBALS['conf']['clean_url']);
    if (!$cached_settings['orig_clean_url']) {
      $GLOBALS['conf']['clean_url'] = TRUE;
    }
  }

  // Now for the url() call. Drumroll, please…
  $url = url($url_params['path'], $url_params['options']);

  // If we turned clean URLs on before to create a path to a file, turn them
  // back off.
  if ($cached_settings['is_file'] && !$cached_settings['orig_clean_url']) {
    $GLOBALS['conf']['clean_url'] = FALSE;
  }

  // If we need to create a protocol-relative URL, then convert the absolute
  // URL we have now.
  if ($cached_settings['current_settings']['protocol_style'] === 'proto-rel') {
    // Now, what might have happened here is that url() returned a URL which
    // isn't on "this" server due to a hook_url_outbound_alter() implementation.
    // We don't want to convert the URL in that case. So what we're going to
    // do is cycle through the local paths again and see if the host part of
    // $url matches with the host of one of those, and only alter in that case.
    $url_parts = @parse_url($url);
    if (!empty($url_parts['host']) && $url_parts['host'] === $cached_settings['current_settings']['base_url_host']) {
      $url = _pathologic_url_to_protocol_relative($url);
    }
  }

  // Apply HTML character encoding, as is required for HTML attributes.
  // @see http://drupal.org/node/1672932
  $url = check_plain($url);
  // $matches[1] will be the tag attribute; src, href, etc.
  return " {$matches[1]}=\"{$url}";
}

/**
 * Convert a full URL with a protocol to a protocol-relative URL.
 *
 * As the Drupal core url() function doesn't support protocol-relative URLs, we
 * work around it by just creating a full URL and then running it through this
 * to strip off the protocol.
 *
 * Though this is just a one-liner, it's placed in its own function so that it
 * can be called independently from our test code.
 */
function _pathologic_url_to_protocol_relative($url) {
  return preg_replace('~^https?://~', '//', $url);
}
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML+RDFa 1.0//EN"
  "http://www.w3.org/MarkUp/DTD/xhtml-rdfa-1.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="pt-pt" version="XHTML+RDFa 1.0" dir="ltr" prefix="content: http://purl.org/rss/1.0/modules/content/ dc: http://purl.org/dc/terms/ foaf: http://xmlns.com/foaf/0.1/ og: http://ogp.me/ns# rdfs: http://www.w3.org/2000/01/rdf-schema# sioc: http://rdfs.org/sioc/ns# sioct: http://rdfs.org/sioc/types# skos: http://www.w3.org/2004/02/skos/core# xsd: http://www.w3.org/2001/XMLSchema#">

<head profile="http://www.w3.org/1999/xhtml/vocab">
  <meta charset="utf-8" />
<link rel="shortcut icon" href="https://trainingacademyhp.pt/sites/default/files/favicon_1_0.ico" type="image/vnd.microsoft.icon" />
<meta name="description" content="Curso avançad" />
<meta name="keywords" content="Formação;DGERT;Personal Trainer;PT;Creditos;IPDJ;Fitness;Profissional;Desporto;Holmes;Place;" />
<meta name="news_keywords" content="Formação;DGERT;Personal Trainer;PT;Creditos;IPDJ;Fitness;Profissional;Desporto;Holmes;Place;" />
<meta name="generator" content="Drupal 7 (http://drupal.org)" />
<link rel="canonical" href="https://trainingacademyhp.pt/pt-pt/formacoes/desenvolvimento-pessoal-e-profissional/excel-avancado" />
<link rel="shortlink" href="https://trainingacademyhp.pt/pt-pt/node/632" />
<meta property="og:site_name" content="http://trainingacademyhp.pt" />
<meta property="og:type" content="company" />
<meta property="og:url" content="http://trainingacademyhp.pt/pt-pt/missao" />
<meta property="og:title" content="Excel Avançado" />
<meta property="og:description" content="Curso avançad" />
<meta property="og:updated_time" content="2022-05-31T17:33:58+01:00" />
<meta property="og:image" content="http://trainingacademyhp.pt/sites/default/files/styles/231x231/public/untitled_design_2.jpg?itok=Da9ErOGs" />
<meta property="article:published_time" content="2020-05-12T18:11:55+01:00" />
<meta property="article:modified_time" content="2022-05-31T17:33:58+01:00" />
  <link href='https://fonts.googleapis.com/css?family=Lato:400,300,700,900' rel='stylesheet' type='text/css'>
  <title>Excel Avançado | Academia Holmes Place</title>
  <style>
@import url("https://trainingacademyhp.pt/modules/system/system.base.css?o3tpvt");
@import url("https://trainingacademyhp.pt/modules/system/system.menus.css?o3tpvt");
@import url("https://trainingacademyhp.pt/modules/system/system.messages.css?o3tpvt");
@import url("https://trainingacademyhp.pt/modules/system/system.theme.css?o3tpvt");
</style>
<style>
@import url("https://trainingacademyhp.pt/sites/all/modules/community/field_group/horizontal-tabs/horizontal-tabs.css?o3tpvt");
</style>
<style>
@import url("https://trainingacademyhp.pt/sites/all/modules/community/simplenews/simplenews.css?o3tpvt");
@import url("https://trainingacademyhp.pt/sites/all/modules/community/colorbox_node/colorbox_node.css?o3tpvt");
@import url("https://trainingacademyhp.pt/sites/all/modules/community/date/date_api/date.css?o3tpvt");
@import url("https://trainingacademyhp.pt/sites/all/modules/community/date/date_popup/themes/datepicker.1.7.css?o3tpvt");
@import url("https://trainingacademyhp.pt/sites/all/modules/community/date/date_repeat_field/date_repeat_field.css?o3tpvt");
@import url("https://trainingacademyhp.pt/sites/all/modules/community/environment_indicator/environment_indicator.css?o3tpvt");
@import url("https://trainingacademyhp.pt/modules/field/theme/field.css?o3tpvt");
@import url("https://trainingacademyhp.pt/modules/node/node.css?o3tpvt");
@import url("https://trainingacademyhp.pt/modules/search/search.css?o3tpvt");
@import url("https://trainingacademyhp.pt/modules/user/user.css?o3tpvt");
@import url("https://trainingacademyhp.pt/sites/all/modules/community/views/css/views.css?o3tpvt");
@import url("https://trainingacademyhp.pt/sites/all/modules/community/ckeditor/css/ckeditor.css?o3tpvt");
</style>
<style>
@import url("https://trainingacademyhp.pt/sites/all/modules/community/colorbox/styles/default/colorbox_style.css?o3tpvt");
@import url("https://trainingacademyhp.pt/sites/all/modules/community/ctools/css/ctools.css?o3tpvt");
@import url("https://trainingacademyhp.pt/sites/all/libraries/jgrowl/jquery.jgrowl.min.css?o3tpvt");
@import url("https://trainingacademyhp.pt/sites/all/modules/community/nicemessages/css/nicemessages_positions.css?o3tpvt");
@import url("https://trainingacademyhp.pt/sites/all/modules/community/nicemessages/css/nicemessages_facebook.css?o3tpvt");
@import url("https://trainingacademyhp.pt/sites/all/modules/community/nicemessages/css/shadows.css?o3tpvt");
@import url("https://trainingacademyhp.pt/sites/all/modules/community/custom_search/custom_search.css?o3tpvt");
@import url("https://trainingacademyhp.pt/sites/all/modules/community/field_group/field_group.css?o3tpvt");
</style>
<style media="screen">
@import url("https://trainingacademyhp.pt/sites/all/themes/adaptivetheme/at_core/css/at.settings.style.headings.css?o3tpvt");
@import url("https://trainingacademyhp.pt/sites/all/themes/adaptivetheme/at_core/css/at.layout.css?o3tpvt");
@import url("https://trainingacademyhp.pt/sites/all/themes/academiahpat/css/global.base.css?o3tpvt");
@import url("https://trainingacademyhp.pt/sites/all/themes/academiahpat/css/global.styles.css?o3tpvt");
@import url("https://trainingacademyhp.pt/sites/all/themes/academiahpat/css/academia.css?o3tpvt");
@import url("https://trainingacademyhp.pt/sites/default/files/adaptivetheme/academiahpat_files/academiahpat.default.layout.css?o3tpvt");
@import url("https://trainingacademyhp.pt/sites/default/files/adaptivetheme/academiahpat_files/academiahpat.fonts.css?o3tpvt");
</style>
  <script src="https://trainingacademyhp.pt/sites/all/modules/community/jquery_update/replace/jquery/1.8/jquery.js?v=1.8.2"></script>
<script src="https://trainingacademyhp.pt/misc/jquery.once.js?v=1.2"></script>
<script src="https://trainingacademyhp.pt/misc/drupal.js?o3tpvt"></script>
<script src="https://trainingacademyhp.pt/sites/all/modules/community/field_group/horizontal-tabs/horizontal-tabs.js?v=1.0"></script>
<script src="https://trainingacademyhp.pt/misc/ajax.js?v=7.34"></script>
<script src="https://trainingacademyhp.pt/sites/all/modules/community/jquery_update/js/jquery_update.js?v=0.0.1"></script>
<script src="https://trainingacademyhp.pt/sites/all/modules/community/environment_indicator/tinycon.min.js?o3tpvt"></script>
<script src="https://trainingacademyhp.pt/sites/all/modules/community/environment_indicator/environment_indicator.js?o3tpvt"></script>
<script src="https://trainingacademyhp.pt/sites/all/modules/community/environment_indicator/color.js?o3tpvt"></script>
<script src="https://trainingacademyhp.pt/sites/default/files/languages/pt-pt_RbzxUqVmMqvpvaSK_DF1d0dCMd2ZNOE76dmraZ2DkQw.js?o3tpvt"></script>
<script src="https://trainingacademyhp.pt/sites/all/libraries/colorbox/jquery.colorbox-min.js?o3tpvt"></script>
<script src="https://trainingacademyhp.pt/sites/all/modules/community/colorbox/js/colorbox.js?o3tpvt"></script>
<script src="https://trainingacademyhp.pt/sites/all/modules/community/colorbox/styles/default/colorbox_style.js?o3tpvt"></script>
<script src="https://trainingacademyhp.pt/sites/all/modules/community/colorbox/js/colorbox_load.js?o3tpvt"></script>
<script src="https://trainingacademyhp.pt/sites/all/modules/community/colorbox/js/colorbox_inline.js?o3tpvt"></script>
<script src="https://trainingacademyhp.pt/sites/all/libraries/jgrowl/jquery.jgrowl.min.js?o3tpvt"></script>
<script src="https://trainingacademyhp.pt/sites/all/modules/community/nicemessages/js/nicemessages.js?o3tpvt"></script>
<script src="https://trainingacademyhp.pt/sites/all/modules/community/custom_search/js/custom_search.js?o3tpvt"></script>
<script src="https://trainingacademyhp.pt/sites/all/modules/community/google_analytics/googleanalytics.js?o3tpvt"></script>
<script>(function(i,s,o,g,r,a,m){i["GoogleAnalyticsObject"]=r;i[r]=i[r]||function(){(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)})(window,document,"script","//www.google-analytics.com/analytics.js","ga");ga("create", "UA-53216807-1", {"cookieDomain":"auto"});ga("set", "anonymizeIp", true);ga("send", "pageview");</script>
<script src="https://trainingacademyhp.pt/sites/all/modules/community/form_placeholder/form_placeholder.js?o3tpvt"></script>
<script src="https://trainingacademyhp.pt/sites/all/modules/community/field_group/field_group.js?o3tpvt"></script>
<script src="https://trainingacademyhp.pt/misc/progress.js?v=7.34"></script>
<script src="https://trainingacademyhp.pt/sites/all/modules/community/colorbox_node/colorbox_node.js?o3tpvt"></script>
<script src="https://trainingacademyhp.pt/sites/all/themes/academiahpat/scripts/jquery.tmpl.js?o3tpvt"></script>
<script src="https://trainingacademyhp.pt/sites/all/themes/academiahpat/scripts/spin.js?o3tpvt"></script>
<script src="https://trainingacademyhp.pt/sites/all/themes/academiahpat/scripts/global.js?o3tpvt"></script>
<script>jQuery.extend(Drupal.settings, {"basePath":"\/","pathPrefix":"pt-pt\/","ajaxPageState":{"theme":"academiahpat","theme_token":"McCHN_xK9wqFemex8W8cKo337UlScUvijCs7aHM7_Pg","jquery_version":"1.8","js":{"sites\/all\/modules\/community\/jquery_update\/replace\/jquery\/1.8\/jquery.js":1,"misc\/jquery.once.js":1,"misc\/drupal.js":1,"sites\/all\/modules\/community\/field_group\/horizontal-tabs\/horizontal-tabs.js":1,"misc\/ajax.js":1,"sites\/all\/modules\/community\/jquery_update\/js\/jquery_update.js":1,"sites\/all\/modules\/community\/environment_indicator\/tinycon.min.js":1,"sites\/all\/modules\/community\/environment_indicator\/environment_indicator.js":1,"sites\/all\/modules\/community\/environment_indicator\/color.js":1,"public:\/\/languages\/pt-pt_RbzxUqVmMqvpvaSK_DF1d0dCMd2ZNOE76dmraZ2DkQw.js":1,"sites\/all\/libraries\/colorbox\/jquery.colorbox-min.js":1,"sites\/all\/modules\/community\/colorbox\/js\/colorbox.js":1,"sites\/all\/modules\/community\/colorbox\/styles\/default\/colorbox_style.js":1,"sites\/all\/modules\/community\/colorbox\/js\/colorbox_load.js":1,"sites\/all\/modules\/community\/colorbox\/js\/colorbox_inline.js":1,"sites\/all\/libraries\/jgrowl\/jquery.jgrowl.min.js":1,"sites\/all\/modules\/community\/nicemessages\/js\/nicemessages.js":1,"sites\/all\/modules\/community\/custom_search\/js\/custom_search.js":1,"sites\/all\/modules\/community\/google_analytics\/googleanalytics.js":1,"0":1,"sites\/all\/modules\/community\/form_placeholder\/form_placeholder.js":1,"sites\/all\/modules\/community\/field_group\/field_group.js":1,"misc\/progress.js":1,"sites\/all\/modules\/community\/colorbox_node\/colorbox_node.js":1,"sites\/all\/themes\/academiahpat\/scripts\/jquery.tmpl.js":1,"sites\/all\/themes\/academiahpat\/scripts\/spin.js":1,"sites\/all\/themes\/academiahpat\/scripts\/global.js":1},"css":{"modules\/system\/system.base.css":1,"modules\/system\/system.menus.css":1,"modules\/system\/system.messages.css":1,"modules\/system\/system.theme.css":1,"sites\/all\/modules\/community\/field_group\/horizontal-tabs\/horizontal-tabs.css":1,"sites\/all\/modules\/community\/simplenews\/simplenews.css":1,"sites\/all\/modules\/community\/colorbox_node\/colorbox_node.css":1,"sites\/all\/modules\/community\/date\/date_api\/date.css":1,"sites\/all\/modules\/community\/date\/date_popup\/themes\/datepicker.1.7.css":1,"sites\/all\/modules\/community\/date\/date_repeat_field\/date_repeat_field.css":1,"sites\/all\/modules\/community\/environment_indicator\/environment_indicator.css":1,"modules\/field\/theme\/field.css":1,"modules\/node\/node.css":1,"modules\/search\/search.css":1,"modules\/user\/user.css":1,"sites\/all\/modules\/community\/views\/css\/views.css":1,"sites\/all\/modules\/community\/ckeditor\/css\/ckeditor.css":1,"sites\/all\/modules\/community\/colorbox\/styles\/default\/colorbox_style.css":1,"sites\/all\/modules\/community\/ctools\/css\/ctools.css":1,"sites\/all\/libraries\/jgrowl\/jquery.jgrowl.min.css":1,"sites\/all\/modules\/community\/nicemessages\/css\/nicemessages_positions.css":1,"sites\/all\/modules\/community\/nicemessages\/css\/nicemessages_facebook.css":1,"sites\/all\/modules\/community\/nicemessages\/css\/shadows.css":1,"sites\/all\/modules\/community\/custom_search\/custom_search.css":1,"sites\/all\/modules\/community\/field_group\/field_group.css":1,"sites\/all\/themes\/adaptivetheme\/at_core\/css\/at.settings.style.headings.css":1,"sites\/all\/themes\/adaptivetheme\/at_core\/css\/at.layout.css":1,"sites\/all\/themes\/academiahpat\/css\/global.base.css":1,"sites\/all\/themes\/academiahpat\/css\/global.styles.css":1,"sites\/all\/themes\/academiahpat\/css\/academia.css":1,"public:\/\/adaptivetheme\/academiahpat_files\/academiahpat.default.layout.css":1,"public:\/\/adaptivetheme\/academiahpat_files\/academiahpat.fonts.css":1}},"colorbox":{"opacity":"0.85","current":"{current} of {total}","previous":"\u00ab Prev","next":"Next \u00bb","close":"Fechar","maxWidth":"98%","maxHeight":"98%","fixed":true,"mobiledetect":true,"mobiledevicewidth":"480px"},"custom_search":{"form_target":"_self","solr":0},"googleanalytics":{"trackOutbound":1,"trackMailto":1,"trackDownload":1,"trackDownloadExtensions":"7z|aac|arc|arj|asf|asx|avi|bin|csv|doc(x|m)?|dot(x|m)?|exe|flv|gif|gz|gzip|hqx|jar|jpe?g|js|mp(2|3|4|e?g)|mov(ie)?|msi|msp|pdf|phps|png|ppt(x|m)?|pot(x|m)?|pps(x|m)?|ppam|sld(x|m)?|thmx|qtm?|ra(m|r)?|sea|sit|tar|tgz|torrent|txt|wav|wma|wmv|wpd|xls(x|m|b)?|xlt(x|m)|xlam|xml|z|zip"},"nicemessages":{"position":"top-right","items":[]},"form_placeholder":{"fallback_support":false,"include":"#user-login *,#user-register-form *,#user-pass *,#commerce-checkout-form-checkout *,#webform-client-form-127 *,#password-hustle-user-pass-reset *,#block-simplenews-1 *","exclude":"","required_indicator":"leave"},"field_group":{"html-element":"full","htabs":"full","htab":"full","div":"full"},"colorbox_node":{"width":"600px","height":"600px"},"adaptivetheme":{"academiahpat":{"layout_settings":{"bigscreen":"three-col-grail","tablet_landscape":"three-col-grail","tablet_portrait":"one-col-vert","smalltouch_landscape":"one-col-vert","smalltouch_portrait":"one-col-stack"},"media_query_settings":{"bigscreen":"only screen and (min-width:1025px)","tablet_landscape":"only screen and (min-width:769px) and (max-width:1024px)","tablet_portrait":"only screen and (min-width:581px) and (max-width:768px)","smalltouch_landscape":"only screen and (min-width:321px) and (max-width:580px)","smalltouch_portrait":"only screen and (max-width:320px)"}}}});</script>
</head>
<body class="html not-front not-logged-in no-sidebars page-node page-node- page-node-632 node-type-forma-o i18n-pt-pt site-name-hidden atr-7.x-3.x atv-7.x-3.2 lang-pt-pt site-name-academia-holmes-place section-formacoes" >
  <div id="skip-link">
    <a href="#main-content" class="element-invisible element-focusable">Skip to main content</a>
  </div>
    <div id="page-wrapper">
  <div id="page" class="container page ssc-n ssw-b ssa-l sss-n btc-n btw-b bta-l bts-n ntc-n ntw-b nta-l nts-n ctc-n ctw-b cta-l cts-n ptc-n ptw-b pta-l pts-n">

    <!-- !Leaderboard Region -->
    <div class="region region-leaderboard"><div class="region-inner clearfix"><div id="block-easy-breadcrumb-easy-breadcrumb" class="block block-easy-breadcrumb no-title odd first last block-count-1 block-region-leaderboard block-easy-breadcrumb" ><div class="block-inner clearfix">  
  
  <div class="block-content content"><div class="easy-breadcrumb"><a href="/pt-pt" class="easy-breadcrumb_segment easy-breadcrumb_segment-front">Início</a><span class="easy-breadcrumb_segment-separator"> &gt;&gt; </span><a href="/pt-pt/formacoes" class="easy-breadcrumb_segment easy-breadcrumb_segment-1">Formações</a><span class="easy-breadcrumb_segment-separator"> &gt;&gt; </span><a href="/pt-pt/formacoes/desenvolvimento-pessoal-e-profissional" class="easy-breadcrumb_segment easy-breadcrumb_segment-2">Desenvolvimento Pessoal e Profissional</a><span class="easy-breadcrumb_segment-separator"> &gt;&gt; </span><a href="/pt-pt/formacoes/desenvolvimento-pessoal-e-profissional/excel-avancado" class="easy-breadcrumb_segment easy-breadcrumb_segment-title">Excel Avançado</a></div></div>
  </div></div></div></div>
    <header id="header" class="clearfix" role="banner">

              <!-- !Branding -->
        <div id="branding" class="branding-elements clearfix">

                      <div id="logo">
              <a href="/pt-pt"><img class="site-logo" typeof="foaf:Image" src="https://trainingacademyhp.pt/sites/default/files/lg_novologo_holmes_place.png" alt="Academia Holmes Place" /></a>            </div>
          
                      <!-- !Site name and Slogan -->
            <div class="element-invisible h-group" id="name-and-slogan">

                              <h1 class="element-invisible" id="site-name"><a href="/pt-pt" title="A página inicial">Academia Holmes Place</a></h1>
              
              
            </div>
          
        </div>
      
      <!-- !Header Region -->
      <div class="region region-header"><div class="region-inner clearfix"><nav id="block-system-user-menu" class="block block-system block-menu no-title odd first last block-count-2 block-region-header block-user-menu"  role="navigation"><div class="block-inner clearfix">  
  
  <ul class="menu clearfix"><li class="first leaf menu-depth-1 menu-item-835"><a href="/pt-pt/user/login">Login</a></li><li class="last leaf menu-depth-1 menu-item-836"><a href="/pt-pt/user/register">Registo</a></li></ul>
  </div></nav></div></div>
    </header>

    <!-- !Navigation -->
    <div id="menu-wrapper"><div id="menu-bar" class="nav clearfix"><div id="block-blockify-blockify-logo" class="block block-blockify no-title menu-wrapper menu-bar-wrapper clearfix odd first block-count-3 block-region-menu-bar block-blockify-logo" >  
  
  <a href="/pt-pt" id="logo" rel="home" title="Return to the Academia Holmes Place home page"><img typeof="foaf:Image" class="image-style-none" src="https://trainingacademyhp.pt/sites/default/files/lg_novologo_holmes_place.png" alt="Academia Holmes Place logo" /></a>
  </div><section id="block-block-7" class="block block-block menu-wrapper menu-bar-wrapper clearfix even block-count-4 block-region-menu-bar block-7" >  
      <h2 class="element-invisible block-title">Newsletter block</h2>
  
  <p><a class="newsToggle" href="#" onclick="return false;">Newsletter?</a></p>
<script type="text/javascript">
jQuery(document).ready(function(){
jQuery("#block-simplenews-1").hide();
jQuery(".newsToggle").on('click',function(){
   jQuery("#block-simplenews-1").toggle();
});

});
</script>

  </section><section id="block-simplenews-1" class="block block-simplenews menu-wrapper menu-bar-wrapper clearfix odd block-count-5 block-region-menu-bar block-1" >  
      <h2 class="element-invisible block-title">Academia Holmes Place newsletter</h2>
  
        <p>Mantenha-se informado com as últimas novidades!</p>
  
        
      <div class="issues-link"><a href="/pt-pt/private/985d5ee1">Questões anteriores</a></div>
  
  
  
  </section><div id="block-search-form" class="block block-search no-title menu-wrapper menu-bar-wrapper clearfix even block-count-6 block-region-menu-bar block-form"  role="search">  
  
  <form class="search-form" role="search" action="/pt-pt/formacoes/desenvolvimento-pessoal-e-profissional/excel-avancado" method="post" id="search-block-form" accept-charset="UTF-8"><div><div class="container-inline">
      <h2 class="element-invisible">Search form</h2>
    <div class="form-item form-type-textfield form-item-search-block-form">
  <label class="element-invisible" for="edit-search-block-form--2">Search this site </label>
 <input title="Introduza os termos pelos quais pretende pesquisar." class="custom-search-box form-text" placeholder="" type="search" id="edit-search-block-form--2" name="search_block_form" value="" size="15" maxlength="128" />
</div>
<div class="form-actions form-wrapper" id="edit-actions"><input type="submit" id="edit-submit" name="op" value="Procurar" class="form-submit" /></div><input type="hidden" name="form_build_id" value="form-ynqWGb1xtBc0KeWmkhVjhWWM15shKcIvxM6ajW3WRww" />
<input type="hidden" name="form_id" value="search_block_form" />
</div>
</div></form>
  </div><nav id="block-system-main-menu" class="block block-system block-menu no-title menu-wrapper menu-bar-wrapper clearfix odd last block-count-7 block-region-menu-bar block-main-menu"  role="navigation">  
  
  <ul class="menu clearfix"><li class="first leaf menu-depth-1 menu-item-233"><a href="/pt-pt">Home</a></li><li class="leaf menu-depth-1 menu-item-1301"><a href="/pt-pt/missao">Missão</a></li><li class="leaf menu-depth-1 menu-item-1302"><a href="/pt-pt/formacoes">Formações</a></li><li class="leaf menu-depth-1 menu-item-1305"><a href="/pt-pt/equipa-training-academy">Equipa</a></li><li class="leaf menu-depth-1 menu-item-1304"><a href="/pt-pt/calendario">Calendário</a></li><li class="last leaf menu-depth-1 menu-item-1307"><a href="/pt-pt/contactos">Contactos</a></li></ul>
  </nav></div></div>
        
    <!-- !Breadcrumbs -->
    
    <!-- !Messages and Help -->
        
    <!-- !Secondary Content Region -->
    
    <div id="columns" class="columns clearfix">
      <main id="content-column" class="content-column" role="main">
        <div class="content-inner">

          <!-- !Highlighted region -->
          
          <section id="main-content">

            
            <!-- !Main Content Header -->
                          <header id="main-content-header" class="clearfix">

                                  <h1 id="page-title">
                    Excel Avançado                  </h1>
                
                
              </header>
            
            <!-- !Main Content -->
                          <div id="content" class="region">
                                <div id="block-system-main" class="block block-system no-title odd first block-count-8 block-region-content block-main" >  
  
  <div  about="/pt-pt/formacoes/desenvolvimento-pessoal-e-profissional/excel-avancado" typeof="sioc:Item foaf:Document" role="article" class="ds-1col node node-forma-o  article odd node-lang-pt-pt node-full tipo-formacao-385 view-mode-full clearfix">

  
  <!--
THIS FILE IS NOT USED AND IS HERE AS A STARTING POINT FOR CUSTOMIZATION ONLY.
See http://api.drupal.org/api/function/theme_field/7 for details.
After copying this file to your theme's folder and customizing it, remove this
HTML comment.
-->
<div class="field field-name-field-header field-type-entityreference field-label-hidden view-mode-full">
    <div class="field-items">
          <div class="field-item even"><div  about="/pt-pt/excel-avancado" typeof="sioc:Item foaf:Document" role="article" class="ds-1col node node-layer-item-simple node-promoted  article even node-lang-pt-pt node-default view-mode-default clearfix">

  
  <div class="field field-name-field-layer-item-image field-type-image field-label-hidden view-mode-default"><div class="field-items"><figure class="clearfix field-item even"><img typeof="foaf:Image" class="image-style-none" src="https://trainingacademyhp.pt/sites/default/files/repository/content/layer-item-image/633/excel-avancado.png" width="725" height="180" alt="" /></figure></div></div></div>

</div>
      </div>
</div>
<div class="required-fields group-wrapper field-group-html-element"><!--
THIS FILE IS NOT USED AND IS HERE AS A STARTING POINT FOR CUSTOMIZATION ONLY.
See http://api.drupal.org/api/function/theme_field/7 for details.
After copying this file to your theme's folder and customizing it, remove this
HTML comment.
-->
<div class="field field-name-title field-type-ds field-label-hidden view-mode-full">
    <div class="field-items">
          <div class="field-item even" property="dc:title"><h2>Excel Avançado</h2></div>
      </div>
</div>
<div class="required-fields group-info field-group-html-element"><!--
THIS FILE IS NOT USED AND IS HERE AS A STARTING POINT FOR CUSTOMIZATION ONLY.
See http://api.drupal.org/api/function/theme_field/7 for details.
After copying this file to your theme's folder and customizing it, remove this
HTML comment.
-->
<div class="field field-name-body field-type-text-with-summary field-label-above view-mode-full">
      <div class="field-label">Descrição&nbsp;</div>
    <div class="field-items">
          <div class="field-item even" property="content:encoded"><p><span style="font-size:14px;"><span style="font-family:arial,helvetica,sans-serif;">Curso avançado de excel (20h) c</span></span><span style="font-size:14px;"><span style="font-family:arial,helvetica,sans-serif;">om certificado DGERT</span></span></p>
<p><span style="font-size:14px;"><span style="font-family:arial,helvetica,sans-serif;">Curso totalmente online com tutoria assíncrona para esclarecimento de dúvidas na realização dos exercícios.</span></span></p>
<p><span style="font-size:14px;"><span style="font-family:arial,helvetica,sans-serif;">Flexibilidade de horário.</span></span></p>
<p> </p>
<p><span style="font-size:14px;"><span style="font-family:arial,helvetica,sans-serif;">No final deste módulo será capaz de:</span></span></p>
<p><span style="font-size:14px;"><span style="font-family:arial,helvetica,sans-serif;">▪ Importar dados de outras aplicações informáticas (gestão comercial, contabilidade, etc...) e de outros formatos para o Excel;</span></span></p>
<p><span style="font-size:14px;"><span style="font-family:arial,helvetica,sans-serif;">▪ Preparar os dados para análise através de transformações avançadas;</span></span></p>
<p><span style="font-size:14px;"><span style="font-family:arial,helvetica,sans-serif;">▪ Organizar, ordenar e agrupar os dados;</span></span></p>
<p><span style="font-size:14px;"><span style="font-family:arial,helvetica,sans-serif;">▪ Extrair informação analítica, sob múltiplas perspetivas e critérios, de um grande volume de dados, em tempo recorde;</span></span></p>
<p><span style="font-size:14px;"><span style="font-family:arial,helvetica,sans-serif;">▪ Realizar análises de sensibilidade e análises de ponto crítico em segundos;</span></span></p>
<p><span style="font-size:14px;"><span style="font-family:arial,helvetica,sans-serif;">▪ Validar, formatar e consolidar a informação das células de forma automática;</span></span></p>
<p><span style="font-size:14px;"><span style="font-family:arial,helvetica,sans-serif;">▪ Aplicar todas as ferramentas abordadas num caso prático final com grande interesse prático e realismo.</span></span></p>
<p> </p>
</div>
      </div>
</div>
</div></div><div class="field-group-htabs-wrapper group-tabs field-group-htabs"><h2 class="element-invisible">TabsWrapper</h2><div class="horizontal-tabs-panes"><fieldset class="collapsible collapsed group-item1 field-group-htab form-wrapper"><legend><span class="fieldset-legend">Estrutura Pedagógica</span></legend><div class="fieldset-wrapper"><!--
THIS FILE IS NOT USED AND IS HERE AS A STARTING POINT FOR CUSTOMIZATION ONLY.
See http://api.drupal.org/api/function/theme_field/7 for details.
After copying this file to your theme's folder and customizing it, remove this
HTML comment.
-->
<div class="field field-name-field-estrutura-pedag-gica field-type-text-long field-label-above view-mode-full">
      <div class="field-label">Estrutura Pedagógica&nbsp;</div>
    <div class="field-items">
          <div class="field-item even"><p><span style="font-family:arial,helvetica,sans-serif;"><strong>Unidade I - Analisar listas de dados com Tabelas Dinâmicas</strong></span></p>
<p><span style="font-family:arial,helvetica,sans-serif;">1. Construir uma Tabela Dinâmica</span></p>
<p><span style="font-family:arial,helvetica,sans-serif;">2. Opções de configuração da Tabela Dinâmica</span></p>
<p><span style="font-family:arial,helvetica,sans-serif;">3. Criar um Gráfico Dinâmico</span></p>
<p> </p>
<p><span style="font-family:arial,helvetica,sans-serif;"><strong>Unidade II - Ordenar, filtrar e inserir subtotais em listas de dados</strong></span></p>
<p><span style="font-family:arial,helvetica,sans-serif;">1. Ordenar uma lista de dados</span></p>
<p><span style="font-family:arial,helvetica,sans-serif;">2. Filtrar lista de dados</span></p>
<p><span style="font-family:arial,helvetica,sans-serif;">3. Inserir subtotais numa lista de dados</span></p>
<p><span style="font-family:arial,helvetica,sans-serif;">4. Remover duplicados</span></p>
<p> </p>
<p><span style="font-family:arial,helvetica,sans-serif;"><strong>Unidade III - Tratar dados com fórmulas avançadas</strong></span></p>
<p><span style="font-family:arial,helvetica,sans-serif;">1. Criar fórmula para copiar para múltiplas células</span></p>
<p><span style="font-family:arial,helvetica,sans-serif;">2. Funções numéricas, de datas e de texto</span></p>
<p><span style="font-family:arial,helvetica,sans-serif;">3. Funções condicionais avançadas</span></p>
<p><span style="font-family:arial,helvetica,sans-serif;">4. Procurar dados e relacionar tabelas de dados</span></p>
<p> </p>
<p><span style="font-family:arial,helvetica,sans-serif;"><strong>Unidade IV - Usar Listas de Dados Externas</strong></span></p>
<p><span style="font-family:arial,helvetica,sans-serif;">1. Abrir ficheiros de outras aplicações</span></p>
<p><span style="font-family:arial,helvetica,sans-serif;">2. Importar dados de uma base de dados externa e da internet</span></p>
<p> </p>
<p><span style="font-family:arial,helvetica,sans-serif;"><strong>Unidade IV - Usar Listas de Dados Externas</strong></span></p>
<p><span style="font-family:arial,helvetica,sans-serif;">1. Atingir objetivo e Análises de sensibilidade</span></p>
<p><span style="font-family:arial,helvetica,sans-serif;">2. Validar dados e formatar células automaticamente</span></p>
<p><span style="font-family:arial,helvetica,sans-serif;">3. Consolidar folhas de cálculo</span></p>
</div>
      </div>
</div>
</div></fieldset>
</div></div><div class="group-hidden field-group-div"><section class="field field-name-field-image field-type-image field-label-above view-mode-full"><h2 class="field-label">Imagem:&nbsp;</h2><div class="field-items"><figure class="clearfix field-item even"><img typeof="foaf:Image" class="image-style-none" src="https://trainingacademyhp.pt/sites/default/files/untitled_design_4_3.png" width="231" height="231" alt="" /></figure></div></section><!--
THIS FILE IS NOT USED AND IS HERE AS A STARTING POINT FOR CUSTOMIZATION ONLY.
See http://api.drupal.org/api/function/theme_field/7 for details.
After copying this file to your theme's folder and customizing it, remove this
HTML comment.
-->
<div class="field field-name-field-siga-code field-type-text field-label-hidden view-mode-full">
    <div class="field-items">
          <div class="field-item even">excelava</div>
      </div>
</div>
</div></div>


  </div><div id="block-block-8" class="block block-block no-title even last block-count-9 block-region-content block-8" >  
  
  <div id="AgendaCursoWrapper">
<script id="AgendaTemplate" type="text/x-jquery-tmpl">
<ul>
{{each(index,value) d.items}}
 <li class="AgendaItem">
   <img src="${d.imgurl}"><div class="infoWrapper"><div class="agendaName">{{html value.programname}}</div><div class="agendaDate">{{html value.begindate}}</div></div><a class="agendaLink" href="${value.url}">Inscreva-se já</a></li>
{{/each}}
</ul>
</script>
  <div class="AgendaHeader">Próximas Acções</div>
  <div class="AgendaData">
   <div id="loader"></div>
   <div class="noresults">Nenhum resultado a apresentar.</div>
  </div>
</div>
<script>
        var opts = {
            lines: 11             // The number of lines to draw
          , length: 9             // The length of each line
          , width: 6              // The line thickness
          , radius: 12            // The radius of the inner circle
          , scale: 0.75            // Scales overall size of the spinner
          , corners: 1            // Roundness (0..1)
          , color: '#000'         // #rgb or #rrggbb
          , opacity: 1/4          // Opacity of the lines
          , rotate: 0             // Rotation offset
          , direction: 1          // 1: clockwise, -1: counterclockwise
          , speed: 1              // Rounds per second
          , trail: 60            // Afterglow percentage
          , fps: 20               // Frames per second when using setTimeout()
          , zIndex: 2e9           // Use a high z-index by default
          , className: 'spinner'  // CSS class to assign to the element
          , top: '50%'            // center vertically
          , left: '50%'           // center horizontally
          , shadow: false         // Whether to render a shadow
          , hwaccel: false        // Whether to use hardware acceleration (might be buggy)
          , position: 'absolute'  // Element positioning 
        };
        var target = document.getElementById('loader');
        var spinner = new Spinner(opts).spin(target);
</script>


  </div>              </div>
            
            <!-- !Feed Icons -->
            
            
          </section><!-- /end #main-content -->

          <!-- !Content Aside Region-->
          
        </div><!-- /end .content-inner -->
      </main><!-- /end #content-column -->

      <!-- !Sidebar Regions -->
            
    </div><!-- /end #columns -->

    <!-- !Tertiary Content Region -->
    <div class="region region-tertiary-content"><div class="region-inner clearfix"><div id="block-block-4" class="block block-block no-title odd first block-count-10 block-region-tertiary-content block-4" ><div class="block-inner clearfix">  
  
  <div class="block-content content"><h3>Contactos Gerais</h3>
<p>Rua Quinta da Fonte, Ed. Forum Q34 Piso 2<br />
Complexo Quinta da Fonte<br />
2770-192 Porto Salvo<br />
Telf: +351 210 414 090<br />
Email: <a href="mailto:academy@homesplace.pt">academy@holmesplace.pt</a></p>
</div>
  </div></div><nav id="block-menu-menu-footer-menu-1" class="block block-menu even block-count-11 block-region-tertiary-content block-menu-footer-menu-1"  role="navigation"><div class="block-inner clearfix">  
      <h2 class="block-title">Footer Menu 1</h2>
  
  <div class="block-content content"><ul class="menu clearfix"><li class="first leaf menu-depth-1 menu-item-1312"><a href="/pt-pt/missao">Missão</a></li><li class="leaf menu-depth-1 menu-item-1313"><a href="/pt-pt/formacoes">Formações</a></li><li class="leaf menu-depth-1 menu-item-1316"><a href="/pt-pt/equipa-training-academy">Equipa</a></li><li class="last leaf menu-depth-1 menu-item-1315"><a href="/pt-pt/calendario">Calendário</a></li></ul></div>
  </div></nav><nav id="block-menu-menu-footer-menu-2" class="block block-menu odd block-count-12 block-region-tertiary-content block-menu-footer-menu-2"  role="navigation"><div class="block-inner clearfix">  
      <h2 class="block-title">Footer Menu 2</h2>
  
  <div class="block-content content"><ul class="menu clearfix"><li class="first leaf menu-depth-1 menu-item-1318"><a href="/pt-pt/contactos">Contactos</a></li><li class="last leaf menu-depth-1 menu-item-1319"><a href="http://academiahp.basepoint.pt/pt-pt/sitemap">Mapa do Site</a></li></ul></div>
  </div></nav><nav id="block-menu-menu-social" class="block block-menu even block-count-13 block-region-tertiary-content block-menu-social"  role="navigation"><div class="block-inner clearfix">  
      <h2 class="block-title">Visite-nos em:</h2>
  
  <div class="block-content content"><ul class="menu clearfix"><li class="first last leaf menu-depth-1 menu-item-1308"><a href="https://www.facebook.com/hptrainingacademy?fref=ts" class="facebook">Facebook</a></li></ul></div>
  </div></nav><div id="block-block-5" class="block block-block no-title odd last block-count-14 block-region-tertiary-content block-5" ><div class="block-inner clearfix">  
  
  <div class="block-content content"><p><img alt="" src="/sites/default/files/imce/ipdj_branco_novo.png" style="width: 41px; height: 49px;" /><img alt="" src="/sites/default/files/imce/logo_certificacao.svg" style="width: 62px; height: 43px;" /><img alt="" src="/sites/default/files/imce/ic_agap_branco_novo.png" style="width: 87px; height: 37px;" /><img alt="" src="/sites/default/files/imce/ic_simbolo.png" style="line-height: 20.8px; width: 46px; height: 45px;" /></p>
</div>
  </div></div></div></div>
    <!-- !Footer -->
          <footer id="footer" class="clearfix" role="contentinfo">
        <div class="region region-footer"><div class="region-inner clearfix"><div id="block-block-3" class="block block-block no-title odd first last block-count-15 block-region-footer block-3" ><div class="block-inner clearfix">  
  
  <div class="block-content content"><div class="powered">Powered by <a href="http://www.basepoint.pt/" target="_blank">Basepoint®</a></div>

<div class="direitos"><span>Holmesplace 2024 </span> © Todos os direitos reservados</div>
</div>
  </div></div></div></div>              </footer>
    
  </div>
</div>
  </body>
</html>