Loading Events

« All Events

LEVEL 2: Microsoft Excel (Intermediate) (2 days)

June 19, 2024 - June 20, 2024

Objectives

The Level 2: Microsoft Excel (Intermediate) program aims to provide participants with an in-depth understanding of intermediate Excel functionalities. The primary objectives include advancing participants’ proficiency in data analysis, enhancing spreadsheet management skills, and introducing them to more complex features of Microsoft Excel. Emphasis is placed on practical application, enabling participants to use Excel as a powerful tool for data manipulation, analysis, and visualization in professional settings.

Target Audience

This training is designed for individuals with a basic understanding of Microsoft Excel or those who have completed a beginner-level course. It caters to professionals, analysts, managers, and anyone looking to elevate their Excel skills to an intermediate level. The program is suitable for participants at various career stages, providing valuable insights and hands-on experience to enhance their spreadsheet capabilities.

Learning Outcomes 

  • Acquire advanced skills in data organization, analysis, and visualization.
  • Learn to manage larger datasets and create dynamic reports.
  • Utilize Excel’s powerful features for enhanced productivity.
  • Empower participants to leverage Excel as a strategic tool for decision-making and data-driven insights in professional roles.

Course Outlines:

Day 1:

Module 1: Introduction to Excel 2016 Interface

  • Starting Excel
  • The Excel Interface
  • Changing Excel’s View
  • Working with Existing Workbook

Module 2: Working with Microsoft Excel 2016

  • Creating Workbooks
  • Saving Workbooks
  • Input Basic Data
  • Using Data Types
  • Cutting, Copying and Pasting Data
  • Editing Workbook’s Properties

Module 3: Using Basic Formulas

  • Building Basic Formulas
  • Using Cell References
  • Using Cell Ranges

Module 4: Formatting Cells and Ranges

  • Inserting and Deleting Cells
  • Manually Formatting Cell Contents
  • Using Format Painter
  • Paste Special Options
  • Formatting Cells with Styles
  • Hyperlink Data

Day 2:

Module 5: Formatting Worksheets

  • Working with Rows and Columns
  • Using Themes
  • Modifying Worksheet’s Appearance
  • Inserting Headers and Footers

Module 6: Adding Pictures and Shapes to a Worksheet

  • Inserting Pictures
  • Adding Shapes and WordArt
  • Deleting, Copying and Moving Graphics
  • Formatting Graphics
  • Using SmartArt Graphics

Module 7: Printing Worksheets

  • Preparing a Document for Printing
  • Printing with Backstage
Pricing:
RM 1,500.00 Per Person (HRD Corp Claimable Course) + 6% SST
 
Kindly scan or click on the link below for your 
Learning Registration.
 
For any enquiries, please contact us at:
 
UOA Academy Sdn Bhd
UOA Corporate Tower, Lobby A, Avenue 10, The Vertical
Bangsar South City, No 8 Jalan Kerinchi
59200 Kuala Lumpur, Malaysia.
Tel: 6019 225 0942 / 6016 806 1760 / 6016 241 3517
Email: register@uoa-academy.com
 
 
Cancellation & Transfer

Please note that should this registration be cancelled fourteen (14) days before the day of the training, a 50% cancellation charge will be imposed. If cancellation is made seven (7) days before the training, full payment of the training will be levied. Please note that amendments can only be made to the above arrangement by giving a minimum of three (3) working days’ notice. Additionally, a 30% upfront payment is required via Human Resource Development Corporation (HRDC) or bank transfer.

Disclaimer: UOA Academy reserves the right to make changes to the venue, date, and speaker,
including cancellation of the workshop if warranted by circumstances beyond its control.

 

HRD-CORP-CLAIMABLE
 

Join Today!

Details

Start:
June 19, 2024
End:
June 20, 2024
Open chat
Learn more about our services!