81 82 83 8888 [email protected]

Advance Computer Course

Syllabus

Module 1 : Working with Objects

  • Shapes, Clipart and Picture, Word Art, Smart Art
  • Columns and Orderings – To Add Columns to a Document
  • Change the Order of Objects
  • Page Number, Date & Time
  • Inserting Text boxes
  • Inserting Word art
  • Inserting symbols
  • Inserting Chart

Module 2 : Merging Documents

  • Typing new address list
  • Importing address list from Excel file
  • Write and insert field
  • Preview Result
  • Finish & Merge options
  • Merging with outlook contact
  • Merging to envelopes
  • Merging to label
  • Setting rules for merges

Module 3 : Sharing and Maintaining Document

  • Changing Word Options
  • Changing the Proofing Tools
  • Managing Templates
  • Restricting Document Access
  • Using Protected View
  • Working with Templates
  • Managing Templates
  • Understanding building blocks

Module 4 : Perform Calculations with Functions

  • Creating Simple Formulas
  • Setting up your own formula
  • Date and Time Functions,
  • Financial FunctionsLogical Functions,
  • Lookup and Reference Functions
  • Mathematical Functions
  • Statistical Functions,
  • Text FunctionsWorking with Templates

Module 5 : Create Effective Charts to Present Data Visually

  • Inserting Column, Pie chart etc
  • Create an effective chart with Chart Tools- Design, Format, and Layout options
  • Adding chart title
  • Changing layouts
  • Chart styles
  • Editing chart data range
  • Editing data series
  • Changing chart
  • Saving chart as template
  • Summarizing data using spark line

Module 6 : Protecting and Sharing the workbook

  • Protecting a workbook with a password
  • Allow user to edit ranges
  • Track changes
  • Working with Comments
  • Insert Excel Objects and Charts in Word Document and PowerPoint Presentation

Module 7: Hyperlinks and Action Buttons

  • Inserting Hyperlinks and Action Buttons
  • Edit Hyperlinks and Action Button
  • Word Art and Shapes

Module 8 : Using slide Master

  • Using slide master
  • Inserting layout option
  • Creating custom layout
  • Inserting place holders
  • Formatting place holders

Module 9 : Internet & E-mail

  • Job Searching, Downloading video and Music
  • Uploading Video or Music, Voice chatting, Webcam Chatting etc.

Module 10 : Project

  • Implementation all the above functionality

Advance computer course

Check the course overview video. Enroll today to learn the advance powerful features of computer.

Courses Offered : Yasham Academy offers following courses leading to an exciting career. Click on the desired course below to know more about the same.