Take your skills to the next level with Microsoft Excel Advanced
Power Query is the recommended experience for discovering, connecting to, and importing data. Power Pivot is a powerful data analysis and data modeling tool. Use Power Query and Power Pivot to mold your data in Excel so you can explore and visualize it with PivotTables, PivotCharts and Power Map.
Duration
2 days / 16 hours
Level
Beginner to Intermediate
Delivery
100% Online - Instructor Led
Request For Information
Key Features
- 48 hours of instructor led training
- Fully Online
- Class recording available
- Interactive Learning
- Additional Coaching Session
- 100% HRDF SBL-KHAS & MDEC MyWiT Claimable!
Pre-Requisites
- Basic Programming Knowledge
- 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
- Analysts
- Managers
- Business owners
- Executives
- Anyone responsible for analyzing data
Course Modules Covered in the Microsoft Excel
Advanced program
Module 1 - Getting Started with Excel 2019
Getting Started with Excel 2019
- Navigate the Excel User Interface
- Use Excel Commands
- Create and Save a Basic Workbook
- Enter Cell Data
- Use Excel Help
Module 2 - Performing Calculations
Performing Calculations
- Create Worksheet Formulas
- Insert Functions
- Reuse Formulas and Functions
Module 3 - Modifying a Worksheet
Modifying a Worksheet
- Insert, Delete, and Adjust Cells, Columns, and Rows
- Search for and Replace Data
- Use Proofing and Research Tools
Module 4 - Formatting a Worksheet
Formatting a Worksheet
- Apply Text Formats
- Apply Number Formats
- Align Cell Contents
- Apply Styles and Themes
- Apply Basic Conditional Formatting
- Create and Use Templates
Module 5 - Create and Use Templates
Printing Workbooks
- Preview and Print a Workbook
- Set Up the Page Layout
- Configure Headers and Footers
Module 6 - Managing Workbooks
Managing Workbooks
- Manage Worksheets
- Manage Workbook and Worksheet Views
- Manage Workbook Properties
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
Get Professionally Certified
Upon successfully completing this program, participants will be awarded the Professional Certification in Python Data Science by International Council for Technology Certifications (ICTC).
This award is a validation to the efforts taken to master the domain expertise that will set you apart from your competition.
Be a part of the global network of data science professionals and join the community across sectors.
Get in Touch With Us Today!
This training program is suitable for anyone who intends to enter into the field of Data Science. This program is being conducted in Malaysia and can be joined by anyone, anywhere in the world remotely.
Program Fee
Funding price MYR 3700 per pax .
Funding Schemes for Companies who are claiming from their HRDF levy or from the MDEC MyWiT scheme.
Limited scholarships available for early self applying individual applicants.
Find out how you can qualify for a scholarship.
Enquire NOW on the various funding options available.
Limited scholarships available for early self applying individual applicants.
Find out how you can qualify for a scholarship.
Enquire NOW on the various funding options available.
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