4.4 Read 30 reviews
Overview
What you will learn
Upon completion of the MS EXCEL Essentials course offered by University Teknologi PETRONAS , participants will be able to:
- Build tools to help you automate, streamline, and absolutely revolutionize your workflow with Excel
- Explore unique tips, tools and case studies that you won't find in ANY other Excel course.
- Master Excel's powerful data analysis tools like Goal Seek, Scenario Manager, Solver.4. Practice with fun, interactive, and highly effective lessons
Programme Structure
The program focuses on:- Customizing the Excel
- Navigating Workbooks
- Ribbon Tools
- Removing Blank Rows
- Autofill and Flash Fill
- Excel Ribbon
- Splitting Text
- Working with Multiple Workbooks
- Unique Values
- Named Range & Table References
- Row & Column Sorting
- Advanced Filter
- Excel Grid
- Hiding Workbook
- Format Painter
- Color and Border
- Centering Selection
- Custom Format
- Grouping Columns and Rows
- IFERROR Function
- Converting Text to Dates
- Dynamic Formats
- Calculation Modes
- Line Breaks in Formulas
- Converting Units of Measurement
- TODAY and NOW Functions
- Pivot-Style Reports
- LEN and SUBSTITUTE Functions
- INDIRECT Function
- Hyperlinks to Worksheets
- VLOOKUP Function
- INDEX & MATCH Functions
- Finding keywords in Lists
- SUMPRODUCT Function
Key information
Duration
- Part-time
- 3 days
Start dates & application deadlines
- StartingApply anytime.
Language
English
Delivered
Online
Disciplines
Business Information SystemsAcademic requirements
We are not aware of any specific GRE, GMAT or GPA grading score requirements for this programme.
English requirements
We are not aware of any English requirements for this programme.
Other requirements
General requirements
- Excel users looking to level-up and master the same tools and techniques used by Excel MVPs
- Anyone hoping to maximize productivity, work more efficiently, and take their career to a new level
- Students looking for an engaging, hands-on, and highly interactive approach to Excel training
- Anyone looking to pursue a career in data analysis or business intelligence
- This course is NOT recommended for absolute beginners (some prior experience with Excel is encouraged)
Tuition Fee
To always see correct tuition fees
-
International
3000 MYR/fullTuition FeeBased on the tuition of 3000 MYR for the full programme during 3 days. -
National
3000 MYR/fullTuition FeeBased on the tuition of 3000 MYR for the full programme during 3 days.
Funding
Improve page content