Live Virtual Training (Most Popular!) > Microsoft Excel 2021 Intermediate
All versions available. Outline version below is Microsoft Excel 2019. If you need assistance just chat with us LIVE.
Upon completion of this program, participants should be able to:
This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their knowledge and practical uses of Microsoft Excel.
This program will be conducted with interactive lectures, PowerPoint presentation, discussion and practical exercise.
Module 1: Referencing Calculations
Topic A: Formula Reference
Topic B: Apply Range Names
Module 2: Working with Functions
Topic A: Data Summary with Function
Topic B: Conditional Data Summary 1
Topic C: Conditional Data Extraction
Topic D: Conditional Data Summary 2
Module 3: Organize Dynamic Data Range with Table
Topic A: Create and Modify Tables
Topic B: Data Validation
Topic C: Sort and Filter Data
Module 4: Data Visualization
Topic A: Conditional Formatting
Topic B: Create Charts
Topic C: Modify and Format Charts
Topic D: Adding Sparklines
Topic E: Editing Sparklines
Module 5: Setting Up Reports as Pages
Topic A: Working with Different Views
Azrulnizam Ahmad has been working in the business industry since 2004 and has been exposed to all the common challenges faced by business personnel. With his years of experience working with business and management, IT services and end users, he understands the importance of business value, infrastructure efficiency and user productivity.He shares his training passion in Microsoft Office 2007 Application - Excel, PowerPoint, and Word; Microsoft Office 2010 Application - Excel, PowerPoint, and Word and also emphasizes on the criticality of this aspect in any implementation
4.5
Managing and maintaining a Microsoft Windows Server 2003 Environment - educate the IT professionals who implement, manage, and troubleshoot existing network and system environments based on the Windows Server 2003 platform. Implementation responsibilities include installing and configuring parts of systems. Management responsibilities include administering and supporting systems
4.5
Izham has 14 years of teaching background with 4 years in the academic department of a public university followed by corporate clienteles in the later years. Since becoming a corporate trainer, Izham has been helping office workers all over cope with data and document volumes in digital form to become efficient and come out being smart office workers.
4.5
Beatrice has been in the training industry for the past 27 years being one of the pioneer trainers of Microsoft Office training programs. She has vast experience having trained many people from various corporate sectors. She is a certified Microsoft Office training consultant and is accredited by Pembangunan Sumber Manusia Berhad (PSMB/HRDC).
4.5
Nazarudin Aziz started freelancing as a Corporate Trainer since the year of 2005 specializing in the field of Multimedia Graphic Designer and Microsoft Office Applications. His list of clients are Perodua, Grand Pacific Hotel, Cosway, UDA Mall, Institut Teknologu Rekabentuk Perabot Malaysia, Telekom Malaysia, Lembaga Tabung Haji, Yayasan Pelajaran MARA, Kementerian Pembangunan Wanita & Masyarakat, Hospital Tengku Ampuan Rahimah Klang, United Engineers Malaysia, Malaysian Maritime & Dredging Corporation, Jabatan Perdana Menteri, Indah Water Consotrium and many more.
Sylvia has been in the IT Training Industry for the past 20 years She began her career as a Corporate Trainer and her personal areas of expertise are wide; encompassing Microsoft and Adobe applications. In addition to that; she also specializes in corporate coaching for government, multi-national companies to local SMEs
Patrick Cheah has been involved in the IT and Training industry since 2002. He is very passionate about sharing knowledge and providing technical solutions. A Microsoft Certified Trainer and a member of the Toastmasters International, he has conducted trainings since 2005 to clients from various sectors. Patrick is also involved in writing and publishing online articles, promotional write-ups and event reports in several web portals.
4.5
CK has been involved in Microsoft Office Consulting for more than 15 years with the intention of helping friends and working adults to reach their full capability which in return will increase their work productivity. Throughout his many years of working experience using Microsoft Office Applications, he participated with various projects involving Engineering Data Analysis, A Complete System for Employees such as Leave Application, Petty Cash Claim, Arranging Schedule and so on with Programming using VBA Programming.
FREE QUOTATION!
THIS PUBLIC COURSE INCLUDES
*T&C Applies
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
4
4
4
4
4
4
4
4
4
4
4
4
3
3
3
Live chat, call or email, we’re here for you
Since its inception in 2009, Quorse, pronounced as “Kor-Say,” has been dedicated to revolutionizing the way you search for and engage with training courses.
As a comprehensive training search engine, our mission is to simplify the process of sourcing courses, making it effortless and efficient for you. Our extensive database, available 24/7, houses over 5000 courses spanning a variety of fields and disciplines.
Sign Up to Bookmark your Favourite Course
or Request for a Quotation instantly
Sign in with your social account
or
By signing up, you agree to our Terms of Use and Privacy Policy