
Physical Training Available
Learn Basic and Intermediate Excel Course
Learn Basic and Intermediate Excel in Singapore with hands-on training. Master formulas, charts, data analysis, and more to boost your productivity and enhance your professional skills confidently.
UTAP
Union Training Assistance Programme


Who Should Attend This Basic and Intermediate Excel Course in Singapore
Ideal for students, professionals, and executives in Singapore seeking to improve their Excel skills for data management and productivity.

Training Professionals

Business professionals

Entrepreneur

Students
Why Choose Us
- Hands-On Exercises
- Attention to each participants
- Interactive Class
- Step-By-Step Course
- 100% Satisfactory Record
- Trained more than 10000 Participants
- 20 Year Experienced Trainer
Excel Training Basic & Intermediate Objectives
This Basic & Intermediate Excel Training course equips learners with essential spreadsheet skills—from data entry to powerful functions and reporting tools—to improve productivity and data analysis at work.
- Learn basic Excel navigation, data entry, and formatting.
- Master essential functions: SUM, VLOOKUP, IF statements
- Use conditional formatting for dynamic visuals
- Create and customize charts for clear data presentation
- Practice sorting, filtering, and managing large datasets
- Build dynamic, professional reports
- Boost efficiency with time-saving Excel tools
- Ideal for professionals aiming to enhance workplace productivity
Basic Excel Course Duration: 1 Day
Course Outline for This Basic Excel Training
Lesson 1: Getting Started with Excel 2021
- Topic A: Navigate the Excel User Interface
- Topic B: Use Excel Commands
- Topic C: Create and Save a Basic Workbook
- Topic D: Enter Cell Data
Lesson 2: Performing Calculations
- Topic A: Create Worksheet Formulas
- Topic B: Insert Functions
- Topic C: Reuse Formulas and Functions
Lesson 3: Modifying a Worksheet
- Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows
- Topic B: Search for and Replace Data
- Topic C: Use Proofing and Research Tools
Lesson 4: Formatting a Worksheet</strong>
- Topic A: Apply Text Formats
- Topic B: Apply Number Formats
- Topic C: Align Cell Contents
- Topic E: Apply Basic Conditional Formatting
- Topic F: Create and Use Templates
Lesson 5: Printing Workbooks
- Topic A: Preview and Print a Workbook
- Topic B: Set Up the Page Layout
- Topic C: Configure Headers and Footers
Lesson 6: Managing Workbooks
- Topic A: Manage Worksheets
- Topic B: Manage Workbook and Worksheet Views
Intermediate Excel Course Duration: 1 day
Course Outline for This Intermediate Excel Training:
Lesson 1: Working with Functions
- Topic A: Work with Ranges
- Topic B: Use Specialized Functions
- Topic C: Work with Logical Functions
- Topic D: Work with Date and Time Functions
- Topic E: Work with Text Functions
Lesson 2: Working with Lists
- Topic A: Sort Data
- Topic B: Filter Data
- Topic C: Query Data with Database Functions
- Topic D: Outline and Subtotal Data
Lesson 3: Analyzing Data
- Topic A: Create and Modify Tables
- Topic B: Apply Intermediate Conditional Formatting
- Topic C: Apply Advanced Conditional Formatting
Lesson 4: Visualizing Data with Charts
- Topic A: Create Charts
- Topic B: Modify and Format Charts
- Topic C: Use Advanced Chart Features
Lesson 5: Using PivotTables and PivotCharts
- Topic A: Create a PivotTable
- Topic B: Analyze PivotTable Data
- Topic C: Present Data with PivotCharts
- Topic D: Filter Data by Using Timelines and Slicers