Diploma in Office automation – MS Office Course

Introduction to MS Office
Introduction to M S Word
Setting up Page Layout
Shortcuts in Word
Document Preparation
Inserting Images and Shapes to a Document
Save and Printing Settings of a Document
Project 1
Project 2
Project 3
Main Project

Create worksheets and worksheets Prepare Workbooks for collaboration
Navigate In Worksheets and Workbooks
Format Worksheets and workbooks
Customize options and views for worksheets and workbooks
Format cells and ranges
Insert data in cells and ranges
Fill cells based on existing data
Apply advanced conditional formatting and filtering
Summarize and organize data
Format and validate data
Create and manage tables
Manage table styles and options
Filter and sort a table
Summarize data by using functions
Perform data analysis
Perform conditional operations by using functions
Perform logical operations in formulas
What If Analysis
Track Changes
Look up data by using functions
Troubleshoot formulas
Create and modify advanced charts
Create and modify PivotTables
Create and modify PivotChart
Create and modify simple macros
Project 1
Project 2
Project 3
Main Project

Creating Slides
Slide Layouts
Designing a Slide
Setting and Apply of Transition
Application of Slide effects Slide Effects
Creation Animations on Slides
Slideshow Operations
PPT Settings
Project 1
Project 2
Project 3
Main Project

Leave your thoughts Click here to cancel the reply