Begin your journey to becoming an Excel professional today
You already know how to get Excel® to perform simple calculations and how to modify your workbooks and worksheets to make them easier to read, interpret, and present to others.
But, Excel is capable of doing so much more. To gain a truly competitive edge, you need to be able to extract actionable organizational intelligence from your raw data.
In other words, when you have questions about your data, you need to know how to get Excel to provide the answers for you. And that's exactly what this course aims to help you do.
Duration
1 day / 8 hours
Level
Beginner to Intermediate
Delivery
100% Online - Instructor Led
Request For Information
Key Features
- 8 hours of instructor led training
- Fully Online
- Class recording available
- Interactive Learning
- Additional Coaching Session
- 100% HRDF SBL-KHAS Claimable!
Pre-Requisites
- Logical Operations’ Microsoft® Office Excel® 2019: Part 1 or equivalent
- Analytical Mindset
- Willingness to self learn online
- No prior experience is required
- We will start from the very basics
- Committed to complete all tasks
Who Should Join
- Business Analysts
- Excel Users
- IT & BI Professionals
Key Learning Outcomes
Upon completion, participants should be able to demonstrate each of the following outcome:-
- Learn different techniques for data analysis that can beeasily implemented in Excel
- Transform Data into insight using powerful methods of analysis, techniques and tools
- Bring your skills of Excel from Basic or Intermediate levels to Expert level
- Learn best practices for data analysis and data presentation
- Work in Excel faster by using hotkey shortcuts
Course Modules Covered in the Microsoft Excel
Intermediate program
Module 1 - Working With Functions
Working With Functions
- Work with Ranges
•Create name range
•Using name range in formulas
•Edit name range
•Deleting name range - Work with Logical Functions
•Sumif
•Countif
•Averageif
•And, Or
•IF - Work with Date & Time Functions
•Getting the current date
•Getting the current date and time
•Getting the day of the week from date
•Calculating date difference - Work with Text Functions
•Converting text to different cases
•Segregating text into multiple column
Module 2 - Working With Lists
Working With Lists
- Sort Data
- Filter Data
- Using advanced filter
- Query Data with Database Functions
- Outline and Subtotal Data
- Filter Data
Module 3 - Analyzing Data
Analyzing Data
- Create and Modify Tables
- Advantage of converting range into table
- Performing calculation in a table
- Editing table range
- Converting a table into range
- Apply Intermediate Conditional Formatting
- Advantage of converting range into table
Module 4 - Visualizing Data With Charts
Visualizing Data With Charts
- Create Charts
- Modify and Format Charts
- Use Advanced Chart Features
- Modify and Format Charts
Our Training Methodology
Practical Assignments
We provide hands-on assignments that requires practical implementation.
Virtual Coaching Sessions
Online coaching sessions that happen over the phone, via video, or on a web platform.
1 Year Access to LMS
Get access to learning resources upto 1 year of class completion.
Live Project Experience
Hands-on learning and training gives participants the opportunity to experience real world situations.
Online Assessments
Participants can assess reflect on their own learning and their level/skills.
Free Industry Webinars
Stay current on market research trends, learn best practices through our webinar sessions.
Program Key Highlights
48 hours of Remote Online Learning
Additional Coaching Hours
Live Hands-on Projects
Certified by International Body
Mentorship with Industry Experts
Designed for Beginners & Professionals
Request For Information
Get in Touch With Us Today!
This training program is suitable for anyone who intends to enter into the field of Microsoft Excel. This program is being conducted in Malaysia and can be joined by anyone, anywhere in the world remotely.
Program Fee
MYR 1300 per pax.
Funding Schemes for Companies who are claiming from their HRDF levy or from the SBL Khas scheme.
One-time fee. One year access to course materials and resources.
Thulija Academy is a HRDF registered training provider. Our panel of expert trainers provide technology training for some of the biggest organizations in Asia.
READY TO KICKSTART YOUR CAREER?
Please fill in the form and a Program Advisor will reach out to you. You can also reach out to us at info@thulija.com or +60123661502
Contact us on Whatsapp for more enquiries