Loading Events

« All Events

  • This event has passed.

LEVEL 1: Microsoft Excel (Fundamentals) (2 days)

March 6, 2024 - March 7, 2024

Objectives

The Level 1 Microsoft Excel (Fundamentals) course aims to provide participants with a foundational understanding of Excel’s fundamental features and functionalities. The primary objective is to equip participants with essential skills, enabling them to navigate the Excel interface, create and format spreadsheets, perform basic calculations, and utilize key tools for data analysis. This course focuses on building a solid Excel proficiency for beginners, laying the groundwork for more advanced data manipulation and analysis in subsequent levels.

Target Audience

The target audience for this Microsoft Excel Fundamentals – Level 1 course is beginners and individuals with little to no prior experience with Excel. It is ideal for office workers, students, administrative professionals, or anyone who needs to work with data and wants to gain a fundamental understanding of Excel’s basic functionalities.

Learning Outcomes 

  • Navigate the Excel interface confidently and efficiently.
  • Create, save, and manage spreadsheets and workbooks.
  • Format data and cells to make the spreadsheet visually appealing and organized.
  • Perform basic calculations using formulas and functions, such as addition, subtraction, multiplication, and division.
  • Develop a solid foundation in Microsoft Excel, providing a basis for further learning and more advanced Excel courses.

Course Outlines:

Day 1:

Module 1: Introduction to Microsoft Excel

  • Excel interface and navigation
  • Working with workbooks and worksheets
  • Basic data entry and editing techniques

Module 2: Formatting Data and Cells

  • Applying font styles and formatting
  • Adjusting cell alignments and indents
  • Using borders and shading
  • Formatting numbers and dates

Module 3: Basic Formulas and Functions

  • Understanding cell references (relative and absolute)
  • Performing arithmetic calculations
  • Using SUM, AVERAGE, COUNT, and other essential functions
  • Applying auto-fill and auto-series techniques

Module 4: Data Sorting and Filtering

  • Sorting data in ascending and descending order
  • Applying custom sorts based on specific criteria
  • Using AutoFilter to filter data

Day 2:

Module 5: Working with Tables

  • Creating and managing Excel tables
  • Using table features for data organization and analysis
  • Utilizing the “Total Row” feature to calculate summary statistics within the table
  • Understanding the benefits of using structured references in formulas within tables

Module 6: Data Visualization with Charts

  • Creating different chart types (column, bar, pie, line, etc.)
  • Formatting and customizing charts for better visualization
  • Applying chart elements like axis titles and chart titles for better context
  • Modifying chart types and switching rows/columns for varied chart representations

Module 7: Conditional Formatting

  • Applying conditional formatting to highlight data based on specific rules
  • Using icon sets, data bars, and color scales
  • Utilizing conditional formatting to identify duplicates or unique values in data
  • Managing and clearing conditional formatting rules as needed

Module 8: Printing and Page Setup

  • Previewing and adjusting print settings
  • Page layout and print area settings
  • Printing options for worksheets and workbooks 

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:
March 6, 2024
End:
March 7, 2024
Open chat
Learn more about our services!