MS Office - Advanced

Course details

OVERVIEW: Microsoft Office is a comprehensive array of programs used by home users and businesses alike to facilitate information management, organization, and presentation. MS Office-Advanced course aims to equip professionals with in-depth knowledge and expertise on Office 365 business applications. It also elaborates on topics such as advanced office management, data processing, analysis & presentation skills.

CAREER OPPORTUNITIES:

Market Trends: Office 365 (Microsoft 365) and G Suite (Workspace) have maintained dominance in the global market for office productivity. With a market share of and current websites, Microsoft 365 is accessed by millions of companies worldwide. In the UAE, Office 365 market share is , almost on par with the global market share, reflecting the growing need for professionals proficient in Microsoft ;

Salary Trends: MS Office experts command above-average salaries because of the high demand for their skills. With the relevant MS Office skills, professionals can increase their salaries by four-fold over the course of their careers. Microsoft Office Specialists earn an annual base salary of AED 103,846 per annum in the United Arab Emirates (UAE).

Demand and Opportunities: Microsoft Office skills are highly sought-after, with about 12% to 20% of incredibly profitable jobs in lucrative industries calling for them. Microsoft Office ranks 4th in global job trends as the most desired skill going forward. As the world undergoes a digital transformation, professionals with Microsoft Office skills continue to be in high ;

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

Working with Text

• Using an outline
• Adding text
• Using bullets and numbering
• Formatting text & paragraphs
• Using text boxes
• Setting tabs

Adding multimedia elements

• Using multimedia elements
• Working with pictures
• Applying styles & effects
• Modifying hyperlinks
• Working with SmartArt

Enhancing presentations

• Adding audio & video media
• Using animation
• Managing multiple transitions
• Changing animation order
• Using slide transitions section

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

MS Outlook

• Working with graphics
• Introduction
• Contacts
• Group
• Messaging with ms outlook
• Calendar
• Meetings and appointments
• Tasks and notes
• Working with folders
• Rules and alerts

KEY TAKEAWAYS:

Successful completion of MS Office-Advanced course will enable a candidate to :

• Discover Microsoft Office's features and functions
• Become proficient in using MS Office in a variety of professional, educational, and personal contexts
• Create effective documents, spreadsheets, and presentations
• Organize work and maximize productivity with Word, Excel, PowerPoint, and Outlook
• Demonstrate advanced proficiency with MS Office

ACCREDITATION:

Our MS Office-Advanced course is accredited by ISO 9001: 2015 and the Knowledge and Human Development Authority (KHDA).

ALUMNI: Our academy graduates are successfully placed in some of the top-notch companies in Dubai like Jumeirah, Aramex, Airarabia, Damac, Emaar, etc. They are entrepreneurs, career changers, and lifelong learners.

WHY LEARNER’S POINT:

As one of the leading providers of MS Office-Advanced courses, we have considerable experience in teaching relevant skills and ;

We offer the following key benefits in our MS Office-Advanced course:

• Our MS Office-Advanced course is designed based on real-world scenarios, formulating and evaluating practical requirements
• Our courses strive to provide a reality check and insight into the requirements of a challenging role and how to fulfill it
• We also provide live interactive sessions and hands-on experience through assignments associated with the actual work environment
• To enhance the learning experience of our students we provide organized group sessions and integrated training modules
• Our discrete approach to career guidance enables our students to get successfully placed in renowned organizations

Updated on 04 July, 2022