Microsoft Excel 2007 Intermediate

Purchase this product now and earn 600 Points!
0 out of 5 based on 0 customer ratings

 Microsoft-Excel-2007-Intermediate-2-days-HRDF-Trainings

Objective

Upon completion of this program, participants should be able to:

  • Create simple to complex formulas and functions, like:
  • IF Functions
  • Nested Functions
  • Database Function – DSUM, DCOUNT
  • Validate data in a Worksheet
  • Filter data using Auto & Advanced Filters
  • Apply workbook protection

Prerequisites

Basic knowledge of Microsoft Excel is essential with the follow pre-requisites:

  • Have attended Microsoft Excel – Foundation Level; OR
  • Able to switch between task applications
  • Able to create a spreadsheet with simple formatting
  • Create a chart
  • Print a spreadsheet with headers and footers added

Who Should Attend

This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their knowledge and practical uses of Microsoft Excel.

Methodology

This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise

Module

  • WORKING WITH FUNCTIONS AND FORMULAS
    • Lesson 2.1 – Using Formulas in Excel
      • Understanding Relative and Absolute Cell References
      • Basic Mathematical Operators
      • Using Formulas with Multiple Cell References
      • The Formula Auditing Buttons
      • Fixing Formula Errors
      • Displaying and Printing Formulas
    • Lesson 2.2 – Exploring Excel Functions
      • What are Functions?
      • Finding the Right Function
      • Some Useful and Simple Functions
    • Lesson 2.3 – Using Functions in Excel
      • Inserting Functions
      • Using Functions and AutoFill to Perform Difficult Calculations
      • Using the IF Function
      • Working with Nested Functions
    • Lesson 2.4 – Working with Names and Ranges
      • What Are Range Names?
      • Defining and Using Range Names
      • Selecting Nonadjacent Ranges
      • Using AutoCalculate
    • Lesson 2.5 – Working with Array Formulas
      • What are Array Formulas?
      • Using Basic Array Formulas
      • Using Functions with Array Formulas
      • Using the IF function in Array Formulas
  • TEMPLATES
    • Lesson 1.1 – Using Templates
      • Opening a Template
      • Downloading a Template
      • Using a Template
      • Creating a Template
  • MANAGING TABLES
    • Lesson 3.1 – Working with Tables
      • What is a Table?
      • Creating Tables
      • Modifying Tables
      • What is the Total Row?
    • Lesson 3.2 – Working with Records and Fields
      • What are Records and Fields?
      • Adding Fields by Inserting Columns
      • Adding Records by Inserting Rows
      • Quickly Adding Records to a Data Table
      • Deleting Records or Fields
    • Lesson 3.3 – Working with Tables and Filters
      • Sorting Data in a Table
      • What is an AutoFilter?
      • Custom AutoFilters
      • Using an Advanced Filter
      • Copying Filtered Records
    • Lesson 3.4 – Using Excel as a Database
      • Filtering with Wildcard Characters
      • Validating Your Data
      • What are Database Functions?
  • FINALIZING YOUR WORKBOOK
    • Lesson 4.1 – Protecting your Workbook
      • Protecting your Workbook
      • Protecting your Worksheets
      • Unlocking Cells
      • Protecting your Excel Files
      • Marking a Workbook as Final
    • Lesson 4.2 – Finishing Your Workbook
      • Find and Replace Formatting
      • Conditional Formatting
      • Using the Document Inspector
      • Using the Compatibility Checker
    • Lesson 4.3 – Advanced Chart Options
      • Changing the Type of Chart
      • Changing the Source Data
      • Working with the Chart Axis and Data Series
      • Saving a Chart as a Template
    • Lesson 4.4 – Using Excel in Word
      • Inserting Excel Data in Word
      • Linking Excel Data in a Word Document
      • Modifying Excel Data after Insertion
      • Insert an Excel Chart into a Word Document
    • Lesson 4.5 – Using Excel With other Programs and Files
      • Opening an Excel File in a Different Format
      • Importing Data from a Text File
      • Publishing a Workbook as a PDF File

RM2,600.00 RM1,300.00

Qty:
Request For In-House
If you purchase this product you will earn 1300 Points!

Fee: RM 1,300 per pax


Loyalty Points: 1300 Points


Duration: 2 Days


Note: In-house course is available. Request it HERE

 Microsoft-Excel-2007-Intermediate-2-days-HRDF-Trainings

Objective

Upon completion of this program, participants should be able to:

  • Create simple to complex formulas and functions, like:
  • IF Functions
  • Nested Functions
  • Database Function – DSUM, DCOUNT
  • Validate data in a Worksheet
  • Filter data using Auto & Advanced Filters
  • Apply workbook protection

Prerequisites

Basic knowledge of Microsoft Excel is essential with the follow pre-requisites:

  • Have attended Microsoft Excel – Foundation Level; OR
  • Able to switch between task applications
  • Able to create a spreadsheet with simple formatting
  • Create a chart
  • Print a spreadsheet with headers and footers added

Who Should Attend

This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their knowledge and practical uses of Microsoft Excel.

Methodology

This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise

Module

  • WORKING WITH FUNCTIONS AND FORMULAS
    • Lesson 2.1 – Using Formulas in Excel
      • Understanding Relative and Absolute Cell References
      • Basic Mathematical Operators
      • Using Formulas with Multiple Cell References
      • The Formula Auditing Buttons
      • Fixing Formula Errors
      • Displaying and Printing Formulas
    • Lesson 2.2 – Exploring Excel Functions
      • What are Functions?
      • Finding the Right Function
      • Some Useful and Simple Functions
    • Lesson 2.3 – Using Functions in Excel
      • Inserting Functions
      • Using Functions and AutoFill to Perform Difficult Calculations
      • Using the IF Function
      • Working with Nested Functions
    • Lesson 2.4 – Working with Names and Ranges
      • What Are Range Names?
      • Defining and Using Range Names
      • Selecting Nonadjacent Ranges
      • Using AutoCalculate
    • Lesson 2.5 – Working with Array Formulas
      • What are Array Formulas?
      • Using Basic Array Formulas
      • Using Functions with Array Formulas
      • Using the IF function in Array Formulas
  • TEMPLATES
    • Lesson 1.1 – Using Templates
      • Opening a Template
      • Downloading a Template
      • Using a Template
      • Creating a Template
  • MANAGING TABLES
    • Lesson 3.1 – Working with Tables
      • What is a Table?
      • Creating Tables
      • Modifying Tables
      • What is the Total Row?
    • Lesson 3.2 – Working with Records and Fields
      • What are Records and Fields?
      • Adding Fields by Inserting Columns
      • Adding Records by Inserting Rows
      • Quickly Adding Records to a Data Table
      • Deleting Records or Fields
    • Lesson 3.3 – Working with Tables and Filters
      • Sorting Data in a Table
      • What is an AutoFilter?
      • Custom AutoFilters
      • Using an Advanced Filter
      • Copying Filtered Records
    • Lesson 3.4 – Using Excel as a Database
      • Filtering with Wildcard Characters
      • Validating Your Data
      • What are Database Functions?
  • FINALIZING YOUR WORKBOOK
    • Lesson 4.1 – Protecting your Workbook
      • Protecting your Workbook
      • Protecting your Worksheets
      • Unlocking Cells
      • Protecting your Excel Files
      • Marking a Workbook as Final
    • Lesson 4.2 – Finishing Your Workbook
      • Find and Replace Formatting
      • Conditional Formatting
      • Using the Document Inspector
      • Using the Compatibility Checker
    • Lesson 4.3 – Advanced Chart Options
      • Changing the Type of Chart
      • Changing the Source Data
      • Working with the Chart Axis and Data Series
      • Saving a Chart as a Template
    • Lesson 4.4 – Using Excel in Word
      • Inserting Excel Data in Word
      • Linking Excel Data in a Word Document
      • Modifying Excel Data after Insertion
      • Insert an Excel Chart into a Word Document
    • Lesson 4.5 – Using Excel With other Programs and Files
      • Opening an Excel File in a Different Format
      • Importing Data from a Text File
      • Publishing a Workbook as a PDF File

Reviews

There are no reviews yet.

Be the first to review “Microsoft Excel 2007 Intermediate”

You're reviewing: Microsoft Excel 2007 Intermediate . How do you rate this product? *

Redemption Products

Pin It on Pinterest