top of page
Picsart_25-11-01_00-39-09-356.png

SidSharmaji

Office Automation (PGDCA-102)

UNIT - I
Working with MS-Word

  1. MS Word

  2. Introduction to Word Processing Software and its Features

  3. Creating New Document

  4. Saving Documents

  5. Opening and Printing Documents

  6. Home Tab: Setting Fonts, Paragraph Settings, Various Styles (Normal, No Spacing, Heading1, Heading2, Title, Strong), Find & Replace, Format Painter, Copy, Paste, and Paste Special

  7. Insert Tab: Pages, Tables, Pictures, ClipArt, Shapes, Header & Footer, WordArt, Equation and Symbols

  8. Page Layout Tab: Page Setup, Page Background, Paragraph (Indent and Spacing)

  9. Mailing Tab: Create Envelopes and Labels, Mail Merge

  10. Review Tab: Spelling and Grammar Check, New Comment, Protect Document

  11. View Tab: Document Views, Zoom, Window (New Window, Split, Switch Window)

UNIT - II
Introduction to MS-Excel 

  1. MS Excel

  2. Introducing Excel

  3. Use of Excel Sheet

  4. Creating New Sheets

  5. Saving, Opening, and Printing Workbooks

  6. Home Tab: Font, Alignment, Number, Styles and Cells Editing, Conditional Formatting

  7. Insert Tab: Table, Charts (Column Chart, Pie Chart, Bar Chart, Line Chart) and Texts (Header & Footer, WordArt, Signature Line)

  8. Page Layout Tab: Page Setup Options, Scale to Width, Height, Scale

  9. Formulas Tab: AutoSum (SUM, AVERAGE, MIN, MAX), Logical (IF, AND, OR, NOT, TRUE, FALSE), Math & Trig (SIN, COSINE, TANGENT, CEIL, FLOOR, FACT, MOD, LOG), Watch Window

  10. Data Tab: Get External Data from MS Access, Sort and Filter Options, Data Validation, Group and Ungroup

  11. Review Tab: Protect Sheet, Protect Workbook, Share Workbook

  12. View Tab: Page Breaks, Page Layout, Freezing Panes, Split and Hide

UNIT - III
Advanced Excel & Data Analysis

  1. Data Analysis

  2. Financial Modeling

  3. Decision Making

  4. Dashboard Reporting

  5. Project Management and its Templates – Gantt Chart Template, Dashboard Template, Status Report Template, Action Plan Template, Estimate Template etc.

  6. Budgeting and Forecasting

  7. Inventory Management

  8. Advanced Excel Formulas – INDEX MATCH

  9. IF combined with AND/OR

  10. OFFSET combined with SUM or AVERAGE

  11. CHOOSE

  12. XNPV and XIRR

  13. SUMIF and COUNTIF

  14. PMT and IPMT

  15. CONCATENATE

  16. VLOOKUP

  17. HLOOKUP

UNIT - IV
Working with MS-Power-Point

MS PowerPoint

  1. Introducing PowerPoint

  2. Using PowerPoint Presentations

  3. Creating New Slides and Saving

  4. Opening and Printing Presentations

  5. Home Tab: New Slide, Layout, Reset, Delete, Setting Text Direction, Align Text, Convert to SmartArt, Drawing Options

  6. Insert Tab: Table, Picture, ClipArt, Photo Album, SmartArt, Shapes and Chart, Movie and Sound, Hyperlink and Action, Textbox, WordArt, Object

  7. Design Tab: Page Setup Options, Slide Orientation, Applying Various Themes, Selecting Background Style and Formatting It

  8. Animations Tab: Custom Animation for Entrance, Exit and Emphasis, Applying Slide Transition, Setting Transition Speed and Sound, Animation on Rehearse Timing

  9. Slide Show & View Tab: Start Slide Show Options, Setup Options

  10. View Tab: Presentation Views, Colours and Window Option

UNIT - V
Working with MS-Access

MS Access

  1. Front End and Back End of Application

  2. Introduction to DBMS

  3. Features of DBMS

  4. Creating Blank Databases

  5. Saving in ACCDB Format

  6. Defining Data Types in MS Access

  7. Home Tab: Datasheet View, Design View, Pivot Chart View, Pivot Table View, Sort and Filter Options

  8. Create Tab: Creating Tables, Creating Reports, Query Wizard

  9. External Data Tab: Import Data from Access and Excel Sheet, Export Data to Excel and MS Word

  10. Datasheet Tab: Relationships, Fields and Columns Options, Data Type and Formatting Options

bottom of page