COURSE OVERVIEW
Gain essential data management skills by mastering key functions, formulas, and formatting techniques. This hands-on course empowers you to efficiently navigate, analyze, and present data for impactful decision-making.
Learning path objective
- Efficiently navigate and customize Excel for enhanced productivity.
- Master essential data management and formatting techniques.
- Apply key formulas and functions for effective data analysis.
Recommended for
All types of professionals seeking to enhance their data visualization skills.
COURSE HIGHLIGHTS
Master essential data management techniques
Learn key formulas for
accurate analysis.
Customize Excel for
improved efficiency.
Hands-on practice with real
business data.
Course Outline
Excel Fundamentals
- Introduction to Excel Interface
- Customising the Quick Access Toolbar
- Understanding the structure of an Excel Workbook
- Saving an Excel workbook
- Common Excel shortcut keys
1
Entering & Editing Text and Formulas
- Cells, columns, rows & sheets
- Working with Numeric Data in Excel
- Entering Date Values
- Working with Cell References
- Creating Basic Formulas in Excel
- Relative Reference vs Absolute Reference
2
Working with Basic Excel Functions
- The structure of Excel Function
- Working with SUM(), COUNT(), MIN(), MAX(), AVERAGE()
- Using the AutoSum command
- Using the AutoFill Command to Copy Formulas
3
Modifying an Excel Worksheet
- Moving and copying data in Excel Worksheet
- Inserting & Deleting rows & columns
- Hiding & Unhiding rows and columns
- Renaming & deleting an Excel worksheet
- Moving and copying an Excel worksheet
4
Formatting data in Excel Worksheet
- Working with Font Formatting
- Changing the background of cell color
- Adding borders to cells
- Number formatting
- Using Excel;s Format Painter
- Merging & Centering Cells
5
Inserting Images & Shapes into Excel Worksheet
- Inserting Images
- Inserting Excel Shapes
- Formatting Excel Shapes
- Working with SmartArt
6
Printing an Excel Worksheet
- Viewing your document in Print Preview
- Changing Margins, Scaling and Orientations
- Working with Page Layout view
- Adding Header and Footer
- Printing a Specific Range of Cells
7
For course customization and further discussion, feel free to reach out to us at marketing@matrixc.com
Trainers Profile
Mazlita Mat Hassan
Director / Lead Trainer, MatrixC Academy
Mazlita Mat Hassan, known as “MEM,” is an accomplished IT corporate trainer and data science expert with a BSc in Computer Science from University College London. With over a decade of experience, she has trained more than 10,000 professionals across Southeast Asia, specializing in Microsoft Office, Google Apps, and Tableau.
As the CEO of RECQA, she drives DeLIMA 2.0, Malaysia’s National Digital Learning Platform, and leads MatrixC Academy’s Change Management training with Google Tools. Globally recognized, she is the SEA & Pacific Leader for UNCTAD’s “e-trade for women” initiative and received the 2023 Women in STEM award from Business and Professional Woman Malaysia for her contribution in co-developing DeLIMA 2.0 with MOE and Google Malaysia.
Ikmal Nordin
Data & AI Lead, Matrix Connexion
A distinguished data analytics trainer, data scientist, and AI specialist with deep expertise in data science, AI, and economic analysis. Renowned for architecting cutting-edge data solutions, he translates complex concepts into practical, high-impact training for both corporate teams and individuals.
Ikmal has successfully trained and consulted for leading companies like Proton, Star Media Group, and BE International, empowering professionals across industries to harness the power of big data and AI for significant productivity gains and career advancement.