MS Office - Advanced

This course is designed for those students who wish to learn numerous advance MS Word. Excel, PowerPoint and Outlook

Talk to an expert Enquire Now
img

Course Objectives

The state of UAE is the home to more than around 1,06,000 various companies and you can be a part of them. Presently, computer knowledge is crucial specially in finding better jobs. You should be a computer literate, particularly in office application.

Course Module

Section 1: Formulas and Functions 
Entering Formulas
Excel Arithmetic Operators
Using AutoFill Options
Using Commonly Used Functions

Section 2: Organizing Worksheet and Table Data
Create and Modify Tables
Sorting and Filtering Data in a Table
Getting Summary Information in a Table

Section 3: Working with Charts
Summarizing Data Using Charts
Customizing Chart Data
Format Chart Legend and Titles
Creating a Pie Chart

Section 4: Working with Graphics
Adding Pictures into a Worksheet
Customizing Pictures and Objects
Adding Drawing Objects
Adding SmartArt into a Worksheet

Section 5: Managing Large Workbook
Managing Large Workbooks
Printing Worksheets
Setting Page Setup Options

Section 6: Customizing & Enhancing Workbooks
Customizing Excel to Your Work
Creating Hyperlinks
Customizing Quick Access Toolbar

Lesson 1: Formatting Text & Paragraphs 
Setting Tab Stops
Organizing List Information

Lesson 2: Formatting Documents to Print
Using Headers & Footers
Proofing
Preparing for Print

Lesson 3: Using Tables in Word 16
Inserting Tables
Modifying Tables
Sorting Lists

Lesson 4: Working with Illustrations 
Inserting Pictures
Manipulating Images
Wrapping Text around a Picture

Lesson 5: Creating Mass Mailing Documents
How do I merge?
Setting Rules for Merging
Creating Simple Mailing Documents

Lesson 6: Referencing Information
Creating an Index
Creating a Table of Contents

Advanced MS Office Training Course Summary

This course is designed for those students who wish to learn numerous advance MS Word. Excel, PowerPoint and Outlook features. By the end of this training, the students will be able to use advance features of Word, Excel, PowerPoint and Outlook in an office environment with maximum efficiency as well as the most important office applications which are extremely useful in secretarial routine and office administrative work. 

It is one of the vital skills that the company seeks for in your resume. Build up your career with computer skills. LearnersPoint is here to assist you in building your career. This course is the initial step in IT education.

Microsoft Office has come with renovated and new features for all the applications included in this package. Among Word, PowerPoint and Excel this pack integrates some other utilities such as Outlook. All the programs come with a renovated ribbon interface and a backstage view which are particularly of this version.

Ms OFFICE

 


Course Objectives

The state of UAE is the home to more than around 1,06,000 various companies and you can be a part of them. Presently, computer knowledge is crucial specially in finding better jobs. You should be a computer literate, particularly in office application.


 

Course Outline

Excel 2016

Section 1: Formulas and Functions 
Entering Formulas
Excel Arithmetic Operators
Using AutoFill Options
Using Commonly Used Functions

Section 2: Organizing Worksheet and Table Data
Create and Modify Tables
Sorting and Filtering Data in a Table
Getting Summary Information in a Table

Section 3: Working with Charts
Summarizing Data Using Charts
Customizing Chart Data
Format Chart Legend and Titles
Creating a Pie Chart

Section 4: Working with Graphics
Adding Pictures into a Worksheet
Customizing Pictures and Objects
Adding Drawing Objects
Adding SmartArt into a Worksheet

Section 5: Managing Large Workbook
Managing Large Workbooks
Printing Worksheets
Setting Page Setup Options

Section 6: Customizing & Enhancing Workbooks
Customizing Excel to Your Work
Creating Hyperlinks
Customizing Quick Access Toolbar

Word 2016

Lesson 1: Formatting Text & Paragraphs 
Setting Tab Stops
Organizing List Information

Lesson 2: Formatting Documents to Print
Using Headers & Footers
Proofing
Preparing for Print

Lesson 3: Using Tables in Word 16
Inserting Tables
Modifying Tables
Sorting Lists

Lesson 4: Working with Illustrations 
Inserting Pictures
Manipulating Images
Wrapping Text around a Picture

Lesson 5: Creating Mass Mailing Documents
How do I merge?
Setting Rules for Merging
Creating Simple Mailing Documents

Lesson 6: Referencing Information
Creating an Index
Creating a Table of Contents

  PowerPoint 2016

Section 1: Working with Text 
Using an Outline
Adding Text
Using Bullets and Numbering
Formatting Text & Paragraphs
Using Text Boxes
Setting Tabs

Section 2: Adding Multimedia Elements
Using Multimedia Elements
Working With Pictures
Applying Styles & Effects
Modifying Hyperlinks
Working With SmartArt

Section 3: Enhancing Presentations
Adding Audio & Video Media
Using Animation
Managing Multiple Transitions
Changing Animation Order
Using Slide Transitions

Section 4:  Preparing The Slide Show
Reviewing the Presentation
Customizing the Presentation
Proofing the Presentation
Setting up a Slide Show
Using Presentation Tools
Using Presenter View
Rehearsing a Presentation
Presenting the Slide Show

Learning Approch

  • Designed with a focus on real world relevance
  • Real-world case studies
  • Hands-on Assignments
  • Individualized Instructor
  • Career Guidance
Program
Dates

Certification (LP Certificate)

Earn a Course Completion Certificate, an official Learners Point credential that confirms that you have successfully completed a course with us.

Certification (KHDA)

Earn a KHDA attested Course Certificate. The Knowledge and Human Development Authority (KHDA) is the educational quality assurance and regulatory authority of the Government of Dubai, United Arab Emirates.

Expert Instructors & Teaching Methods

test
Our Trainer

We, at Learners Point, take immense pride in our teaching methods and instructors. Our instructors are some of the best experts from their fields and employ a practical approach to learning. Many of them are globally recognised and have a diverse set of experience in their field of expertise. You are always sure to have the best in the industry as your teachers who are ready to guide you at every step and make the experience informative yet enjoyable. Apart from the focus on learning your chosen course, our instructors also encourage students to develop communication skills and interpersonal skills necessary to excel in the practical world. 

 

test

Our Trainer

Learners Experience

Frequently Asked Questions

Our trainings are mostly instructor led and classroom based. However, we also offer high quality live and interactive online sessions.

Our highly skilled faculties from around the globe are experts in their fields and come with decades of diverse industry experience. Our trainers are internationally recognized and locally preferred with rich research driven experience which will ensure highly customizable, engaging and top in the class learning experience.

Choosing LearnersPoint is true value for money as our trainings are right blend of theory and practice and specially developed keeping tomorrow's business needs in mind. All the training sessions are closely monitored through specially designed progress tracker to ensure reinforced and unparalleled learning experience.

Once you have registered for a course and wish to not to proceed with the training for any reason, you are entitled for a refund of the fees provided we are notified in writing within 2 days from the date of initial registration before the training commencement. The refunds are processed within 4 weeks from the day of withdrawal.