Certificate in Office Expert

Last Updated : April 13, 2023

Expert

43 Lessons

2 Enrolled

About Course

COA or Certificate in Office Expert is one popular course among students completed their Secondary or Higher Secondary education. Get in depth knowledge about computer operation which will give extra benefit in professional life.

Course Content

Fundamentals of Computer

Know the evolution of computer

04:14
Understanding Generations of computer

08:30
Understand Computer & Components

11:11
Understand Computer Types

08:01
Introduction to Windows OS (7/8/10/11)

20:06

Typing Techniques

Microsoft Word

Introduction to Microsoft Word Application

12:33
MS Word Home Tab- Clipboard & Font group

20:32
MS Word Home Tab- Paragraph and Styles

16:27
MS Word Home Tab- Find Replace & Selection Panel

06:59
MS Word Cover page

06:27
MS Word Insert Tab- Table

18:28
MS Word Insert Tab- Working with Pictures

11:58
MS Word Insert Tab- Shape SmartArt & Chart

19:17
MS Word Insert Tab- Header & Footer

08:59
MS Word Insert Tab- Text Box, Drop Cap, WordArt

12:06
MS Word Design Tab- Water Mark, Colour, Border, Theme

10:47
Understanding Page Setup

12:58
MS Word- Printing Setup

04:46

Microsoft Excel

Excel introduction

04:43
Understanding Excel Interface

15:46
Understanding Excel Tabs and ribbons

06:11
Excel Backstage View

16:55
Excel organize workbook, sheet, row & column

23:19
Excel Data sorting & Filtering

09:37
Excel Data Conditional Formatting

10:46
Excel Security Implementation

14:23
Excel Formula & Function anatomy

13:20
Excel Basic Formula- Add, Subtract, Multiple, Divide And Percentage

09:05
Excel Function- SUM, SUMIF, SUMIFS, SUMPRODUCT

22:14
Excel Function- Count, Counta, Countblank, Countif, Countifs

13:12
Excel Function- Average, Averageif, Averageifs

14:31
Understanding IF Function

14:18
MS Excel- Create Academic Marksheet

13:23
Data Visualization usingCharts

08:29

Certificate in Office Expert

About Course

Course Content

Fundamentals of Computer

Know the evolution of computer

Understanding Generations of computer

Understand Computer & Components

Understand Computer Types

Introduction to Windows OS (7/8/10/11)

Typing Techniques

Understanding Keyboard Layout & Speed Typing

Microsoft Word

Introduction to Microsoft Word Application

MS Word Home Tab- Clipboard & Font group

MS Word Home Tab- Paragraph and Styles

MS Word Home Tab- Find Replace & Selection Panel

MS Word Cover page

MS Word Insert Tab- Table

MS Word Insert Tab- Working with Pictures

MS Word Insert Tab- Shape SmartArt & Chart

MS Word Insert Tab- Header & Footer

MS Word Insert Tab- Text Box, Drop Cap, WordArt

MS Word Design Tab- Water Mark, Colour, Border, Theme

Understanding Page Setup

MS Word- Printing Setup

Microsoft Excel

Excel introduction

Understanding Excel Interface

Understanding Excel Tabs and ribbons

Excel Backstage View

Excel organize workbook, sheet, row & column

Excel Data sorting & Filtering

Excel Data Conditional Formatting

Excel Security Implementation

Excel Formula & Function anatomy

Excel Basic Formula- Add, Subtract, Multiple, Divide And Percentage

Excel Function- SUM, SUMIF, SUMIFS, SUMPRODUCT

Excel Function- Count, Counta, Countblank, Countif, Countifs

Excel Function- Average, Averageif, Averageifs

Understanding IF Function

MS Excel- Create Academic Marksheet

Data Visualization usingCharts

Microsoft PowerPoint

Introduction to PowerPoint

Create a New Presentation

Saving Options in PowerPoint

Manage PowerPoint Slide

Apply and manage theme

Add Object in PowerPoint

Apply Transition in Presentation

Internet & Email Technology

Basics of Internet Technology

Install App | Get Certified