MICROSOFT EXCEL - INTERMEDIATE
MICROSOFT EXCEL - INTERMEDIATE MICROSOFT OFFICE STANDARD Microsoft Office Application Training Selangor, Malaysia, Kuala Lumpur (KL), Shah Alam Training, Workshop | Iconic Training Solutions Sdn Bhd

Microsoft Excel - Intermediate

Course Durations: 2 Days

Audience: 

This course is suitable for participants who works with lots of formulas and creates report to understand the necessary techniques on how the electronic spreadsheet works.

Prerequisites:

  • Able to switch between task applications
  • Able to create a spreadsheet with simple formatting
  • Able to create a basic chart
  • Able to print a spreadsheet with headers and footers added
  • Able to use Auto Filter command
  • Able to apply Freeze Pane command
  • Able to create basic formulas - Addition, Substraction, Multiplication and Division
  • Able to use basic functions - AutoSum, Count, Max, Min and Average functions

Benefits:

  • Create a simple formulas and functions
  • Validate data in a worksheet
  • Filter data using Auto & Advanced Filters
  • Advanced Chart Formatting
  • Clean duplicate records
  • Visualizing data as a graphic

Course Outlines:

Module 1: Performing Calculations

  • Reuse Formulas

Module 2: Creating Advanced Formulas

  • Apply Range Names

Module 3: Working with Functions

  • Using Statistical Functions
  • Using Mathematical Functions
  • Using Logical Functions
  • Using Database Functions

Module 4: Organizing Worksheet Data with Tables

  • Create and Modify Tables
  • Sort and Filter Data
  • Use Subtotal and Database Functions to Calculate Data
  • Data Validation

Module 5: Visualizing Data as a Graphics

  • Conditional Formatting
  • Create Charts
  • Modify & Format Charts
  • Adding Sparklines
  • Editing Sparklines

Module 6: Managing Views

  • Working with Different Views
  • Managing Multiple Windows

Please leave your enquiry here, we will reply as soon as possible.

Switch To Desktop Version