/** * Deprecated functions. */ /** * Extra CSS class helper. * * @deprecated 5.0.5 Replaced with more clear name su_get_css_class(). * * @param array $atts Shortcode attributes. * @return string String with CSS class name(s). */ function su_ecssc( $atts ) { return su_get_css_class( $atts ); } /** * Shortcut for Su_Tools::decode_shortcode() * * @deprecated 5.0.5 Replaced with more clear name su_do_attribute(). */ function su_scattr( $value ) { return Su_Tools::do_attr( $value ); } /** * Shortcode names prefix in compatibility mode * * @deprecated 5.0.5 Replaced with more clear name su_get_shortcode_prefix(). */ function su_compatibility_mode_prefix() { return su_get_shortcode_prefix(); } /** * Shortcut for su_compatibility_mode_prefix() * * @deprecated 5.0.5 Replaced with more clear name su_get_shortcode_prefix(). */ function su_cmpt() { return su_get_shortcode_prefix(); } /** * Custom do_shortcode function for nested shortcodes * * @deprecated 5.0.5 Replaced with more clear name su_do_nested_shortcodes(). * * @param string $content Shortcode content * @param string $pre First shortcode letter * * @return string Formatted content */ function su_do_shortcode( $content, $pre ) { if ( strpos( $content, '[_' ) !== false ) { $content = preg_replace( '@(\[_*)_(' . $pre . '|/)@', "$1$2", $content ); } return do_shortcode( $content ); } /** * Shortcut for Su_Tools::get_icon() * * @deprecated 5.0.5 Replaced with more clear name su_html_icon(). */ function su_get_icon( $args ) { return Su_Tools::get_icon( $args ); } /** * Color shift a hex value by a specific percentage factor * * @param string $supplied_hex Any valid hex value. Short forms e.g. #333 accepted. * @param string $shift_method How to shift the value e.g( +,up,lighter,>) * @param integer $percentage Percentage in range of [0-100] to shift provided hex value by * * @return string shifted hex value * @version 1.0 2008-03-28 * * @deprecated 5.2.0 Replaced with su_adjust_brightness(). */ function su_hex_shift( $supplied_hex, $shift_method, $percentage = 50 ) { $shifted_hex_value = null; $valid_shift_option = false; $current_set = 1; $RGB_values = array(); $valid_shift_up_args = array( 'up', '+', 'lighter', '>' ); $valid_shift_down_args = array( 'down', '-', 'darker', '<' ); $shift_method = strtolower( trim( $shift_method ) ); // Check Factor if ( !is_numeric( $percentage ) || ( $percentage = ( int ) $percentage ) < 0 || $percentage > 100 ) trigger_error( "Invalid factor", E_USER_NOTICE ); // Check shift method foreach ( array( $valid_shift_down_args, $valid_shift_up_args ) as $options ) { foreach ( $options as $method ) { if ( $method == $shift_method ) { $valid_shift_option = !$valid_shift_option; $shift_method = ( $current_set === 1 ) ? '+' : '-'; break 2; } } ++$current_set; } if ( !$valid_shift_option ) trigger_error( "Invalid shift method", E_USER_NOTICE ); // Check Hex string switch ( strlen( $supplied_hex = ( str_replace( '#', '', trim( $supplied_hex ) ) ) ) ) { case 3: if ( preg_match( '/^([0-9a-f])([0-9a-f])([0-9a-f])/i', $supplied_hex ) ) { $supplied_hex = preg_replace( '/^([0-9a-f])([0-9a-f])([0-9a-f])/i', '\\1\\1\\2\\2\\3\\3', $supplied_hex ); } else { trigger_error( "Invalid hex color value", E_USER_NOTICE ); } break; case 6: if ( !preg_match( '/^[0-9a-f]{2}[0-9a-f]{2}[0-9a-f]{2}$/i', $supplied_hex ) ) { trigger_error( "Invalid hex color value", E_USER_NOTICE ); } break; default: trigger_error( "Invalid hex color length", E_USER_NOTICE ); } // Start shifting $RGB_values['R'] = hexdec( $supplied_hex[0] . $supplied_hex[1] ); $RGB_values['G'] = hexdec( $supplied_hex[2] . $supplied_hex[3] ); $RGB_values['B'] = hexdec( $supplied_hex[4] . $supplied_hex[5] ); foreach ( $RGB_values as $c => $v ) { switch ( $shift_method ) { case '-': $amount = round( ( ( 255 - $v ) / 100 ) * $percentage ) + $v; break; case '+': $amount = $v - round( ( $v / 100 ) * $percentage ); break; default: trigger_error( "Oops. Unexpected shift method", E_USER_NOTICE ); } $shifted_hex_value .= $current_value = ( strlen( $decimal_to_hex = dechex( $amount ) ) < 2 ) ? '0' . $decimal_to_hex : $decimal_to_hex; } return '#' . $shifted_hex_value; } /*! Select2 4.1.0-rc.0 | https://github.com/select2/select2/blob/master/LICENSE.md */ !function(){if(jQuery&&jQuery.fn&&jQuery.fn.select2&&jQuery.fn.select2.amd)var e=jQuery.fn.select2.amd;e.define("select2/i18n/es",[],(function(){return{errorLoading:function(){return"No se pudieron cargar los resultados"},inputTooLong:function(e){var n=e.input.length-e.maximum;return"Por favor, elimine "+n+" car"+(1==n?"ácter":"acteres")},inputTooShort:function(e){var n=e.minimum-e.input.length;return"Por favor, introduzca "+n+" car"+(1==n?"ácter":"acteres")},loadingMore:function(){return"Cargando más resultados…"},maximumSelected:function(e){var n="Sólo puede seleccionar "+e.maximum+" elemento";return 1!=e.maximum&&(n+="s"),n},noResults:function(){return"No se encontraron resultados"},searching:function(){return"Buscando…"},removeAllItems:function(){return"Eliminar todos los elementos"}}})),e.define,e.require}(); ICDL Microsoft Excel 2010/2013 Course (ES WSQ) - Advanced - Novasoft Academy

Novasoft Academy

IT Training Courses in Singapore

ICDL Module 4: ES WSQ
Perform Advanced Spreadsheet Functions
(Microsoft Excel 2010/2013)

What is Microsoft Excel?

In layman terms, Microsoft Excel is a software used to create spreadsheets for storing, organising, and manipulating data.

Course Overview

This 3-day Microsoft Excel advanced course prepares you for the ICDL Module 4 Perform Advanced Spreadsheet Functions exam.

On top of that, you will learn how to apply more advanced spreadsheet functions such as sorting query and link data, editing and enhancing numerics, and presenting advanced formatting operations on graphs and charts.

Learning Outcomes

This is a bootcamp that provides students with the knowledge and skills necessary to install, operate, and troubleshoot a small to medium-sized network, including connecting to a WAN and implementing network security.

Course Outline

Microsoft Excel Advanced (2010/2013)

Module 1. Using Conditional and Custom Formats
Module 2. Using Templates
Module 3. Working with Databases
Module 4. Working with Advanced Filters
Module 5. Revising Charting Features
Module 6. Creating/Revising PivotTables
Module 7. Using Auditing Tools and Range Names

Module 8. Exporting and Importing Data
Module 9. Using Advanced Functions
Module 10. Using Scenarios
Module 11. Using Worksheet Protection
Module 12. Tracking and Merging Workbooks
Module 13. Recording Macros
Module 14. Comments

Course Fees & Funding Options

Course Fee (inclusive of GST)  $535
Course Fee after 80% SkillsFuture Funding, capped at $17 per hour (inclusive of GST)*  $135

*Singapore Citizens aged ≥ 21 years.

Frequently Asked Questions

Upon completion of this module course under WDA funding, students will receive Statement of Attainment (SOA) Certificates from WDA. The details of SOA of each module are given below.
IT-NMM-401S-1 : Install and configure a Switch
IT-NMM-402S-1 : Install Switches and Multi-Switched local area network

Upcoming Classes

Microsoft Excel Advanced (2010)
16 - 17 Mar 2017 (9am - 6pm)
21 - 22 Mar 2017 (9am - 6pm)
27 - 28 Mar 2017 (9am - 6pm)
30 - 31 Mar 2017 (9am - 6pm)
6 - 7 Apr 2017 (9am - 6pm)
17 - 18 Apr 2017 (9am - 6pm)

Microsoft Excel Advanced (2013)
2 - 3 Mar 2017 (9am - 6pm)
13 - 14 Mar 2017 (9am - 6pm)
30 - 31 Mar 2017 (9am - 6pm)
6 - 7 Apr 2017 (9am - 6pm)
17 - 18 Apr 2017 (9am - 6pm)
27 - 28 Apr 2017 (9am - 6pm)

Course Reservation Form

Select a Course Date to Reserve Your Seat

Related Courses

Microsoft Excel (Beginners)

Accomplish basic tasks with Microsoft Excel such as creating a workbook, formatting text and cells, and data management.

Learn more →

Microsoft Word (Advanced)

Learn advanced word processing outputs, illustrating sophisticated typographical, formatting and layout presentations, including tables, forms or graphics.

Learn more →

Microsoft Powerpoint (Advanced)

Learn advanced formatting and layout techniques, enhance the presentation with the use of drawing and imaging tools, and create and use macros and multimedia effects.

Learn more →

Microsoft Project (Advanced)

Learn more advanced project information customisation, tracking project progress, importing and exporting data, and working with graphics and web pages.

Learn more →