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

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