17/08/2024
ADVANCE OFFFICE PACKAGE/COMPUTER/OPERATOR/DATA ENTRY
FONDAMENTAL OF COMPUTER
Typing English/Nepali
MSWORD
Protech Document
Keyboard make shortcut key as our choice
Convert word into PDF and PDF to Word
Highlight sentences
Eliminate Distractions
Quick Access
Vast use of format painter
Remove space after paragraph
Removing or delating and replacing words, spaces of the lines etc
DIrectly going to desire pages,lines, paragraphs etc
Use of Clipboard
Use of table,calculate and draw
Shapes,Smart Arts, Chart,Screenshot, Hyperlink
Header,Footer,Page Number and Custom Page Number
Equation, Symbol
Size,Orientation,Margin,Column,Breaks
Watermark,Page Color,Pageboarder,Indent
Position,Wrap Text,Alight,Group,Rotate etc
Table of Containts, Insert Footnote
Spelling and Grammar,Research, Thesaurus,Word Count etc
Print Layout,Full screen & Marcos etc
Print and Custom Print
Project works what we see that we do
MSEXCEL
ADVANCE EXCEL
COURSE CONTENTS
SUM,SUMIF, COUNT,COUNTIF, COUNTA, MIN,MAX,AVERAGE,IF, AND, OR
Substract,Multiply,Divide,Percentage
Hide,Unhide Rows/Columns
Conditional Formatting
Date &Text Function
Advance Filter
Charts &Pivot Table
Convert Day Month Year to Date
What If Analysis: Goal Seek, Data Table
Scenario Manager
Group, Subtotal
Cell Reference, Number Formatting
PMT Function for Installment
Data Validation &Consolidate
Header / Footer, Page Numbering in Sheet
Freeze Pans &Macros
Protect Cell &Sheet
Page Setup
Vlookup&Hlookup
ProjectWork:Simple Bill, Salary Sheet ,Sales Report,Working Hours, TelephoneBill,Electricity Bill, Marks Sheet, Interest Find Out Age,Sales &Purchase Sheet and Loss Profit, Calculation, Attendance Sheet, Balance Sheet, PL Account,LedgerTemplate Manymore………
POWERPOINT
How to Make a PowerPoint Presentation
Open PowerPoint and click ‘New’
Choose a theme or create your own
Creating PowerPoint Slides
Create a variety of slides for differen
