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
Frequently Asked Questions (FAQ).
What will I learn in the Basic & Intermediate Excel Course in Singapore?
You will learn basic Excel navigation, data entry, formatting, formulas, and functions, plus intermediate skills including specialized functions (logical, date/time, text), charts, and PivotTables with PivotCharts.
Who should attend this course?
This course is suitable for beginners who want to build a foundation in Excel, as well as those with basic Excel knowledge who want to develop intermediate skills in data analysis and reporting.
Do I need prior Excel knowledge?
No prior Excel knowledge is required for the basic portion. For the intermediate portion, you should have basic Excel skills including creating workbooks, entering data, and using basic formulas.
What formulas and functions will I learn?
In the basic portion, you will learn to create worksheet formulas and insert functions. In the intermediate portion, you will work with ranges, specialized functions, logical functions, date and time functions, and text functions.
Will I learn how to organize and manage data?
Yes. The basic portion covers creating and saving workbooks, entering data, and managing workbooks. The intermediate portion covers working with lists and analyzing data.
Does the course cover formatting and charts?
Yes. The basic portion covers text formats, number formats, alignment, and basic conditional formatting. The intermediate portion covers creating, modifying, and formatting charts, including advanced chart features.
Will I learn pivot tables?
Yes. The intermediate portion covers creating PivotTables, analyzing PivotTable data, presenting data with PivotCharts, and filtering data using timelines and slicers.
How do I apply for this course?
You can register through the enrollment process on the course page. Course schedules and registration details are provided online
Are there any entry requirements?
Learners are encouraged to review the course requirements and prerequisites provided on the course page before registration. No prior knowledge is needed for the basic portion; basic Excel skills are recommended for the intermediate portion.
+65 8421 2824
info@exceltraining.com.sg
Chat With Us