ICDL – Perform Advanced Spreadsheet Functions (Microsoft Excel 2016)

excel_training_courses_singapore_logo

ICDL - Perform Advanced Spreadsheet Functions (Microsoft Excel 2016)

The ICDL Advanced Spreadsheets module is designed to further your spreadsheet application skills to an expert level, allowing you to master the advanced functions of spreadsheet applications, enabling them to produce more sophisticated reports, and to perform complex mathematical and statistical calculations.

Share on facebook
Share on twitter
Share on linkedin

Overview

The ICDL Advanced Spreadsheets module is designed to further your spreadsheet application skills to an expert level, allowing you to master the advanced functions of spreadsheet applications, enabling them to produce more sophisticated reports, and to perform complex mathematical and statistical calculations. This will help you save time and improve productivity when working with spreadsheets.

Course Outline

  • Applying An AutoFormat/Table Style To A Cell Range
  • Applying Conditional Formats
  • Editing a Conditional Format
  • Changing a Conditional Format
  • Creating a Custom Conditional Format
  • Using Data Bars
  • Deleting a Conditional Format
  • Creating a Custom Number Format
  • Review Exercise
  • Copying Worksheets
  • Hiding Columns and Rows
  • Unhiding Columns and Rows
  • Split Text to Columns
  • Split a Window, Move, Remove Split Bars
  • Saving a Workbook as a Template
  • Using a Template
  • Editing a Template
  • Inserting a New Worksheet
  • Hiding/Unhiding  a Worksheet
  • Deleting a Template
  • Finding Online Templates
  • Review Exercise
  • Grouping in a Worksheet
  • Creating Subtotals in a List
  • Removing Subtotals from a List
  • Sorting Data by Multiple Levels
  • Using Custom Sort
  • Using Data Validation
  • Validating Data using List
  • Creating a Custom Error Message
  • Removing Data Validation
  • Review Exercise
  • Automatically Filter a List in Place
  • Creating a Criteria Range
  • Using a Criteria Range
  • Clearing and Advanced Filter
  • Using an Advanced AND Condition
  • Using an Advanced OR Condition
  • Copying Filtered Records
  • Using Database Functions
  • Finding Unique Records
  • Removing Duplicates from a Table
  • Review Exercise
  • Create a Combined Column and Line Chart
  • Create a Combined Column and Area Chart
  • Sparklines
  • Re-position Chart Title, Legend, Data Labels
  • Formatting an Axis
  • Changing the Axis Scaling
  • Formatting the Data Series
  • Adding Data from Different Worksheets
  • Using a Secondary Axis
  • Changing Data Series Chart Types
  • Changing Source Data Range
  • Review Exercise
  • Creating a PivotTable Report
  • Adding PivotTable Report Fields
  • Selecting a Report Filter Item
  • Refreshing a PicotTable Report
  • Changing the Summary Function
  • Adding New Fields to a PivotTable Report
  • Moving PivotTable Report Fields
  • Creating Report Filter Pages
  • Formatting a PivotTable Report
  • Creating a PivotChart Report
  • Grouping Data Manually
  • Review Exercise
  • Jumping to a Named Range
  • Assigning Names
  • Using Range Names in Formulas
  • Creating Range Names form Headings
  • Applying Range Names
  • Deleting Range Names
  • Using Range Names in 3-D Formulas
  • Displaying/Removing Dependent Arrows
  • Displaying/Removing Precedent Arrows
  • Showing Formulas
  • Using Group Mode
  • Review Exercise
  • Linking Data within a Spreadsheet
  • Importing Data from Text Files
  • Removing Linked Data
  • Creating a  Hyperlink
  • Editing a Hyperlink
  • Removing a Hyperlink
  • Review Exercise
  • Using the VLOOKUP Function
  • Using the HLOOKUP Function
  • Using the IF Function
  • Using the Nested IF Functions
  • Using an AND Condittion with IF
  • Using an OR Condition with IF
  • Using the NOT Function
  • Using the ROUND Function
  • Using Date Functions
  • Using the COUNTIF Function
  • Using the COUNTBLANK Function
  • Using the SUMIF Function
  • Using the RANK Function
  • Using Financial Functions
  • Using Text Functions
  • Using a 3-D References within a Function
  • Use Mixed References in Formulas
  • Review Exercise
  • Creating a Scenario
  • Displaying a Scenario
  • Editing a Scenario
  • Creating a Scenario Summary Report
  • Working with Data Tables
  • Placing Formulas in Data Tables
  • Creating a One-Variable Table
  • Creating a Two-Variable Table
  • Review Exercise
  • Unlocking Cells in Worksheet
  • Hide, Unhide Formulas
  • Protecting a Worksheet
  • Unprotecting a Worksheet
  • Creating Allow-Editing Ranges
  • Deleting Allow-Editing Ranges
  • Assigning a Password
  • Opening a Password-Protected File
  • Removing a Password
  • Review Exercise
  • Saving a Shared Workbook
  • Viewing Users Sharing a Workbook
  • Viewing Shared Workbook Changes
  • Changing the Update Frequency
  • Highlighting Changes
  • Managing Conflicting Changes
  • Resolving Conflicting Changes
  • Setting Change History Options
  • Adding a History Worksheet
  • Reviewing Tracked Changes
  • Merging Shared Workbook Files
  • Review Exercise
  • Recording a Macro
  • Saving a Macro-Enabled Workbook
  • Running a Macro
  • Assigning a Shortcut Key
  • Using a Shortcut Key
  • Deleting a Macro
  • Adding a Macro to the Quick Access Toolbar
  • Deleting a Macro From the Quick Access Toolbar
  • Review Exercise
  • Inserting Comments
  • Viewing Comments
  • Reviewing Comments
  • Printing Comments
  • Paste Special
  • Review Exercise

Get Brochure and Pricing

More Like This

Get the course Brochure & Pricing

Our course consultant will contact you within 1 working day

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Stay-Home-Series-main-header-v2

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Open chat
Get in touch with our consultant