Sale!

Microsoft Excel 2007 Intermediate

Original price was: RM2,600.00.Current price is: RM1,300.00.

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

Description

Fee: RM 1,300 per pax

Loyalty Points: 1300 Points

Duration: 2 Days

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