Date : 23/03/2020 - 24/03/2020
Time : 9:00 am - 5:00 pm
Location : The HUB @ Jaya One, PJ-old


Contact Person : Esther Yong
Email : inquiry@knowledgehub-asia.com
Mobile : +012-2662728
Office Tel : +603-7622 0578
Normal Rate : MYR 0.00
Promotion Rate : Contact us for discounted rate.


INTRODUCTION :

When presenting ideas that include references to data, it can be helpful to make the point using a graph or table. These visual methods can make the point much stronger than simply describing the data. While they can be powerful methods, they also have the potential to ruin a presentation if they convey the wrong message or they confuse the audience. Appropriate use of graphs and tables is one way to enhance the message you are delivering

Accounting data is often presented in the form of tables of numbers, sometimes simply as a print out from a spreadsheet or reports from an accounting software package. While this style of presentation provides detailed figures, it may not always be the most effective way to present and communicate information. It may be that some key information should be highlighted, perhaps relationships between certain figures should be emphasised, or trends identified. Appropriate presentation of data in the form of graphs or charts can be a useful analysis tool and if the data is then effectively interpreted this can facilitate the decision-making process.

OBJECTIVE  :

  • Get the idea and guide how to manage data efficiently and more accurate
  • Understand how to work with large data and manage to give up-to-date data to management
  • Understand how to produce a professional documentation such as Report and Proposal with effective using standard APA.
  • Knowledge to create Table of Content as fast as a second.
  • Know how to prepare a good presentation with maximizing all objects by replacing texts.
Module 1 :Excel For Data Management with PivotLesson 1 :

Streamlining Workflow

Conditional Formatting

Data Validation 

Lesson 2 :

Analysing Data Using Pivot

What is a PivotTable?

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 : rofessional Documentation Using American Psychological Association (APA) Format Lesson 1:

APA Format – Cover Page

Standard Profesional 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

Lesson 7:

Bibliography / References

How to insert Bibliography using APA format style

Module 3 :Creating Creative Presentation UsingMicrosoft PowerPoint

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 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 (Entry, 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

Lesson 8:

Slide Master

How to create Master Slide

Customize Master Slide to fit your presentation

Module 4 : Interaction :Lesson 1: Hyperlink between Application

Lesson 2: Mail Merge

–          Letter

–          Report

–          Certificate

–          Envelope

Lesson 3: Presentation with Efficient and Accurate



For registration please Contact :

Email : inquiry@knowledgehub-asia.com
Contact Person : Esther Yong
Mobile : +012-2662728
Office Tel : +603-7622 0578
Open chat
Hello