Microsoft® Excel for Intermediate/Advance User

by Knowledge Hub Claim Listing

Knowing how to write a letter in Word or perform a calculation in Excel does not mean that you have mastered all of the functions of these tools. However, it is unlikely that you will need to know how to use all of these!

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Knowledge Hub Logo

img Duration

Please Enquire

Course Details

Knowing how to write a letter in Word or perform a calculation in Excel does not mean that you have mastered all of the functions of these tools. However, it is unlikely that you will need to know how to use all of these!

Therefore, you should focus on the essentials and on functions that meet your present and future needs.

The ability to operate efficiently will move the business forward and make you an invaluable part of the team, a better co-worker, and a leader in the workplace.

From project management to office coordination, having a better grip on Microsoft Word, Excel, and PowerPoint will have a positive impact on your organization. This includes lesser-known formulas, shortcuts, and capabilities that can help you save your employer time and money.

 

Target Audience:

This Course Is Designed For Clerks, Officers, Executives, Supervisors, Administrators, Managers Of All levels, And Personnel Who Already Know And Understand And Want To Further Enhance Their Knowledge And Practical Uses Of Microsoft Office

 

Prerequisites:

Know-Well About Microsoft Word, Excel & PowerPoint

 

Main Objective:

  • To Integrate All Microsoft Application To Simplify It With efficiency And accuracy

  • Standardize Working Process

 

Module 1:

Excel For Data Management with Pivot

Objectives:

  • Participants will get the idea and guidance on how to manage data efficiently and more accuratelyly.

  • Participants will also understand how to work with large amounts of amounts of data and manage to give up-to-date data to management

 

Lesson 1 : Streamlining Workflow

  • Conditional Formatting

  • Data Validation

 

Lesson 2 : Analyzing Data Using Pivot

  • What is a pivot table?

  • Creating a PivotTable

  • Using the PivotTable Tools Tabs

  • Adding and Removing Data

  • Changing the Field List Layout

  • Pivoting Data

  • Slicer (2010/2013/2016/2019)

  • Pivot Charts

 

Lesson 3 : Excel Dashboard

  • What is Dashboard in Excel???

  • Purpose

 

Lesson 4 : Linking and Embedding

  • Linking Workbooks

  • Consolidating Workbooks

  • Insert Hyperlink

 

Module 2:

Professional Documentation Using American Psychological Association (APA) Format (Words)

 

Objectives:

  • Participants will understand how to produce a professional document such as a report or proposal using standard APA.

  • Participants also know how to create different page numbering formatsss in one document.

  • Participants also gain the knowledge to create tables of contents as fast as a second.

  • How to insert Bibliography using APA format

 

Lesson 1: APA Format: Cover Page

  • Standard professional Documents

 

Lesson 2: Table of Content

  • Insert Table of Contents

  • Insert List of Figures

 

Lesson 3: Inserting Pictures

  • Inserting Pictures From Drive

  • Inserting Pictures From Internet

  • Inserting Screen Clipping/Snapshot

  • How to edit Pictures

  • How to label the Pictures

 

Lesson 4: Inserting Graphs

  • How to create Graphs

  • Graphs Layout

  • How to label the Graphs

 

Lesson 5:Sections

  • Objectives to create section

  • How to create page breaks to create section

  • Page Numbering with different format

 

Module 3:

Creating Creative Presentation Using Microsoft PowerPoint

 

Objectives:

  • Participants will know how to prepare a good presentation by maximizing all objects by replacing texts.

  • Animation and transitions will have a greater impact on the current presentation.

  • Customize Master Slide to fit your presentation

 

Lesson 1: Adding Diagram to Presentation

  • How to Create Diagram such as Shapes, Charts and Tables

  • Modify Diagram

 

Lesson 2: Working with Images

  • How to Insert Pictures, Clip Art and Pictures From Web

  • Screen Clipping

  • How to remove background of Pictures

  • Cropping Images

 

Lesson 3: Inserting Multimedia Objects

  • Working with Background Music

  • How to Insert Video into a Slide Presentation

  • How to trim the music and video to make presentation more presentable

 

Lesson 4: Smart Art

  • Choose the best Smart Art to present your idea

 

Lesson 5: Working with Animation

  • Types of Animation (Enter, Emphasize, Exit and Draw your animation)

 

Lesson 6: Inserting Special Effects

  • Effects for Videos

  • Effects for Audio

 

Lesson 7: Slide Transition

  • Insert animation transition for all slide

  • Insert animation transition for selected slide

  • Petaling Jaya Branch

    100-7.047, Block J, JayaOne No. 72A, Petaling Jaya

Check out more MS Excel courses in Malaysia

New Horizons Malaysia Logo

Microsoft Excel 2019

The Microsoft Excel certification course and labs thoroughly cover the MO-200 exam objectives and provide the ability to create and edit a workbook with multiple sheets and use a graphic element to represent data visually.

by New Horizons Malaysia [Claim Listing ]
Pentawise Sdn Bhd Logo

Manipulating Data Effectively with Microsoft Excel

This is an ideal course for users who desires to manage data, sort and filter, analyze data, and learn to automate some common Excel tasks.

by Pentawise Sdn Bhd
SIRIM Academy Logo

MS PowerPoint (Beginner)

MS PowerPoint course is offered by SIRIM Academy. SIRIM Academy - which focuses on technology training, personnel certification, talent, and vendor development, ESG and people skills.

by SIRIM Academy [Claim Listing ]
Akademi Suria Logo

Microsoft PowerPoint (Basic To Advance)

Microsoft PowerPoint course is offered by Akademi Suria. At the heart of Akademi Suria is our dedicated team of highly experienced trainers and staff members. They bring a wealth of knowledge and expertise to our training programs.

by Akademi Suria [Claim Listing ]
G-Tec Computer Education Sdn. Bhd Logo

MS Excel

A successful database is efficient, quick, accurate, and easy to use. This course covers how to create such a database with MS Excel.

by G-Tec Computer Education Sdn. Bhd [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy