|
Login / Register
Diploma Courses

Mastering Basics of Microsoft Excel

Mastering Basics of Microsoft Excel
HR Professional Courses
Accredited Institute
HR Professional Courses
Certificate Type
Professional Certificate
Course Schedule (4 Days)

Upcoming Cohorts & Training Dates

Open For Enrollment

Choose from the upcoming 4-day cohorts below for online virtual sessions or physical classroom training.

Cohort A Enrolling Now
Oct 21, 2026
to Oct 24, 2026 (4 Days)
Duration: 4 Days Format: Online & Physical Classroom
Cohort B Next Batch
Oct 25, 2026
to Oct 28, 2026 (4 Days)
Duration: 4 Days Format: Online & Physical Classroom
Cohort C Upcoming
Oct 29, 2026
to Nov 01, 2026 (4 Days)
Duration: 4 Days Format: Online & Physical Classroom
Select your preferred cohort and enroll online or contact admissions for on-site physical classroom attendance.

Course Description

Relying on manual calculations and unorganized data sheets slows down daily business operations and increases the risk of costly reporting errors. Mastering Basics of Microsoft Excel strips away complex, high-level programming to offer a highly practical, step-by-step workbook approach to navigating the world’s most trusted spreadsheet software.

Across 24 foundational modules, you will explore the essential tools required to manage corporate data cleanly. The curriculum guides you from the absolute ground up: navigating the ribbon interface, formatting rows and columns, writing error-free formulas (such as SUM, AVERAGE, and COUNT), and setting up automatic data sorting rules.

You will practice using real-world business scenarios, such as organizing monthly department budgets, tracking inventory lists, and building simple client contact databases. By anchoring these fundamental spreadsheet habits into your daily routine, you will graduate from this program fully prepared to eliminate manual paperwork, structure messy corporate data, and present clean, readable reports to your management team.

COURSE OBJECTIVES

Upon successful completion of this training program, participants will be able to:

  • Master core practical methodologies, industrial frameworks, and international best practices.
  • Apply key technical concepts to real workplace operational challenges and scenarios.
  • Understand regulatory compliance, safety protocols, and quality assurance principles.
  • Prepare for certified professional examinations and earn an industry-recognized credential.

Course Outline

Text-based Curriculum

  • 1. Overview of Microsoft Excel and Its Applications
  • 2. Navigating the Excel Interface (Ribbons, Toolbars, and Worksheets)
  • 3. Understanding Workbooks, Worksheets, Rows, Columns, and Cells
  • 4. Basic Data Entry, Editing, and Formatting
  • 5. Saving and Managing Excel Files

  • 1. Introduction to Formulas and Functions
  • 2. *Using Basic Arithmetic Operations (+, -, , /)
  • 3. Common Functions: SUM, AVERAGE, MIN, MAX, COUNT
  • 4. Understanding Cell References: Absolute vs. Relative
  • 5. Introduction to Logical Functions (IF, AND, OR)

  • 1. Formatting Cells: Numbers, Text, Dates, and Conditional Formatting
  • 2. Sorting and Filtering Data Efficiently
  • 3. Using Tables for Better Data Organization
  • 4. Working with Multiple Worksheets and Linking Data
  • 5. Data Validation and Error Handling

  • 1. Introduction to Charts and Graphs
  • 2. Creating and Customizing Bar, Line, and Pie Charts
  • 3. Conditional Formatting for Better Data Insights
  • 4. Inserting and Formatting Images, Shapes, and SmartArt
  • 5. Printing and Sharing Excel Files Effectively

  • 1. Essential Excel Keyboard Shortcuts
  • 2. Intro to Freeze Panes, Split View, and Zoom Options
  • 3. Protecting and Securing Worksheets
  • 4. Hands-on Project: Creating a Functional Excel Spreadsheet

Training Venue (Physical Classroom Training)

Certfee Executive Training Center

Address: Port Harcourt Training Center, Rivers State, Nigeria.

Inquiry Phone: +234 707 670 5931

Physical Attendance Seats
Class sizes are capped to maintain interactive instructor mentoring. Call Venue Coordinator

Certificate Type & Accreditations

Professional Certificate Globally Verifiable

Upon course completion and evaluation, candidates are awarded an official certificate issued under the accreditation of HR Professional Courses. Each certificate carries a unique verification number for online credential validation.

HR Professional Courses

FAQ About This Course

Yes! We hold weekday and weekend physical training sessions at our center in Port Harcourt, Nigeria, as well as live online virtual batches.

Yes. Multiple upcoming cohort batches are available throughout the year. You can choose the intake date that matches your schedule or transfer your enrollment if your availability changes.

Digital verifiable certificates are issued within 48 to 72 hours of completing course evaluations. Hard-copy certificates can be collected at the institute or shipped to your address.
Course Fee

₦180,000.00

₦240,000.00
  • Level: Beginners Level
  • Duration: 4 Days
  • Lessons: 24 Modules
  • Certification: Included
  • Institute: HR Professional Courses
Enroll Online
Physical Classroom Training

Port Harcourt Training Center, Rivers State, Nigeria

Direct Line: +234 707 670 5931
Share On
Recommended

Related Courses

View All Courses