Microsoft Excel

Intermediate – Advanced Level

About this course

Students will build upon the foundational Microsoft Office Excel  knowledge and skills already acquired and learn to create advanced workbooks and worksheets, including advanced formulas, tables and data analysing tools.

Audience profile

Students who have basic skills with Microsoft Excel  who want to learn more advanced skills or students who want to learn the topics covered in this course in the interface.

At course completion

After completing this course, students will be able to

  • Manage database effectively.
  • Apply proper formula and function.
  • Troubleshooting errors
  • Link and Embed Data from other sources.
  • Applying Conditional Formatting and Validation Rules

Prerequisite

  • Basic level of Excel.

Course Duration

  • 2 Days

Course Outline

Day1

Lesson 1: Customizing the Excel Environment

Lesson 2: Creating Advanced Formulas

Lesson 3: Working with Power Query

Day2

Lesson 4: Organizing and Analysing Datasets and Tables

Lesson 5: Visualizing Data with Charts

Lesson 6 : Using Pivot Tables and Power Pivot

Need help? Call our award-winning support team 8:00am -17:00pm at (603) 89229619

CONSULTANT

Online Training -UOC

Certification (IRCA)

About Us

UK TRAINER PLT are Qualified training provider in Malaysia Human Resource Development Ministry. Enrolled in Malaysian government certification program (IMALAYSIAGRIP). Varies international standard certification program and high hand training do conducting in Malaysia, Singapore, India, Indonesia & South Africa.

Weekly Newsletter