Live Virtual Training (Most Popular!) > Microsoft Excel Intermediate
All versions available. Outline version below is Microsoft Excel 2019. If you need assistance just chat with us LIVE.
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, discussions 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: Organizing Dynamic Data Range with Tables
Topic A: Create and Modify Tables
Topic B: Sort and Filter Data
Topic C: Use Subtotal to Calculate Data
Topic D: Data Validation
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
Topic B: Managing Multiple Windows
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
FREE QUOTATION!
COURSE DETAILS
COURSE BENEFITS
ALL IN FROM ONLY
RM0/DAY
*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
4
4
4
4
4
4
4
4
4
4
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