Advanced Excel Course for Job and Real World

Course Overview

• Course Title: Advanced Excel Course for Job and Real World
• Instructor: Zechariah Tech
• Target Audience:
  • Individuals looking to learn MS Excel from basic to advanced levels
  • Professionals aiming to enhance their Excel skills for job applications
• Prerequisites:
  • Basic Computer Knowledge
  • Basic Excel Knowledge
  • Understand English Language

Curriculum Highlights

• Key Topics Covered:
  • Advanced uses of MS Excel
  • Essential skills of MS Excel
  • Advanced Excel functions and formulas
  • VLOOKUP, HLOOKUP
  • Match, Audit Report
  • Macro, VBA
  • Entry Bill, Salary Slip
  • Job Formula
  • FV and PV
  • Index and Match
• Key Skills Learned:
  • Writing robust, elegant formulas from scratch
  • Building dynamic tools & Excel dashboards
  • Creating formula-based Excel formatting rules
  • Joining datasets from multiple sources
  • Manipulating dates, times, text, and arrays

Course Format

• Duration: 4.5 hours on-demand video
• Format: Self-paced online course
• Resources:
  • 1 article
  • 1 downloadable resource
  • Access on mobile and TV
  • Certificate of completion