Excel - Formulas & Functions Beginner to Expert Course

Course Overview

• Course Title: Excel - Formulas & Functions Beginner to Expert Course
• Instructor: Web Oral
• Target Audience:
  • Beginners looking to build a strong foundation in Excel formulas and functions.
  • Intermediate users aiming to expand their Excel capabilities.
  • Professionals seeking to enhance their data analysis and reporting skills.
  • Students and job seekers looking to bolster their resume with valuable Excel expertise.
• Prerequisites:
  • There is no need for any knowledge or experience on Microsoft Excel.
  • A laptop or smartphone with Internet access.
  • Installed Microsoft Excel in your laptop or smartphone.

Curriculum Highlights

• Key Topics Covered:
  • Fundamentals of Formulas
  • Conditional & Logical Functions
  • Common Statistical Functions
  • TEXT Functions
  • DATE and TIME Functions
  • Dynamic Array Formulas
  • LOOKUP and Reference Functions
• Key Skills Learned:
  • Proper use of formulas and functions in Excel.
  • Techniques for data validation and cleaning.
  • Efficient use of logical functions like IF and nested IFs.
  • Specialized functions for targeted calculations.
  • Data transformation techniques.
  • Professional data presentation skills.
  • Practical application through hands-on exercises and real-world examples.

Course Format

• Duration: 2 hours on-demand video
• Format: Self-paced online course
• Resources:
  • 14 downloadable resources
  • Access on mobile and TV
  • Certificate of completion