EMPOWERUS

Talk To Our Course Advisor

EMPOWERUS

Excel Training Program: Data Management and Analysis (Basic)

Build a strong foundation in Excel, covering basic functions, data entry, formatting, and simple formulas for everyday work efficiency.

Empowerus-Excel-Training-Fundamentals-scaled.webp

Objectives

1

Learn the basics of Excel navigation, data entry, and formatting.

Course content ›
2

Apply simple formulas and functions to automate calculations.

Course content ›
3

Create charts and summaries to present information clearly.

Course content ›

Course Content

  • Understanding Excel’s ribbon menu, toolbars, and quick-access features

  • Workbook vs. worksheet navigation

  • Inputting text, numbers, and dates efficiently

  • Editing shortcuts: autofill, copy-paste, undo/redo

  • Font customization for readability

  • Borders, colors, and styles for organization

  • AutoFit and alignment features

  • Number formatting (currency, percentages, dates, custom formats)

  • Writing formulas for basic calculations (add, subtract, multiply, divide)

  • Using AutoSum for quick totals

  • Introduction to common functions: SUM, AVERAGE, MIN, MAX

  • Copying and replicating formulas with Fill Handle

  • Sorting and filtering datasets

  • Using text-to-columns for data cleanup

  • Creating and customizing basic charts (bar, line, pie)

  • Recommended Charts feature

  • Purpose and benefits of PivotTables

  • Creating PivotTables to summarize data

  • Sorting and filtering within PivotTables

  • Generating quick reports

Learning Outcomes

  • • Navigate Excel confidently and perform efficient data entry.
  • • Apply formatting tools to create professional worksheets.
  • • Use formulas and functions to save time and reduce errors.
  • • Create charts and PivotTables to summarize and visualize data.

Inspiring growth and success through engaging learning experiences.

Company

Quick Links

Contact

+6016-6658527

empowerus@syncovis.world

160-4B, Batu 3 1/2,
Jalan Klang Lama,
58100 Kuala Lumpur
Wilayah Persekutuan Kuala Lumpur

Copyright © 2025 All Right Reserved