You have no items in your shopping cart.
Course Details
Course Details
What You'll Learn
Topic 1: Spreadsheet Basics
Introduction
Pre work: Creating a Google drive account
Pre work: Creating a copy of my spreadsheet templates!
Spreadsheet basics
Toolbar walkthrough
Data types in Spreadsheets
Navigating Spreadsheets with shortcuts
Simple formatting tricks – beautify your Spreadsheets
Topic 2 Introduction to functions
Get familiar with SUM, COUNT, AVERAGE, COUNTA, MIN, MAX
Activity
Topic 3: Conditional Functions
IF Statement
AND / OR statements
IF’s and nesting IF
Conditional formatting
Conditional arithmetic functions (eg: SUMIF)
Topic 4: Pivot Tables, Sorting & Filtering
Introduction to raw data and the new section format
Pivot tables
Sorting and filtering
Topic 5: Charts & graphs
Creating charts and graphs in Google Sheets
Topic 6: Data Validation & introduction to Dynamic Models
Data validation
Creating basic dynamic model
Data validation and intermediate modelling
Topic 7: Errors, IF Error and Creating named ranges
Errors that we need to know and how to fix them
IFERROR formula
Named ranges
Topic 8: VLOOKUP, Lookup and Index Match
Vlookup
Hlookup
Index Match
Topic 9: Text functions
Adding words together and changing their case
Extracting first and last names from a cell
Left function
Right function
Len function
Trim function
Topic 10: Date & time functions
Edate, EOMonth
Interactive calendar
Topic 11: Rounding and Randomizing
Randomizing using RAND and RANDBETWEEN
ROUND, ROUNDUP and ROUNDDOWN
Course Info
Promotion Code
Your will get 10% discount voucher for 2nd course onwards if you write us a Google review.
Minimum Entry Requirement
Knowledge and Skills
- Able to operate using computer functions
- Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)
Attitude
- Positive Learning Attitude
- Enthusiastic Learner
Experience
- Minimum of 1 year of working experience.
Target Age Group: 18-65 years old
Minimum Software/Hardware Requirement
Software:
TBD
Hardware: Window or Mac Laptops
Job Roles
Job Roles
- Data Analyst
- Administrative Assistant
- Office Manager
- Project Manager
- Accountant
- Financial Analyst
- Marketing Coordinator
- Sales Representative
- Human Resources Coordinator
- Research Assistant
- Business Development Manager
- Product Manager
- Operations Manager
- Educator
- Small Business Owner
Trainers
Trainers
is an accomplished IT and data specialist with over 20 years of experience in academia, ICT leadership, and professional training, with a strong focus on data analytics and Excel-based solutions. He has developed and delivered specialized training programs on Statistical Data Analysis with Excel and Visual Basic for Applications (VBA) for Excel, equipping learners with advanced data manipulation, automation, and reporting skills. His expertise extends to automating institutional reporting systems, where he successfully streamlined academic records management through Excel-based tools, integrating macros and automation to improve efficiency and accuracy. As a trainer and consultant, Dr. Siraj has taught Excel to diverse audiences, including university staff, administrative teams, and professionals in banking, security, and education, ensuring they can apply Excel for decision-making, statistical modeling, and process automation. His practical mastery of Excel is complemented by his deep knowledge of office automation and ICT project management, making him a highly sought-after trainer in data analysis and productivity tools. With his blend of hands-on technical expertise and instructional experience, Dr. Siraj stands out as a credible authority in leveraging Excel to drive organizational efficiency and data-driven strategies
Review
Customer Reviews (10)
- Worth every cent Review by Course Participant/Trainee
-
Good hands-on training with plenty of examples. I feel much more confident applying these skills now. (Posted on 11/28/2024)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Very useful course Review by Course Participant/Trainee
-
Well organised course with clear objectives. The step-by-step approach made it easy to follow. (Posted on 8/9/2024)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Very useful course Review by Course Participant/Trainee
-
Very informative and interactive. The small class size meant we got a lot of personal attention. (Posted on 7/19/2024)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Superb training Review by Course Participant/Trainee
-
The trainer was knowledgeable and explained the concepts clearly with real-world examples. (Posted on 4/12/2024)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Worth every cent Review by Course Participant/Trainee
-
Solid content and a supportive trainer. I would definitely sign up for more courses here. (Posted on 1/15/2024)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment
Write Your Own Review
- Recommended Courses
