Microsoft Excel 2007 Intermediate




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


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.


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


    • 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
    • Lesson 1.1 – Using Templates
      • Opening a Template
      • Downloading a Template
      • Using a Template
      • Creating a Template
    • 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?
    • 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

Fee: RM 1,300 per pax

Loyalty Points: 1300 Points

Duration: 2 Days

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


There are no reviews yet.

Be the first to review “Microsoft Excel 2007 Intermediate”