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

International College of Management and Sports - ICMS Logo

Powerpoint (Basic to Advance)

The Powerpoint (Basic to Advance) Program is offered by the International College of Management and Sports (ICMS).

by International College of Management and Sports - ICMS [Claim Listing ]
Sarawak Skills Logo

Microsoft Excel (Basic & Intermediate)

Microsoft Excel course is offered by Sarawak Skills. Sarawak Skills is the preferred provider of Technical and Vocational Education and Training (TVET) for industrial workers and school leavers. 

by Sarawak Skills [Claim Listing ]
New Horizons Logo

Microsoft Word Foundation

Microsoft Word-Foundation Course is offered by New Horizons. New Horizons is a Microsoft Gold Certified Partner for learning Solutions, ensuring clients receive high quality training from a Microsoft accredited and endorsed provider.

by New Horizons [Claim Listing ]
Success Edge Logo

Word Mastery Workshop

Tailored for all proficiency levels, this workshop delivers comprehensive training on maximizing Microsoft Word’s utility. Participants will embark on a journey spanning essential features, advanced techniques, and collaborative practices to elevate document creation, formatting, and teamwork.

by Success Edge [Claim Listing ]
CitiPro Institute Logo

MS Office 365

MS Office 365 course is offered by CitiPro Institute for all skill levels. Our program is designed to fit your busy schedule while providing high-quality education and boosting your professional skills.

by CitiPro Institute [Claim Listing ]

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