Creating Amazing Business Report Using MS Office Application Tools

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 Pivot

 

Lesson 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 :

 

Professional 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 Using

Microsoft 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

 

Open chat
Hello