Loading Events

« All Events

  • This event has passed.

Level 2: Microsoft Excel (Intermediate)

November 14, 2023 - November 15, 2023

Objectives
This course will enable participants to gain a good general understanding of the main features of Excel, giving them the ability to produce standard spreadsheets, creating simple formula, formatting and printing spreadsheets 

Target Audience
Anyone who is required to manage high volumes of email and communicate electronically. The content is applicable for people from all levels.

Learning Outcomes
This course will provide learners with a core understanding of how to effectively operate and use the Excel spreadsheet software at an intermediate level.
● Create advanced formulas
● Analyse Data with Logical and Lookup Functions
● Create and Modify Tables
● Sort and Filter Data
● Use Subtotal and Database Functions to Calculate Data
● Visualize Data with Charts
● Create Advanced Charts
● Create a PivotTable
● Filter Data by Using Slicers
● Analyse Data with Pivot Charts
● Insert and Modify Graphic Objects
● Layer and Group Graphic Objects
● Customize Workbooks
● Manage Themes
● Create and Use Templates
● Protect Files
● Preparing a Workbook for Multiple Audiences

Course Outline
Topic 1 : Introduction to Excel 2016 Interface
● Starting Excel
● The Excel Interface
● Changing Excel’s View
● Working with Existing Workbook

Topic 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

Topic 3 : Using Basic Formulas
● Building Basic Formulas
● Using Cell References
● Using Cell Ranges

Topic 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

Topic 5 : Formatting Worksheets
● Working with Rows and Columns
● Using Themes
● Modifying Worksheet’s Appearance
● Inserting Headers and Footers

Topic 6 : Adding Pictures and Shapes to a Worksheet
● Inserting Pictures
● Adding Shapes and WordArt
● Deleting, Copying and Moving Graphics
● Formatting Graphics
● Using SmartArt Graphics

Topic 7 : Printing Worksheets
● Preparing a Document for Printing
● Printing with Backstage

Pricing:
RM 1,000.00 Per Person (HRD Corp Claimable Course)
 
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.
 
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:
November 14, 2023
End:
November 15, 2023
Open chat
Learn more about our services!