
Microsoft Excel (Advance)

Microsoft Excel (Advance)
The objective of the course was to provide exposure and knowledge of formula functions in microsoft excel as well as to maximise its use in speeding up work involving a lot of data.
Target Audience
Duration
Certification
Pahang Skills Development Centre
Pahang Skills Development Centre
Module 1
WORKING WITH WORKBOOK
§ Arrange the Workbook
§ Using a Workspace
§ Linking the Workbook
§ Merging the Workbooks
§ Share a Workbooks
§ Remove a User From a Shared Workbook
§ Grouping and Outlining Data
§ Preview and Printing Workbooks
Module 2
WORKING NAMED RANGES
§ Adding and Deleting Named Ranges
§ To Create a Named Range
§ To Delete a Named Range
§ To Use a Named Range In A Formula
§ Using VLOOKUP Functions
Module 3
CREATING AND USING EXCEL LISTS
§ Create a Data Form
§ Creating and Formatting a List
§ Searching For Records
§ Sorting Record
§ Setting Up a List Filter
Module 4
DISPLAYING AND FORMATTING DATA
§ Applying Number Format
§ Using Conditional Formatting
§ Performing Calculations and Changing Detail on a List
 Module 5
AUDITING A WORKBOOK
§ Creating a Data Entry List
§ Establishing Valid Data Entries
§ Tracing Errors, Precedent Cells and Dependent Cells
§ Consolidating Worksheet Data
Â
Module 6
PIVOT TABLE
§ Creating a PivotTable
§ Group PivotTable Items
§ Multi-Level PivotTable
§ Frequency Distribution
§ Pivot Chart
§ Slicers
§ Update PivotTable
§ Calculated Field/Item
§ Get Pivot Data
Module 7
SHARING WORKBOOKS
§ Creating, Editing and Removing Comments in Worksheets
§ Tracking Changes in a Workbook
§ Accepting or Rejecting Changes to a Worksheet
§ Applying and Removing Password Protection
§ Protecting Worksheets and Workbooks
Share :
Course Categories
- Graduates (8)
- Micro-Credential (61)
- School Leavers (7)