CERTIFICATION | COACHING | training provider
INFORMATION TECHNOLOGY, COMPUTING AND MANAGEMENT TRAINING COURSES
BROWSE BY CATEGORY
OUR POPULAR COURSES
MERN FULLSTACK 5 DAYS BOOTCAMP
BECOME A WELL-ROUNDED DEVELOPER FOR TODAY'S FASTEST TECHNOLOGY!
WHY YOU SHOULD ATTEND THIS BOOTCAMP
Attending the MERN fullstack development bootcamp will provide a wide range of benefits, from increasing your job prospects and working with cutting-edge technologies to developing your skills as a well-rounded developer:
Fullstack development skills: Learning MERN fullstack development means you will be proficient in both frontend and backend development, which can make you a more well-rounded developer and increase your job prospects.
Popular technology stack: MERN is a popular technology stack that is widely used by many companies and organizations. By learning MERN, you can increase your chances of landing a job and working with cutting-edge technologies.
High demand for MERN developers: The demand for MERN developers is high, and is expected to continue growing in the future. This means there are many job opportunities available for developers with MERN skills.
Rapid development: The MERN stack allows for rapid development of web applications, as it provides a set of well-integrated tools and libraries for frontend and backend development. This can help you build and deploy applications more quickly than using separate technologies for frontend and backend.
JavaScript-centric: The MERN stack is JavaScript-centric, which means that developers who are proficient in JavaScript can easily learn and work with MERN. Additionally, the MERN stack leverages the power of Node.js and its vast ecosystem of libraries and tools.
OBJECTIVES
The objective of a MERN fullstack course is to provide students with a comprehensive understanding of the MERN stack, modern web development concepts, and best practices for building and deploying fullstack web applications. By the end of the course, students should be able to create a fullstack web application using the MERN stack and deploy it to a production environment.
Understand the MERN stack: Students will learn the core components of the MERN stack, including MongoDB, Express.js, React, and Node.js. They will understand how these technologies work together to create a fullstack web application.
Build a fullstack web application: Students will learn how to build a fullstack web application using the MERN stack. They will gain experience with frontend and backend development, including creating dynamic user interfaces with React and building robust server-side APIs with Express.js.
Learn modern web development concepts: Students will learn modern web development concepts, such as Single Page Applications (SPAs), RESTful APIs, and MVC architecture. They will also learn about modern web development tools, such as Webpack, Babel, and ESLint.
Understand database design and management: Students will learn about database design and management using MongoDB. They will learn how to model data, create collections, and query data using MongoDB.
Learn to implement user authentication and access control: Students will learn how to implement user authentication and access control in a web application using JSON Web Tokens (JWT) and middleware functions.
Deploy a MERN application to production: Students will learn how to deploy a MERN application to a production environment, including configuring the application for production, debugging and troubleshooting common deployment issues, and securing and maintaining a production application.
WHO SHOULD ATTEND THIS COURSE
This MERN fullstack bootcamp is ideal for anyone who wants to learn modern web development and build fullstack web applications using the MERN stack:
Web developers who want to learn modern web development concepts and best practices for building and deploying fullstack web applications using the MERN stack.
Frontend developers who want to expand their skills and learn how to build robust server-side APIs using Express.js.
Backend developers who want to learn how to build dynamic user interfaces with React.
Fullstack developers who want to expand their skills and learn how to build fullstack web applications using modern web development tools and techniques.
Entrepreneurs and business owners who want to build their own web applications and need a comprehensive understanding of the MERN stack and modern web development.
Students and graduates who want to pursue a career in web development and need to build a strong foundation in modern web development concepts and tools.
METHODOLOGY
The methodology of this MERN fullstack bootcamp is a combination of classes, hands-on exercises, code reviews, discussions, and collaborative projects. This approach provides a well-rounded learning experience that reinforces understanding and application of concepts learned in the classroom.
Classes: The instructor will provide lectures to introduce new concepts and explain the core components of the MERN stack, modern web development concepts, and best practices for building and deploying fullstack web applications.
Hands-on exercises: Students will work on hands-on exercises and projects to apply the concepts learned in lectures. This will provide practical experience with building fullstack web applications using the MERN stack.
Code reviews: The instructor will review student code to provide feedback and guidance on best practices for coding, debugging, and troubleshooting.
Discussions and Q&A sessions: The instructor will facilitate discussions and Q&A sessions to help students understand concepts, troubleshoot issues, and reinforce their learning.
Collaborative projects: Students will work in teams to build collaborative projects that demonstrate their understanding of the MERN stack, modern web development concepts, and best practices for building and deploying fullstack web applications.
COURSE OUTLINE
(THIS IS A 5 DAYS BOOTCAMP)
DAY 1:
Introduction to the MERN stack: The instructor can give an overview of the MERN stack and its components, including MongoDB, Express.js, React, and Node.js. They can explain how each component fits into the full stack architecture and highlight the benefits of using the MERN stack for web development.
Installing and setting up the development environment: The instructor can guide the students through the process of installing the necessary software and tools for the course, including Node.js, npm, and MongoDB. They can also help the students set up a development environment using an IDE like Visual Studio Code or Sublime Text.
Overview of MongoDB and Mongoose: The instructor can give an introduction to MongoDB and NoSQL databases, and explain how Mongoose can be used as an Object-Document Mapping (ODM) tool for MongoDB. They can also cover topics like collections, documents, schemas, and CRUD operations in MongoDB.
Creating a simple Node.js and Express.js server: The instructor can demonstrate how to create a basic server using Node.js and Express.js, and explain the concepts of routing, middleware, and error handling in Express.js. They can also show how to use Postman to test the server.
Connecting to MongoDB database with Mongoose: The instructor can guide the students through the process of connecting the server to a MongoDB database using Mongoose, and demonstrate how to perform basic CRUD operations on the database.
DAY 2:
Introduction to React and JSX: The instructor can give an introduction to React and explain how it differs from traditional HTML and JavaScript. They can also demonstrate how to use JSX to write React components and explain the benefits of using a component-based architecture for UI development.
Setting up a basic React application with create-react-app: The instructor can guide the students through the process of creating a new React application using create-react-app, and explain the basic folder structure and configuration files in a React application.
Building a frontend UI with React components: The instructor can demonstrate how to build a basic UI using React components, and explain the concepts of props and state in React. They can also show how to use CSS to style the components and add interactivity using event handlers.
Handling user input and events with React: The instructor can demonstrate how to handle user input and events in React, and show how to use controlled components and form validation to create a more robust UI.
DAY 3:
Integrating the frontend and backend with RESTful API endpoints: The instructor can explain the concepts of RESTful APIs and demonstrate how to create and test API endpoints in Express.js. They can also show how to use tools like Postman or Insomnia to test the API endpoints.
Creating and testing API routes in Express.js: The instructor can guide the students through the process of creating and testing API routes in Express.js, and explain how to use middleware functions like body-parser and CORS to handle incoming requests and responses.
Using Axios to make API requests from React components: The instructor can demonstrate how to use Axios to make API requests from React components, and explain how to handle asynchronous data fetching and error handling in React.
Handling data flow and state management with Redux: The instructor can introduce Redux as a tool for state management in React applications, and demonstrate how to use Redux to manage the data flow between the frontend and backend. They can also explain the concepts of actions, reducers, and the Redux store.
DAY 4:
Adding authentication and authorization to the application: The instructor can introduce the concepts of authentication and authorization, and demonstrate how to use JSON Web Tokens (JWT) to secure the application. They can also explain the differences between authentication and authorization, and the importance of secure user authentication and access control in a web application.
Using JSON Web Tokens (JWT) for authentication: The instructor can guide the students through the process of implementing JWT-based authentication in the application, and explain how to generate and verify JWTs using libraries like jsonwebtoken and passport-jwt.
Creating protected routes with middleware: The instructor can demonstrate how to create protected routes in the application using middleware functions, and explain how to handle authentication and authorization errors in the frontend and backend.
Storing and managing user sessions with cookies and sessions: The instructor can explain the concepts of cookies and sessions, and demonstrate how to use them to store and manage user sessions in the application. They can also discuss best practices for session management, including session expiration and revocation.
DAY 5:
Deploying the MERN application to production: The instructor can demonstrate how to deploy the MERN application to a production environment, and discuss the different deployment options and considerations. They can also cover topics like server configuration, SSL certificates, and DNS settings.
Overview of different deployment options (e.g. Heroku, AWS, DigitalOcean): The instructor can give an overview of different deployment options for the MERN application, including popular cloud platforms like Heroku, AWS, and DigitalOcean. They can explain the benefits and limitations of each option, and provide guidance on how to choose the best option for the specific application and requirements.
Configuring the application for production: The instructor can guide the students through the process of configuring the application for production, including optimizing performance, securing the application, and configuring environment variables.
Debugging and troubleshooting common deployment issues: The instructor can explain the common deployment issues and errors that might occur in a production environment, and provide guidance on how to debug and troubleshoot these issues. They can also discuss best practices for monitoring and logging in a production environment.
Best practices for securing and maintaining a production application: The instructor can discuss best practices for securing and maintaining a production application, including regular backups, security patches, and performance monitoring. They can also provide resources and guidance on how to stay up-to-date with the latest security threats and trends.
LEARNING OUTCOME
The learning outcomes of this MERN fullstack bootcamp includes becoming proficient in the MERN stack, modern web development concepts, and best practices for building and deploying fullstack web applications. By the end of the bootcamp, students should be able to create and deploy a fullstack web application using the MERN stack, and have a solid understanding of modern web development through:
Proficiency in MERN stack: Students will become proficient in the MERN stack, including MongoDB, Express.js, React, and Node.js. They will understand how these technologies work together to create a fullstack web application.
Ability to build a fullstack web application: Students will be able to build a fullstack web application using the MERN stack. They will be able to create dynamic user interfaces with React, build robust server-side APIs with Express.js, and manage data with MongoDB.
Familiarity with modern web development concepts: Students will be familiar with modern web development concepts, such as Single Page Applications (SPAs), RESTful APIs, and MVC architecture. They will also be familiar with modern web development tools, such as Webpack, Babel, and ESLint.
Ability to implement user authentication and access control: Students will be able to implement user authentication and access control in a web application using JSON Web Tokens (JWT) and middleware functions.
Knowledge of database design and management: Students will have knowledge of database design and management using MongoDB. They will be able to model data, create collections, and query data using MongoDB.
Ability to deploy a MERN application to production: Students will be able to deploy a MERN application to a production environment, including configuring the application for production, debugging and troubleshooting common deployment issues, and securing and maintaining a production application.
PRODUCTIVITY WITH CHATGPT
TAKING ADVANTAGE OF AI EFFECTIVELY
“ChatGPT is a large language model created by OpenAI designed to understand natural language and generate human-like responses to questions and prompts. It has been trained on a vast amount of text data and have the ability to answer a wide range of questions on various topics and is capable of engaging in conversations, providing information, and even assisting with tasks.” - ChatGPT 08/03/2023
As an AI language model, the primary objective of ChatGPT is to provide helpful and informative responses to a wide range of questions in natural language, covering various topics such as science, technology, history, culture, and many more. In addition, ChatGPT aims to:
1. Improve user experience by providing accurate and relevant answers in a timely manner
2. Assist users in finding the information they need, regardless of the complexity or difficulty of the question
3. Enhance communication between people by bridging language barriers and providing assistance in multiple languages
4. Continuously learn and improve its responses through machine learning algorithms and human feedback to provide better quality and more reliable answers
5. Be accessible to everyone and promote inclusivity by providing equal access to information regardless of the user's background, location, or circumstances
Overall, ChatGPT's objectives revolve around providing helpful and accurate information, promoting knowledge sharing, and enhancing communication and inclusivity.
So how can ChatGPT help you complete your daily tasks more productively? JOIN THIS COURSE!
OBJECTIVES
1. Learn how to use ChatGPT for research, gathering information, and organising your work
2. Understand pros and cons of using ChatGPT
3. The difference between tacit and explicit knowledge comprehension
4. Using ChatGPT with Google Sheets
5. Improving search results
6. Using ChatGPT for job searching
WHO SHOULD ATTEND THIS COURSE
Anyone who is interested in learning and using ChatGPT effectively in improving their daily productivity:
1. Working Professionals
2. Writers
3. Students
METHODOLOGY
This is a hands-on, practical-based course. Trainees will be required to follow along with immersive practical training and exercises during the class.
COURSE OUTLINE
(THIS IS A 1 DAY TRAINING PROGRAMME)
0. CHATGPT BASICS
1. HISTORY OF MODERN TECHNOLOGY
2. WHAT IS ARTIFICIAL INTELLIGENCE
3. WHAT IS OPENAI
4. CHATGPT HISTORY
5. HOW CHATGPT REALLY WORKS
6. LIMITATIONS OF SPOKEN AND WRITTEN LANGUAGE
7. WRITING YOUR IDEAS
8. SPEAKING YOUR IDEAS
1. HOW CHATGPT REALLY WORKS
1. CHATGPT MODELS
2. LANGUAGE MODELS AND NLP
3. TRANSFORMER ARCHITECTURE
4. FROM TRANSFORMERS TO GPT, GPT2, AND GPT3
5. TEACHING GPT TO INTERACT WITH HUMANS: INSTRUCTGPT AND CHATGPT
2. UNDERSTANDING CHATGPT
1. EXAMPLES
2. CAPABILITIES 3. LIMITATIONS
3. ORGANISING YOUR QUERIES (IMPROVING SEARCH RESULTS)
1. HOW TO ASK QUESTIONS
2. PHRASING YOUR WORDS
3. BREAKING YOUR QUERIES
4. EFFECTIVE QUOTATIONS
5. EXERCISE: FREE-RANGE QUERIES
4. USING CHATGPT WITH GOOGLE SHEETS
1. USING SHEETGPT
2. EXAMPLES
3. EXERCISE: USING SOCIAL MEDIA POSTS TO CREATE CHATGPT SEARCH
5. CHATGPT FOR JOB SEARCHING
1. ANALYSING JOB DESCRIPTIONS
2. TAILOR YOUR RESUME
3. OPTIMISE YOUR RESUME BULLETS
4. WRITE YOUR COVER LETTER
5. PREPARE FOR INTERVIEWS
6. THE 80:20 RULE OF CHATGPT
7. EXERCISE:
1. ANALYSING JOB DESCRIPTION
2. WRITING YOUR COVER LETTER
6. FREE CHATGPT ADD-ONS TO AUTOMATE YOUR LIFE/WORK
1. WEBCHATGPT + EXERCISE
2. CHATGPT FOR GOOGLE + EXERCISE
3. CHATGPT WRITER + EXERCISE
4. GOD IN A BOX + EXERCISE
5. MERLIN + EXERCISE
6. CODEGPT + EXERCISE
7. TWEETGPT + EXERCISE
8. SUMMARIZE + EXERCISE
9. CHATGPT PROMPT GENIUS + EXERCISE
10. PROMPTHEUS + EXERCISE
11. FANCY GPT + EXERCISE
7. COMPETITORS AND KILLERS
1. ZEROGPT
2. GOOGLE BARD
3. OPT
4. PALM
5. BLOOM
6. GOOGLE LAMBDA
7. CHARACTER AI
GOOGLE WORKSPACE 5 Days TRAINING programme
FOR COMPANIES/ENTERPRISES USING THE GOOGLE WORKSPACE PAID OR FREE SERVICE
Google Workspace is a collection of cloud computing, productivity and collaboration tools, software and products developed and marketed by Google.
Google Workspace plans provide a custom email for your business and include collaboration tools like Gmail, Calendar, Meet, Chat, Drive, Docs, Sheets, Slides, Forms, Sites, and more. Easily work on documents, spreadsheets, and slides across your devices, with or without internet. Work in a single document with teammates or people outside your company. See edits as others type, communicate through built-in chat, and ask questions in comments.
This five days course is based on the Google Workspace Learning Center and additional resources listed at the end of this webpage.
PRODUCTS YOU WILL LEARN
APPLICATIONS:
1. Gmail - Secure business email and so much more. The latest Gmail makes it easier to stay
on top of the work that matters. With secure, ad-free email as a foundation, you can also chat, make voice or video calls, and stay on top of project work with shared files and tasks – all right in Gmail.
2. Calendar - Your plans, at your fingertips. Google Calendar brings all of your calendars together in one place, so you can manage work, events, meetings, personal life and everything in between.
3. Drive - Store, access, and share your files in one secure place. Store any and every file. Access files anytime, anywhere from your desktop and mobile devices. Control how files are shared.
4. Chat - Simplify 1:1 messaging and group collaboration. From direct messages to group conversations, Google Chat and Spaces help teams collaborate fluidly and efficiently from anywhere. Securely connect with anyone with whom you work, and take group work to the next level with shared chat, files and tasks.
5. Meet - Secure video meetings for your business. Keep your team connected with enterprise-grade video conferencing built on Google’s robust and secure global infrastructure. Meet is included with Google Workspace and Google Workspace for Education.
6. Jamboard - Visualise your ideas in a new and collaborative way Unleash your team’s creativity with Jamboard. Sketch your ideas whiteboard-style while benefiting from the access and connectivity of an interactive canvas, on mobile, or right from your web browser. Drop images, add notes, and pull assets directly from the web while collaborating with team members from anywhere.
7. Docs - Word processing for teams. Create and edit text documents right in your browser —no dedicated software required. Multiple people can work at the same time, and every change is saved automatically.
8. Sheets - Collaborative, smart, secure spreadsheets for fast-moving organisations. Sheets was designed with the needs of agile organisations in mind. AI features mean that you can tap into the right insights to make meaningful business decisions. A cloud-based architecture enables you to collaborate with anyone, anytime, anywhere. Compatibility with external systems, including Microsoft Office, removes the friction of working with multiple data sources. And built on top of Google’s infrastructure, Sheets gives you the freedom to create, while helping to keep your information secure.
9. Slides - Beautiful presentations created together. Create and edit polished presentations in your browser—no software required. Multiple people can work at the same time so everyone always has the latest version.
10. Forms - Easy to create surveys and forms for everyone. Create custom forms for surveys and questionnaires at no extra cost. Gather everything in a spreadsheet and analyse data right in Google Sheets.
11. Sites - Effortlessly create impactful team sites. Collaboratively create engaging, high-quality sites for your team, project or event. The sites look great on every screen, from desktop to smartphone. All without learning design or programming.
12. Keep - Capture what’s important and get more done. Keep organised. Capture inspiration and to-dos effortlessly. Collaborate on notes with teammates and set reminders to stay on track. Everything syncs across your devices, so what’s important is always in reach.
13. Cloud Search - The information that you need, right when you need it. Use the power of Google to search across your company’s content. From Gmail and Drive to Docs, Sheets, Slides, Calendar and more, Google Cloud Search answers your questions and delivers relevant suggestions to help you throughout the day.
SECURITY & MANAGEMENT:
14. Admin (Console) - Manage Google Workspace for your organisation. Easily add users, manage devices, and configure security and settings so your data stays safe. Administration shouldn't need a manual.
15. Google Tag Manager & Google Analytics - Tag Manager gives you the ability to add and update your own tags for conversion tracking, site analytics, re-marketing, and more. Google Analytics is a web analytics service that provides statistics and basic analytical tools for search engine optimisation (SEO) and marketing purposes.
16. Endpoint management - Keep things simple – and moving. Endpoint management for Android, iOS, Windows, Chrome OS, MacOS and Linux is easy to set up and use.
17. Vault - Data retention and eDiscovery for Google Workspace. Keep track of what matters. Retain, search and export your organisation’s data from select apps with Vault for Google Workspace Business and Enterprise editions.
COURSE OUTLINE
(THIS IS A 5 DAYS / 35 HOURS COURSE)
APPLICATIONS:
Day 1
0. GOOGLE WORKSPACE ACCOUNT
1. LOGIN AND CREDENTIALS
2. WORKSPACE APPS OVERVIEW
3. UNDERSTANDING CLOUD-BASED WORKSPACE
1. GMAIL
1. COMPOSING E-MAILS AND FORMATTING
2. BOXES, CATEGORIES AND LABELS
3. PERSONALISING YOUR E-MAIL
4. GMAIL ACCOUNT MANAGEMENT
5. CALENDAR, CHAT AND MEET SETTINGS
2. CALENDAR
1. UNDERSTANDING EVENTS ( OR MEETINGS)
2. BOOKING AND EDITING CALENDAR EVENTS
3. INVITING PARTICIPANTS TO AN EVENT
4. MULTIPLE CALENDARS AND SHARING CALENDARS
5. CALENDAR,BOOKING FOR MEET
3. CHAT
1. STARTING A GROUP CONVERSATION
2. CREATING AND BROWSING SPACE
3. FINDING APP AND MESSAGE REQUESTS
Day 2
4. DRIVE
1. GOOGLE DRIVE FRAMEWORK
2. CREATING FOLDERS AND DOCUMENTS
3. EDITING YOUR DRIVE
4. ORGANISE TEAM FILES IN SHARED SPACE
5. DESKTOP DRIVE APP FOR WINDOWS AND MAC OS
5. KEEP
1. NOTE TAKING
2. CREATING REMINDERS
3. EDITING LABELS
4. ARCHIVING AND DELETING ITEMS
6. MEET
1. BOOKING AND INVITING PARTICIPANTS TO A MEETING
2. CREATING AN INSTANT MEETING AND MEETING FOR LATER
3. SCHEDULE MEET IN GOOGLE CALENDAR
4. SHARE-SCREEN, CHAT, HOST CONTROL AND ACTIVITIES
7. JAMBOARD
1. SETTINGS, OPTIONS, AND CREATING FRAMES
2. DRAWING AND EDITING JAMBOARD
3. JOIN A MEET EVENT WITH JAMBOARD
4. MORE ACTIONS AND SHARING JAMBOARD
5. IMPORTING IMAGES INTO JAMBOARD
Day 3
8. DOCS
1. BLANK DOCUMENT AND TEMPLATES
2. IMPORTING FROM MS. WORD
3. CREATING/EDITING/SAVING AND SHARING A DOCUMENT
4. SHARING, CO-EDITING AND GOOGLE MEET OPTIONS
5. ADDING IMAGES, CHARTS AND DATA TO DOCS
6. MENU FUNCTIONS AND PRINTING (HARD AND SOFT COPIES)
7. MOVING SHEETS AND OTHER DOCUMENTS INTO DOCS
8. SETTINGS AND MENU OPTIONS
9. SHEET
1. MAKING A SHEET OR USING A TEMPLATE
2. IMPORTING FROM MS. POWERPOINT
3. SETTINGS, OPTIONS, AND SHARING SHEETS
4. FORMULAS AND FUNCTIONS
5. MENUS AND CELLS SETTINGS
6. TABLES AND TABLE SETTINGS
7. CHARTS AND GRAPHS
8. IMPORTING DATA INTO SHEETS
9. LINKING BETWEEN SHEETS AND OTHER DOCUMENTS
10. ADDITIONAL: DROP-DOWN CHIP FUNCTION
Day 4
10. SLIDES
1. MAKING FROM A BLANK SLIDE OR USING A TEMPLATE
2. IMPORTING FROM MS. POWERPOINT
3. SETTINGS, OPTIONS, AND SHARING SLIDES
4. MAKING THE MOST OF SLIDESHOW
5. IMPORTING DATA/TABLES/IMAGES INTO SLIDESHOW
6. IMPORT CHARTS FROM GOOGLE SHEET
11. FORMS
1. BLANK FORMS OR USING A TEMPLATE
2. TYPES OF FORMS (INCLUDING QUIZ AND ANSWERS)
3. EMBEDDING FORMS IN E-MAIL, WEBSITE OR LINKS
4. READING FORM RESPONSES IN GOOGLE SHEET
5. CREATING CHARTS AND ANALYSING FORMS DATA
12. SITES
1. BLANK SITE OR USING A TEMPLATE
2. USING THEMES IN SITES
3. CREATING AND NAVIGATING PAGES
4. ADDING EXTERNAL LINKS TO SITES
5. INSERTING TEXT, IMAGES, EMBEDDING LINKS AND DRIVE
6. SOCIAL MEDIA LINKS, YOUTUBE, CALENDAR, MAPS AND OTHER GOOGLE APP
7. SHARING AND PUBLISHING YOUR SITE
13. CLOUD SEARCH
1. LOGGING IN TO CLOUD SEARCH ON MULTIPLE PLATFORMS
2. SYNCING ACROSS DEVICES
3. BOOKMARKING AND SHARING DATA
SECURITY & MANAGEMENT
Day 5
14. ADMIN
1. UNDERSTANDING GOOGLE ADMIN DASHBOARD
2. ADDING, MANAGING, DELETING USERS
3. MANAGE BILLING, DOMAINS AND ALERTS
4. CREATE MAILING LIST GROUPS
5. ANALYSING DASHBOARD DATA
6. SECURITY MATTERS
15. GOOGLE TAG MANAGER AND GOOGLE ANALYTICS
1. PURPOSE OF GTM & GA
2. IMPLEMENTING GTM IN GOOGLE SITES
3. ANALYSING DATA FROM GA
4. MULTIPLE SOURCE DATA READING
5. GTM FOR NON-GOOGLE SITES
16. ENDPOINT MANAGEMENT
1. ENDPOINT MANAGEMENT FOR ANDROID, IOS, WINDOWS, CHROME OS, MACOS AND LINUX
2. CENTRALISED ADMINISTRATION OF YOUR ACCOUNTS AND DEVICES
3. USING INTEGRATED CLOUD IDENTITY
4. SETUP 2-STEP VERIFICATION AND SECURITY KEYS
5. ANALYSE SECURITY ANALYTICS
17. VAULT
1. SET UP VAULT USER ACCESS AND VAULT PRIVILEGES
2. RETENTION AND E-DISCOVERY FOR ORGANISATIONS
3. LICENSE REQUIREMENTS
4. INFORMATION GOVERNANCE: RETAIN AND DELETE DATA
5. E-DISCOVERY: SEARCH, HOLD, AND EXPORT DATA OF INTEREST
6. ACCESS CONTROL AND AUDITING
_______________________________________________________________________________________
REFERENCES:
1. GOOGLE Workspace Learning Center
2. Coursera - Google Career Certificates
3. Google Workspace Courses - Training
4. Introduction to Google Workspace Administration - cloudskillsboost
5. Google Cloud CITIbank PBWM-Neueda Technologies Ireland
6. GOOGLE Workspace Centre-Marc & Zed Training Pte Ltd Singapore
WHO SHOULD ATTEND
Anyone who is new to Google Workspace or interested in learning and using the broad range of Google Workspace products in their daily work.
If your organisation has subscribed to GOOGLE WORKSPACE.
RATIONALITY
This is a hands-on, practical-based course. Trainees will be required to follow along with immersive practical training and exercises during the class.
LEARNING OUTCOME
By the end of this course, you will get:
Learn the Google Workspace, a cloud-based platform
Effectively use the apps and their crossover functionalities
Practise Incremental Development
Understand Process & Product Adaptation
LICENSING INFORMATION The work in this document and subsequent materials used in training are licensed or are open-source licensed (Creative Commons License) by the respective parties.
Please e-mail admin@marcnzed.com or call +65 9052 3859 / +60124514977 for further details and fees
Microsoft Excel Beginner, Intermediate & Advanced Skills 3D PROGRAMME
FOR INDIVIDUAL/COMPANIES/ENTERPRISES WHO WANT TO MASTER EXCEL SKILLS!
THREE DAYS TRAINING PROGRAMME
Microsoft Excel is the industry leading spreadsheet software program, a powerful data visualisation and analysis tool. It is a powerful tool that can help you organise, calculate, analyse, revise, update, and present your data much easier and in less time. To achieve these skills, the courses is divided into three levels which is for beginners, intermediate and advanced.
THE TRAINER
Dr. Khairul Anuar is well experienced trainer and has 17 years of work experience as a trainer/lecturer/senior researcher and project engineer. He attained his PhD in Engineering from Universiti Science Malaysia. He has used Microsoft Excel entensively including in specific engineering field of Design of Experiments (DOE).
A HRDC Certified Trainer he has been a lead trainer with Marc & Zed SPACES since July 2022.
OBJECTIVES
Practise useful tips in Excel spreadsheet and create charts, works with formulas & functions, filtering, remove duplications, pivot table, logical and lookup function.
Understand what is dashboard so that the participants can conduct analysis using historical data,
clean data and complete analysis report in shorter time as well as to build fast statistical and interactive report.To create and use Pivot table incorporating slicers to filter report. Aside that the participant
can update data source, group, filter & sort data within Pivot table.
WHO SHOULD ATTEND THIS COURSE
Anyone who is new or have some basic knowledge of Microsoft Excel or interested in learning and using advanced functions of Microsoft Excel in their daily work.
METHODOLOGY
This is a hands-on, practical-based course. Trainees will be required to follow along with immersive practical training and exercises during the class.
COURSE OUTLINE
COURSE DELIVERY TIMES WILL BE BASED ON THE BELOW (UNLESS STATED OTHERWISE):
Time: 9.00 am- 5.00 pm (Break: 10.30am-10.45am/ 3.30pm-3.45pm Lunch: 12.30pm-1.30pm)
BEGINNER LEVEL
Duration : 1 Day
MODULE 1 - GETTING STARTED
Lesson 1.1 - About Workbooks
Creating a New Workbook
Opening a Workbook
Saving a Workbook
About Excel File Types
Closing a Workbook
Lesson 1.2 - Exploring your Workbook
Using Worksheets
The Active Cell
Selecting Cells
Exploring a Worksheet
Using Zoom
MODULE 2 - THE EXCEL INTERFACE
Lesson 2.1 - The Quick Access Toolbar and File Menu
The Default QAT Commands
Adding Commands
Removing Commands
Customising the Toolbar
Using the File (Backstage) Menu
MODULE 3 - EXCEL BASICS
Lesson 3.1 - Working with Excel
Columns, Rows, Cells, and Ranges
Creating Worksheet Labels
Entering and Deleting Data
Lesson 3.2 - Basic Excel Features
AutoFill
AutoSum
AutoComplete
Working with Basic Formula
Lesson 3.3 - Moving your Data
Dragging and Dropping Cells
How to Cut, Copy, and Paste Cells
How to Cut, Copy, and Paste Multiple Cells
Using Paste Special
Inserting and Deleting Cells, Rows, and Columns
Using Undo, Redo, and Repeat
MODULE 4 - EDITING YOUR WORKBOOK
Lesson 4.1 - Modifying Cells and Data
Changing the Size of Rows or Columns
Adjusting Cell Alignment
Rotating Text
Creating Custom Number and Date Formats
Lesson 4.2 - Cell Formatting
The Format Painter
Cell Merging and AutoFit
Lesson 4.3 - Enhancing a Worksheet’s Appearance
Adding Patterns and Colours
Adding Borders
Working with Styles
Working with Themes
Lesson 4.4 - Working with Charts, Part 1
Creating a Chart
Styling Charts with the Design Tab
Modifying Charts with the Layout Tab
Manipulating a Chart
MODULE 5 - PRINTING AND VIEWING YOUR WORKBOOK
Lesson 5.1 - Using the View Tab
Using Normal View
Using Full Screen View
Using Page Layout View
Page Break Preview
Lesson 5.2 - Printing your Workbook
Print Commands
Print Preview
Using Basic Print Options
Other Print Options
INTERMEDIATE LEVEL
Duration: 1 Day
MODULE 1 - WORKING WITH FUNCTIONS AND FORMULAS
Lesson 1.1 - Using Formulas in Excel
Understanding Relative and Absolute Cell References
Understanding Basic Mathematical Operators
Lesson 1.2 - Exploring Excel Functions
What are Functions?
Finding the Right Functions
Inserting Functions
Some Useful and Simple Functions
Lesson 1.3 - Using Functions in Excel
Working with Nested Functions
Using the IF Function
Nested IF Functions
Text, date & time functions
MODULE 2 - MANAGING TABLES
Lesson 2.1 - Working with Tables
What is a Table?
Creating Tables
Modifying Tables
Using the Table Tools – Design Tab
Adding a Total Row
Lesson 2.2 - Working with Tables and Filters
Sorting Data in a Table
What is an AutoFilter?
Creating a Custom AutoFilter
Using an Advanced Filter
Using an Advanced Filter with Logical Statements
Copying Filtered Records
MODULE 3 - SHOWING DATA AS A GRAPHIC
Lesson 3.1 - Adding Sparklines
What are Sparklines?
Adding Sparklines
About the Sparkline Tools Tab
Editing Sparkline Data
ADVANCED LEVEL
Duration: 1 Day
MODULE 1 - GETTING THE MOST FROM YOUR DATA
Lesson 1.1 - Exploring Scenarios
What is a Scenario?
Creating a Scenario
Saving Multiple Scenarios
Creating a Scenario Summary Report
Lesson 1.2 - Using Data Analysis Tools
Using a One or Two Input Data Table
Using Goal Seek
Lesson 1.3 - Using Solver
Enabling Data Analysis Tools
Understanding Solver
Generating Reports and Scenarios with Solver
Changing Solver Values
Managing Solver Constraints
Choosing a Solving Method
Using Solver as a Goal Seek Tool
Lesson 1.4 - Excel and Hyperlinks
What is a Hyperlink?
Inserting Hyperlinks
Editing Hyperlinks
Formatting Hyperlinks
Using Hyperlinks in Excel
MODULE 2 - PIVOTING DATA
Lesson 2.1 - Getting Started with PivotTables
What is a PivotTable?
Creating a PivotTable
Using the PivotTable Tools Tabs
Adding and Removing Data with the Field List
Changing the Field List Layout
Pivoting Data
Lesson 2.2 - Working with PivotTable Data
Expanding and Collapsing Data
Filtering Data
Sorting Data
Grouping Data
Refreshing Data
Editing the Data Source
Lesson 2.3 - Formatting a PivotTable
Modifying Fields and Labels
Modifying Values
Using the Layout Group on the Design Tab
Applying a Style to a PivotTable
Changing PivotTable Style Options
Manually Formatting a PivotTable
Using the PivotTable Options Dialog
Lesson 2.4 - Advanced PivotTable Tasks
Creating a Slicer
Using the Slicer Tools Tab
MODULE 3 - ADVANCED EXCEL TASKS
Lesson 3.1 - Using the VLOOKUP Function
Understanding VLOOKUP and HLOOKUP
Using VLOOKUP to Find Data
How to Find an Exact Match with VLOOKUP
Finding an Approximate Match with VLOOKUP
Using VLOOKUP as an Array Formula
Lesson 3.2 - Linking, Consolidating, and Combining Data
Linking Workbooks
Consolidating Workbooks
Combining Worksheets
Pivoting Consolidated Data
MODULE 4 - WORKING WITH MACROS AND CONTROLS
Lessons 4.1: Creating Macros in Excel
What Is a Macro?
Creating a Macro
Playing a Macro
Assigning A Shortcut Key to Macro
Macros, Buttons And Toolbars
Certificate
Upon successful completion of the course, participants will be awarded a verified digital certificate by Marc & Zed Training Singapore in collaboration with Marc & Zed SPACES Malaysia
Please e-mail admin@marcnzed.com or call +65 9052 3859 / +60124514977 for further details and fees
EFFECTIVE TRAINING NEED ANALYSIS (TNA)
HRDCorp Malaysia Train-The-Trainer Certification Programme Standard
Many people entering the training world sees the TNA process as a 'waste of time', or the beginning of the world, or a process that need not be re-looked at; while in reality, its is a productive step, re-iterative process that is summing up of much previous work, and plan the future needs. The development of TNA is the anchor document for all forms of business/ employee development.
Training Need Analysis (or TNA) is a final step-process of understanding both the business and employee needs in improving business performance. It is an extremely complicated process id sinew without planning or understanding of the nature of business of the trainees.
While there are many versions of TNA in the market; ranging from 3 to 10 step-process, or even the iterative-process TNA, our course will provide the Malaysia HRDCorp along with samples of real-life examples of good and bad designs.
Our course will also be looking at other TNAs requirements that are specific for industries and/ or countries (examples of 3 to 7 step-process TNAs). We will not only prepare the trainees to to be able to make their own TNAs, but also teach on how to prepare extract information necessary from employees or clients and then-on, planning and preparing TNAs based on the gathered information.
NOTE: This course will include examples of good and bad design TNAs, exercises in building your own industry-based TNAs and a thorough step-by-step matrix approach.
RATIONALITY
Learn on how to gather business and employees goals
Establish the key performance indicators (KPI) and standard operating procedures (SOP) 3. Practise Incremental Development towards planning and assessment of TNA
Outline the process and adaptation needed for the final training programme preparation 5. Determine scope of TNA using key performance areas (organisation/departments) and employee competency profile/job description so that the 3 levels of TNA are identified
LEARNING OUTCOME
Anchor the ideas of TNA development in earlier work, giving the learners continuity from the past to the present with clear future gains
Make clear that the TNA manifesto is a set of values, not a prescription for a particular type of process
Learn other TNA methods that can help you understand and achieve your targets as required in the TTT certifications in achieving company targets.
Develop a TNA manifesto that will be the guidance for the organisation needs.
WHO SHOULD ATTEND
Anyone who wants to make TNAs for their organisation or who need more information and an opportunity to practice their skills in designing good TNA that meets the standard of Malaysia HRDCorp requirements.
METHODOLOGY
This course is a hands-on and practise-based development of TNAs. We use a number of examples from different methodologies used around world that are based on specific industries development of their TNA, however the mindset, practices and skills learned can be applied to any business/employees and departments.
This course is based on the Train-The-Trainer section of the Training Need Analysis of the Malaysia HRDCorp with additional material from WSQ-Singapore and AITD-Australia as listed in the reference section of this course outline.
COURSE OUTLINE
MORNING SESSION (9AM -12.30PM)
1. BASICS OF TNA & MINDSET
1.1 Origins of TNA
1.2 TNA Mindset
1.3 Scope of TNA
1.4 TNA Types
1.4.1 Organisational level
1.4.2 Departmental level
1.4.3 Individual Level
2. DETERMINE DATA GATHERING METHODS
2.1 Type of Qualitative Data Collection Techniques
2.1.1 Observational Technique 2.1.2 Interviews
2.1.3 Focus Group
2.2 Types of Quantitative Data Collection Techniques
2.2.1 Surveys 2.2.2 Tracking
3. PERFORMANCE GAP ANALYSIS
2.1 Training Gap
2.2 Prepare Data Gathering Instruments
2.3 Administration Process Of Data Gathering
AFTERNOON SESSION (1.30PM - 5PM)
2.4 Data Analysis
2.4.1 Constant Comparison/Grounded Theory 2.4.2 Analytic Induction
2.4.3 Logical Analysis/Matrix Analysis
2.4.4 Quasi-statistics
2.4.5 Event Analysis/Microanalysis
2.4.6 Content Analysis
2.5. Reliability and Validity of Data
3. REPORT TRAINING NEED ANALYSIS FINDINGS
3.1 Determine Training Related Issues
3.2 Determine Non-Training Related Issues
3.3 Recommend Training Solutions
4. IDENTIFY TRAINING PROGRAMMES ACCORDING TO FINDINGS
4.1 Identify Target Participants
4.2 Select Appropriate Training Programmes
4.3 Prioritise Selected Training Programmes
5. DISCUSSION : EXAMPLES OF TNA
Your Trainer : Dr. Harjinthar Singh (HRDC Accredited, ACLP and AITD Professional Member)
_______________________________________________________________________________________
REFERENCES:
PSMB Train-The-Trainer Certification Programme material (Edition 2019)
Malaysia - HRDCorp Training Effectiveness Evaluation (TEE) https://hrdcorp.gov.my/hrd-tee/
Singapore - ACLP-WSQ Certification https://www.ssg.gov.sg/wsq.html
Australia - AITD-Need Analysis & Evaluation https://www.aitd.com.au/needs-analysis-and-evaluation
FOR PRICING AND BOOKING THIS COURSE, PLEASE E-MAIL US AT admin@marcnzed.com
OR CALL +6012 451 4977 (MALAYSIA) OR +65 9052 3859 (SINGAPORE)
Certificate
Upon successful completion of the course, participants will be awarded a verified digital certificate by Marc & Zed Training Singapore in collaboration with Marc & Zed SPACES Malaysia
haccp training & certification
HAZARD ANALYSIS CRITICAL CONTROL POINT (MS1480) CERTIFICATION | CONSULTANCY | TRAINING PROGRAMME
The Essentials of HACCP Explained
“the HACCP food safety management system requires food processors to have a written safety plan or a “HACCP Plan” which begins by conducting a Hazard Analysis that identifies “Critical Control Points” or CCPs — those points, steps or procedures in food manufacturing process at which control can be applied and as a result, a food safety hazard can be prevented, eliminated or reduced to an acceptable level.
Once CCPs are identified, food processors can then establish critical limits for each CCP, then continually monitor, take corrective actions where necessary, then validate and document that safe procedures are being followed.”
Source reference: Food & Drugs Administration
What and How We Will Help You
We provide a consultancy services of 5 consultants/advisors/trainers with multi-discipline, multi-experience to provide specialist services to: plan, develop and to achieve compliance of the HACCP internationally recognised certification for the client.
We propose a seamless, fast, strategic planning with exact goals and outcome known as a ROADMAP. This ROADMAP has been adapted from Ministry of Health Malaysia’s ‘GUIDELINES FOR HACCP CERTIFICATION’ and REMCO PRODUCT’s ‘WHITE PAPER HACCP Planning for Food Safety’ manuals. Based on ad-hoc requirements, we will add new/additional expertise, to achieve HACCP requirements/compliance.
The ROADMAP method project will be carried-out and implemented by marc&zed (along with the client's HACCP team) until completion. Therefore, the client need not hire a HACCP Consultant or any additional manpower for HACCP implementation. Any existing HACCP co-ordinator along with current staff to establish a HACCP team should suffice; and will be trained by us for future development, audits, and updating the HACCP documentations.
The remainder of this document is the ‘who’, ‘what’, ‘why’, ‘how’ and ‘when’ questions that are project fundamentals; that are necessary to be answered for planning, development and compliance for most certification requirements. This document in its entirety is a useful guide from the initial assessment (start of HACCP roadmap), all the way to final compliance approval of HACCP.
HACCP-BASED ON CODEX ALIMENTARIUS/GMP COMPLIANCE PROGRAMME (MS1480)
A. TRAINING
2 Days (14 hours)
Certificate of Completion
Online Instructor-led or client's venue
B. CONSULTANCY TOWARDS CERTIFICATION (Duration of up-to 6 months until certification)
On-site and off-site work- preparation for HACCP audit
Producing HACCP manual for client towards submission for certification
Please e-mail admin@marcnzed.com or call +65 9052 3859 / +60124514977 for further details and fees
BUSINESS COACHING PROGRAMME
INSPIRE TO WIN | GUIDE, MENTOR, BUSINESS PARTNER
WHO WE COACH?
• SME business entities
• Company without a senior management team
• Small businesses going through a growth momentum
• Business owner who need experienced mentors
• Business owner who wants to speed up their growth process and avoid mistakes
• Business entities without a large scale budget, corporate or growth experience
• Business entities that want to move on into their next level of growth
COACHING DURATION
Basic coaching – 3 months
Short-term coaching – 6 months
Long-term coaching – 1 year
Note : coaching programmes can be planned based on the customer's requirement and budget
COACHING PROGRAMME & OBJECTIVE
• Characteristics and attitude of CEO / founder / manager
• Effectiveness of networking
• Improving leadership skills
• Negotiation skills & tips
• Marketing and business development challenges
• Financial and management reporting
• How to secure banking facilities
• How to build-up your company track record for future growth
• Managing business partner/s perception
• Business sustainability
• To produce positive result based-on KPI
• To develop the right mind set
• To develop the right attitude towards success
• To enhance & build self confidence
• To highlight challenges, required to be a successful Manager / leader / CEO
Please e-mail admin@marcnzed.com or call +65 9052 3859 / +60124514977 for further details and fees
THINK, PLAN AND ACT LIKE A CEO TALK
THE KEY FOR A SUCCESSFUL & PROFITABLE BRANCH
Management& Motivational talk that will enhance branch managers leadership & desire to succeed
TARGET AUDIENCE
Branch Manager
Head of Department
Regional Manager
Assistant Branch Manager
PROGRAMME DURATION
4 hours session (1/2 day)
PROGRAMME METHOD
Class room or round table
Knowledge & experience sharing
2 ways discussion
Mentoring programme
PROGRAMME & OBJECTIVE
To develop and motivate a Branch Manager & Division Head :
To act as a branch CEO
To produce positive result towards your KPI
To develop the right mind set
To develop the right attitude to succeed
To enhance & build self confidence
To highlight challenges in becoming a successful Manager
PROGRAMME OUTLINE
Why a Branch Manager is the CEO of the branch?
Characteristics and attitude of a CEO
Networking tips
Effectiveness of networking
The magic of networking
How to translate networking into sales result
Leadership
Negotiation skills & tips
Marketing and business development challenge
How to tackle high-net worth customers
Please e-mail admin@marcnzed.com or call +65 9052 3859 / +60124514977 for further details and fees
SEMINAR & TALKS SERIES
(CLICK HERE TO SEE MORE)
THINK, PLAN & ACT LIKE CEO : THE KEY FOR A SUCCESSFUL & PROFITABLE BRANCH (BANKING INDUSTRY)
A TO Z OF MALAYSIA FINANCIAL, GOVERNMENT & INVESTMENT OPPORTUNITIES FOR FOREIGN INVESTORS
BUSINESS COOPERATION AND OPPORTUNITIES FOR LOCAL & FOREIGN INVESTORS
EFFECTIVE MOTIVATION AND LEADERSHIP : KEY TO BE A SUCCESSFUL BUSINESS OWNER IN MALAYSIA
ARE YOU MENTALLY, PHYSICALLY & COMMERCIALLY READY TO START YOUR OWN BUSINESS
CHALLENGES TO START OWN BUSINESS, ARE YOU READY TO FACE IT?
MARKETABILITY OF FRESH GRADUATES – HOW TO BE A DIFFERENT AND OUTSTANDING GRADUATES
THE ROUTE TO BE A WORLD CHAMPION FOR LOCAL AND FOREIGN BUSINESSES!
IN-BUILDING COVERAGE FOR MOBILE TELECOMMNUNICATION INDUSTRY
WHY MALAYSIA IS A GOOD INVESTORS HAVEN | INFRASTRUCTURE, GOVERNANCE AND FINANCE ASPECTS
MEDICAL STAFF TALK: MANAGEMENT VS. LEADERSHIP