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 2,200.00 Per Person (HRD Corp Claimable Course) + 8% SST
To inquire about pricing for our training, please contact us for a quote.
Kindly scan or click on the link below for your.
Learning Registration.
For any enquiries, please contact us at:
UOA Academy Sdn Bhd
Suite 1-2, Lower Level 1, City, The Horizon Annexe, Avenue 7,
Bangsar South, 59200 Kuala Lumpur, Wilayah Persekutuan Kuala Lumpur.
Tel: 6013 482 4810 / 6016 241 3517
Email: register@uoa-academy.com
Click Here for Registration & Further Details!
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.
