Information Technology

The information technology courses we offer are relevant and practical to ensure you are fully prepared to translate your knowledge into tangible business impact.

Find the programme that’s right for you

Overview

Microsoft Word is one of the most important computer programs because of the key role it plays in many sectors. It is used to create and edit letters, articles, newsletters, flyers, and any other text-based document. In this session, participants will be able to learn about Microsoft Word in an easy to navigate way.

Objectives

At the end of the course, participants will be able to do the following:

  • Understand the basic features of Microsoft Word, including the Ribbons
  • Create a new document, set basic document parameters, and save your work
  • Create complex and professional documents with a consistent look and feel
  • Enhance a document with more features such as creating lists of items, inserting and managing pictures, and adding special effects to documents

Methodology

The course is delivered via online / physical lectures and practical activities.

For Whom

This course is designed for those who would like to be able to work comfortably with Microsoft Word. Users who have a ‘basic to good’ understanding and knowledge of Microsoft Word, and those who are keen to further their working knowledge of Microsoft Word, would benefit from this course.

No. of Participants

25 persons max

Duration

1 Day

INTERESTED? WANT TO KNOW MORE?

To Request Full Proposal, click here 

Overview


Microsoft Word is one of the most important computer programs because of the key role it plays in many sectors. It is used to create and edit letters, articles, newsletters, flyers, and any other text-based document. In this session, participants will be able to learn about Microsoft Word in an easy to navigate way.

Objectives

At the end of the course, participants will be able to do the following:

  • Automate tedious tasks such as preparing a letter to send to every customer of your organization
  • Implement time-saving features such as document templates and automated mailings help your organization reduce expenses

Methodology

The course is delivered via online / physical lectures and practical activities.

For Whom

This course is designed for those who would like to be able to work comfortably with Microsoft Word. Users who have a ‘basic to good’ understanding and knowledge of Microsoft Word, and those who are keen to further their working knowledge of Microsoft Word, would benefit from this course.

No. of Participants

25 persons max

Duration

1 Day

INTERESTED? WANT TO KNOW MORE?

To Request Full Proposal, click here 

Overview

Microsoft PowerPoint is a presentation software that enables users to create engaging presentations that consist of individual pages, or slides, which may contain text, graphics, sound, movies, hyperlinks, and other objects. PowerPoint enables users to add animation and effects to slide show elements.

In this session, participant will be able to learn about Microsoft PowerPoint in an easy to navigate way.

Objectives

At the end of the course, participants would have good working knowledge of Microsoft PowerPoint that would assist them in their day-to-day work.

  • Understand the basic features of Microsoft Powerpoint, including the Ribbons, format slides and use templates.
  • Create and manipulate simple slide shows with outlines and notes.
  • Create slide presentations that include text, graphics, animation, and transitions
  • Create a new Powerpoint by using slide sorter, set basic parameters, and reorganize a presentation.
  • Create a customized and professional Powerpoint with a consistent look, feel for different types of slides.

Methodology

The course is delivered via online / physical lectures and practical activities.

For Whom

This course is designed for those who would like to be able to work comfortably with Microsoft PowerPoint. Users who have a ‘basic to good’ understanding and knowledge of Microsoft PowerPoint, and those who are keen to further their working knowledge of Microsoft PowerPoint, would benefit from this course.

No. of Participants

25 persons max

Duration

1 Day

INTERESTED? WANT TO KNOW MORE?

To Request Full Proposal, click here 

Overview

Microsoft PowerPoint is a presentation software that enables users to create engaging presentations that consist of individual pages, or slides, which may contain text, graphics, sound, movies, hyperlinks, and other objects. PowerPoint enables users to add animation and effects to slide show elements.

In this session, participant will be able to learn about Microsoft PowerPoint in an easy to navigate way.

Objectives

At the end of the course, participants would have good working knowledge of Microsoft PowerPoint that would assist them in their day-to-day work.

  • Enhance a Powerpoint with more features such as Animation, Clipart, special effects, charts and custom shows.
  • Understand on how to arrange the objects, working with images and creating charts using Powerpoint.
  • Working with themes, slides master design layouts and use the professional template for presentations.
  • Using Navigation by utilizing, editing, managing hyperlink and playing media link in the Powerpoint.
  • Implement time-saving features such as Outline tab, Zip around in your presentation fast with numerous shortcuts.

Methodology

The course is delivered via online / physical lectures and practical activities.

For Whom

This course is designed for those who would like to be able to work comfortably with Microsoft PowerPoint. Users who have a ‘basic to good’ understanding and knowledge of Microsoft PowerPoint, and those who are keen to further their working knowledge of Microsoft PowerPoint, would benefit from this course.

No. of Participants

25 persons max

Duration

1 Day

INTERESTED? WANT TO KNOW MORE?

To Request Full Proposal, click here 

Overview

Microsoft Excel is one of the most important computer programs because off the key role it plays in many sectors. It is used to create grids of text, numbers and formulas specifying calculations. That’s extremely valuable for many businesses, which use it to record expenditures and income, plan budgets, chart data and succinctly present fiscal results.

In this session, participants will be able to learn about Microsoft Excel in an easy to navigate way.

Objectives

At the end of the course, participants would have good working knowledge of Microsoft Excel that would assist them in their day-to-day work. This programme will assist the participants as follow:

  • Understand on how to indicate the functions and identify the elements of the Excel interface that will able them to create a basic worksheet.
  • Able to perform calculations, create formulas in a worksheet, insert functions in a worksheet and modify a worksheet by manipulate data, Insert, Manipulate & Delete Cells, Columns and rows
  • Able to use the functions of Search for, Replace Data and Spell Check a Worksheet
  • Understand on how to indicate the functions and identify the elements in the basic functions – AutoSum, Count, Max, Min and Average functions.
  • Understand on how to create basic formula (Addition, Subtraction, Multiplication and Division) and advance formulas using Excel by using the apply range functions
  • Create and modify charts and worksheet using time saving formulas and features to increase participants productivity.
  • The Participants will be able to convert, sort, filter, and manage lists. The participants will be able to work with tables, Insert and modify illustrations in a worksheet

Methodology

The course is delivered via online / physical lectures and practical activities.

For Whom

This course is designed for those who would like to be able to work comfortably with Microsoft Excel. Users who have a ‘basic to good’ understanding and knowledge of Microsoft Excel, and those who are keen to further their working knowledge of Microsoft Excel, would benefit from this course.

No. of Participants

25 persons max

Duration

2 Days

INTERESTED? WANT TO KNOW MORE?

To Request Full Proposal, click here 

Overview

Microsoft Excel is one of the most important computer programs because off the key role it plays in many sectors. It is used to create grids of text, numbers and formulas specifying calculations. That’s extremely valuable for many businesses, which use it to record expenditures and income, plan budgets, chart data and succinctly present fiscal results.

In this session, participants will be able to learn about Microsoft Excel in an easy to navigate way.

Objectives

Upon completion of this program, participants should be able to:

  • Create Subtotal Using the Subtotal Function
  • Analyze data Using Pivot Tables
  • Perform What If Analysis using:
  • Goal Seek/ Solver/ Input Table/ Scenarios
  • Use VLOOKUP function to extract data
  • Nesting INDEX and MATCH Function
  • Combining & Consolidating Data
  • Summarizing & Analyzing with Pivot Table and Pivot Charts
  • Record and Run a Macro

Prerequisites

Basic knowledge of Microsoft Excel is essential with the following pre-requisites:

  • Have attended Microsoft Excel – Foundation & Intermediate Level; OR
  • Able to switch between task applications
  • Able to create simple to complex formulas and functions
  • Able to validate data in a Worksheet
  • Able to apply Filter data using Auto & Advanced Filters
  • Able to clean Duplicate Records

Methodology

The course is delivered via online / physical lectures and practical activities.

For Whom

This course is designed for those who would like to be able to work comfortably with Microsoft Excel. Users who have a ‘basic to good’ understanding and knowledge of Microsoft Excel, and those who are keen to further their working knowledge of Microsoft Excel, would benefit from this course.

No. of Participants

25 persons max

Duration

1 Day

INTERESTED? WANT TO KNOW MORE?

To Request Full Proposal, click here 

Overview

So, what is an Excel Dashboard?

An Excel Dashboard provides insight, analysis, and alerts. They’re fully interactive and dynamic and can help with project management, customer service, retail management, financial forecasting and much more.

  • Usually fits on one page
  • Displays key trends, comparisons, and data graphically or in small tables
  • Provides the reader with conclusions to their objective
  • Is often interactive allowing the user to filter data and switch views themselves
  • Employs best practices that enable the report to be updated quickly and

Objectives

In this Excel Dashboard Course, you will:

  • Learn the simple techniques you can apply in Excel to make dashing dashboards.
  • Learn how to build Excel Dashboard reports from the ground up.
  • Create reports that are quick and easy to update, fully interactive so the user can change the view themselves.
  • Learn many useful Formula and Functions that will take your Excel knowledge to another level.
  • Choose the right charts for your data.

Methodology

The course is delivered via online / physical lectures and practical activities.

Requirements

Those attending should be familiar with writing formulas, working with large datasets, sorting and filtering data, perform Vlookup in Microsoft Excel.

No. of Participants

25 persons max

Duration

2 Days

INTERESTED? WANT TO KNOW MORE?

To Request Full Proposal, click here 

Overview

Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Your data maybe an Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses. Power BI lets you easily connect to your data sources, visualize and discover what’s important, and share that with any one or everyone you want.

Objectives

  • To provide an introduction on the usage of data analytics tools in Power BI for the purpose of discovering a deeper meaning and gain added insights from large data sets (bigdata).
  • To understand how the process of data analysis is performed in Power BI and what are the steps taken.
  • To learn the methods in creating data visualization in Power BI

Methodology

Instructor led, Hands on Training.

For Whom

This program is ideal for Managers, Supervisors, and personnel who wish to gain more knowledge in this field.

No. of Participants

25 persons max

Duration

2 days

INTERESTED? WANT TO KNOW MORE?

To Request Full Proposal, click here 

Overview

In recent years, the phenomenal growth of connected devices and advanced data technologies along with the availability of affordable data storage, transfer and processing capabilities has enabled businesses to gain competitive intelligence on demand. Data has undoubtedly becomebusiness asset beyond imagination.

It is common knowledge that understanding data improves organisational performance. Businesses use metrics from various sources in the current technology-enabled landscape, including websites, social media, digital devicesand other sources. Managers unlock growth strategies by combining raw data with analytics. And teams are empowered with the information to collaborate and operate efficiently.

The course is designed for managers to understand how data driven thinking is applied to design decisions around strategy, process, business intelligence products, business structures and the customer experience. Managers and aspiring leaders who are keen to embrace data driven decision making, understand how data can be applied to actionable operational insights and pitch their data driven projects will find that this course provides the necessary fundamental knowledge.

Objectives

At the end of this course participants will be able to:

  • Develop awareness on opportunities to use data to make informed decision
  • Explain the key concepts of digital data and understand the role of data in driving business outcome
  • Learn to appreciate the importance of data ecosystem and the fundamentals of data analysis methodology from data gathering to modelling and corrective actions
  • Develop the clarity of business problem framing to define the question or goal behind the analysis: What areyou trying to discover and how the discovery can be important
  • Identify opportunities at your workplace where data analytics can be leveraged.
  • Start activating thought provoking questions around data strategy linking to business strategy: Technology, Talents, Organisational & Structure, Process & Governance.

Methodology

Instructor led, Hands on Training.

For Whom

This course is targeted for top level management of the organization who are driving the organizational strategy and looking at aligning the organizational practices towards driving outcomes.

No. of Participants

25 persons max

Duration

1 day

INTERESTED? WANT TO KNOW MORE?

To Request Full Proposal, click here 

Can't find what you're looking for?

It’s OK! Not everyone’s perfect programme can be found on a website. At Q3, we pride ourselves on creating training experiences that meet your needs. If you’re not sure where to begin, get in touch with our experienced learning advisers who will guide you through the process.

×

Hello!

Click one of our representatives below to chat on WhatsApp or send us an email to enquiry@q3solutions.com.my

× How can we help you today?