Microsoft Excel..

Microsoft Excel (Advance Level) Class in Jalan Tun Razak

By ArcNet Training & Development Sdn Bhd
Microsoft Excel (Advance Level) Class in Jalan Tun Razak
Price : RM 699 per Package
About the class

Class level : Advanced .

Age requirement : 13 years old - above .

Number of lessons : 2 lessons for each Package .

Fee Includes

- 2 day full time classes

- Training material

- Hi tea

Why Book Through AOne?

  • Booking is safe. When you book with us, your details are protected by a secure connection.
  • Secure your slot instantly. Book classes with us and your seat is confirmed immediately

What You'll Learn

Pivot Tables
• Using a Pivot Table.
• Filtering and Sorting Data
• Grouping Data


Input Tables
• One-Input Data Tables.
• Two-Input Data Tables.


Charts
• Combined Line and Column Chart.
• Adding a Secondary Axis.
• Changing the Chart Type For a Data


Series.
• Adding a Data Series to a Chart.
• Removing a Data Series from a Chart.
• Modifying the Chart Title, Legend & Data


Labels.
• Chart Axis Scales.
• Inserting Images Into Chart Columns.
• Formatting the Chart Area


Hyperlinks
• Inserting a Hyperlink.
• Editing a Hyperlink
• Removing a Hyperlink


Linking & Embedding
• Linking Data within a Worksheet.
• Linking Cells between Worksheets within
a Workbook.
• Linking Data between Workbooks.
• Linking Data from Excel to a Word
Document.
• Linking an Excel Chart to a Word
Document.
• Updating, Locking and Breaking Links.
Importing Text Files
• Importing a Delimited Text File.


Sorting and Filtering Data
• Sorting Data by Multiple Columns
• Custom Sorts
• Customized List
• AutoFilter.
• Top 10 AutoFilter.
• Advanced Filter Criteria.
• Sub-Totalling.
• Removing Subtotals.
• Expanding and Collapsing Outline Detail.


Tracking and Reviewing Changes
• Enabling or Disabling 'Track Changes'.
• Sharing, Comparing and Merging
Worksheets.


Scenarios
• Scenario Manager.
• Scenario Summary Reports.


Validating
• Whole Number.
• Decimal Number.
• List.
• Date.
• Time.
• Text Length.
• Validation Input Message and Error Alert.
• Removing Data Validation.
Auditing
• Tracing Precedent Cells.
• Tracing Dependent Cells.
• Identifying Cells With Missing
Dependents.
• Showing All Formulas In a Worksheet.
• Comments..


Macros
• Using Macros
• Assigning a Macro to a Button on the
Quick Access Toolbar.
• Deleting Macros.


Passwords & Security Issues
• Password Protection.
• Password Protecting Cells and
Worksheets.
• Hiding Formulas.
• Un-Hiding Formulas.

More Lessons by ArcNet Training & Development Sdn Bhd

Wish to know more about this class? Send your inquiry now!

Name* :
Mobile Number* :
Email Address * :
Subject* :
Message * :

Looking for other classes? Let us know!

Location
KL/Selangor

Similar Lessons