• learn@digital-academy.com.pk
  • 021-34816113
Mountains

Microsoft Office

Microsoft Office


Price :call for Fees Rs

Microsoft Office is the industry standard for office automation. From documentation, reporting, spreadsheet calculations and multimedia presentations to emailing and database management, Microsoft Office is the ultimate choice of the businesses. As technology continues to expand in businesses across the world, the demand of the highly skilled and qualified Microsoft Office professionals has greatly evolved. Whether you want to stand out in the job market or to improve and upgrade your skills in the new version of Microsoft Office, this program will prepare you to take on these challenges.

Certified Microsoft Office Professional program specifically targets workplace demand for latest MS Office application skills. On the successful completion of the program, participants are qualified to use the full features of the latest version of Office system, making them more valuable to companies who want to reinforce their technology investment with accelerated productivity and improved organizational performance. The Certified Microsoft Office Professional Program will cover all the demanding tools and features of Microsoft Office suite right from basics to advanced level.

Certified Microsoft Office Professional Program will help you:

  • Set yourself apart as a desktop computing expert
  • Demonstrate computing efficiency in the workplace
  • Differentiate yourself from others
  • Build credibility through proof of skills
  • Possess a professional credential
  • Complete all in one MS Office Course.
  • Cater to the needs of everyone, from beginners to professionals.
  • Designed considering the practical application of these applications.
  • The knowledge gained during the course will help you enhance your job prospects.
  • 100% Practical Course designed as per the need of day-to-day office worker

 

MS Office Course

MICROSOFT WORD

  • Microsoft Office Word 2010 allows you to create and edit personal and business documents, such as letters, reports, invoices, emails and books. By default, documents saved in Word 2010 are saved with the .docx extension. Microsoft Word can be used for the following purposes −
  • To create business documents having various graphics including pictures, charts, and diagrams.
  • To store and reuse readymade content and formatted elements such as cover pages and sidebars.
  • To create letters and letterheads for personal and business purpose.
  • To design different documents such as resumes or invitation cards etc.
  • To create a range of correspondence from a simple office memo to legal copies and reference documents.

MS WORD BASICS

  • Word 2010 ─ Getting Started
  • Word 2010 ─ Explore Window
  • Word 2010 ─ Backstage View
  • Word 2010 ─ Entering Text
  • Word 2010 ─ Move .Around
  • Word 2010 ─ Save Document
  • Word 2010 ─ Opening a Document
  • Word 2010 ─ Closing a Document
  • Word 2010 ─ Context Help

EDITING DOCUMENTS

  • Word 2010 ─ Insert
  • Word 2010 ─ Select Text
  • Word 2010 ─ Delete Text
  • Word 2010 ─ Move
  • Word 2010 ─ Copy & Paste
  • Word 2010 ─ Find & Replace
  • Word 2010 ─ Spell
  • Word 2010 ─ Zoom In-Out.
  • Word 2010 ─ Special Symbols
  • Word 2010 ─ Undo

 

FORMATTING TEXT

  • Word 2010 ─ Setting Text
  • Word 2010 ─ Text Decoration
  • Word 2010 ─ Change Text
  • Word 2010 ─ Text
  • Word 2010 ─ Indent
  • Word 2010 ─ Create Bullets
  • Word 2010 ─ Set Line Spacing
  • Word 2010 ─ Borders and Shades
  • Word 2010 ─ Set Tabs
  • Word 2010 ─ Apply Formatting

 

FORMATTING PAGES

  • Word 2010 ─ Adjust Page
  • Word 2010 ─ Header and Footer
  • Word 2010 v Word 2010 ─ Add Page Numbers
  • Word 2010 ─ Insert Page Breaks
  • Word 2010 ─ Insert Blank Page
  • Word 2010 ─ Cover Pages
  • Word 2010 ─ Page Orientation

WORKING WITH TABLES

  • Word 2010 ─ Create a Table
  • Word 2010 ─ Rows & Columns
  • Word 2010 ─ Move a Table
  • Word 2010 ─ Resize a Table
  • Word 2010 ─ Merging
  • Word 2010 ─ Split a Table
  • Word 2010 ─ Split Cells
  • Word 2010 ─ Add Formula
  • Word 2010 ─ Borders & Shades

ADVANCED OPERATIONS

  • Word 2010 ─ Quick Styles
  • Word 2010 Change Styles
  • Word 2010 ─ Use Templates
  • Word 2010 ─ Use Graphics
  • Word 2010 ─ Auto Correction
  • Word 2010 ─ Auto Formatting
  • Word 2010 ─ Table of Contents
  • Word 2010 ─ Preview Documents
  • Word 2010 ─ Printing Documents
  • Word 2010 ─ Email Documents
  • Word 2010 ─ Translate Document
  • Word 2010 ─ Compare Documents
  • Word 2010 ─ Document Security
  • Word 2010 ─ Set Watermark

 

MICROSOFT EXCEL

  • Microsoft Excel is a commercial spreadsheet application, written and distributed by Microsoft for Microsoft Windows and Mac OS X. At the time of writing this tutorial the Microsoft excel version was 2010 for Microsoft Windows and 2011 for Mac OS X.
  • Microsoft Excel is a spreadsheet tool capable of performing calculations, analyzing data and integrating information from different programs.
  • By default, documents saved in Excel 2010 are saved with the .xlsx extension whereas the file extension of the prior Excel versions are .xls.

Introduction to Microsoft Excel

 

  • How to Add, Subtract, Multiply, Divide in Excel
  • Excel Data Validation, Filters, Grouping
  • Introduction to formulas and functions in Excel
  • Logical functions (operators) and conditions in Excel
  • Visualizing data using charts in Excel
  • Case Study: Managing personal finance using Microsoft Excel

 

 

Advance Stuff

  • Connecting Microsoft Excel to External Data Sources
  • Pivot Tables in Excel: Beginner’s Guide
  • Creating Advanced Charts in Excel
  • Excel in the cloud: Office 365
  • CSV vs Excel (.xls) - What's the Difference?
  • Excel VLOOKUP for Beginners: Learn with Examples
  • Excel ISBLANK Function: Learn with Example
  • SUMIF function in Excel: Learn with EXAMPLE

 

Macros & VBA in Excel

  • Introduction to Macros in Excel
  • Creating your First Visual Basic for Applications (VBA) in Excel
  • VBA Data Types, Variables & Constant
  • VBA Arrays
  • VBA Excel Form Control & Activex Control
  • VBA Arithmetic Operators
  • VBA String Operators
  • VBA Comparison Operators
  • VBA Logical Operators
  • Excel VBA Call a Subroutine
  • Excel VBA Function: Return, Call, Examples
  • VBA Range Objects

 

 

MICROSOFT POWERPOINT

Microsoft PowerPoint is a commercial presentation application written and distributed by Microsoft for Microsoft Windows and Mac OS X. The current versions at the time of writing this tutorial are 2010 for Microsoft Windows and 2011 for Mac OS X. Microsoft PowerPoint is a presentation tool that supports text, shapes, graphics, pictures and multimedia along with integration with other Microsoft Office products like Excel. By default, documents saved in PowerPoint 2010 are saved with the .pptx extension whereas, the file extension of the prior PowerPoint versions is .ppt.

Presentation Basics

Text Basics

Inserting Picture

Working with Tables

Working with Charts

Slide Effects

 

MICROSOFT OUTLOOK

Microsoft Outlook is a personal information manager from Microsoft, available as a part of the Microsoft Office suite. Although often used mainly as an email application, it also includes a calendar, task manager, contact manager, note taking, journal, and web browsing.It can be used as a stand-alone application, or can work with Microsoft Exchange Server and Microsoft SharePoint Server for multiple users in an organization, such as shared mailboxes and calendars, Exchange public folders, SharePoint lists, and meeting schedules. Microsoft has also released mobile applications for most mobile platforms, including iOS and Android. Developers can also create their own custom software that works with Outlook and Office components using Microsoft Visual Studio. In addition, Windows Phone devices can synchronize almost all Outlook data to Outlook Mobile.

MS Outlook Basic

  • MS Outlook Online Training - Home
  • Ms Outlook - Install
  • Ms Outlook - User Interface
  • Ms Outlook - Adding and Removing Account
  • Ms Outlook - Configure Email Manually
  • Ms Outlook - Create Outlook Shortcut Key

Ms Outlook Navigation

 Ms Outlook - Managing Email Folders

Ms Outlook Navigation

  • Ms outlook - Add and Remove Columns
  • Ms outlook - Sorting
  • Ms outlook - Search
  • Ms outlook - Advanced Search
  • Ms outlook - Filter
  • Ms outlook - Group By
  • Ms outlook - Conditional Formatting
  • Ms outlook - Layout
  • Ms outlook - Color Categories To Email
  • Ms Outlook - View Settings
  • Ms outlook - Change View
  • Ms outlook - New Email Notifications and Settings
  • Ms outlook - Change Color Categories to Contact
  • Ms outlook - Rules
  • Ms outlook - Quick Steps

Ms outlook Email

  • Ms outlook - Reading An Email
  • Ms outlook - Creating and Sending Email
  • Ms outlook - Text Body Formatting
  • Ms outlook - Signatures
  • Ms outlook - Creating Stationary
  • Ms outlook - Voting Options
  • Ms outlook - Attachment
  • Ms outlook - Email Formats
  • Ms outlook - Spell Check
  • Ms outlook - Delay Delivery

 

 

Ms outlook -Contact

  • Ms outlook - Create Contact
  • Ms outlook - Create Contact Group
  • Ms outlook - Edit Contact
  • Ms outlook - Contact Views
  • Ms outlook - Create Contacts From Email
  • Ms outlook - Export Contacts To CSV
  • Ms outlook - Import Contacts From CSV
  • Ms outlook - Search Contacts
  • Ms outlook - Create Contact Group and Folder
  • Ms outlook - Forward Contacts
  • Ms outlook - Import Gmail Contacts
  • Ms outlook - Export Contacts To Gmail

Ms outlook Calendar

  • Ms outlook - Introduction To Calendar
  • Ms outlook - Create New Appointment
  • Ms outlook - Recurring Appointments
  • Ms outlook - Printing A Calendar

Ms outlook Meeting

  • Ms outlook - Create Meeting Request
  • Ms outlook - Reply To Meeting Request

Ms outlook Task

  • Ms outlook - Create Task
  • Ms outlook - Recurrence Task
  • Ms outlook Notes
  • Ms outlook – Notes

 

MICROSOFT ACCESS

Microsoft Access is a Database Management System (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software development tools. It is a part of the Microsoft Office suite of applications, included in the professional and higher editions. This is an introductory tutorial that covers the basics of MS Access.

 

 

Registration

Ready to Begin?

Find subjects you're passionate about by browsing our online course categories. Start
learning with top courses Built With Industry Experts.

Start Learning